Practitioner Membership data conveys the details of the associations/relationships between practitioners and organisations they work for. There are different membership types for the different types of practitioner data ODS publish. Note that membership start and end dates are not always available due to limitations in the raw data received by ODS.
The scope of this dataset is set by data in the Practitioner table, and those parent organisation who are present in the Organisation table.
|
Master Data Attribute (ODS Internal Reference) |
Source Type | Length | Nullable | Description |
Mapping to ODS Data Search & Export field (excluding predefined reports) |
Mapping to ORD API (ORD schema containers, elements and attributes) |
Mapping to ODS STU3 API |
Mapping to ODS FHIR R4 API Please refer to ODS FHIR R4 Implementation Guide and the OAS Specification |
|
| ODS Practitioner CodeSystem | ODS Prescriber Relationship Instance CodeSystem | ||||||||
| UniquePractitionerMembershipID | [nvarchar] | 255 | NOT NULL |
PractitionerID&_&_ParentOrganisationCode&_&JoinParentOrganisationDate
to create a unique membership ID
(accommodating practitioners leaving and
then rejoining the same practice etc) for
GPs and PCDPs For Consultants, where no JoinParentOrganisationDate is available: PractitionerID_&_ParentOrganisationCode |
Not available | Not available | Not available | Not available |
concept.code concept.display |
| PractitionerID | [nvarchar] | 12 | NOT NULL | Only available via Pre Defined reports that replicate the legacy ODS practitioner csv files - if relevant | Not available | Not available | Not available | property.practitionerCode.Coding | |
| PractitionerMembershipTypeCode | [nvarchar] | 20 | NOT NULL | ME1, ME2, ME3, ME4, ME5 | Only available via Pre Defined reports that replicate the legacy ODS practitioner csv files - if relevant | Not available | Not available | ?? | Not available |
| PractitionerMembershipTypeName | [nvarchar] | 255 | NOT NULL | ME1 = General Medical Practice Membership, ME2 = Private Controlled Drug Prescriber Membership, ME3 = Hospital Consultant Membership, ME4 = Dental Consultant Membership, ME5 = Nurse Prescriber Membership | Only available via Pre Defined reports that replicate the legacy ODS practitioner csv files - if relevant | Not available | Not available | Not available | Not available |
| ParentOrganisationCode | [nvarchar] | 12 | NOT NULL | Only available via Pre Defined reports that replicate the legacy ODS practitioner csv files - if relevant | Not available | Not available | property.[typeCode] = parentOrganisationCode (active only) | property.orgCode.Coding | |
| JoinParentOrganisationDate | [nvarchar] | 8 | NULL | Only available for General Practitioner (prescriber codes) to GP Practice relationships. | Only available via Pre Defined reports that replicate the legacy ODS practitioner csv files - if relevant | Not available | Not available | Not available | property.joinDate |
| LeftParentOrganisationDate | [nvarchar] | 8 | NULL | Only available for General Practitioner (prescriber codes) to GP Practice relationships. | Only available via Pre Defined reports that replicate the legacy ODS practitioner csv files - if relevant | Not available | Not available | Not available | property.leftDate |
| Status | [nvarchar] | 20 | NULL | Active, Inactive (based on LeftParentOrganisationDate for GPs, Nurse Prescribers and PCDPs - all Consultant records will be 'Active' by default due to the source data being a snapshot of active records only) | Only available via Pre Defined reports that replicate the legacy ODS practitioner csv files - if relevant | Not available | Not available | Not available | property.status |
| *Legacy fields: | Nurse Prescriber - Sub ICB Location to be inherited from parent practice postcode (maps to legacy csv field' current care organisation code' and 'current care org name'). | ||||