Scottish laboratory data covering virology tests from the Tayside regions.

ADR  > NHS Tayside Virology @ 129

This covers lab tests for a large variety of virus antigen and antibody data, including covid19 from 2010 onwards.

Scottish Health Data

NHS Tayside and Fife

PROCHI

Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.

VirologyRestructured

Community Health Index (CHI) number is a unique personal identifier allocated to each patient on first registration with a GP Practice. It follows the format DDMMYYRRGC where DDMMYY represents the persons date of birth, RR are random digits, G is another random digit but acts as a gender identifier, (where odd numbers indicate males and even numbers indicate females), and the final digit is an arithmetical check digit.

PatientID

This field represents the providing organisation. The data is defined by 'NINEWELL'.

ProvidingOrganisationID

RequestingPartyID

RequestingPartyPosition

RequestingPartyName

RequestingPartyStatus

RequestingOrganisationID

RequestingOrganisationStatus

Discipline

ClinicalDataRequired

This is the alpha and/or numeric Health Board code in which the patient CHI information was extracted from. The Health Board codes are:    D = State Hospital  X = Common Services Agency  H = 01 = Highland  N = 02 = Grampian  T = 03 = Tayside  F = 04 = Fife  S = 05 = Lothian  B = 06 = Borders  V = 07 = Forth Valley  C = 08 = Argyle and Clyde  G = 09 = Greater Glasgow  L = 10 = Lanarkshire  A = 11 - Ayrshire and Arran  Y = 12 = Dumfries and Galloway  R = 13 = Orkney  Z = 14 = Shetland  W = 15 = Western Isles.

hb_extract

The result of the test being carried out.  This field contains numeric data only.  .

QuantityValue

Units of measure for the test result QuantityValue field..

QuantityUnit

This field represents additional information to be used in conjunction with the numeric result field QuantityValue.   The contents should be interpreted along with the QuantityValue, for example, some EGFR results may be reported as QuantityValue = 60, with ArithmeticComparator = '>'    This means the result is greater than 60..

ArithmeticComparator

Maximum guideline value for the test result at the time of testing.      HIC Observation: These ranges vary based on relevant criteria such as age, gender, and guidelines will also change over time..

RangeHighValue

Minimum guideline value for the test result at the time of testing.    HIC Observation: These ranges vary based on relevant criteria such as age, gender, and guidelines will also change over time..

RangeLowValue

Units of the guideline values presented in the RangeHighValue and RangeLowValue fields.    HIC Observation: Don't assume that these units match those of the QuantityValue and Unit..

RangeUnit

Interpretation

This field store the test code for the test taken/performed (e.g., CHOL = Cholesterol) as used by the providing organisation.  Note that this field is not always completed.      Legacy Data Mapping: This field replaces Test_code..

LocalClinicalCodeValue

LocalClinicalCodeScheme

LocalClinicalCodeSchemeId

LocalClinicalCodeDescription

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

Read code scheme used by the local lab system for read code fields, e.g. R1.

ReadCodeScheme

ReadCodeSchemeId

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 is a textual description supplied by the local lab systems..

ClinicalCircumstanceDescription

Part of the internal HIC primary key used in linking the Labs data together.  This field should be used in communicating record specific queries with HIC as it allows us  to locate the record in question.  This is a unique identifier assigned by the lab system based on the order in which the tests were run on the sample.  For legacy data (TS <07), the value of this field is imputed.  .

TestResultOrder

hic_resultID

Part of the internal HIC primary key used in linking the Labs data together.  This is a unique identifier assigned by the lab system.   This field should be used in communicating record specific queries with HIC as it allows us to locate the record in question.  .

LabNumber

Part of the internal HIC primary key used in linking the Labs data together.  This is a unique identifier assigned by the lab system.   This field should be used in communicating record specific queries with HIC as it allows us to locate the record in question.  For legacy data (Tayside <2007), the value of this field is constant..

TestReportID

This indicates the type of sample taken for the test. Sample types include:  Blood  Cerebrospinal  Faeces  Fluid  Fluoride Oxalate  Hair  Liver Biopsy  Miscellaneous  Muscle Biopsy  Serum  Skin Biopsy  Stone  Sweat  Urine  Water    HIC Observation: Tayside labs report both Serum and Blood samples with SampleName = Blood.  The read code value / description can be used to interpret the Sample correctly.  This has been confirmed with the Tayside Lab experts..

SampleName

This is the date and time when the sample was taken from the patient..

DateTimeSampled

DateTimeReceived

TestSet_ClinicalCircumstanceDescription

TestSet_ReadCodeValue

TestSet_ReadCodeScheme

TestSet_ReadCodeSchemeId

TestSet_ReadCodeDescription

TestSet_LocalClinicalCodeDescription

TestSet_LocalClinicalCodeValue

TestSet_LocalClinicalCodeScheme

TestSet_LocalClinicalCodeSchemeId

Part of the internal HIC primary key used in linking the Labs data together.  This is a unique identifier assigned by the lab system.   This field should be used in communicating record specific queries with HIC as it allows us to locate the record in question..

NHS Tayside Virology

Summary

Documentation

Coverage

Spatial

Temporal

Provenance

Access and Governance

Usage

Access

Format and Standards

Observations

Origin