NHS Tayside and Fife Haematology

Preview of JSON file

{
  "summary": {
    "title": "NHS Tayside and Fife Haematology",
    "abstract": "NHS Tayside and Fife labs Haematology data.",
    "keywords": "Haematology;,;labs;,;HIC;,;NHS;,;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 Haematology",
    "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": 981000
  },
  "coverage": {
    "spatial": "United Kingdom,Scotland,Tayside Region;,;United Kingdom,Scotland,Fife",
    "followUp": "Unknown",
    "typicalAgeRange": "0-150"
  },
  "required": {
    "issued": "2024-10-08T11:28:33.977755Z",
    "version": "4.0.0",
    "modified": "2024-10-08T11:28:33.977771Z",
    "gatewayId": "130",
    "revisions": [
      {
        "url": "https://web.prod.hdruk.cloud//dataset/130?version=1.0.0",
        "version": "1.0.0"
      }
    ],
    "gatewayPid": "b44f4454-a6ae-402b-8d7e-58c34aa0c79f"
  },
  "provenance": {
    "origin": {
      "purpose": "Care",
      "imageContrast": "Not stated",
      "collectionSituation": "Services"
    },
    "temporal": {
      "timeLag": "1-2 weeks",
      "startDate": "1994-08-06",
      "accrualPeriodicity": "Monthly",
      "distributionReleaseDate": "2021-09-24"
    }
  },
  "observations": [
    {
      "observedNode": "Persons",
      "measuredValue": 981000,
      "observationDate": "2021-09-24",
      "measuredProperty": "COUNT",
      "disambiguatingDescription": "There are 981,000 patients in the dataset"
    },
    {
      "observedNode": "Events",
      "measuredValue": 242080000,
      "observationDate": "2021-11-11",
      "measuredProperty": "Count",
      "disambiguatingDescription": "242,080,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": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "PROCHI",
          "dataType": "varchar(10)",
          "sensitive": false,
          "description": "Anonymised patient identifier"
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "LabNumber",
          "dataType": "varchar(15)",
          "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 Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "TestReportID",
          "dataType": "varchar(10)",
          "sensitive": false,
          "description": "This field represents a unique number to the patient and test and is anonymised on extraction."
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "PatientID",
          "dataType": "varchar(10)",
          "sensitive": false,
          "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."
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "ProvidingOrganisationID",
          "dataType": "varchar(100)",
          "sensitive": false,
          "description": "ID of the organisation providing the test results.."
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "ProvidingOrganisationName",
          "dataType": "varchar(256)",
          "sensitive": false,
          "description": "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 Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "ProvidingOrganisationType",
          "dataType": "varchar(100)",
          "sensitive": false,
          "description": "Type of organisation providing the test results.    For legacy data, this contains either: Hospital - HIC data - Pre98 or Hospital - HIC data - Post98 as appropriate.."
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "RequestingPartyID",
          "dataType": "varchar(100)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (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 Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "RequestingPartyName",
          "dataType": "varchar(256)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "RequestingPartyStatus",
          "dataType": "varchar(20)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "RequestingOrganisationID",
          "dataType": "varchar(100)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (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 Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "RequestingOrganisationStatus",
          "dataType": "varchar(20)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (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 Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (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 Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (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 data.."
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (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 Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (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 Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (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 Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "ArithmeticComparator",
          "dataType": "varchar(100)",
          "sensitive": false,
          "description": "This field contains 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 Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (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 Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (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 Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (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 Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "Interpretation",
          "dataType": "varchar(max)",
          "sensitive": false,
          "description": "Contains comments regarding the result.."
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (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 ield is not always completed.      Legacy Data Mapping: This field rerplaces Test_code.."
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "LocalClinicalCodeScheme",
          "dataType": "varchar(255)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "LocalClinicalCodeSchemeId",
          "dataType": "varchar(255)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "LocalClinicalCodeDescription",
          "dataType": "varchar(255)",
          "sensitive": false,
          "description": "Description of LocalClinicalCode."
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (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 proivided.    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 Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (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 Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "ReadCodeDescription",
          "dataType": "varchar(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 Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (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 Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (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 Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "hic_resultID",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "hic_dataLoadRunID",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "hic_validFrom",
          "dataType": "datetime",
          "sensitive": false,
          "description": "The date the record was loaded by hic into the LIVE hic data repository."
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (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:    B = Blood  C = Cerebrospinal  FA = Faeces  F = Fluid  FO = Floride Oxalate  H = Hair  LI = Liver Biopsy  M = Miscellaneous  MU = Muscle Biopsy  SK = Skin Biopsy  ST = Stone  SW = Sweat  U = Urine  W = Water    (can also include full textual descriptions) ."
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (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 Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "DateTimeReceived",
          "dataType": "datetime",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "SampleRequesterComment",
          "dataType": "varchar(max)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (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 Taysdie laboratory experts used all of the available data to assign standardisaed 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 ambiguoius, 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 Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "TestSet_ClinicalCircumstanceDescription",
          "dataType": "varchar(100)",
          "sensitive": false,
          "description": "This is a textual description supplied by the local lab systems.."
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "TestSet_ReadCodeValue",
          "dataType": "varchar(255)",
          "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 Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "TestSet_ReadCodeScheme",
          "dataType": "nchar(10)",
          "sensitive": false,
          "description": "Read code scheme used by the local lab system for read code fields, e.g. R1."
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "TestSet_ReadCodeDescription",
          "dataType": "varchar(255)",
          "sensitive": false,
          "description": "This field represents the read code description."
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "TestSet_LocalClinicalCodeDescription",
          "dataType": "varchar(255)",
          "sensitive": false,
          "description": "Description of LocalClinicalCode."
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "TestSet_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 Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "TestSet_LocalClinicalCodeScheme",
          "dataType": "nchar(10)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "TestSet_LocalClinicalCodeSchemeId",
          "dataType": "nchar(10)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Haematology (Lab Data Restructured)",
      "columns": [
        {
          "name": "TestIdentifier",
          "dataType": "int",
          "sensitive": false,
          "description": "This field represents a unique number to the patient and test and is anonymised on extraction."
        }
      ],
      "description": "Tayside and Fife labs Haematology data. This data is provided in a format based upon the SCI-Store system.   This is a data repository which retains patient information at a health board level.   Data prior to 2007 for Tayside has been transformed to fit this new structure. There is no data available for this earlier time period for Fife.  Fife data starts in 2005/6 and all originates from SCI-Store.  This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    }
  ]
}