Data Description
This data contains names and identifying codes for Dental Consultants employed by NHS Trusts in England. The codes are derived from the Practitioner’s General Dental Council code (GDC code), to which a ‘CD’ prefix is added. GDC numbers can vary in length from 3 to 6 characters, so in order to maintain a standard length of 8 characters (the same as medical consultant codes) filling zeros are used between the prefix and the GDC number, where required.
* Many consultants working in a dental specialty are also qualified doctors, and therefore have a GMC number in addition to their GDC number. In these cases, the consultants are allocated a Consultant Code (derived from their GMC number) and will also appear in the Hospital Consultant data. There are some dental consultants however, who do not have a GMC number. They are qualified purely in their dental specialty and only have a GDC number and will only be shown under the Dental Consultant data
How Data is Maintained
Dental 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 a number of (NHS) organisation types: NHS Trusts, Sub ICB Locations, Care Trusts and Special Health Authorities.
Key Information - Roles, Code Formats and Data Source
| Key Information | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Geographic coverage |
| ||||||||||||||||||
| Practitioner ID | General Dental Council - GDC codes | ||||||||||||||||||
| Practitioner Type Code | PDENTCON | Practitioner Type Name | Dental Consultants | ||||||||||||||||
| Practitioner Role ID | PDENTCON+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 |
| ME4 | Dental Consultant Membership | RO197 (NHS Trust) RO107 (Care Trust) |
Legacy .csv Field Mapping
eDconcur.csv file
All records should contain PractitionerAttributeTypeID = 4 for “Dental Consultant Code”.
Notes:
- If a consultant has more than one active ME4 (Dental 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] | GDC Code | General Dental Council code. Where PractitionerAttributeTypeID = 6 and where StatusName = ‘ACTIVE’ |
2 | [PractitionerID] | Practitioner Code | Where PractitionerAttributeTypeID = 4 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 | Location Organisation Code | ME4 Membership where ‘Status’ = Active | |
9 | NULL | Column 9 | |
10 | NULL | Column 10 | |
11 | NULL | Column 11 | |
12 | NULL | Column 12 | |
13 | NULL | Column 13 |