National Reference Files
National Reference files are a set of data files maintained by ISD primarily used in the validation of patient based data returns from NHS Boards. They are also used in health and social care operational systems across Scotland, for example, Administrative, Financial and Human Resource Systems.
Current National Reference files hold data on, for example, NHS locations, GP practices, consultants, specialties, ICD10 and OPCS4 classifications and are listed below. The Reference Files Team issue and maintain many of these codes and publish some on behalf of third parties.
Most of the files are updated on a daily basis, others are updated as required (e.g. Error_messages, GP_CHP etc).
For further information on Reference Files (or on downloading the files from the NHSnet) please contact the Reference Files team by e-mail on NSS.isdDIGReference@nhs.net .
For enquires regarding GP's, GP Practices or GP Branches, please get in touch with the Datamarts team by e-mail on NSS.email@example.com.
For all Reference file enquires from users of SCI Gateway please contact the SCI Gateway Helpdesk on 0141 282 2100. (email: NSS.NISGServiceDesk@nhs.net)
Updating Reference Files
If you would like to update consultant data, please click here and log in. If you need a username and password, please contact NSS.isdDIGReference@nhs.net or call one of these numbers - 0131 275 6265, 0131 275 6708 or 0131 275 6503.
Downloading the ISD SMR Data Reference files
NHSnet users can download the data files here
Click on the filename to download that file :
The Reference File search facility can be accessed here www.natref.scot.nhs.uk
A list of all current NHS hospitals in Scotland can be accessed here.
|REFFILES.zip||All 17 standard reference files||28/03/2017|
|REFFILES.zip||All 17 standard reference files for non-NHS users To gain access to these files, please fill in a confidentiality statement and return to NSS.isdDIGReference@nhs.net.||28/03/2017|
|clinfaci||Clinical facility - a room, suite of rooms or a vehicle equipped and available for clients/patients to receive health care.||Clinical Facility||28/03/2017|
|conspec||Consultants mapped to their valid specialties.||GMC/HCP No. to Specialty||28/03/2017|
|consprov||Consultants mapped to their valid providers.||GMC/HCP to Provider Code||28/03/2017|
|facility||Significant Facility - a type of clinical facility which is identified for clinical and/or costing purposes.||Significant Facility||28/03/2017|
|facrtype||Significant facilities mapped to SMR type.||Significant Facility to Record Type||28/03/2017|
|gpbranch||Scottish GP branch surgeries.||GP Branch||28/03/2017|
|gpprac||Scottish GP Practices.||Scottish GP Practices||28/03/2017|
|gpref||Scottish GP details.||GP Ref||28/03/2017|
|hcp||Health care professionals.||Health Care Professional No||28/03/2017|
|location||ISD locations.||Location Codes||28/03/2017|
|medden||Medical and dental staff.||Medical, Dental & GP GMC||28/03/2017|
|provlocs||Provider mapped to specialty mapped to location.||Provider to Location to Spec||28/03/2017|
|purchpro||Organisation codes.||Organisation Codes||28/03/2017|
|specfac||Specialties mapped to significant facilities.||Specialty to Significant Facility||28/03/2017|
|specrtyp||Specialties mapped to SMR type.||Specialty to Record Type||28/03/2017|
|ukgpprac||UK GP Practices.||Rest of UK GP Practices||28/03/2017|
|postcode||Full postcode (postcode only) file||28/03/2017|
|icd10||The International Statistical Classification of Diseases and Related Health Problems, Tenth Revision (ICD10).||ICD10||28/03/2017|
|ICD10v4||ICD10 file prior to version 5 updates in April 2016.||n/a||04/03/2016|
|opcs4||Office of Population Censuses and Surveys, Classification of Surgical Operations and Procedures (OPCS4 file version 4.7)||OPCS4||28/03/2017|
|gw_gpprac||GW gpprac file (for SCI Gateway use only). Holds updated HB cypher "G" or "H" for "old" Argyll & Clyde practices||28/03/2017|
|gw_hcp||GW Health Care professionals linked to GW-Specialties (for SCI Gateway use only)||28/03/2017|
|gw_hprov||Description for file gw_hprov||28/03/2017|
|gw_hspec||GW Health Care professionals linked to GW-Specialties (for SCI Gateway use only)||28/03/2017|
|gw_pls||GW_Provider/Location/Specialty file (for SCI Gateway use only)||28/03/2017|
|gw_specs||GW_Specialty file (for SCI Gateway use only)||28/03/2017|
|Clinical Document Type.zip||Within v3.0 there are no CDI code changes, it has been created in order to align to (EH4001) Clinical Document Indexing Standards V3.0 which is published on the eHealth Standards Library web page. A downloadable file is published here. If you have any queries please contact NSS.isdDataStandards@nhs.net||28/03/2017|
|dentprac||Dental Practices (PSD data extracts)||dentprac||28/03/2017|
|dentref||Dentists (PSD data extracts)||dentref||28/03/2017|
|Error_messages||File of error messages for use by SCI Validation Engine||28/03/2017|
|lookup_files.zip||Standard lookup files for use by SCI Validation Engine||28/03/2017|
|optprac||Optician Premises (PSD data extracts)||optprac||28/03/2017|
|optref||Opticians (PSD data extracts)||optref||28/03/2017|