NHS Tayside Virology

Preview of JSON file

{
  "summary": {
    "title": "NHS Tayside Virology",
    "abstract": "Scottish laboratory data covering virology tests from the Tayside regions.",
    "keywords": "Virology;,;NHS;,;Tayside;,;HIC;,;LIMS;,;Scotland",
    "publisher": {
      "name": "Health Informatics Centre - University of Dundee",
      "gatewayId": "5baa31c1-0280-4482-b8b7-a4953869f184"
    },
    "inPipeline": "Not available",
    "shortTitle": "NHS Tayside Virology",
    "datasetType": "Health and disease",
    "description": "This covers lab tests for a large variety of virus antigen and antibody data, including covid19 from 2010 onwards.",
    "contactPoint": "hicsupport@dundee.ac.uk",
    "datasetSubType": "Not applicable",
    "populationSize": 341000
  },
  "coverage": {
    "pathway": "ALL primary and secondary care LIMS records for Tayside & Fife",
    "spatial": "United Kingdom,Scotland",
    "followUp": "Unknown",
    "typicalAgeRange": "0-150"
  },
  "required": {
    "issued": "2024-10-08T11:28:33.86059Z",
    "version": "7.0.0",
    "modified": "2024-10-08T11:28:33.860602Z",
    "gatewayId": "129",
    "revisions": [
      {
        "url": "https://web.prod.hdruk.cloud//dataset/129?version=1.0.0",
        "version": "1.0.0"
      }
    ],
    "gatewayPid": "331d31f8-4179-4905-9983-9fb85067b1f3"
  },
  "provenance": {
    "origin": {
      "source": "LIMS",
      "purpose": "Care",
      "imageContrast": "Not stated",
      "collectionSituation": "Services"
    },
    "temporal": {
      "timeLag": "1-2 weeks",
      "startDate": "2010-01-01",
      "accrualPeriodicity": "Continuous",
      "distributionReleaseDate": "2021-07-15"
    }
  },
  "observations": [
    {
      "observedNode": "Persons",
      "measuredValue": 341000,
      "observationDate": "2021-11-11",
      "measuredProperty": "Count",
      "disambiguatingDescription": "341,000 patients in the dataset"
    },
    {
      "observedNode": "Events",
      "measuredValue": 2991000,
      "observationDate": "2021-11-11",
      "measuredProperty": "Count",
      "disambiguatingDescription": "2,991,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": "Not applicable",
      "accessRequestCost": "Quotation available on request",
      "accessServiceCategory": "TRE/SDE"
    },
    "formatAndStandards": {
      "formats": "CSV;,;Database",
      "languages": "en",
      "vocabularyEncodingSchemes": "LOCAL"
    }
  },
  "structuralMetadata": [
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "PROCHI",
          "dataType": "varchar(10)",
          "sensitive": false,
          "description": "Anonymised patient identifier"
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "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 labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "ProvidingOrganisationID",
          "dataType": "varchar(100)",
          "sensitive": false,
          "description": "This field represents the providing organisation. The data is defined by 'NINEWELL'."
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "RequestingPartyID",
          "dataType": "varchar(100)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "RequestingPartyPosition",
          "dataType": "varchar(100)",
          "sensitive": false,
          "description": "The data is defined by 'Active'."
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "RequestingPartyName",
          "dataType": "varchar(256)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "RequestingPartyStatus",
          "dataType": "varchar(20)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "RequestingOrganisationID",
          "dataType": "varchar(100)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "RequestingOrganisationStatus",
          "dataType": "varchar(20)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "Discipline",
          "dataType": "varchar(20)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "ClinicalDataRequired",
          "dataType": "varchar(max)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "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. The Health Board codes are:    D = State Hospital  X = Common Services Agency  H = 01 = Highland  N = 02 = Grampian  T = 03 = Tayside  F = 04 = Fife  S = 05 = Lothian  B = 06 = Borders  V = 07 = Forth Valley  C = 08 = Argyle and Clyde  G = 09 = Greater Glasgow  L = 10 = Lanarkshire  A = 11 - Ayrshire and Arran  Y = 12 = Dumfries and Galloway  R = 13 = Orkney  Z = 14 = Shetland  W = 15 = Western Isles."
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "QuantityValue",
          "dataType": "float",
          "sensitive": false,
          "description": "The result of the test being carried out.  This field contains numeric data only.  ."
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "QuantityUnit",
          "dataType": "varchar(24)",
          "sensitive": false,
          "description": "Units of measure for the test result QuantityValue field.."
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "ArithmeticComparator",
          "dataType": "varchar(100)",
          "sensitive": false,
          "description": "This field represents additional information to be used in conjunction with the numeric result field QuantityValue.   The contents should be interpreted along with the QuantityValue, for example, some EGFR results may be reported as QuantityValue = 60, with ArithmeticComparator = '>'    This means the result is greater than 60.."
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "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 labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "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 labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "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 labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "Interpretation",
          "dataType": "varchar(max)",
          "sensitive": false,
          "description": "Contains comments regarding the result.."
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "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 labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "LocalClinicalCodeScheme",
          "dataType": "varchar(255)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "LocalClinicalCodeSchemeId",
          "dataType": "varchar(255)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "LocalClinicalCodeDescription",
          "dataType": "varchar(255)",
          "sensitive": false,
          "description": "Description of LocalClinicalCode."
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "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 labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "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 labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "ReadCodeSchemeId",
          "dataType": "varchar(255)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "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 labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "ClinicalCircumstanceDescription",
          "dataType": "varchar(250)",
          "sensitive": false,
          "description": "This is a textual description supplied by the local lab systems.."
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "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 labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "hic_resultID",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "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 labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "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 labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "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 labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "DateTimeSampled",
          "dataType": "datetime",
          "sensitive": false,
          "description": "This is the date and time when the sample was taken from the patient.."
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "DateTimeReceived",
          "dataType": "datetime",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "TestSet_ClinicalCircumstanceDescription",
          "dataType": "varchar(100)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "TestSet_ReadCodeValue",
          "dataType": "varchar(255)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "TestSet_ReadCodeScheme",
          "dataType": "nchar(10)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "TestSet_ReadCodeSchemeId",
          "dataType": "nchar(10)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "TestSet_ReadCodeDescription",
          "dataType": "varchar(255)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "TestSet_LocalClinicalCodeDescription",
          "dataType": "varchar(255)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "TestSet_LocalClinicalCodeValue",
          "dataType": "varchar(255)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "TestSet_LocalClinicalCodeScheme",
          "dataType": "nchar(10)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "TestSet_LocalClinicalCodeSchemeId",
          "dataType": "nchar(10)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "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 labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "VirologyRestructured",
      "columns": [
        {
          "name": "hic_dataLoadRunID",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Tayside labs virology data. This data is provided in a format based upon the SCI-Store system.  Data prior to 2007 has been transformed to fit this new structure.      This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    }
  ]
}