Change Request
 

NHS Connecting for Health

NHS Data Model and Dictionary Service

Reference: Change Request 1031
Version No:
Subject:August Update Patch
Effective Date:Immediate
Reason for Change:Patch
Publication Date:26 Aug 2008

Background:

This patch updates the NHS Data Model and Dictionary to correct errors identified in the test publication.

This patch includes:

Summary of changes:

Attribute Definitions
CONSULTANT CODE   Changed Description
 
Data Elements
AMOUNT STERLING   Changed linked Attribute
CONSULTANT CODE   Changed Description
 
Data Set
NATIONAL WORKFORCE DATA SET   Changed Description
 
Supporting Information
CDS VERSION NHS003 AND 4 TYPE LIST renamed from CDS VERSION NHS003 / 4 TYPE LIST   Changed Name
CHANGE MENU   Changed Description
CLINICAL CODING   Changed Description
CLINICAL CODING INTRODUCTION   Changed Description
DIAGRAMS INTRODUCTION   Changed Description
MAIN MENU   Changed Description
NHS TRUST MERGERS   Changed Description
PUBLICATION INFORMATION CONTACT DETAILS   Changed Description
REFERENCED ORGANISATIONS MENU   Changed Description
WHAT'S NEW: AUGUST 2008   Changed Description
 
Binary
DOSEARCH   Changed changed element type
NHSDD FIX CSS1   Changed attached binary file
SEARCH   Changed changed element type
 
Packages
CLASSES   New Package
CLASSES   New Package
DATA FIELD NOTES   Changed Description, Aliases
DATA FIELD NOTES   Changed Description, Aliases
DATA FIELD NOTES   Changed Description, Aliases
 

Date:26 Aug 2008
Sponsor:Nicholas Oughtibridge, NHS Connecting for Health

Note: New text is shown with a blue background. Deleted text is crossed out. Within the Diagrams deleted classes and relationships are red, changed items are blue and new items are green.

Click here for a printer friendly view of this page.

NATIONAL WORKFORCE DATA SET
Change to Data Set: Changed Description

National Workforce Data Set Overview

The National Workforce Data Set comprises of data elements grouped by the following section categories:

    Reporting Period 
    Organisational 
    Personal/Operational 
    Deployment 
    Education 
    Absence 
    Staff Movements and Numbers 
Data Set Data Elements  NWDS
  Id. 		 NWDS/ESR Field Name
Data Set Data Elements  NWDS
  Id. 		 NWDS/ESR Field Name
Reporting Period

 
REPORTING PERIOD START DATE       
REPORTING PERIOD START DATE       
REPORTING PERIOD END DATE      
REPORTING PERIOD END DATE      
Organisational

 
POSITION IDENTIFIER  ORPN  ESR: Position Number
POSITION IDENTIFIER  ORPN  ESR: Position Number
ORGANISATION CODE (EMPLOYER)  OCSC  Employing Organisation Code
ORGANISATION CODE (EMPLOYER)  OCSC  Employing Organisation Code
ORGANISATION NAME (EMPLOYER)  ORGN  Employing Organisation Name
ORGANISATION NAME (EMPLOYER)  ORGN  Employing Organisation Name
ORGANISATION TYPE (EMPLOYER)  ORGT  Employing Organisation Type
ORGANISATION TYPE (EMPLOYER)  ORGT  Employing Organisation Type
ORGANISATION CODE (POSITION NON-NHS FUNDER)  ORGF  Post Funded By
ORGANISATION CODE (POSITION NON-NHS FUNDER)  ORGF  Post Funded By
SITE CODE (EMPLOYING ORGANISATION)  ORST  Site Description (Location)
SITE CODE (EMPLOYING ORGANISATION)  ORST  Site Description (Location)
SITE NAME (EMPLOYING ORGANISATION)  ORGP  Site Description (Location)
SITE NAME (EMPLOYING ORGANISATION)  ORGP  Site Description (Location)
Personal/Operational

 
EMPLOYEE NHS IDENTIFIER  PENO  ESR: Unique NHS Identifier (ID)
EMPLOYEE NHS IDENTIFIER  PENO  ESR: Unique NHS Identifier (ID)
PERSON AGE IN YEARS (REPORTING PERIOD END DATE)  PEAG  Age in Years
ESR: Age
PERSON AGE IN YEARS (REPORTING PERIOD END DATE)  PEAG  Age in Years
ESR: Age
PERSON BIRTH DATE  PEBD  Date of Birth
PERSON BIRTH DATE  PEBD  Date of Birth
EMPLOYEE DISABILITY STATUS CODE  PDSS  Disability Status
ESR: Disabled
EMPLOYEE DISABILITY STATUS CODE  PDSS  Disability Status
ESR: Disabled
ETHNIC CATEGORY  PETH  Ethnic Category
ESR: Ethnic Origin
ETHNIC CATEGORY  PETH  Ethnic Category
ESR: Ethnic Origin
PERSON GIVEN NAME (FIRST)  PNMA  Forename (1)
ESR: First Name
PERSON GIVEN NAME (FIRST)  PNMA  Forename (1)
ESR: First Name
PERSON GIVEN NAME (SECOND)  PNMB  Forename (2)
ESR: Middle Name
PERSON GIVEN NAME (SECOND)  PNMB  Forename (2)
ESR: Middle Name
PERSON GIVEN NAME (THIRD)  PNMC  Forename (3)
ESR: Middle Name
PERSON GIVEN NAME (THIRD)  PNMC  Forename (3)
ESR: Middle Name
PERSON GENDER AT REGISTRATION  PSEX  Gender
PERSON GENDER AT REGISTRATION  PSEX  Gender
PERSON INITIALS  PEIN  Initials
PERSON INITIALS  PEIN  Initials
EMPLOYEE LOCAL IDENTIFIER  PLNO  Local Unique Employee Number
ESR Employee Number
EMPLOYEE LOCAL IDENTIFIER  PLNO  Local Unique Employee Number
ESR Employee Number
NATIONAL INSURANCE NUMBER  PNIN  National Insurance Number (NI Number)
NATIONAL INSURANCE NUMBER  PNIN  National Insurance Number (NI Number)
COUNTRY CODE (AT ASSIGNMENT)  PNAT  Nationality
COUNTRY CODE (AT ASSIGNMENT)  PNAT  Nationality
EMPLOYEE RESIDENCY STATUS  PSTA  Residency Status
EMPLOYEE RESIDENCY STATUS  PSTA  Residency Status
PERSON FAMILY NAME  PSUR  Surname
ESR: Last Name
PERSON FAMILY NAME  PSUR  Surname
ESR: Last Name
EMPLOYEE WORK PERMIT END DATE  PWPE  Work Permit Expiry Date
EMPLOYEE WORK PERMIT END DATE  PWPE  Work Permit Expiry Date
Deployment

 
AREA OF WORK NAME  GRWA  ESR: Area of Work
AREA OF WORK NAME  GRWA  ESR: Area of Work
FLEXIBLE WORKING PATTERN TYPE CODE  GRFL  ESR: Flexible Working Pattern
FLEXIBLE WORKING PATTERN TYPE CODE  GRFL  ESR: Flexible Working Pattern
JOB ROLE TITLE (POSITION)  GRJB  ESR: Job Role (for a Position)
JOB ROLE TITLE (POSITION)  GRJB  ESR: Job Role (for a Position)
POSITION ROTA PATTERN CODE  GRST  ESR: Rota Pattern
POSITION ROTA PATTERN CODE  GRST  ESR: Rota Pattern
POSITION SHIFT TYPE CODE  GRWP  ESR: Shift Type (Work Requirement)
POSITION SHIFT TYPE CODE  GRWP  ESR: Shift Type (Work Requirement)
CARE GROUP CODE (POSITION)  GRCP  Care Group(s) applicable to a Position
CARE GROUP CODE (POSITION)  GRCP  Care Group(s) applicable to a Position
CARE GROUP CODE (EMPLOYEE ASSIGNMENT)  GRCA  Care Group (s) covered by an Employee
CARE GROUP CODE (EMPLOYEE ASSIGNMENT)  GRCA  Care Group (s) covered by an Employee
OCCUPATION CODE (CLINICAL SECOND SPECIALTY)  GCSB  Clinical Second Specialty
ESR: Second Specialty
OCCUPATION CODE (CLINICAL SECOND SPECIALTY)  GCSB  Clinical Second Specialty
ESR: Second Specialty
OCCUPATION CODE (CLINICAL SPECIALTY)  GCSA  Clinical Specialty
ESR: See Area of Work and Occupation Code
OCCUPATION CODE (CLINICAL SPECIALTY)  GCSA  Clinical Specialty
ESR: See Area of Work and Occupation Code
AREA OF WORK NAME (CLINICAL SUB SPECIALTY)  GCSS  Clinical Sub-Specialty
AREA OF WORK NAME (CLINICAL SUB SPECIALTY)  GCSS  Clinical Sub-Specialty
ASSIGNMENT GROUP CODE  GRGC  Group Code
ASSIGNMENT GROUP CODE  GRGC  Group Code
PAYSCALE SPINE POINT CODE  GRSP  Incremental Point
ESR: Grade Step
PAYSCALE SPINE POINT CODE  GRSP  Incremental Point
ESR: Grade Step
OCCUPATION CODE  GROC  Occupation Code
OCCUPATION CODE  GROC  Occupation Code
OCCUPATION CODE DESCRIPTION  GROD  Occupation Code Description
OCCUPATION CODE DESCRIPTION  GROD  Occupation Code Description
PAYSCALE CODE (EMPLOYEE ASSIGNMENT LATEST)  GRAG  Payscale (for an Assignment/Post)
ESR: Grade (Assignment)
PAYSCALE CODE (EMPLOYEE ASSIGNMENT LATEST)  GRAG  Payscale (for an Assignment/Post)
ESR: Grade (Assignment)
PAYSCALE CODE  GRCD  Payscale Code
ESR: Grade Scale Code
PAYSCALE CODE  GRCD  Payscale Code
ESR: Grade Scale Code
PAYSCALE DESCRIPTION  GRDS  Payscale Description
ESR: Grade Scale Description
PAYSCALE DESCRIPTION  GRDS  Payscale Description
ESR: Grade Scale Description
PAYSCALE TYPE  GRTP  Payscale Type (Derived)
ESR: National/Local Identifier (Grade)
PAYSCALE TYPE  GRTP  Payscale Type (Derived)
ESR: National/Local Identifier (Grade)
Education

 
TRAINING ACTIVITY TYPE CODE  ETAT  ESR: Activity Type (Training)
TRAINING ACTIVITY TYPE CODE  ETAT  ESR: Activity Type (Training)
STAFF GROUP CODE (TRAINING ACTIVITY CLASSIFICATION)  ETAC  ESR: Category Type (Training Classification)
STAFF GROUP CODE (TRAINING ACTIVITY CLASSIFICATION)  ETAC  ESR: Category Type (Training Classification)
TRAINING ACTIVITY DELIVERY METHOD TYPE CODE  ESR: Category Type (Delivery Method)
TRAINING ACTIVITY DELIVERY METHOD TYPE CODE  ESR: Category Type (Delivery Method)
QUALIFICATION SUBJECT AREA CODE  EQSA  ESR: Subject Area
QUALIFICATION SUBJECT AREA CODE  EQSA  ESR: Subject Area
TRAINING ACTIVITY ACCREDITATION CREDIT AMOUNT  EACC  Accreditation from Training Course
ESR: Amount (Professional Credit)
TRAINING ACTIVITY ACCREDITATION CREDIT AMOUNT  EACC  Accreditation from Training Course
ESR: Amount (Professional Credit)
TRAINING ACTIVITY ACTUAL COMPLETION DATE (SPECIALIST TRAINING)  ESPD  Actual CCST Date (Derived)
TRAINING ACTIVITY ACTUAL COMPLETION DATE (SPECIALIST TRAINING)  ESPD  Actual CCST Date (Derived)
TRAINING ACTIVITY ACTUAL COMPLETION DATE (GP TRAINING)  EGPC  Actual GP Training Completion Date (Derived)
TRAINING ACTIVITY ACTUAL COMPLETION DATE (GP TRAINING)  EGPC  Actual GP Training Completion Date (Derived)
EMPLOYEE LEARNING ACCOUNT START DATE  ELAS  Date NHS Learning Account Funding Started
EMPLOYEE LEARNING ACCOUNT START DATE  ELAS  Date NHS Learning Account Funding Started
PROFESSIONAL REGISTRATION FIRST REGISTRATION DATE  EPRD  Date of First Professional Registration
ESR: First Registration Date
PROFESSIONAL REGISTRATION FIRST REGISTRATION DATE  EPRD  Date of First Professional Registration
ESR: First Registration Date
EMPLOYEE QUALIFICATION AWARDED DATE  EQDT  Date Qualification Awarded
ESR: Awarded Date (Qualification)
EMPLOYEE QUALIFICATION AWARDED DATE  EQDT  Date Qualification Awarded
ESR: Awarded Date (Qualification)
EMPLOYEE HESA STUDENT NUMBER  EHEI  HESA Student Identifier
EMPLOYEE HESA STUDENT NUMBER  EHEI  HESA Student Identifier
APPRAISAL REVIEW PLANNED DATE (CONSULTANT JOB PLAN NEXT)  EPED  Job Plan End Date
ESR: Next Review Date (Consultant Job Plan)
APPRAISAL REVIEW PLANNED DATE (CONSULTANT JOB PLAN NEXT)  EPED  Job Plan End Date
ESR: Next Review Date (Consultant Job Plan)
PROFESSIONAL REGISTRATION TYPE CODE (POSITION)  ERDP  Mandatory Registration Details for Position
ESR: Registration and Membership Requirements for Position
PROFESSIONAL REGISTRATION TYPE CODE (POSITION)  ERDP  Mandatory Registration Details for Position
ESR: Registration and Membership Requirements for Position
EMPLOYEE NATIONAL TRAINING NUMBER  ESRN  Medical and Dental Training Number
EMPLOYEE NATIONAL TRAINING NUMBER  ESRN  Medical and Dental Training Number
PERSON FULL NAME (CLINICAL SUPERVISOR LATEST)  ECSN  Name of Employee's Clinical Supervisor
PERSON FULL NAME (CLINICAL SUPERVISOR LATEST)  ECSN  Name of Employee's Clinical Supervisor
PERSON FULL NAME (EDUCATIONAL SUPERVISOR LATEST)  EESN  Name of Employee's Educational Supervisor
PERSON FULL NAME (EDUCATIONAL SUPERVISOR LATEST)  EESN  Name of Employee's Educational Supervisor
TRAINING ACTIVITY NAME  ETRN  Name of Training Course
ESR: Name (Training Activity)
TRAINING ACTIVITY NAME  ETRN  Name of Training Course
ESR: Name (Training Activity)
APPRAISAL REVIEW PLANNED DATE (NEXT)  ENXT  Next/Future Performance Review (Appraisal) Date
APPRAISAL REVIEW PLANNED DATE (NEXT)  ENXT  Next/Future Performance Review (Appraisal) Date
APPRAISAL REVIEW PLANNED DATE (PDP NEXT)  EPDE  PDP (Personal Development Plan) Review Date
APPRAISAL REVIEW PLANNED DATE (PDP NEXT)  EPDE  PDP (Personal Development Plan) Review Date
APPRAISAL REVIEW DATE  EPDR  Performance and Development Review Date
APPRAISAL REVIEW DATE  EPDR  Performance and Development Review Date
ORGANISATION NAME (PROFESSIONAL REGISTRATION BODY)  EPRB  Professional Registration Body
ESR: Registration/Membership Body
ORGANISATION NAME (PROFESSIONAL REGISTRATION BODY)  EPRB  Professional Registration Body
ESR: Registration/Membership Body
PROFESSIONAL REGISTRATION EXPIRY DATE  EPRE  Professional Registration Expiry Date
ESR: Expiry Date (Professional Registration)
PROFESSIONAL REGISTRATION EXPIRY DATE  EPRE  Professional Registration Expiry Date
ESR: Expiry Date (Professional Registration)
PROFESSIONAL REGISTRATION ENTRY IDENTIFIER  EPRN  Professional Registration Number
PROFESSIONAL REGISTRATION ENTRY IDENTIFIER  EPRN  Professional Registration Number
PROFESSIONAL REGISTRATION STATUS  EPRS  Professional Registration Status (Derived)
PROFESSIONAL REGISTRATION STATUS  EPRS  Professional Registration Status (Derived)
EMPLOYEE QUALIFICATION PLANNED COMPLETION DATE (SPECIALIST TRAINING)  ESPA  Projected CCST Date (Derived)
EMPLOYEE QUALIFICATION PLANNED COMPLETION DATE (SPECIALIST TRAINING)  ESPA  Projected CCST Date (Derived)
EMPLOYEE QUALIFICATION PLANNED COMPLETION DATE (GP TRAINING)  EGPA  Projected GP Training Completion Date (Derived)
EMPLOYEE QUALIFICATION PLANNED COMPLETION DATE (GP TRAINING)  EGPA  Projected GP Training Completion Date (Derived)
QUALIFICATION TITLE  EQTT  Qualification Title
QUALIFICATION TITLE  EQTT  Qualification Title
QUALIFICATION TYPE CODE  EQTY  Qualification Type
QUALIFICATION TYPE CODE  EQTY  Qualification Type
QUALIFICATION PLANNED COMPLETION DATE CHANGE REASON (CCT)  ESPM  Reason for Moving CCST Date
QUALIFICATION PLANNED COMPLETION DATE CHANGE REASON (CCT)  ESPM  Reason for Moving CCST Date
PROFESSIONAL REGISTRATION TYPE CODE  ERGT  Registration Type
PROFESSIONAL REGISTRATION TYPE CODE  ERGT  Registration Type
TRAINING ACTIVITY START DATE (SPECIALIST TRAINING)  ESPS  Start Date of CCST
ESR: Start Date of Qualification
TRAINING ACTIVITY START DATE (SPECIALIST TRAINING)  ESPS  Start Date of CCST
ESR: Start Date of Qualification
TRAINING ACTIVITY START DATE (GP TRAINING)  EGPS  Start Date of GP Training
ESR: Start Date of Qualification
TRAINING ACTIVITY START DATE (GP TRAINING)  EGPS  Start Date of GP Training
ESR: Start Date of Qualification
TRAINING ACTIVITY ASSESSOR TYPE CODE  EATY  Type of Assessor
TRAINING ACTIVITY ASSESSOR TYPE CODE  EATY  Type of Assessor
Absence

 
EMPLOYEE ABSENCE CATEGORY CODE  ACAT  Absence Category
ESR: Category (Absence)
EMPLOYEE ABSENCE CATEGORY CODE  ACAT  Absence Category
ESR: Category (Absence)
EMPLOYEE ABSENCE DURATION  ADCD  Absence Duration In Calendar Days (Derived)
EMPLOYEE ABSENCE DURATION  ADCD  Absence Duration In Calendar Days (Derived)
EMPLOYEE ABSENCE END DATE  AEND  Absence End Date
EMPLOYEE ABSENCE END DATE  AEND  Absence End Date
EMPLOYEE ABSENCE RATE (REPORTING PERIOD)  ARTE  Absence Rate (Derived)
EMPLOYEE ABSENCE RATE (REPORTING PERIOD)  ARTE  Absence Rate (Derived)
EMPLOYEE ABSENCE START DATE  ASTD  Absence Start Date
EMPLOYEE ABSENCE START DATE  ASTD  Absence Start Date
EMPLOYEE ABSENCE TYPE CODE  ATYP  Absence Type
ESR: Type (Absence)
EMPLOYEE ABSENCE TYPE CODE  ATYP  Absence Type
ESR: Type (Absence)
EMPLOYEE ABSENCE OCCURRENCE TOTAL (REPORTING PERIOD)  AEPI  Episodes of Absence (Derived)
ESR: Number of Absence Occurrences
EMPLOYEE ABSENCE OCCURRENCE TOTAL (REPORTING PERIOD)  AEPI  Episodes of Absence (Derived)
ESR: Number of Absence Occurrences
EMPLOYEE ABSENCE SICKNESS REASON CODE  AREA  Reason for Sickness Absence
ESR: Reason (Sickness Absence)
EMPLOYEE ABSENCE SICKNESS REASON CODE  AREA  Reason for Sickness Absence
ESR: Reason (Sickness Absence)
EMPLOYEE ABSENCE WORKING HOURS LOST (REPORTING PERIOD)  AWHL  Working Hours Lost due to Absence
EMPLOYEE ABSENCE WORKING HOURS LOST (REPORTING PERIOD)  AWHL  Working Hours Lost due to Absence
Staff Movements and Numbers

 
EMPLOYMENT HISTORY EMPLOYMENT LEAVING DATE  STRD  Actual Termination Date
EMPLOYMENT HISTORY EMPLOYMENT LEAVING DATE  STRD  Actual Termination Date
ASSIGNMENT STATUS CODE  SSTA  Appointment Status
ESR: Assignment Status
ASSIGNMENT STATUS CODE  SSTA  Appointment Status
ESR: Assignment Status
POSITION BUDGETED FTE  SBUD  Budgeted Whole Time Equivalent (WTE) for Position
ESR: FTE (Position Budgeted)
POSITION BUDGETED FTE  SBUD  Budgeted Whole Time Equivalent (WTE) for Position
ESR: FTE (Position Budgeted)
EMPLOYMENT CONTRACT NATURE CODE  SCEN  Census - Nature of Contract (Derived)
EMPLOYMENT CONTRACT NATURE CODE  SCEN  Census - Nature of Contract (Derived)
EMPLOYMENT HISTORY CONTINUOUS SERVICE TYPE 1 DATE  SCSA  Continuous NHS Service Date (Type 1)
ESR: CSD 3 Months
EMPLOYMENT HISTORY CONTINUOUS SERVICE TYPE 1 DATE  SCSA  Continuous NHS Service Date (Type 1)
ESR: CSD 3 Months
EMPLOYMENT HISTORY CONTINUOUS SERVICE TYPE 2 DATE  SCSB  Continuous NHS Service Date (Type 2)
ESR: CSD 12 Months
EMPLOYMENT HISTORY CONTINUOUS SERVICE TYPE 2 DATE  SCSB  Continuous NHS Service Date (Type 2)
ESR: CSD 12 Months
EMPLOYMENT CONTRACT WORKING HOURS  SCHR  Contracted Hours
ESR: Working Hours
EMPLOYMENT CONTRACT WORKING HOURS  SCHR  Contracted Hours
ESR: Working Hours
EMPLOYMENT CONTRACT WORKING SESSIONS  SCSE  Contracted Sessions
EMPLOYMENT CONTRACT WORKING SESSIONS  SCSE  Contracted Sessions
ASSIGNMENT CONTRACTED FTE  SCON  Contracted Whole Time Equivalent (WTE) for an Assignment (Derived)
ESR: Assignment Budget Value
ASSIGNMENT CONTRACTED FTE  SCON  Contracted Whole Time Equivalent (WTE) for an Assignment (Derived)
ESR: Assignment Budget Value
POSITION CONTRACTED FTE  SWTC  Contracted Whole Time Equivalent (WTE) for Position
POSITION CONTRACTED FTE  SWTC  Contracted Whole Time Equivalent (WTE) for Position
EMPLOYMENT HISTORY NHS LEAVING DATE (LATEST)  SDGO  Date of Leaving NHS (Derived)
EMPLOYMENT HISTORY NHS LEAVING DATE (LATEST)  SDGO  Date of Leaving NHS (Derived)
EMPLOYMENT HISTORY NHS JOINING DATE (LATEST)  SREJ  Date of Rejoining NHS (Derived)
EMPLOYMENT HISTORY NHS JOINING DATE (LATEST)  SREJ  Date of Rejoining NHS (Derived)
EMPLOYMENT CONTRACT START DATE  SCSD  Date of Starting Current Contract of Employment
EMPLOYMENT CONTRACT START DATE  SCSD  Date of Starting Current Contract of Employment
EMPLOYMENT HISTORY LEAVING DESTINATION CODE  SDOL  Destination on Leaving
EMPLOYMENT HISTORY LEAVING DESTINATION CODE  SDOL  Destination on Leaving
EMPLOYMENT HISTORY EXIT INTERVIEW INDICATOR  SXIN  Exit Interview
EMPLOYMENT HISTORY EXIT INTERVIEW INDICATOR  SXIN  Exit Interview
EMPLOYMENT HISTORY EXIT QUESTIONNAIRE INDICATOR  SEIQ  Exit Interview Questionnaire (Derived)
ESR: Exit Questionnaire
EMPLOYMENT HISTORY EXIT QUESTIONNAIRE INDICATOR  SEIQ  Exit Interview Questionnaire (Derived)
ESR: Exit Questionnaire
EMPLOYMENT CONTRACT END DATE  SCXP  Fixed Term/Temporary Contract Expiry Date
EMPLOYMENT CONTRACT END DATE  SCXP  Fixed Term/Temporary Contract Expiry Date
HEADCOUNT (ORGANISATION CURRENT)  SHED  Headcount
HEADCOUNT (ORGANISATION CURRENT)  SHED  Headcount
HEADCOUNT (POSITION ASSIGNMENT CURRENT)  Headcount
HEADCOUNT (POSITION ASSIGNMENT CURRENT)  Headcount
EMPLOYEE INTERNATIONAL RECRUIT INDICATOR  SINR  International Recruit (Derived)
EMPLOYEE INTERNATIONAL RECRUIT INDICATOR  SINR  International Recruit (Derived)
ASSIGNMENT JOB SHARE INDICATOR  SJOS  Job Sharer
ASSIGNMENT JOB SHARE INDICATOR  SJOS  Job Sharer
EMPLOYMENT HISTORY ORGANISATION JOINING DATE  SLHD  Joining Organisation Date
ESR: Latest Start Date
EMPLOYMENT HISTORY ORGANISATION JOINING DATE  SLHD  Joining Organisation Date
ESR: Latest Start Date
ASSIGNMENT LAST WORKING DATE  SLWD  Last Working Day
ASSIGNMENT LAST WORKING DATE  SLWD  Last Working Day
EMPLOYEE ORGANISATION LENGTH OF SERVICE  SLEN  Length of Service with an Employing Organisation (Derived)
EMPLOYEE ORGANISATION LENGTH OF SERVICE  SLEN  Length of Service with an Employing Organisation (Derived)
EMPLOYEE NHS LENGTH OF SERVICE  SYRS  Length of Service with NHS (Derived)
EMPLOYEE NHS LENGTH OF SERVICE  SYRS  Length of Service with NHS (Derived)
POSITION VACANCY LENGTH OF TIME UNFILLED  SVLN  Length of Time Vacancy Unfilled (Derived)
POSITION VACANCY LENGTH OF TIME UNFILLED  SVLN  Length of Time Vacancy Unfilled (Derived)
POSITION INTERNATIONAL RECRUITMENT INDICATOR  SINT  Position Suitable for International Recruitment
POSITION INTERNATIONAL RECRUITMENT INDICATOR  SINT  Position Suitable for International Recruitment
POSITION STATUS CODE  SPSS  Position /Post Status (Derived)
POSITION STATUS CODE  SPSS  Position /Post Status (Derived)
POSTCODE  SPOC  Post Code
POSTCODE  SPOC  Post Code
ASSIGNMENT END DATE  SAED  Post Effective End Date
ESR: To (Assignment Effective End Date)
ASSIGNMENT END DATE  SAED  Post Effective End Date
ESR: To (Assignment Effective End Date)
EMPLOYMENT HISTORY LEAVING REASON CODE  SLGO  Reason for Leaving
EMPLOYMENT HISTORY LEAVING REASON CODE  SLGO  Reason for Leaving
EMPLOYMENT HISTORY RECRUITMENT SOURCE CODE  SSOU  Source of Recruitment
EMPLOYMENT HISTORY RECRUITMENT SOURCE CODE  SSOU  Source of Recruitment
HEADCOUNT STABILITY RATE (JOB ROLE IN REPORTING PERIOD)  SSHC  Stability Rate - Head Count (Derived)
HEADCOUNT STABILITY RATE (JOB ROLE IN REPORTING PERIOD)  SSHC  Stability Rate - Head Count (Derived)
HEADCOUNT STABILITY RATE (ORGANISATION IN REPORTING PERIOD) 
HEADCOUNT STABILITY RATE (STAFF GROUP IN REPORTING PERIOD) 
FTE STABILITY RATE (JOB ROLE IN REPORTING PERIOD)  SSWE  Stability Rate- WTE (Derived)
FTE STABILITY RATE (JOB ROLE IN REPORTING PERIOD)  SSWE  Stability Rate- WTE (Derived)
FTE STABILITY RATE (ORGANISATION IN REPORTING PERIOD) 
FTE STABILITY RATE (STAFF GROUP IN REPORTING PERIOD) 
STAFF GROUP STANDARD HOURS  SGHR  Standard Hours for Grade
STAFF GROUP STANDARD HOURS  SGHR  Standard Hours for Grade
STAFF GROUP STANDARD SESSIONS      
STAFF GROUP STANDARD SESSIONS      
START DATE (ASSIGNMENT PAYSCALE)  SGSD  Start Date in Grade
START DATE (ASSIGNMENT PAYSCALE)  SGSD  Start Date in Grade
EMPLOYMENT HISTORY NHS JOINING DATE (FIRST)  SSTD  Start Date in NHS
ESR: NHS Entry Date
EMPLOYMENT HISTORY NHS JOINING DATE (FIRST)  SSTD  Start Date in NHS
ESR: NHS Entry Date
EMPLOYEE LENGTH OF TIME IN POSITION  STER  Time in Post (Derived)
EMPLOYEE LENGTH OF TIME IN POSITION  STER  Time in Post (Derived)
HEADCOUNT TURNOVER RATE (ORGANISATION IN REPORTING PERIOD)  STUR  Turnover Rate - Head Count (Derived)
HEADCOUNT TURNOVER RATE (ORGANISATION IN REPORTING PERIOD)  STUR  Turnover Rate - Head Count (Derived)
HEADCOUNT TURNOVER RATE (FTE IN REPORTING PERIOD)  STOR  Turnover Rate- WTE (Derived)
HEADCOUNT TURNOVER RATE (FTE IN REPORTING PERIOD)  STOR  Turnover Rate- WTE (Derived)
ASSIGNMENT TYPE CODE  STYP  Type of Appointment
ESR: Employee Category
ASSIGNMENT TYPE CODE  STYP  Type of Appointment
ESR: Employee Category
EMPLOYMENT CONTRACT TYPE CODE  STCO  Type of Contract
ESR: Assignment Category
EMPLOYMENT CONTRACT TYPE CODE  STCO  Type of Contract
ESR: Assignment Category
EMPLOYMENT CONTRACT SESSION TYPE CODE  STSS  Type of Session
EMPLOYMENT CONTRACT SESSION TYPE CODE  STSS  Type of Session
POSITION VACANCY END DATE  SVED  Vacancy End Date
ESR: To (Vacancy Date)
POSITION VACANCY END DATE  SVED  Vacancy End Date
ESR: To (Vacancy Date)
POSITION VACANCY START DATE  SVSD  Vacancy Start Date
ESR: From (Vacancy Date)
POSITION VACANCY START DATE  SVSD  Vacancy Start Date
ESR: From (Vacancy Date)
POSITION VACANCY STATUS CODE  SVAS  Vacancy Status
POSITION VACANCY STATUS CODE  SVAS  Vacancy Status
POSITION VACANCY FTE  SDIF  Vacancy Whole Time Equivalent (WTE) (Derived)
ESR: Vacancy Full Time Equivalent (FTE)
POSITION VACANCY FTE  SDIF  Vacancy Whole Time Equivalent (WTE) (Derived)
ESR: Vacancy Full Time Equivalent (FTE)
POSITION VACANCY IDENTIFIER  SVAC  Vacant Position/Post
ESR Vacancy
POSITION VACANCY IDENTIFIER  SVAC  Vacant Position/Post
ESR Vacancy
POSITION WORKED FTE (REPORTING PERIOD)  SAHR  Worked Whole Time Equivalent (WTE) for Position (Derived)
POSITION WORKED FTE (REPORTING PERIOD)  SAHR  Worked Whole Time Equivalent (WTE) for Position (Derived)
POSITION FTE VARIANCE  SVAR  WTE Variance (Derived)
POSITION FTE VARIANCE  SVAR  WTE Variance (Derived)

top

CDS VERSION NHS003 AND 4 TYPE LIST  renamed from CDS VERSION NHS003 / 4 TYPE LIST
Change to Supporting Information: Changed Name

top

CHANGE MENU
Change to Supporting Information: Changed Description

top

CLINICAL CODING
Change to Supporting Information: Changed Description


top

CLINICAL CODING INTRODUCTION
Change to Supporting Information: Changed Description


top

DIAGRAMS INTRODUCTION
Change to Supporting Information: Changed Description

DIAGRAMS



The new generic dictionary is based on a small set of rationalised diagrams. The list of these diagrams is located on the left.

top

MAIN MENU
Change to Supporting Information: Changed Description


top

NHS TRUST MERGERS
Change to Supporting Information: Changed Description

GUIDANCE ON NHS TRUST MERGERS AND THE CONCLUSION OF HOSPITAL PROVIDER SPELLS

Introduction
  1. This guidance explains the circumstances under which Hospital Provider Spells should close and reopen as a result of a merger or demerger, in terms of NHS data standards. It specifies which codes should be used for those Hospital Provider Spells which must be closed and reopened,

    Note that the NHS-wide Clearing Service (NWCS) has also issued Guidance Note NWCS/GN-003 which explains the use of NWCS Exchange Protocols when NHS Trusts merge.

When Hospital Provider Spells Should be Closed and Reopened
  1. A Hospital Provider Spell is provided by one ORGANISATION acting as a Health Care Provider. This means that the spell is linked to the ORGANISATION CODE of the provider. If the ORGANISATION CODE changes, the spell must end and another begin with the new ORGANISATION CODE. If the spell does end, the Consultant Episode (Hospital Provider) within the spell must also end.

    The following scenarios explain what this means in terms of NHS Trust mergers or demergers. Note that these assume that nothing changes other than the fact that the NHS Trusts merge or demerge, e.g. the CONSULTANT stays the same, etc.

Mergers
  1. Trust A merges with Trust B to produce Trust C, which has a new ORGANISATION CODE. The ORGANISATION CODE will change for both Trust A and B. Therefore Hospital Provider Spells in both Trust A and B should close, and new spells should be opened using the new ORGANISATION CODE for Trust C.
  2. Trust A merges with Trust B to produce an ORGANISATION which uses Trust A's ORGANISATION CODE. For those Hospital Provider Spells in Trust A, the ORGANISATION CODE will not change. Therefore Trust A's Hospital Provider Spells should not be closed just as a result of the merger. However, for Trust B the ORGANISATION CODE will change. Therefore Hospital Provider Spells in Trust B should close, and new spells should be opened using the new ORGANISATION CODE for Trust A.
Demergers
  1. Trust A splits into Trust B and Trust C, both of which have a new ORGANISATION CODE. The ORGANISATION CODE will change for both Trust B and C. Therefore all Hospital Provider Spells in Trust A should close, and new spells should be opened in Trust B and C using the new ORGANISATION CODES for each.
  2. Trust A splits into Trust B and C. Trust B retains Trust A's ORGANISATION CODE and Trust C is issued with a new one. The ORGANISATION CODE for Hospital Provider Spells in Trust A which are taken over by Trust B will not change. Therefore they should not be closed just as a result of the merger. However, Trust A's Hospital Provider Spells which are taken over by Trust C should close, and new spells should be opened using the new ORGANISATION CODE for Trust C.
The Codes Used when Hospital Provider Spells are Closed and Reopened
  1. If Hospital Provider Spells are to be closed and reopened only as a result of NHS Trust mergers or demergers, for most cases the codes below should be used.
The CLOSED Hospital Provider Spell

DISCHARGE DESTINATIONS

This depends on the type of WARD the PATIENT is in, but will be either:

51     NHS Hospital Provider - WARD for general PATIENTS or the younger physically disabled

52     NHS Hospital Provider - WARD for maternity PATIENTS or neonates

53     NHS Hospital Provider - WARD for PATIENTS who are mentally ill or have learning disabilities

DISCHARGE METHOD

1     PATIENT discharged on clinical advice or with clinical consent

The REOPENED Hospital Provider Spell

ADMISSION METHOD

81     Transfer of any admitted PATIENT from other Hospital Provider other than in an emergency

Note that this ADMISSION METHOD is classed under "Other Admission". It is not elective and the PATIENT does therefore not have an entry on an Elective Admission List.
SOURCE OF ADMISSION

Again, this depends on the type of WARD the PATIENT is in, but will be either:

51     NHS Hospital Provider - WARD for general PATIENTS or the younger physically disabled or Accident And Emergency Department

52     NHS Hospital Provider - WARD for maternity PATIENTS or neonates

53     NHS Hospital Provider - WARD for PATIENTS who are mentally ill or have learning disabilities

REFERRER CODE

This will be the referrer to the Hospital Provider Spell within which the PATIENT was receiving care before the merger, i.e. the "original" Hospital Provider Spell.

top

PUBLICATION INFORMATION CONTACT DETAILS
Change to Supporting Information: Changed Description

CONTACT DETAILS

  1. General Enquiries about the NHS Data Model and Dictionary:

    NHS Data Model and Dictionary Service
    NHS Connecting for Health
    Princes Exchange
    Princes Square
    Leeds
    LS1 4HY

    Email: datastandards@nhs.net

    NHS Data Model and Dictionary Service Website:

    Internet: http://www.connectingforhealth.nhs.uk/systemsandservices/data/datamodeldictionary

  2. The NHS Information Standards Board:

    The NHS Information Standards Board
    NHS Connecting for Health
    Princes Exchange
    Princes Square
    Leeds
    LS1 4HY

    Internet: http://www.isb.nhs.uk/

  3. Hospital Episode Statistics (HES):

    Website: HES online

    Queries: HES queries

  4. Clinical Coding general enquiries:

    International Classification of Diseases (ICD-10)
    Classification of Surgical Operations and Procedures Fourth Revision Consolidated Version (OPCS-4);
    Clinical Terms (The Read Codes);
    Clinical Coding Products:

    For all general enquiries, contact:

    NHS Connecting for Health
    Data Standards and Products Help Desk
    E-mail: datastandards@nhs.net

    • Electronic copies of International Classification of Diseases (ICD-10) Volumes 1, 2 and 3;
      • The ICD-10 metadata file and its specification;
      • The ICD-10 Codes and Titles (on diskette);
      • The ICD-10 Tables of Equivalence (on diskette);
    • The Alphabetical Index of Classification of Surgical Operations and Procedures (Fourth Revision Consolidated Version (OPCS-4) in hard copy;
      • Electronic format of Index and Tabular List of OPCS-4;
      • OPCS-4 metadata file and its specification;
    • The Clinical Terminology Browser is released every six months (March and September) and distributed on CD-ROM;
    • Clinical Terms (The Read Codes) is released to licensees every six months (March and September) as flat ASCII files and distributed on CD-ROM.

    Hard copy versions of ICD-10 and the Tabular List of OPCS-4 are available from The Stationery Office (formerly HMSO).

  5. Clinical Coding general enquiries:

    International Classification of Diseases (ICD-10)
    Classification of Surgical Operations and Procedures Fourth Revision Consolidated Version (OPCS-4);
    Clinical Terms (The Read Codes);
    SNOMED CT® (Systematised Nomenclature of Medicine Clinical Terms)

    For all general enquiries, contact:

    NHS Connecting for Health
    Data Standards and Products Help Desk
    E-mail: datastandards@nhs.net

    • Electronic copies of International Classification of Diseases (ICD-10) Volumes 1, 2 and 3;
      • The ICD-10 metadata file and its specification;
      • The ICD-10 Codes and Titles (on diskette);
      • The ICD-10 Tables of Equivalence (on diskette);
    • The Alphabetical Index of Classification of Surgical Operations and Procedures (Fourth Revision Consolidated Version (OPCS-4) in hard copy;
      • Electronic format of Index and Tabular List of OPCS-4;
      • OPCS-4 metadata file and its specification;
    • Clinical Terms (The Read Codes) and SNOMED CT® (Systematised Nomenclature of Medicine Clinical Terms) are released to licensees every six months (March and September) via the Terminology Reference Data Update Distribution Service (TRUD). 

    Information on the Terminology Reference Data Update Distribution Service (TRUD) can be found at: https://www.uktcregistration.nss.cfh.nhs.uk/trud/.

    Hard copy versions of ICD-10 and the Tabular List of OPCS-4 are available from The Stationery Office (formerly HMSO).

  6. NHS Administrative Codes:

    The National Administrative Codes Service of NHS Connecting for Health:

    General enquiries to NACS should be addressed to:

    Help Desk
    National Administrative Codes Service
    Hexagon House
    Pynes Hill
    Rydon Lane
    Exeter
    Devon EX2 5SE

    exeter.helpdesk@nhs.net
    Tel: 01392 206 248

    National Administrative Codes Service Website:

    Internet: http://www.connectingforhealth.nhs.uk/systemsandservices/data/standards/nacs/index_html

  7. Postcodes:

    Postcode and Geographic Area Queries
    All Fields Postcode Directory
    Areas of Residence Classification
    NHS Organisation Manual
    1991 Frozen Postcode File
    Communal Establishment File

    Tel: 01329 813243 or 813477
    Fax: 01329 813383
    e-mail: ons.geography@ons.gov.uk
    Internet: http://www.statistics.gov.uk

    ONS Geography Customer Services Unit
    Office for National Statistics
    Segensworth Road
    Titchfield
    Fareham
    Hants
    PO15 5RR

top

REFERENCED ORGANISATIONS MENU
Change to Supporting Information: Changed Description

Organisations

Referenced Organisations

top

WHAT'S NEW: AUGUST 2008
Change to Supporting Information: Changed Description

 

Release: August 2008

DSCNs Incorporated into the NHS Data Model and Dictionary:

  • CP861 (Immediate) - DSCN 16/2008 Central Return:  Hospital and Community Services Complaints and General Practice (including Dental) Complaints - KO41(a) and KO 41(b)
  • CP964 (Immediate) - DSCN 14/2008 Central Return: 18 Weeks ‘Adjusted’ Referral to Treatment (RTT) Dataset
  • CP965 (Immediate) - DSCN 13/2008 Data Standards: Organisation Data Service (ODS) - Change to the Default Codes Set to Support Changes to GMS Contract
  • CP879 (Immediate) - DSCN 12/2008 Data Standards: Quarterly Monitoring: Cancelled Operations Data Set (QMCO)

Release: May 2008

DSCNs Incorporated into the NHS Data Model and Dictionary:

  • CP502 (Immediate) - DSCN 10/2008 Data Standards: National Workforce Data Definitions (v2.0)
  • CP910 (1 April 2008) - DSCN 08/2008 Data Standards: National Direct Access Audiology Patient Tracking List (PTL) and Waiting Times (WT) data sets
  • CP900 (Immediate) - DSCN 07/2008 Data Standards: Inter-Provider Transfer Administrative Minimum Data Set
  • CP934 (1 April 2008) - DSCN 06/2008 Data Standards: Mental Health Minimum Data Set (version 3.0)
  • CP935 (Immediate) - DSCN 05/2008 Data Standards: 18 Weeks Rules Suite
  • CP925 (1 September 2008) - DSCN 04/2008 Genitourinary Medicine Clinic Activity Data Set Change to an Information Standard
  • CP942 (1 June 2008) - DSCN 03/2008 General Practice and General Medical Practitioner (GMP) - changes resulting from the introduction of the General Medical Services (GMS) Contract)

Release: February 2008

DSCNs Incorporated into the NHS Data Model and Dictionary:

  • CP812 (Immediate) - DSCN 01/2008 Central Return: Diagnostics Waiting Times Census Data Set
  • CP881 (31 December 2007) - DSCN 42/2007 Central Return: Referral To Treatment Summary Patient Tracking List
  • CP904 (Immediate) - DSCN 41/2007 Data Standards: Admission Intended Procedure Update
  • CP824 (1 February 2008) - DSCN 39/2007 Data Standards: 48 Hour Genitourinary Medicine Access Monthly Monitoring (GUMAMM)

Release: November 2007

DSCNs Incorporated into the NHS Data Model and Dictionary:

  • CP919 (Immediate) - DSCN 38/2007 Data Standards: Mental Health Minimum Data Set Schema
  • CP814 (1 April 2008) - DSCN 37/2007 Data Standards: Introduction of Mental Health Minimum Data Set version 2.1
  • CP930 (31 December 2007) - DSCN 35/2007 Data Standards: A correction to the version 6 Commissioning Data Set schema
  • CP834 (Immediate) - DSCN 34/2007 Data Standards: Referral Request Received Date
  • CP875 (Immediate) - DSCN 33/2007 Data Standards: National Administrative Codes Service: Introduction of codes for the new Pan SHAs
  • CP880 (Immediate) - DSCN 29/2007 Data Standards: Amendments to Doctor Index Number (DIN) Description

Release: August 2007

DSCNs Incorporated into the NHS Data Model and Dictionary:

  • CP845 (Immediate) - DSCN 28/2007 Data Standards: Treatment Function Code (Referral to Treatment Period)
  • CP831 (1 October 2007) - DSCN 27/2007 Data Standards: Update to Commissioning Data Set XML Schema v5
  • CP825 (1 October 2007) - DSCN 16/2007 Data Standards: Source of Referral for Outpatients (18 Weeks)

Release: June 2007

DSCNs Incorporated into the NHS Data Model and Dictionary:

  • CP799 (31 December 2007) - DSCN 18/2007 Data Standards: Introduction of Commissioning Data Set Version 6
  • CP833 (Immediate) - DSCN 17/2007 Data Standards: Introduction of Commissioning Data Set validation table
  • CP801 (Immediate) - DSCN 15/2007 Data Standards: Cover of Vaccination Evaluated Rapidly (COVER) Return

Release: May 2007

DSCNs Incorporated into the NHS Data Model and Dictionary:

  • CP800 (31 December 2007) - DSCN 14/2007 Commissioning Data Set Schema Version 6-0
  • CP856 (1 October 2007) - DSCN 13/2007 Data Standards: Discharge Ready Date
  • CP869 (Immediate) - DSCN 12/2007 Data Standards: Update to Clinical Coding Introduction
  • CP827 (1 October 2007) - DSCN 09/2007 Data Standards: Earliest Reasonable Offer Date
  • CP817 (1 October 2007) - DSCN 08/2007 Data Standards: Introduction of Age into Commissioning Data Sets
  • CP849 (May 2007) - DSCN 07/2007 National Administrative Codes Service: Introduction of new identification codes for Dental Consultants
  • CP822 (Immediate) - DSCN 06/2007 Data Standards: Update to Organisation Codes
  • CP850 (Immediate) - DSCN 05/2007 National Administrative Codes Service: Amendments to Default Codes
  • CP786 (1 April 2007) - DSCN 04/2007 Quarterly Monitoring Accident and Emergency Services (QMAE) Central Return

Release: February 2007

DSCNs Incorporated into the NHS Data Model and Dictionary:

  • CP811 (Immediate) - DSCN 03/2007 Diagnostic Waiting Times and Activity
  • CP826 (1 October 2007) - DSCN 02/2007 Extension of Treatment Function to Support the Measurement of 18 Week Referral to Treatment Periods
  • CP813 (1 April 2007) - DSCN 01/2007 Paediatric Critical Care Minimum Data Set
  • CP768 (1 January 2007) - DSCN 18/2006 Changes to the NHS Data Dictionary to support the measurement of 18 week referral to treatment periods
  • CP798 (6 November 2006) - DSCN 19/2006 Commissioning Data Set (CDS) Version 5 XML Message Schema

Release: September 2006

DSCNs Incorporated into the NHS Data Model and Dictionary:

  • CP795 (31 October 2006) - DSCN 22/2006 Organisation Codes / Organisation Site Codes
  • CP792 (1 April 2007) - DSCN 15/2006 Neonatal Critical Care
  • CP719 (1 April 2006) - DSCN 09/2006 Measuring and Recording of Waiting Times
  • CP791 (1 April 2007) - DSCN 13/2006 Priority Type
  • CP774 (1 September 2006) - DSCN 12/2006 Person Marital Status

Release: May 2006

DSCNs Incorporated into the NHS Data Model and Dictionary:

  • CP764 (1 April 2006) - DSCN 08/2006 Diagnostics waiting times and activity
  • Correction to menu structure to include Critical Care Minimum Data Set

Release: April 2006

DSCNs Incorporated into the NHS Data Model and Dictionary:

  • CP608 (1 October 2006) - DSCN 07/2006 Introduction of Commissioning Data Set Version 5 and its associated XML schema into the NHS Data Dictionary.
  • CP756 (1 September 2005) - DSCN 19/2005 PbR Commissioning for Out of Area Treatments (OATs) and Charge-Exempt Overseas Visitors
  • CP724 (1 April 2006) - DSCN 13/2005 Critical Care Minimum Data Set
  • CP754 (1 April 2006) - DSCN 17/2005 Treatment Function and Main Specialty Code Revisions
  • CP763 (1 April 2006) - DSCN 20/2005 New Treatment Functions for therapy services and anticoagulant service
  • CP767 (Immediate) - DSCN 02/2006 Referral Request Received Date
  • CP690 (1 September 2005) - DSCN 16/2005 Marital Status

Release: August 2005

DSCNs Incorporated into the NHS Data Model and Dictionary:

  • CP555 (1 April 2005) - DSCN 11/2005 Data Standards: COVER - Hepatitis B immunisation for babies
  • CP715 (Immediate) - DSCN 10/2005 Data Standards: Treatment Function Codes - correction and clarification of names and descriptions
  • CP706 (1 April 2005) - DSCN 09/2005 Data Standards: Cancer Registration Data Set
  • CP691 (1 July 2005) - DSCN 06/2005 Data Standards: NSCAG Commissioner Code

NHS Data Model and Dictionary: Change Menu

Data Set Change Notice (DSCN) Website

top

CONSULTANT CODE
Change to Attribute: Changed Description

A code uniquely identifying a CONSULTANT.

The CONSULTANT CODE is derived from either the GENERAL MEDICAL COUNCIL (GMC) NUMBER for GENERAL MEDICAL PRACTITIONERS, or the GENERAL DENTAL COUNCIL NUMBER for GENERAL DENTAL PRACTITIONERS (where the dentist doesn't have a GENERAL MEDICAL COUNCIL (GMC) NUMBER).

If the CONSULTANTS GENERAL MEDICAL COUNCIL (GMC) NUMBER is known, the CONSULTANT CODE is the GENERAL MEDICAL COUNCIL (GMC) NUMBER prefixed with "C".For GENERAL MEDICAL PRACTITIONERS working as CONSULTANTS, the GENERAL MEDICAL PRACTITIONER's GENERAL MEDICAL COUNCIL (GMC) NUMBER should be used, see data item note for GENERAL MEDICAL PRACTITIONER (SPECIFIED).

If the CONSULTANTS GENERAL MEDICAL COUNCIL (GMC) NUMBER is not known, then their CONSULTANT CODE is the GENERAL DENTAL COUNCIL NUMBER prefixed with "CD".For GENERAL DENTAL PRACTITIONERS, working as CONSULTANTS, the GENERAL MEDICAL COUNCIL (GMC) NUMBER should be used, prefixed with "C".

Where a Dental CONSULTANT doesn't have a GENERAL MEDICAL COUNCIL (GMC) NUMBER, the GENERAL DENTAL COUNCIL NUMBER should be used, prefixed with "CD".

For Dental CONSULTANTS, where the GENERAL MEDICAL COUNCIL (GMC) NUMBER or GENERAL DENTAL COUNCIL NUMBER is not known, the default code should be used.

Note: There are some overseas-qualified dentists who are not fully registered with the General Dental Council but enjoy what is called "Temporary Registration". These dentists are not currently in the scope of the Dental Consultant codes file published by the National Administrative Codes Service (NACS) and will not be included.

Consultant Code format


Practitioner
Code Type

Character Position

Allocated
By

Allocated
To

Known
As

Notes

1

 

2

 

3

 

4

 

5

 

6

 

7

 

8

 
Hospital Consultant C 0-9 0-9 0-9 0-9 0-9 0-9 0-9 Health and Social Care Information Centre  Hospital Consultants in England and Wales Consultant Code Derived from General Medical Council number, prefixed with a C
Dental Consultant C D 0-9 0-9 0-9 0-9 0-9 0-9 Health and Social Care Information Centre  Dental Consultants in England and Wales Dental Consultant Code Derived from General Dental Council number, prefixed with CD.
Note that General Dental Council number vary in length.
Filling zeros are used between the prefix and General Dental Council number, where required, to maintain total length of 8 characters
For NHS PATIENTS treated overseas, the commissioner of the overseas treatment is responsible for assuring that the overseas doctor is provided with a GENERAL MEDICAL COUNCIL (GMC) NUMBER.

For NHS PATIENTS treated overseas, the commissioner of the overseas treatment is responsible for assuring that the overseas doctor is provided with a GENERAL MEDICAL COUNCIL (GMC) NUMBER. In the case of overseas doctors the default code C9999998 should only be used where no GENERAL MEDICAL COUNCIL (GMC) NUMBER has been assigned.

All Midwife Episodes are identified in the Admitted Patient Care Commissioning Data Set (CDS) and Hospital Episode Statistics (HES) by a pseudo MAIN SPECIALTY CODE, 560, see Main Specialty and Treatment Function Codes. A default code is used in the CONSULTANT CODE field to show that a MIDWIFE is the responsible professional. Note that the midwife's own code is not used.

All Nursing Episodes are identified in the Admitted Patient CDS and HES by a pseudo MAIN SPECIALTY CODE, 950, see Main Specialty and Treatment Function Codes.All Nursing Episodes are identified in the Admitted Patient Commissioning Data Set and Hospital Episode Statistics by a pseudo MAIN SPECIALTY CODE, 950, see Main Specialty and Treatment Function Codes. A default code is used in the CONSULTANT CODE field to show that a NURSE is the responsible professional. Note that the nurse's own Nursing and Midwifery Council code is not used. Note that the NURSE's own Nursing and Midwifery Council code is not used.

 

top

AMOUNT STERLING
Change to Data Element: Changed linked Attribute

AMOUNT STERLING
 
Attribute:
CURRENCY TYPE
There are no data links on this item.

top

CONSULTANT CODE
Change to Data Element: Changed Description

Format/length: an8
HES item: CONSULT
National Codes:  
Default Codes: C9999998 - Consultant, General Medical Council (GMC) number not known
  CD999998 - Dental Consultant: General Medical Council (GMC) number/ General Dental Council (GDC) number not known
  D9999998 - Dentist, Dental Practice Board (DPB) number not known
  M9999998 - Midwife
  N9999998 - Nurse
  H9999998 - Other health care professional

Notes:
This is the GENERAL MEDICAL COUNCIL (GMC) NUMBER for the CONSULTANT. For GENERAL MEDICAL PRACTITIONERS working as CONSULTANTS, the GENERAL MEDICAL PRACTITIONER's GENERAL MEDICAL COUNCIL (GMC) NUMBER should be used, see data item note for GENERAL MEDICAL PRACTITIONER (SPECIFIED). For NHS PATIENTS treated overseas, the commissioner of the overseas treatment is responsible for assuring that the overseas doctor is provided with a GENERAL MEDICAL COUNCIL (GMC) NUMBER. In the case of overseas doctors the default code C9999998 should only be used where no GENERAL MEDICAL COUNCIL (GMC) NUMBER has been assigned.For GENERAL DENTAL PRACTITIONERS, working as CONSULTANTS, the GENERAL MEDICAL COUNCIL (GMC) NUMBER should be used, prefixed with "C".

Where a Dental CONSULTANT doesn't have a GENERAL MEDICAL COUNCIL (GMC) NUMBER, the GENERAL DENTAL COUNCIL NUMBER should be used, prefixed with "CD".Notes:

For Dental CONSULTANTS, where the GENERAL MEDICAL COUNCIL (GMC) NUMBER or GENERAL DENTAL COUNCIL NUMBER is not known, the default code should be used.This is the same as attribute CONSULTANT CODE.

All Midwife Episodes and attendances are identified in the Commissioning Data Sets and Hospital Episode Statistics by a pseudo MAIN SPECIALTY CODE, 560, see Main Specialty And Treatment Function Codes. A default code is used in the CONSULTANT CODE field to show that a MIDWIFE is the responsible professional. Note that the MIDWIFE's own code is not used.

All Nursing Episodes and attendances are identified in the Commissioning Data Sets and Hospital Episode Statistics by a pseudo MAIN SPECIALTY CODE, 950, see Main Specialty And Treatment Function Codes. A default code is used in the CONSULTANT CODE field to show that a NURSE is the responsible professional. Note that the NURSE's own Nursing and Midwifery Council code is not used.

 

top

CLASSES
Change to Package: New Package

 

top

CLASSES
Change to Package: New Package

A

ACCOMMODATION STATUS
ACTIVITY
ACTIVITY DATE TIME
ACTIVITY DRUG
ACTIVITY GROUP
ACTIVITY PRIORITY
ACTIVITY PROPERTY
ACTIVITY RELATIONSHIP
ACTIVITY SUSPENSION
ADDRESS
ADDRESS ASSOCIATION
ADDRESS IN GEOGRAPHIC AREA
ADDRESS STRUCTURED
ADDRESS UNSTRUCTURED
ADMINISTRATIVE CATEGORY
ADMINISTRATIVE CATEGORY PERIOD
ALCOHOL STATUS
ANAESTHETIC OR ANALGESIC
APPOINTMENT
APPOINTMENT OFFER
APPOINTMENT SLOT
APPOINTMENT WAITING LIST
APPRAISAL REVIEW
AREA OF WORK
ASPIRIN THERAPY LOCATION
ASSIGNMENT
ASSIGNMENT PAYSCALE POINT

top

DATA FIELD NOTES
Change to Package: Changed Description, Aliases

 

top

DATA FIELD NOTES
Change to Package: Changed Description, Aliases

A

ABSENCE WITHOUT LEAVE END DATE
ABSENCE WITHOUT LEAVE END REASON (LAST)
ABSENCE WITHOUT LEAVE START DATE
ABSENCE WITHOUT LEAVE TOTAL
ABSENCE WITHOUT LEAVE TOTAL DAYS
ACCIDENT AND EMERGENCY ADMISSION TOTAL PER WAIT BAND
ACCIDENT AND EMERGENCY ADMISSION NUMBER OF HOURS WAIT BAND
ACCIDENT AND EMERGENCY ATTENDANCE TOTAL
ACCIDENT AND EMERGENCY ATTENDANCE TOTAL PER WAIT BAND
ACCIDENT AND EMERGENCY ATTENDANCE NUMBER OF HOURS WAIT BAND
ACCIDENT AND EMERGENCY DEPARTMENT TYPE TOTAL
ACCIDENT AND EMERGENCY DIAGNOSIS - FIRST
ACCIDENT AND EMERGENCY DIAGNOSIS - SECOND
ACCIDENT AND EMERGENCY FIRST ATTENDANCE TOTAL
ACCIDENT AND EMERGENCY FOLLOW-UP ATTENDANCE TOTAL
ACCIDENT AND EMERGENCY INVESTIGATION - FIRST
ACCIDENT AND EMERGENCY INVESTIGATION - SECOND
ACCIDENT AND EMERGENCY TREATMENT - FIRST
ACCIDENT AND EMERGENCY TREATMENT - SECOND
ACCOMMODATION STATUS (MENTAL HEALTH)
ACTIVITY DATE (CRITICAL CARE)
ADDRESS FORMAT CODE
ADDRESS FORMAT CODE (MOTHER)
A and E ARRIVAL MODE
A and E ATTENDANCE CATEGORY
A and E ATTENDANCE CONCLUSION TIME
A and E ATTENDANCE DISPOSAL
A and E ATTENDANCE NUMBER
A and E DEPARTMENT TYPE
A and E DEPARTURE TIME
A and E INCIDENT LOCATION TYPE
A and E INITIAL ASSESSMENT TIME
A and E PATIENT GROUP
A and E STAFF MEMBER CODE
A and E TIME SEEN FOR TREATMENT

top

DATA FIELD NOTES
Change to Package: Changed Description, Aliases

  • Changed Description
  • Alias Changes
    Name Old Value New Value
    shortname Data Elements Data Element
    plural   Data Elements

top

DOSEARCH
Change to Binary: Changed changed element type

  • null

top

NHSDD FIX CSS1
Change to Binary: Changed attached binary file

top

SEARCH
Change to Binary: Changed changed element type

  • null

top

For enquiries, contact datastandards@nhs.net