National Workforce Data Set

The National Workforce Data Set (NWD) is a reference Data Set comprising standardised definitions to facilitate the capture of nationally consistent information relating to the NHS and wider healthcare workforce.

Overview

Introduction

The National Workforce Data Set  (NWD) is a reference Data Set comprising standardised definitions to facilitate the capture of nationally consistent information relating to the NHS and wider healthcare workforce.   National Workforce data items and definitions support a variety of workforce based collections. They are also embedded within operational HR/workforce systems including Electronic Staff Record (ESR), and the NHS Jobs web system.

The National Workforce Data Set  provides common definitions for those data items that are needed to support workforce planning for the NHS workforce and is intended as a reference with an agreed set of data definitions for people who plan workforce at strategic, national and local level.

The changing nature of the provision of NHS funded care is leading to plurality of supply, and therefore a  National Workforce Data Set ensures that all suppliers of NHS care provide workforce information in an agreed and pre-determined format. This provides a practical means for the consistent collection of this information from all providers of NHS funded care to enable comprehensive Healthcare Workforce planning going forwards.

The information captured using the values defined in the National Workforce Data Set will also be used locally within ORGANISATIONS  by a range of people in addition to those mentioned above, such as in Training and Development, Workforce Information and Planning and Equality and Diversity.  The accuracy and relevance of the data captured using the National Workforce Data Set  values will therefore impact on a number of issues at local level and beyond.

Further guidance has been produced by NHS England  and is available on their website at: National Workforce Data Set (NWD) and NHS occupation codes.

Specification

STAFF MOVEMENTS AND NUMBERS DETAILS

Mandation

Data Elements

EMPLOYMENT HISTORY EMPLOYMENT LEAVING DATE

ASSIGNMENT STATUS

POSITION BUDGETED FTE

EMPLOYMENT CONTRACT NATURE CODE

EMPLOYMENT HISTORY CONTINUOUS SERVICE TYPE 1 DATE

EMPLOYMENT HISTORY CONTINUOUS SERVICE TYPE 2 DATE

EMPLOYMENT CONTRACT WORKING HOURS

EMPLOYMENT CONTRACT WORKING SESSIONS

ASSIGNMENT CONTRACTED FTE

POSITION CONTRACTED FTE

EMPLOYMENT HISTORY NHS LEAVING DATE (LATEST)

EMPLOYMENT HISTORY NHS JOINING DATE (LATEST)

EMPLOYMENT CONTRACT START DATE

EMPLOYMENT HISTORY LEAVING DESTINATION

EMPLOYMENT HISTORY EXIT INTERVIEW INDICATOR

EMPLOYMENT HISTORY EXIT QUESTIONNAIRE INDICATOR

EMPLOYMENT CONTRACT END DATE

HEADCOUNT (ORGANISATION CURRENT)

HEADCOUNT (POSITION ASSIGNMENT CURRENT)

EMPLOYEE INTERNATIONAL RECRUIT INDICATOR

ASSIGNMENT JOB SHARE INDICATOR

EMPLOYMENT HISTORY ORGANISATION JOINING DATE

ASSIGNMENT LAST WORKING DATE

EMPLOYEE ORGANISATION LENGTH OF SERVICE

EMPLOYEE NHS LENGTH OF SERVICE

POSITION VACANCY LENGTH OF TIME UNFILLED

POSITION INTERNATIONAL RECRUITMENT INDICATOR

POSITION STATUS

POSTCODE

ASSIGNMENT END DATE

EMPLOYMENT HISTORY LEAVING REASON

EMPLOYMENT HISTORY RECRUITMENT SOURCE

HEADCOUNT STABILITY RATE (JOB ROLE IN REPORTING PERIOD)

HEADCOUNT STABILITY RATE (ORGANISATION IN REPORTING PERIOD)

HEADCOUNT STABILITY RATE (STAFF GROUP IN REPORTING PERIOD)

FTE STABILITY RATE (JOB ROLE IN REPORTING PERIOD)

FTE STABILITY RATE (ORGANISATION IN REPORTING PERIOD)

FTE STABILITY RATE (STAFF GROUP IN REPORTING PERIOD)

STAFF GROUP STANDARD HOURS

STAFF GROUP STANDARD SESSIONS

START DATE (ASSIGNMENT PAYSCALE)

EMPLOYMENT HISTORY NHS JOINING DATE (FIRST)

EMPLOYEE LENGTH OF TIME IN POSITION

HEADCOUNT TURNOVER RATE (ORGANISATION IN REPORTING PERIOD)

HEADCOUNT TURNOVER RATE (FTE IN REPORTING PERIOD)

ASSIGNMENT TYPE

EMPLOYMENT CONTRACT TYPE

REASON FOR EMPLOYEE FIXED TERM OR TEMPORARY EMPLOYMENT CONTRACT

EMPLOYMENT CONTRACT SESSION TYPE

POSITION VACANCY END DATE

POSITION VACANCY START DATE

POSITION VACANCY STATUS

POSITION VACANCY FTE

POSITION VACANCY IDENTIFIER

POSITION WORKED FTE (REPORTING PERIOD)

POSITION FTE VARIANCE

Also Known As

This data set is also known by these names:

Context Alias
Also known as NWDS
Full name National Workforce Data Set
Short name National Workforce