Data Set: National Workforce Data Set

National Workforce Data Set

ORGANISATIONAL DETAILS

Organisational
Data Set 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

Personal/Operational
Data Set 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

Deployment
Data Set 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

Education
Data Set 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

Absence
Data Set 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

Staff Movements and Numbers
Data Set 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