NHS Tayside and Fife Immunology

Preview of JSON file

{
  "summary": {
    "title": "NHS Tayside and Fife Immunology",
    "abstract": "NHS Tayside and NHS Fife laboratory data.",
    "keywords": "Immunology;,;HIC;,;Tayside;,;Fife;,;NHS;,;Scotland",
    "publisher": {
      "name": "Health Informatics Centre - University of Dundee",
      "gatewayId": "5baa31c1-0280-4482-b8b7-a4953869f184"
    },
    "inPipeline": "Not available",
    "shortTitle": "NHS Tayside and Fife Immunology",
    "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": 385000
  },
  "coverage": {
    "spatial": "United Kingdom,Scotland,Tayside Region;,;United Kingdom,Scotland,Fife",
    "followUp": "Unknown",
    "typicalAgeRange": "0-150"
  },
  "required": {
    "issued": "2024-10-08T11:28:32.911018Z",
    "version": "4.0.0",
    "modified": "2024-10-08T11:28:32.911028Z",
    "gatewayId": "127",
    "revisions": [
      {
        "url": "https://web.prod.hdruk.cloud//dataset/127?version=1.0.0",
        "version": "1.0.0"
      }
    ],
    "gatewayPid": "0913cafc-51cf-4b43-af63-5c5ed112df9a"
  },
  "provenance": {
    "origin": {
      "source": "LIMS",
      "purpose": "Care",
      "imageContrast": "Not stated",
      "collectionSituation": "Services"
    },
    "temporal": {
      "timeLag": "1-2 weeks",
      "startDate": "1999-01-02",
      "accrualPeriodicity": "Monthly",
      "distributionReleaseDate": "2021-09-14"
    }
  },
  "observations": [
    {
      "observedNode": "Persons",
      "measuredValue": 385000,
      "observationDate": "2021-09-14",
      "measuredProperty": "Count",
      "disambiguatingDescription": "385,000 patients in the dataset"
    },
    {
      "observedNode": "Events",
      "measuredValue": 2936000,
      "observationDate": "2021-11-11",
      "measuredProperty": "Count",
      "disambiguatingDescription": "2,936,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": "Immunology (Extractable Immunology)",
      "columns": [
        {
          "name": "PROCHI",
          "dataType": "char(10)",
          "sensitive": false,
          "description": "Anonymised patient identifier"
        }
      ],
      "description": "This data is provided in a format based upon the SCI-Store system. This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Immunology (Extractable Immunology)",
      "columns": [
        {
          "name": "hb_extract",
          "dataType": "varchar(1)",
          "sensitive": false,
          "description": "This field represents the alpha and/or numeric Health Board code in which the patient CHI information was extracted from. ."
        }
      ],
      "description": "This data is provided in a format based upon the SCI-Store system. This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Immunology (Extractable Immunology)",
      "columns": [
        {
          "name": "Sample_date",
          "dataType": "datetime",
          "sensitive": false,
          "description": "This field indicates the date when the sample was taken. It is in the format dd MMM yyyy (e.g. 12 Oct 2011).  Note that in the new system 99 the time element is included aswell as the date.."
        }
      ],
      "description": "This data is provided in a format based upon the SCI-Store system. This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Immunology (Extractable Immunology)",
      "columns": [
        {
          "name": "Sample_type",
          "dataType": "varchar(20)",
          "sensitive": false,
          "description": "This field represents the type of sample taken for the test. The pre-2005 sample type is all D.."
        }
      ],
      "description": "This data is provided in a format based upon the SCI-Store system. This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Immunology (Extractable Immunology)",
      "columns": [
        {
          "name": "Test_code",
          "dataType": "varchar(32)",
          "sensitive": false,
          "description": "This field represents the code for the  test taken/performed (e.g. CHLA = Chlamydia PCR).."
        }
      ],
      "description": "This data is provided in a format based upon the SCI-Store system. This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Immunology (Extractable Immunology)",
      "columns": [
        {
          "name": "LocalClinicalCodeDescription",
          "dataType": "varchar(255)",
          "sensitive": false,
          "description": "This field represents the description of LocalClinicalCode."
        }
      ],
      "description": "This data is provided in a format based upon the SCI-Store system. This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Immunology (Extractable Immunology)",
      "columns": [
        {
          "name": "Result",
          "dataType": "real",
          "sensitive": false,
          "description": "This field represents the result of the test done in decimal format.."
        }
      ],
      "description": "This data is provided in a format based upon the SCI-Store system. This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Immunology (Extractable Immunology)",
      "columns": [
        {
          "name": "hic_DerivedResult",
          "dataType": "real",
          "sensitive": false,
          "description": "Due to the combination of old and new data the actual result field is spread across three columns, Result, Interpretation (in the new system) and origResult (in the old system).  In all cases there should be at least 1 value in one of these columns.  This is a derived column which selects the most appropriate value (if any) of these 3 columns (Also supplied seperately) in a single column for ease of access.."
        }
      ],
      "description": "This data is provided in a format based upon the SCI-Store system. This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Immunology (Extractable Immunology)",
      "columns": [
        {
          "name": "origResult",
          "dataType": "varchar(120)",
          "sensitive": false,
          "description": "This field represents the original result field from the lab system. HIC extracts the decimal part and puts it in the Result field. Any non-numeric values go into the Comment field.. For some tests where results are recorded as GT or LT or Negative/Positive (eg GT60 for eGFR tests) then this field will have to be used."
        }
      ],
      "description": "This data is provided in a format based upon the SCI-Store system. This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Immunology (Extractable Immunology)",
      "columns": [
        {
          "name": "Comment",
          "dataType": "varchar(4096)",
          "sensitive": false,
          "description": "This field represents additional information from the laboratory system in free text.. It might contain additional information about the laboratory test."
        }
      ],
      "description": "This data is provided in a format based upon the SCI-Store system. This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Immunology (Extractable Immunology)",
      "columns": [
        {
          "name": "Source_code",
          "dataType": "varchar(10)",
          "sensitive": false,
          "description": "This field represents the code for where the test was done (e.g. N1 = NW Ward 1).. This field does contain practice codes if the test was performed at a practice."
        }
      ],
      "description": "This data is provided in a format based upon the SCI-Store system. This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Immunology (Extractable Immunology)",
      "columns": [
        {
          "name": "Lab_number",
          "dataType": "varchar(50)",
          "sensitive": false,
          "description": "This field represents a unique internal number assigned in MasterLab system. It is used by HIC for referring back to individual laboratory results.."
        }
      ],
      "description": "This data is provided in a format based upon the SCI-Store system. This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Immunology (Extractable Immunology)",
      "columns": [
        {
          "name": "Units",
          "dataType": "varchar(24)",
          "sensitive": false,
          "description": "This field represents the units of the test code (e.g. HGB = g/dL).  ."
        }
      ],
      "description": "This data is provided in a format based upon the SCI-Store system. This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Immunology (Extractable Immunology)",
      "columns": [
        {
          "name": "Low",
          "dataType": "varchar(24)",
          "sensitive": false,
          "description": "This field represents the normal lower limit for a laboratory test based on patient age and/or sex. ."
        }
      ],
      "description": "This data is provided in a format based upon the SCI-Store system. This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Immunology (Extractable Immunology)",
      "columns": [
        {
          "name": "High",
          "dataType": "varchar(24)",
          "sensitive": false,
          "description": "This field represents the normal upper limit for a laboratory test based on patient age and/or sex.."
        }
      ],
      "description": "This data is provided in a format based upon the SCI-Store system. This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Immunology (Extractable Immunology)",
      "columns": [
        {
          "name": "Lab_system",
          "dataType": "int",
          "sensitive": false,
          "description": "This field represents the Lab System source the data came from.  For this dataset it is manually changed by Thomas Nind to 1 for old system (All the old legacy data held by HIC) and 99 for new system (Data loaded properly by Gordon McAllistar from Sci-Store Tayside and Fife).."
        }
      ],
      "description": "This data is provided in a format based upon the SCI-Store system. This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Immunology (Extractable Immunology)",
      "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": "This data is provided in a format based upon the SCI-Store system. This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Immunology (Extractable Immunology)",
      "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": "This data is provided in a format based upon the SCI-Store system. This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Immunology (Extractable Immunology)",
      "columns": [
        {
          "name": "Interpretation",
          "dataType": "varchar(max)",
          "sensitive": false,
          "description": "This field represents comments regarding the result in free text."
        }
      ],
      "description": "This data is provided in a format based upon the SCI-Store system. This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    },
    {
      "name": "Immunology (Extractable Immunology)",
      "columns": [
        {
          "name": "hic_dataLoadRunID",
          "dataType": "int",
          "sensitive": false,
          "description": "This field represents the data load batch that loaded this record, this will be null if the data was not loaded through the RDMP framework.."
        }
      ],
      "description": "This data is provided in a format based upon the SCI-Store system. This is a complex dataset which is supplied in a hierarchical form, this extract is a flattening of that hierarchy by HIC."
    }
  ]
}