NHS Tayside and NHS Fife laboratory data.

MDW Discover  > NHS Tayside and Fife Immunology @ 127

MDW Discover

Browse All

London SDE

West Midlands SDE

Kent, Medway & Sussex SDE

MDW - Discover

This data is provided in a format based upon the SCI-Store system. SCI-Store is a data repository which retains patient laboratory test result information at a health board level. Data prior to 2007 for Tayside has been transformed to fit this structure.  Fife data starts in 2005 and all originates from SCI-Store. There is earlier data available for Fife.

HDR UK

NHS Tayside and Fife

PROCHI

This data is provided in a format based upon the SCI-Store system. This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.

Immunology (Extractable Immunology)

This field represents the alpha and/or numeric Health Board code in which the patient CHI information was extracted from. .

hb_extract

This field indicates the date when the sample was taken. It is in the format dd MMM yyyy (e.g. 12 Oct 2011).  Note that in the new system 99 the time element is included aswell as the date..

Sample_date

This field represents the type of sample taken for the test. The pre-2005 sample type is all D..

Sample_type

This field represents the code for the  test taken/performed (e.g. CHLA = Chlamydia PCR)..

Test_code

This field represents the description of LocalClinicalCode.

LocalClinicalCodeDescription

This field represents the result of the test done in decimal format..

Result

Due to the combination of old and new data the actual result field is spread across three columns, Result, Interpretation (in the new system) and origResult (in the old system).  In all cases there should be at least 1 value in one of these columns.  This is a derived column which selects the most appropriate value (if any) of these 3 columns (Also supplied seperately) in a single column for ease of access..

hic_DerivedResult

This field represents the original result field from the lab system. HIC extracts the decimal part and puts it in the Result field. Any non-numeric values go into the Comment field.. For some tests where results are recorded as GT or LT or Negative/Positive (eg GT60 for eGFR tests) then this field will have to be used.

origResult

This field represents additional information from the laboratory system in free text.. It might contain additional information about the laboratory test.

Comment

This field represents the code for where the test was done (e.g. N1 = NW Ward 1).. This field does contain practice codes if the test was performed at a practice.

Source_code

This field represents a unique internal number assigned in MasterLab system. It is used by HIC for referring back to individual laboratory results..

Lab_number

This field represents the units of the test code (e.g. HGB = g/dL).  .

Units

This field represents the normal lower limit for a laboratory test based on patient age and/or sex. .

This field represents the normal upper limit for a laboratory test based on patient age and/or sex..

High

This field represents the Lab System source the data came from.  For this dataset it is manually changed by Thomas Nind to 1 for old system (All the old legacy data held by HIC) and 99 for new system (Data loaded properly by Gordon McAllistar from Sci-Store Tayside and Fife)..

Lab_system

The read code allocated to the test.  This field is useful as a standardised grouping for the tests, for example, if you are looking in Serum Total Cholesterol, all records marked with 44P. represent this regardless of the localClinicalCode provided.    HIC Observation:  Restructuring has significantly improved the quality and accuracy of this field.   For legacy data, field completion rates are much greater, with over 95% of the legacy results now featuring a read code.  HIC have also developed a lookup table, which will be used throughout the data project lifecycle and released along with this data set..

ReadCodeValue

This is a textual description supplied by the local lab systems for the relevant read code.    HIC Observation: This field appears to have not been mapped to the read code standard. The mapping of read code to description often changes, possibly over time, or versions of read code, for example:  44P. may be described as both 'Serum Total Cholesterol' and 'Total Cholesterol (S)' on different records..

ReadCodeDescription

This field represents comments regarding the result in free text.

Interpretation

This field represents the data load batch that loaded this record, this will be null if the data was not loaded through the RDMP framework..

NHS Tayside and Fife Immunology

Documentation

Coverage

Provenance

Origin

Temporal

Accessibility

Access

Usage

Format and Standards

Observations

Origin