Accurate data, minor issues:

Status without associated dates / Some PCC codes duplicate with ODS code (such as PCNs) / No address validation at source

All practices coded.

All start dates set to 1974 regardless as start dates not provided in raw data.

Raw data is provided as a snapshot - which leads to dropped records. ODS has to apply end dates in this scenario. 

ODS have to validate/amend address data.

NI Boards have to be added by ODS.

1

[OrganisationCode]

Organisation Code

2

[OrgName]

Name

3

[NHSER_code]

National Grouping

Change from Legacy csv: Now derived from a dynamic mapping of the organisation postcode to the NHS Postcode Directory (Health and Care boundary data). Previously, this value was derived from the parent/commissioner. This is a data improvement as the geography is now purely based on the practice postcode, not the commissioner.

4

[ICB_code]

High Level Health Geography

Change from Legacy csv: Now derived from a dynamic mapping of the organisation postcode to the NHS Postcode Directory (Health and Care boundary data). Previously, this value was derived from the parent/commissioner. This is a data improvement as the geography is now purely based on the practice postcode, not the commissioner.

5

[Address1]

Address Line 1

Change from Legacy csv: There are some address data differences between the legacy epraccur.csv file and the address data within contemporary tools for practice records. We have applied an extra level of address validation to improve data quality.

6

[Address2] 

Address Line 2

7

[Address3] 

Address Line 3

8

[Town]

Address Line 4

9

[County] 

Address Line 5

Change from legacy csv: As this is a legacy field, not populated for new addresses since 2018, this field within the ODS Data Search & Export tool (including pre defined reports) will not be populated.

Note that the value (where populated) is available via the FHIR Organization Resource in the address.district property.

10

[Postcode] 

Postcode

11

[LegalStartDate] 

Open Date

12

[LegalEndDate] 

Close Date

13

[StatusName]

Status

Change from Legacy csv: Previously populated with single character: A (Active), C (Closed), D (Dormant) or P (Proposed). Now the status name/description is provided in full.

Note that if using the FHIR R4 API, the Dormant and Proposed statuses need to be retrieved from the Organization or AdditionalAttributes CodeSystem.

14

[Primary Role / OrgTypeID]

Organisation Sub-Type Code

Change from Legacy csv: Set as “B” if the record has an active/latest RE6 (as per field 24) relationship, or “Z” if not.

15

[TargetOrgCode]

Commissioner

Target organisation code for the RE4 'is commissioned by' relationship to the Sub ICB Location – Where LegalEndDate is null, or where the relationship LegalEndDate is equal to the organisation LegalEndDate (no change in how this field is derived).

See further notes in Data Description section above re how this value is derived from the source data.

16

[LegalStartDate]

Join Provider/Purchaser Date

RE6 'is operated by' relationship legal start date (Supporting Column 24)

17

[LegalEndDate]

Left Provider/Purchaser Date

RE6 'is operated by' relationship legal end date (Supporting Column 24)

18

[TelephoneNumber]

Contact Telephone Number

22

‘1’

Amended Record Indicator

Set to 1 for Report

24

[TargetOrgCode]

Provider/Purchaser

Can be derived from the RE6 'is operated by' relationship (if available) to an ISHP, LA, Trust or Sub ICB Location code – Where LegalEndDate is null, or where the relationship LegalEndDate is equal to the organisation LegalEndDate.  No change in how this field is derived. If no RE6 relationship is available this column will be NULL; as will columns 16 and 17.

Please note that this field will not be populated for Channel Islands or Isle of Man prescribing cost centres.

There are a very small number of inactive English records that do not have a provider/purchaser populated, this is because the parent record was closed prior to the site record closing (i.e. the site had no parent at the point of closure).

26

[RoleID]

Prescribing Setting

Change from Legacy csv: Previously populated with a single character indicator, now populated with the corresponding non primary roleID, where there is a non primary role that is active or has a legal end date as equal to the organisation’s end date.  See mapping table below.

Note: The legacy prescribing setting “3 = WIC + OOH Practice” is broken down into two non-primary roles. In the ODS Data Search & Export pre defined report both non primary roles are presented as an array separated by pipes.