NHS Tayside and Fife Biochemistry

Preview of JSON file

{
  "summary": {
    "title": "NHS Tayside and Fife Biochemistry",
    "abstract": "NHS Tayside and NHS Fife laboratory data.",
    "keywords": "Biochemistry;,;HIC;,;Labs;,;Tayside;,;Fife;,;SCOTLAND",
    "publisher": {
      "name": "Health Informatics Centre - University of Dundee",
      "gatewayId": "5baa31c1-0280-4482-b8b7-a4953869f184"
    },
    "inPipeline": "Not available",
    "shortTitle": "NHS Tayside and Fife Biochemistry",
    "datasetType": "Health and disease",
    "description": "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.",
    "contactPoint": "hicsupport@dundee.ac.uk",
    "datasetSubType": "Not applicable",
    "populationSize": 1131000
  },
  "coverage": {
    "spatial": "United Kingdom,Scotland,Tayside Region;,;United Kingdom,Scotland,Fife",
    "followUp": "Unknown",
    "typicalAgeRange": "0-150"
  },
  "required": {
    "issued": "2024-10-08T11:28:29.395323Z",
    "version": "4.0.0",
    "modified": "2024-10-08T11:28:29.395338Z",
    "gatewayId": "109",
    "revisions": [
      {
        "url": "https://web.prod.hdruk.cloud//dataset/109?version=1.0.0",
        "version": "1.0.0"
      }
    ],
    "gatewayPid": "0ec2151a-16b4-4a11-ba0c-afe82860f429"
  },
  "provenance": {
    "origin": {
      "source": "LIMS",
      "purpose": "Care",
      "imageContrast": "Not stated",
      "collectionSituation": "Services"
    },
    "temporal": {
      "timeLag": "1-2 weeks",
      "startDate": "1986-01-01",
      "accrualPeriodicity": "Monthly",
      "distributionReleaseDate": "2021-09-23"
    }
  },
  "observations": [
    {
      "observedNode": "Persons",
      "measuredValue": 1131000,
      "observationDate": "2021-09-23",
      "measuredProperty": "Count",
      "disambiguatingDescription": "1,131,000 patients in dataset"
    },
    {
      "observedNode": "Events",
      "measuredValue": 267620000,
      "observationDate": "2021-11-11",
      "measuredProperty": "Count",
      "disambiguatingDescription": "267,620,000 records in the dataset"
    }
  ],
  "accessibility": {
    "usage": {
      "resourceCreator": {
        "name": "NHS Tayside and Fife"
      },
      "dataUseLimitation": "General research use",
      "dataUseRequirement": "Disclosure control"
    },
    "access": {
      "accessRights": "https://www.dundee.ac.uk/hic/governance-service",
      "jurisdiction": "GB-SCT",
      "accessService": "HIC has implemented a remote-access Trusted Research Environment to protect data confidentiality, satisfy public concerns about data loss and reassure Data Controllers about HIC’s secure management and processing of their data.\n\nData is not released externally to data users for analysis on their own computers but placed on a server at HIC, within a restricted, secure IT environment, where the data user is given secure remote access to carry out their analysis.\n\nFull details are available via the following link:\nhttps://www.dundee.ac.uk/hic/safe-haven",
      "dataProcessor": "University of Dundee, Health Informatics Centre",
      "dataController": "Local NHS boards",
      "deliveryLeadTime": "2-4 weeks",
      "accessRequestCost": "Quotation available on request",
      "accessServiceCategory": "TRE/SDE"
    },
    "formatAndStandards": {
      "formats": "CSV;,;Database",
      "languages": "en",
      "vocabularyEncodingSchemes": "LOCAL"
    }
  },
  "structuralMetadata": [
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "PROCHI",
          "dataType": "varchar(10)",
          "sensitive": false,
          "description": "Anonymised patient identifier"
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "LabNumberIdentifiable",
          "dataType": "varchar(10)",
          "sensitive": false,
          "description": "This field represents the Lab Number."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "ClinicalDataRequired",
          "dataType": "varchar(max)",
          "sensitive": false,
          "description": "Contains comments from the original requestor.  May give the reason for requesting the test, or comments on condition, last eaten etc. This field is not populated for legacy (TS < 07) data.."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "ProvidingOrganisationID",
          "dataType": "varchar(100)",
          "sensitive": false,
          "description": "ID / short name of the organisation providing the test results. E.G. NINEWELLS.  For full name see ProvidingOrganisationName.."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "ProvidingOrganisationName",
          "dataType": "varchar(256)",
          "sensitive": false,
          "description": "Local name of the organisation providing the test results.  This maybe include location as well as service name, for example:  (NINEWELL) Tayside Clinical Lab Services."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "ProvidingOrganisationType",
          "dataType": "varchar(100)",
          "sensitive": false,
          "description": "Type of organisation providing the test results. For Example: Hospital.  For legacy (TS < 07) data, this contains either: Hospital - HIC data - Pre98 or Hospital - HIC data - Post98 as appropriate.."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "RequestingPartyPosition",
          "dataType": "varchar(100)",
          "sensitive": false,
          "description": "Position held by the party requesting the test results, for example, this might be GP or Consultant.."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "RequestingOrganisationName",
          "dataType": "varchar(256)",
          "sensitive": false,
          "description": "The laboratory providing the sample.   For legacy data, this contains the record source, for example:  Ninewells Data prior to Pinnacle  Perth Masterlab  Perth data from Ilims system  Ninewells Pinnacle Data."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "RequestingOrganisationType",
          "dataType": "varchar(100)",
          "sensitive": false,
          "description": "The type of organisation that the requestor is part of.  This contains values such as:  Hospital  Practice  Ward."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "Discipline",
          "dataType": "varchar(20)",
          "sensitive": false,
          "description": "This is the discipline code for the laboratory test. For all biochemistry tests, the discipline code is CC, which represents Clinical Chemistry. ."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "hb_extract",
          "dataType": "varchar(1)",
          "sensitive": false,
          "description": "This is the alpha and/or numeric Health Board code in which the patient CHI information was extracted from. ."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "QuantityValue",
          "dataType": "float",
          "sensitive": false,
          "description": "The result of the test being carried out.  This field contains numeric data only.  ."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "QuantityUnit",
          "dataType": "varchar(24)",
          "sensitive": false,
          "description": "Units of measure for the test result QuantityValue field.."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "ArithmeticComparator",
          "dataType": "varchar(100)",
          "sensitive": false,
          "description": "This fieldrepresents 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.."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "RangeHighValue",
          "dataType": "varchar(24)",
          "sensitive": false,
          "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.."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "RangeLowValue",
          "dataType": "varchar(24)",
          "sensitive": false,
          "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.."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "RangeUnit",
          "dataType": "varchar(24)",
          "sensitive": false,
          "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.."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "Interpretation",
          "dataType": "varchar(max)",
          "sensitive": false,
          "description": "Contains comments regarding the result.."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "LocalClinicalCodeValue",
          "dataType": "varchar(255)",
          "sensitive": false,
          "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.."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "LocalClinicalCodeDescription",
          "dataType": "nvarchar(255)",
          "sensitive": false,
          "description": "Description of LocalClinicalCode."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "ReadCodeValue",
          "dataType": "varchar(50)",
          "sensitive": false,
          "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.."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "ReadCodeScheme",
          "dataType": "varchar(255)",
          "sensitive": false,
          "description": "Read code scheme used by the local lab system for read code fields, e.g. R1."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "ReadCodeDescription",
          "dataType": "nvarchar(255)",
          "sensitive": false,
          "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.."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "ClinicalCircumstanceDescription",
          "dataType": "varchar(250)",
          "sensitive": false,
          "description": "This is a textual description supplied by the local lab systems.."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "hic_dataLoadRunID",
          "dataType": "int",
          "sensitive": false,
          "description": "The data load batch that loaded this record, this will be null if the data was not loaded through the RDMP framework.."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "TestResultOrder",
          "dataType": "int",
          "sensitive": false,
          "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.  ."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "LabNumber",
          "dataType": "varchar(10)",
          "sensitive": false,
          "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.  ."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "TestReportID",
          "dataType": "varchar(10)",
          "sensitive": false,
          "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.."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "SampleName",
          "dataType": "varchar(50)",
          "sensitive": false,
          "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.."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "DateTimeSampled",
          "dataType": "datetime",
          "sensitive": false,
          "description": "This is the date and time when the sample was taken from the patient.."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "SampleRequesterComment",
          "dataType": "varchar(max)",
          "sensitive": false,
          "description": "This field is free text."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "ServiceProviderComment",
          "dataType": "varchar(max)",
          "sensitive": false,
          "description": "For legacy data, this field tells you how the SampleName field was derived.    Where SampleName is completed, the decision on which original sample_type to take is coded as follows:  \"RCA\": The sample was derived during HICs Read Code Analysis workshops.  HIC, assisted by researchers, clinicians, and validated by Tayside laboratory experts used all of the available data to assign standardised read codes to a large portion of the data (95%+).  The SampleName was derived from the allocated read code.    \"Header = lkp\": Both legacy sample header and legacy HIC lookup value for the relevant test code matched.  \"lkp in header\": The legacy sample header consisted of multiple values (e.g. 'B - U - FO'), but contained the HIC lookup value (e.g. 'Blood') for the relevant test code.  For this example, the final SampleName value would be 'Blood.'  \"header only\": There was no information available other than the legacy sample header type.  \"lkp only\": There was no information available other than the legacy HIC lookup sample type for the relevant test code.    For SampleName = 'Unknown'  \"no lkp, no header\" = No information stored in either legacy header or look up for the test code.  \"Header only\": Only a legacy header sample type was provided, and is ambiguous, e.g.  'B - FO - M'  This original value is recorded in this field, for this example, the stored value would be \"Header only - B - FO - M\"  \"Header: {*} Lookup: {*}\" = The legacy header and sample type provide conflicting values.  This field also records the original values.   ."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    },
    {
      "name": "Biochemistry (Lab Data Restructured)",
      "columns": [
        {
          "name": "TestIdentifier",
          "dataType": "int",
          "sensitive": false,
          "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.."
        }
      ],
      "description": "Tayside and Fife labs biochemistry data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no legacy data for Fife as this data starts in 2005/6 and all comes from SCI-Store.      Data is complete in later years, but for older Tayside data (particularly pre-98), there may be missing patches in Ninewells data.    Perth data incomplete as early computer systems were simply turned off and data was lost.  Stracathro data became computerised much later than the other labs.    This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC.     The HIC recommended approach to using this data is to use the lookup file z_LocalClinicalCodeValue. Use the HICDescription column to find the codes you require. Next identify the records in 2 ways: Use the identified ReadCodeValue OR Use the identified ClinicalCodeValue along with the hb_extract."
    }
  ]
}