NHS Tayside Virology

Preview of JSON file

[{"id": "", "description": "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.", "name": "VirologyRestructured", "dataElementsCount": 46, "dataElements": [{"id": "", "description": "Anonymised patient identifier", "name": "PROCHI", "type": "PrimitiveType"}, {"id": "", "description": "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.", "name": "PatientID", "type": "PrimitiveType"}, {"id": "", "description": "This field represents the providing organisation. The data is defined by 'NINEWELL'.", "name": "ProvidingOrganisationID", "type": "PrimitiveType"}, {"id": "", "description": "No Column Description Available", "name": "RequestingPartyID", "type": "PrimitiveType"}, {"id": "", "description": "The data is defined by 'Active'.", "name": "RequestingPartyPosition", "type": "PrimitiveType"}, {"id": "", "description": "No Column Description Available", "name": "RequestingPartyName", "type": "PrimitiveType"}, {"id": "", "description": "No Column Description Available", "name": "RequestingPartyStatus", "type": "PrimitiveType"}, {"id": "", "description": "No Column Description Available", "name": "RequestingOrganisationID", "type": "PrimitiveType"}, {"id": "", "description": "No Column Description Available", "name": "RequestingOrganisationStatus", "type": "PrimitiveType"}, {"id": "", "description": "No Column Description Available", "name": "Discipline", "type": "PrimitiveType"}, {"id": "", "description": "No Column Description Available", "name": "ClinicalDataRequired", "type": "PrimitiveType"}, {"id": "", "description": "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.", "name": "hb_extract", "type": "PrimitiveType"}, {"id": "", "description": "The result of the test being carried out.  This field contains numeric data only.  .", "name": "QuantityValue", "type": "PrimitiveType"}, {"id": "", "description": "Units of measure for the test result QuantityValue field..", "name": "QuantityUnit", "type": "PrimitiveType"}, {"id": "", "description": "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..", "name": "ArithmeticComparator", "type": "PrimitiveType"}, {"id": "", "description": "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..", "name": "RangeHighValue", "type": "PrimitiveType"}, {"id": "", "description": "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..", "name": "RangeLowValue", "type": "PrimitiveType"}, {"id": "", "description": "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..", "name": "RangeUnit", "type": "PrimitiveType"}, {"id": "", "description": "Contains comments regarding the result..", "name": "Interpretation", "type": "PrimitiveType"}, {"id": "", "description": "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..", "name": "LocalClinicalCodeValue", "type": "PrimitiveType"}, {"id": "", "description": "No Column Description Available", "name": "LocalClinicalCodeScheme", "type": "PrimitiveType"}, {"id": "", "description": "No Column Description Available", "name": "LocalClinicalCodeSchemeId", "type": "PrimitiveType"}, {"id": "", "description": "Description of LocalClinicalCode.", "name": "LocalClinicalCodeDescription", "type": "PrimitiveType"}, {"id": "", "description": "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..", "name": "ReadCodeValue", "type": "PrimitiveType"}, {"id": "", "description": "Read code scheme used by the local lab system for read code fields, e.g. R1.", "name": "ReadCodeScheme", "type": "PrimitiveType"}, {"id": "", "description": "No Column Description Available", "name": "ReadCodeSchemeId", "type": "PrimitiveType"}, {"id": "", "description": "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..", "name": "ReadCodeDescription", "type": "PrimitiveType"}, {"id": "", "description": "This is a textual description supplied by the local lab systems..", "name": "ClinicalCircumstanceDescription", "type": "PrimitiveType"}, {"id": "", "description": "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.  .", "name": "TestResultOrder", "type": "PrimitiveType"}, {"id": "", "description": "No Column Description Available", "name": "hic_resultID", "type": "PrimitiveType"}, {"id": "", "description": "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.  .", "name": "LabNumber", "type": "PrimitiveType"}, {"id": "", "description": "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..", "name": "TestReportID", "type": "PrimitiveType"}, {"id": "", "description": "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..", "name": "SampleName", "type": "PrimitiveType"}, {"id": "", "description": "This is the date and time when the sample was taken from the patient..", "name": "DateTimeSampled", "type": "PrimitiveType"}, {"id": "", "description": "No Column Description Available", "name": "DateTimeReceived", "type": "PrimitiveType"}, {"id": "", "description": "No Column Description Available", "name": "TestSet_ClinicalCircumstanceDescription", "type": "PrimitiveType"}, {"id": "", "description": "No Column Description Available", "name": "TestSet_ReadCodeValue", "type": "PrimitiveType"}, {"id": "", "description": "No Column Description Available", "name": "TestSet_ReadCodeScheme", "type": "PrimitiveType"}, {"id": "", "description": "No Column Description Available", "name": "TestSet_ReadCodeSchemeId", "type": "PrimitiveType"}, {"id": "", "description": "No Column Description Available", "name": "TestSet_ReadCodeDescription", "type": "PrimitiveType"}, {"id": "", "description": "No Column Description Available", "name": "TestSet_LocalClinicalCodeDescription", "type": "PrimitiveType"}, {"id": "", "description": "No Column Description Available", "name": "TestSet_LocalClinicalCodeValue", "type": "PrimitiveType"}, {"id": "", "description": "No Column Description Available", "name": "TestSet_LocalClinicalCodeScheme", "type": "PrimitiveType"}, {"id": "", "description": "No Column Description Available", "name": "TestSet_LocalClinicalCodeSchemeId", "type": "PrimitiveType"}, {"id": "", "description": "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..", "name": "TestIdentifier", "type": "PrimitiveType"}, {"id": "", "description": "No Column Description Available", "name": "hic_dataLoadRunID", "type": "PrimitiveType"}]}]