Data Description
This data contains names and identifying codes for Hospital Consultants employed by NHS Trusts in England. The codes are derived from the Practitioner’s General Medical Council code (GMC code), to which a ‘C’ prefix is added.
How Data is Maintained
Hospital Consultant information is provided once a month by the Workforce & Facilities team within the NHS England. The data is collated from an extract drawn from the Electronic Staff Record system (ESR).
*Users should note that as the extract is sourced from ESR, it will not include any consultants working for an organisation that does not use the system. This also limits the extracts to NHS organisations.
Key Information - Roles, Code Formats and Data Source
| Key Information | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Geographic coverage |
| ||||||||||||||||||
| Practitioner ID | General Medical Council code (GMC code) | ||||||||||||||||||
| Practitioner Type Code | PHOSPCON | Practitioner Type Name | Hospital Consultants | ||||||||||||||||
| Practitioner Role ID | PHOSPCON + SpecialtyCode | Practitioner Role Name | MAIN SPECIALTY CODE (datadictionary.nhs.uk) | ||||||||||||||||
| Specialty Code | MAIN SPECIALTY CODE (datadictionary.nhs.uk) | ||||||||||||||||||
| Raw Data Source | Workforce & Facilities team within the NHS Digital | Update Frequency | Monthly | ||||||||||||||||
| Code Format |
| ||||||||||||||||||
Permitted Relationships
Practitioner Membership | Membership Type Code | Relationship Type Name | Parent Organisation Type |
| ME3 | Hospital Consultant Membership | N/A |
Legacy .csv Field Mapping
eConcur.csv file
All records should contain PractitionerAttributeTypeID = 3 for “Hospital Consultant Code”.
Notes:
- If a consultant has more than one active ME3 (hospital consultant membership) relationship, there will be a record in this report for each of those memberships. This will mean the record looks like a duplication other than the ‘Location Organisation Code’.
- If the consultant has multiple active practitioner roles, these will be presented as an array separated by pipes.
- This report is a snapshot of the current active consultants in our data, hence why the status for most attributes needs to be Active.
Col | Data Item | Report Alias (Legacy csv) | Notes |
1 | [PractitionerAdditionalAttribute] | GMC Code | Where PractitionerAttributeTypeID = 6 (which is GMC code) and StatusName = ‘ACTIVE’. |
2 | [PractitionerID] | Practitioner Code | Where PractitionerAttributeTypeID = 3 (which is GNC code) and StatusName = ‘ACTIVE’ |
3 | [PractitionerName] | Practitioner Name | Change from legacy csv: Previously ‘Surname’. Surnames and initials have been concatenated for consistency across all practitioner types |
4 | NULL | Initials | Change from legacy csv: Previously ‘Initials’. Surnames and initials have been concatenated for consistency across all practitioner types |
5 | NULL | Sex | Change from legacy csv: Attribute still available in data model but not populated as raw data not reliable. Set to NULL for predefined report. |
6 | [RoleID] | Main Specialty Code | Change from legacy csv: Where a Practitioner currently performs more than one role/specialty (in the same organisation or in different organisations) these are presented as an array separated by pipes. Where role Status = ‘Active’ |
7 | NULL | Practitioner Type | Change from legacy csv: Previously universally populated with 'C', but this adds no value so is no longer present in the pre defined report. |
8 | [ParentOrganisationCode] | Location Organisation Code | ME3 Membership where ‘Status’ = Active |
9 | NULL | Column 9 | |
10 | NULL | Column 10 | |
11 | NULL | Column 11 | |
12 | NULL | Column 12 | |
13 | NULL | Column 13 |