National Workforce Data Set

IntroductionThe 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 Digital  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 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

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