National Workforce Data Set

Description

Due to the ongoing software migration to a new authoring and publishing tool (Mauro), it has not been possible to uplift the National Workforce Data Set (NWD) represented in the NHS Data Model and Dictionary to the latest version, v3.6. As such, the NHS Data Model and Dictionary is currently displaying v3.5 of the NWD. Whilst work is ongoing to ensure that the latest version of the NWD is represented, users wishing to access the current approved version of the NWD in the meantime are advised to refer to the NWD v3.6 Specification.

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


ORGANISATIONAL DETAILS
Mandation	Data Elements
	POSITION IDENTIFIER
	ORGANISATION IDENTIFIER (EMPLOYER)
	ORGANISATION NAME (EMPLOYER)
	ORGANISATION IDENTIFIER (POSITION NON-NHS FUNDER)
	ORGANISATION SITE IDENTIFIER (EMPLOYING ORGANISATION)
	ORGANISATION SITE NAME (EMPLOYING ORGANISATION)


PERSONAL/OPERATIONAL DETAILS
Mandation	Data Elements
	EMPLOYEE NHS IDENTIFIER
	PERSON AGE IN YEARS (REPORTING PERIOD END DATE)
	PERSON BIRTH DATE
	EMPLOYEE DISABILITY STATUS
	ETHNIC CATEGORY
	PERSON GIVEN NAME (FIRST)
	PERSON GIVEN NAME (SECOND)
	PERSON GIVEN NAME (THIRD)
	PERSON STATED GENDER CODE
	PERSON STATED SEXUAL ORIENTATION CODE
	PERSON INITIALS
	EMPLOYEE LOCAL IDENTIFIER
	NATIONAL INSURANCE NUMBER
	PERSON STATED NATIONALITY
	EMPLOYEE RESIDENCY STATUS
	PERSON FAMILY NAME
	EMPLOYEE WORK PERMIT END DATE


DEPLOYMENT DETAILS
Mandation	Data Elements
	AREA OF WORK NAME
	FLEXIBLE WORKING PATTERN TYPE
	JOB ROLE TITLE (POSITION)
	POSITION ROTA PATTERN TYPE
	POSITION SHIFT TYPE
	CARE GROUP CODE (POSITION)
	CARE GROUP CODE (EMPLOYEE ASSIGNMENT)
	OCCUPATION CODE (CLINICAL SECOND SPECIALTY)
	OCCUPATION CODE (CLINICAL SPECIALTY)
	AREA OF WORK NAME (CLINICAL SUB SPECIALTY)
	PAYSCALE SPINE POINT
	OCCUPATION CODE
	OCCUPATION CODE DESCRIPTION
	PAYSCALE CODE (EMPLOYEE ASSIGNMENT LATEST)
	PAYSCALE CODE
	PAYSCALE DESCRIPTION
	PAYSCALE TYPE


EDUCATION DETAILS
Mandation	Data Elements
	TRAINING ACTIVITY TYPE
	STAFF GROUP CODE (TRAINING ACTIVITY CLASSIFICATION)
	TRAINING ACTIVITY DELIVERY METHOD
	QUALIFICATION SUBJECT AREA
	TRAINING ACTIVITY ACCREDITATION CREDIT AMOUNT
	TRAINING ACTIVITY ACTUAL COMPLETION DATE (SPECIALIST TRAINING)
	TRAINING ACTIVITY ACTUAL COMPLETION DATE (GP TRAINING)
	EMPLOYEE LEARNING ACCOUNT START DATE
	PROFESSIONAL REGISTRATION FIRST REGISTRATION DATE
	EMPLOYEE QUALIFICATION AWARDED DATE
	EMPLOYEE HESA STUDENT NUMBER
	APPRAISAL REVIEW PLANNED DATE (CONSULTANT JOB PLAN NEXT)
	PROFESSIONAL REGISTRATION TYPE (POSITION)
	EMPLOYEE NATIONAL TRAINING NUMBER
	PERSON FULL NAME (CLINICAL SUPERVISOR LATEST)
	PERSON FULL NAME (EDUCATIONAL SUPERVISOR LATEST)
	TRAINING ACTIVITY NAME
	APPRAISAL REVIEW PLANNED DATE (NEXT)
	APPRAISAL REVIEW PLANNED DATE (PDP NEXT)
	APPRAISAL REVIEW DATE
	PROFESSIONAL REGISTRATION BODY CODE
	PROFESSIONAL REGISTRATION EXPIRY DATE
	PROFESSIONAL REGISTRATION ENTRY IDENTIFIER
	PROFESSIONAL REGISTRATION STATUS
	EMPLOYEE QUALIFICATION PLANNED COMPLETION DATE (SPECIALIST TRAINING)
	EMPLOYEE QUALIFICATION PLANNED COMPLETION DATE (GP TRAINING)
	QUALIFICATION TITLE
	QUALIFICATION TYPE
	QUALIFICATION PLANNED COMPLETION DATE CHANGE REASON (CCT)
	PROFESSIONAL REGISTRATION TYPE
	TRAINING ACTIVITY START DATE (SPECIALIST TRAINING)
	TRAINING ACTIVITY START DATE (GP TRAINING)
	TRAINING ACTIVITY ASSESSOR TYPE


ABSENCE DETAILS
Mandation	Data Elements
	EMPLOYEE ABSENCE CATEGORY
	EMPLOYEE ABSENCE DURATION
	EMPLOYEE ABSENCE END DATE
	EMPLOYEE ABSENCE RATE (REPORTING PERIOD)
	EMPLOYEE ABSENCE START DATE
	EMPLOYEE ABSENCE TYPE
	EMPLOYEE ABSENCE TYPE RELATED REASON
	EMPLOYEE ABSENCE OCCURRENCE TOTAL (REPORTING PERIOD)
	EMPLOYEE ABSENCE SICKNESS REASON
	EMPLOYEE ABSENCE WORKING HOURS LOST (REPORTING PERIOD)


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