Page last updated: 6-OCT-2006

Managing Data Quality

National Reference Files

Computerised patient based data collected by ISD Scotland is subject to data validation process. This process includes the checking of some data items against an agreed set of reference files (e.g. ICD10 and OPCS4 coding classifications, Postcodes and Consultant specialty files). The content of the files are monitored and updated as necessary.

The standard Data Validation Reference files (e.g. consultants, GPs, location etc) are updated on the website on a weekly basis. Other files (e.g. ICD10/OPCS4, postcodes etc) are updated monthly.

Reference files are updated by users via the submission of forms to ISD.

For further information on Reference Files (or on downloading the files from the NHSnet) please contact Dougie Ferguson, Reference Files Manager by e-mail on dougie.ferguson@isd.csa.scot.nhs.uk or by telephone on 0131 275 6265.

Downloading the ISD SMR Data Reference files
NHSnet users can download the data files from here

Click on the filename to download that file :

The Reference File search facility can be accessed here http://www.natref.scot.nhs.uk/

SMR Validation Reference Files

Filename

Lastupdate

Description

RF0608A.EXE

14/07/08

17 standard reference files as at 14/07/08. (NHSnet access required to download this file)

gpdata.exe

20/05/08

For users of the GP Enquiry system. To update data, copy file onto floppy disk, rename as 'reffiles.exe' and import to system

RF0608B.EXE 

16/06/08

Full ICD10/OPCS4 files at June 2008

RF0608C.EXE

16/06/08

Updates to ICD10 file since May 2008.

RF0608D.EXE

14/07/08

Postcode (postcode only) file at 14/07/08

RF0608E.EXE

14/07/08

Updates to the postcode file since 07/07/08

RF0608F.EXE

14/07/08

Cumulative updates to the postcode file since 07/01/08

 

SCI Validation Reference Files

Filename

Lastupdate

Description

RF0608I.EXE

14/07/08

GW_Provider/Location/Specialty file (for SCI Gateway use only) as at 14/07/08

RF0608J.EXE

14/07/08

GW_Specialty file (for SCI Gateway use only) as at 14/07/08

RF0608K.EXE

14/07/08

GW Health Care professionals (for SCI Gateway use only ) as at 14/07/08

RF0608L.EXE

14/07/08

GW Health Care professionals linked to Providers (for SCI Gateway use only ) as at 14/07/08

RF0608M.EXE

14/07/08

GW Health Care professionals linked to GW-Specialties (for SCI Gateway use only) as at 14/07/08

RF0608N.EXE

14/07/08

GW gpprac file (for SCI Gateway use only).  Holds updated HB cypher "G" or "H" for "old" Argyll & Clyde practices as at 14/07/08

RF0608P.EXE

15/07/08 gw_entitytype test data

RF0608Q.EXE

15/07/08 gw_address test data

RF0608R.EXE

15/07/08 gw_candidateentity test data

RF0608S.EXE

15/07/08 gw_directoryentity test data

RF0608T.EXE

15/07/08

gw_personname test data


 

Other Files

Filename

Lastupdate

Description

LOC_HB.EXE

18/04/06

File mapping location code to HB cypher. Can be used to map previous Argyll and Clyde locations to Glagow or Highland

RF0608G.EXE

16/06/08

GP Practice/CHP file at 16/06/08

 

 

PLSP0704.EXE

12/07/04

Provider/Location/Specialty mapping file as at July 2004.

LF2706A.ZIP

27/06/06

Standard lookup files for use by SCI Validation Engine as at 27/06/06

LF0610

05/10/06

File of error messages for use by SCI Validation Engine as at 05/10/06

NW111207

11/12/07

New Ways Project - New Ways Data Definitions

Clinical Document type. zip

04/05/07

Standard types and subtypes [2006 Normative]

 

Updating Reference Files
Forms
used to notify ISD of changes to the Reference files.

SMR Reference File Layouts

Organisation Codes

Specialty

Location Codes

Specialty to Record Type

Health Care Professional No

Significant Facility

Medical, Dental & GP GMC

Significant Facility to Record Type

GMC/HCP No. to Specialty

Specialty to Significant Facility

Scottish GP Practices 

Clinical Facility

GP Ref

ICD10

GP Branch 

OPCS4

GMC/HCP to Provider Code

Postcodes

Provider to Location to Spec

Loc_HB

Rest of UK GP Practices

 


Main contact: Email Dougie Ferguson