Skip to content

Unscheduled Care Data Mart

Summary

Abstract

The data mart links data from (NHS 24, Scottish Ambulance Service, Out of Hours Primary Care, Emergency Department, Acute, Mental Health and Deaths) to show a Continuous Unscheduled Care Pathway (CUP) for records with a valid CHI number.

Keywords

Publisher

  • Name
    Public Health Scotland
  • Logo

    Not available

  • Description
    Not available
  • Contact point
    Not available

Documentation

Description

The Unscheduled Care Data Mart (UCD) is a collaboration between Public Health Scotland (PHS), NHS 24 and Scottish Ambulance Service (SAS). The data mart links data from (NHS 24, Scottish Ambulance Service, Out of Hours Primary Care, Emergency Department, Acute, Mental Health and Deaths) to show a patient journey for records with a valid CHI number. This data will help understand the full patient journey through emergency and urgent care services e.g. from first contact by telephone with NHS 24, transport by ambulance to an A&E department and then emergency hospital admission. PROVISIONAL DATA: NHS24/SAS SUBMITTED DAILY. A&E DATA (MONTHLY). INPATIENT ADMISSIONS (MONTHLY)

Coverage

Spatial

  • Spatial coverage

    United Kingdom, Scotland

  • Geographic levels
    Not available

Temporal

  • Start date
    01/01/2011
  • End date
    Not available
  • Frequency
    Other
  • Distribution release date
    31/08/2020

Provenance

  • Purpose
    Care
  • Source
    Not available
  • Collection situation
    Secondary care - Accident and Emergency, Secondary care - In-patients, Other

Access and governance

  • Conditions of access
    General research use

Requesting access to this data

This is a secure dataset that can only be accessed by researchers from approved organisations.

Find out how to apply to access this dataset

Usage

  • Conditions of use
    Geographical restrictions
  • Resource creator
    Public Health Scotland; National Services Scotland; Scottish Ambulance Service; NHS24; GP OOH
  • Is referenced by
    Not available

Access

Format and standards

  • Language
    English
  • Format
    Text, csv

Enrichment and linkage

  • Related datasets
    • Not available
  • Linkage opportunity
    Not available
  • Tools
    • Not available

Synthetic data

Synthetic data is not yet available for this dataset. 

Technical information

A JSON file is available with further technical information. This can include details of variables and data classes contained in the dataset.

Preview of JSON file

{
  "required": {
    "gatewayId": "57",
    "gatewayPid": "585b3fce-d015-480c-8411-44e50d7363f0",
    "issued": "2024-10-08T11:28:15.872Z",
    "modified": "2024-10-08T11:28:15.872Z",
    "version": "1.0.0",
    "revisions": [
      {
        "version": "1.0.0",
        "url": "https://web.prod.hdruk.cloud//dataset/57?version=1.0.0"
      },
      {
        "url": "https://healthdatagateway.org//dataset/57?version=1.0.0",
        "version": "1.0.0"
      }
    ]
  },
  "summary": {
    "abstract": "The data mart links data from (NHS 24, Scottish Ambulance Service, Out of Hours Primary Care, Emergency Department, Acute, Mental Health and Deaths) to show a Continuous Unscheduled Care Pathway (CUP) for records with a valid CHI number.",
    "contactPoint": "phs.edris@phs.scot",
    "keywords": "Ambulance;,;Out of Hours;,;A&E",
    "datasetType": "Health and disease",
    "datasetSubType": "Not applicable",
    "populationSize": -1,
    "description": "The Unscheduled Care Data Mart (UCD) is a collaboration between Public Health Scotland (PHS), NHS 24 and Scottish Ambulance Service (SAS). The data mart links data from (NHS 24, Scottish Ambulance Service, Out of Hours Primary Care, Emergency Department, Acute, Mental Health and Deaths) to show a patient journey for records with a valid CHI number. This data will help understand the full patient journey through emergency and urgent care services e.g. from first contact by telephone with NHS 24, transport by ambulance to an A&E department and then emergency hospital admission.\n\nPROVISIONAL DATA: NHS24/SAS SUBMITTED DAILY. A&E DATA (MONTHLY). INPATIENT ADMISSIONS (MONTHLY)",
    "shortTitle": "Unscheduled Care Data Mart",
    "title": "Unscheduled Care Data Mart",
    "publisher": {
      "name": "Public Health Scotland",
      "gatewayId": "c40be7ce-f0ca-4fd8-b63c-0632593d2507"
    },
    "inPipeline": "Not available"
  },
  "coverage": {
    "pathway": "Secondary care data only",
    "spatial": "United Kingdom,Scotland",
    "followUp": "Other",
    "typicalAgeRange": "0-150"
  },
  "provenance": {
    "origin": {
      "purpose": "Care",
      "collectionSituation": "Secondary care - Accident and Emergency;,;Secondary care - In-patients;,;Other",
      "imageContrast": "Not stated"
    },
    "temporal": {
      "startDate": "2011-01-01T00:00:00Z",
      "timeLag": "1-2 months",
      "accrualPeriodicity": "Other",
      "distributionReleaseDate": "2020-08-31T23:00:00Z"
    }
  },
  "accessibility": {
    "access": {
      "deliveryLeadTime": "Variable",
      "jurisdiction": "GB",
      "dataController": "Public Health Scotland / National Records Scotland / Scottish Ambulance Service / NHS 24",
      "dataProcessor": "National Services Scotland",
      "accessRights": "https://publichealthscotland.scot/services/data-research-and-innovation-services/electronic-data-research-and-innovation-service-edris/services-we-offer/",
      "accessService": "Scottish National Safe Haven / Trusted Research Environment: https://publichealthscotland.scot/services/data-research-and-innovation-services/electronic-data-research-and-innovation-service-edris/national-safe-haven-nsh/",
      "accessRequestCost": "https://publichealthscotland.scot/services/data-research-and-innovation-services/electronic-data-research-and-innovation-service-edris/cost-of-services/",
      "accessServiceCategory": "TRE/SDE"
    },
    "usage": {
      "dataUseLimitation": "General research use",
      "dataUseRequirement": "Geographical restrictions",
      "resourceCreator": {
        "name": "Public Health Scotland;,;National Services Scotland;,;Scottish Ambulance Service;,;NHS24;,;GP OOH"
      }
    },
    "formatAndStandards": {
      "vocabularyEncodingSchemes": "NHS SCOTLAND NATIONAL CODES",
      "languages": "en",
      "formats": "text;,;csv"
    }
  },
  "linkage": {
    "associatedMedia": "https://publichealthscotland.scot/services/data-research-and-innovation-services/electronic-data-research-and-innovation-service-edris/overview/what-is-edris/ , https://publichealthscotland.scot/services/national-data-catalogue/national-datasets/search-the-datasets/unscheduled-care-datamart-ucd/"
  },
  "observations": [
    {
      "observedNode": "Events",
      "measuredValue": 13708599,
      "observationDate": "2021-01-20T00:00:00Z",
      "measuredProperty": "count",
      "disambiguatingDescription": "NHS24 calls"
    },
    {
      "observedNode": "Events",
      "measuredValue": 6461925,
      "observationDate": "2021-01-20T00:00:00Z",
      "measuredProperty": "count",
      "disambiguatingDescription": "Incidents"
    }
  ],
  "structuralMetadata": [
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "GCS Verbal Response",
          "dataType": "Varchar(20)",
          "sensitive": false,
          "description": "The patient’s verbal response rating on the Glasgow Coma Scale, e.g. incomprehensible."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Sub Division",
          "dataType": "Varchar(50)",
          "sensitive": false,
          "description": "The geographical sub division areas, e.g. Argyll and Clyde, Fife.  N/A will be nulled."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Gender",
          "dataType": "Varchar(10)",
          "sensitive": false,
          "description": "The gender of the patient, i.e. Male, Female."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Despatch Code",
          "dataType": "Varchar(15)",
          "sensitive": false,
          "description": "Presenting Complaint - the initial diagnosis code recorded by the EMDC, e.g. 33C02."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Incident No",
          "dataType": "Varchar(15)",
          "sensitive": false,
          "description": "A number to uniquely identify the incident within the EMDC."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Journey Type",
          "dataType": "Varchar(40)",
          "sensitive": false,
          "description": "The type of journey undertaken by a resource, e.g."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Clear Reason Desc",
          "dataType": "Varchar(40)",
          "sensitive": false,
          "description": "The reason the call was stopped recorded by the crew, e.g. Admission, Inter-Hospital Transfer. Dealt with by other vehicle."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Amphetamine",
          "dataType": "DateTime",
          "sensitive": false,
          "description": "Indicates if the call was associated with amphetamine abuse."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Patient Age",
          "dataType": "Int",
          "sensitive": false,
          "description": "The patient’s age."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Full Postcode",
          "dataType": "Varchar(8)",
          "sensitive": false,
          "description": "The postcode of the location of the Incident."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Patient Surname",
          "dataType": "Varchar(50)",
          "sensitive": false,
          "description": "The surname of the patient."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Respiratory Rate",
          "dataType": "Int",
          "sensitive": false,
          "description": "The patient’s respiratory rate."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Pulse Rate",
          "dataType": "Int",
          "sensitive": false,
          "description": "The patient’s pulse rate."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Resource Left Scene Date Time",
          "dataType": "DateTime",
          "sensitive": false,
          "description": "The Date Time a resource left the scene of an incident."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Inhalant",
          "dataType": "DateTime",
          "sensitive": false,
          "description": "Indicates if the call was associated with inhalant abuse."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Ecstasy",
          "dataType": "DateTime",
          "sensitive": false,
          "description": "Indicates if the call was associated with ecstasy abuse."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Patient CHI Number",
          "dataType": "Varchar(10)",
          "sensitive": false,
          "description": "The patient’s CHI number."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "GCS Eye Opening",
          "dataType": "Varchar(20)",
          "sensitive": false,
          "description": "The patient’s eye opening rating on the Glasgow Coma Scale, e.g. spontaneous."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Barbiturate",
          "dataType": "DateTime",
          "sensitive": false,
          "description": "Indicates if the call was associated with barbiturate abuse."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Call Type",
          "dataType": "Varchar(10)",
          "sensitive": false,
          "description": "The type of call, i.e. Emergency, Urgent or Routine."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "SPO2",
          "dataType": "Int",
          "sensitive": false,
          "description": "The measure of the patient’s oxygen saturation."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "GCS Total",
          "dataType": "Int",
          "sensitive": false,
          "description": "The patient’s Glasgow Coma Scale score (a number between 3 and 15)."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Resource Arrived Scene Date Time",
          "dataType": "DateTime",
          "sensitive": false,
          "description": "The Date Time a resource arrived at the scene of an incident."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Patient No",
          "dataType": "Varchar(3)",
          "sensitive": false,
          "description": "A number to uniquely identify a patient at resource incident level. If multiple resources are allocated to one incident the same patient could be seen by more than one resource but may be allocated different patient numbers."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Call Started Date Time",
          "dataType": "DateTime",
          "sensitive": false,
          "description": "The Date Time the call was taken by the EMDC."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Cocaine",
          "dataType": "DateTime",
          "sensitive": false,
          "description": "Indicates if the call was associated with cocaine abuse."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Call Category",
          "dataType": "Varchar(15)",
          "sensitive": false,
          "description": "The emergency call category, e.g. Cat A Call. N/A will be submitted for urgent and routine calls, i.e. non-emergency calls."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Incident Northing",
          "dataType": "Int",
          "sensitive": false,
          "description": "The northing of the location of the incident."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Circulation Treatment IV Fluids",
          "dataType": "DateTime",
          "sensitive": false,
          "description": "Indicates if IV Fluids was used as a Circulation Treatment."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Resource Arrived Destination Date Time",
          "dataType": "DateTime",
          "sensitive": false,
          "description": "The Date Time a resource arrived at its destination, e.g. hospital, care home."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Chief Complaint Group",
          "dataType": "Varchar(2)",
          "sensitive": false,
          "description": "Presenting Complaint Group – the grouping of the initial diagnosis code."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Incident Easting",
          "dataType": "Int",
          "sensitive": false,
          "description": "The easting of the location of the incident."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Receiving Hospital",
          "dataType": "Varchar(200)",
          "sensitive": false,
          "description": "The name of the hospital the patient was taken to for treatment entered by the crew.  The list of hospitals is not stable so a reference file cannot be provided."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Temperature",
          "dataType": "Varchar(5)",
          "sensitive": false,
          "description": "The patient’s temperature."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "To Hospital",
          "dataType": "Varchar(2000)",
          "sensitive": false,
          "description": "Allocated Hospital - the name of the hospital the patient was allocated to be taken to by the EMDC based upon the geography of the incident. The list of hospitals is not stable so a reference file cannot be provided."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Resource Cleared Date Time",
          "dataType": "DateTime",
          "sensitive": false,
          "description": "The Date Time a resource was cleared to be available to attend another incident."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Cannabis",
          "dataType": "DateTime",
          "sensitive": false,
          "description": "Indicates if the call was associated with cannabis abuse."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Other Substance Description",
          "dataType": "Varchar(2000)",
          "sensitive": false,
          "description": "A freetext field to describe the other substance the call may have been associated with."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Patient Forename",
          "dataType": "Varchar(20)",
          "sensitive": false,
          "description": "The forename of the patient."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "EMDC",
          "dataType": "Varchar(30)",
          "sensitive": false,
          "description": "The call centre based upon the incident location and not the centre that took the call. Paisley Control Area is to be mapped to Cardonald Control Area. N/A will be nulled."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Circulation Treatment IV Cannula",
          "dataType": "DateTime",
          "sensitive": false,
          "description": "Indicates if an IV Cannula was used as a Circulation Treatment."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Opiate",
          "dataType": "DateTime",
          "sensitive": false,
          "description": "Indicates if the call was associated with opiate abuse."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Doctor In Attendance",
          "dataType": "DateTime",
          "sensitive": false,
          "description": "Indicates if there was a doctor at the scene."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "GCS Motor Response",
          "dataType": "Varchar(20)",
          "sensitive": false,
          "description": "The patient’s motor response rating on the Glasgow Coma Scale, e.g. Extension to Pain."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Resource Allocated Date Time",
          "dataType": "DateTime",
          "sensitive": false,
          "description": "The Date Time a resource was allocated to attend an incident."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Final AMPDS Code",
          "dataType": "Varchar(6)",
          "sensitive": false,
          "description": "Diagnosis - the diagnosis code recorded by the paramedic after treating the patient."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Crew Member 2 Paramedic status",
          "dataType": "Varchar(1)",
          "sensitive": false,
          "description": "Indicates if the second crew member was a paramedic."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "DOB",
          "dataType": "Date",
          "sensitive": false,
          "description": "The patient’s date of birth."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "AVPU",
          "dataType": "Varchar(20)",
          "sensitive": false,
          "description": "The patient’s AVPU score, i.e. Alert, Voice, Pain, Unresponsive."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "BP Systolic",
          "dataType": "Int",
          "sensitive": false,
          "description": "The patient’s Systolic blood pressure."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "SEWS",
          "dataType": "Int",
          "sensitive": false,
          "description": "The patient’s Scottish Early Warning System score (from 0 to 18)."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Patient Postcode",
          "dataType": "Varchar(10)",
          "sensitive": false,
          "description": "The patient’s postcode at the time of the incident."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Crew Member 1 Paramedic status",
          "dataType": "Varchar(1)",
          "sensitive": false,
          "description": "Indicates if the first crew member was a paramedic."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Call Stopped Reason",
          "dataType": "Varchar(40)",
          "sensitive": false,
          "description": "The reason the call was stopped recorded by the EMDC, e.g. Not required good intent."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Resource Mobilised Date Time",
          "dataType": "DateTime",
          "sensitive": false,
          "description": "The Date Time a resource was mobilized to attend an incident."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Callsign",
          "dataType": "Varchar(10)",
          "sensitive": false,
          "description": "A number to uniquely identify a resource, e.g. ED456. All callsigns were changed in April 2011 which may impact on callsign counts."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Resource Type",
          "dataType": "Varchar(40)",
          "sensitive": false,
          "description": "Type of vehicle of a callsign, e.g. Accident and Emergency. The asterisk submitted at the end of the file name will be removed during processing."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Method of Call",
          "dataType": "Varchar(255)",
          "sensitive": false,
          "description": "The method of call, e.g. Police, Fire Service, Coastguard, NHS24 etc. Hosptial will be corrected to Hospital during the file processing.  Unknown and N/A will be nulled."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Alcohol",
          "dataType": "DateTime",
          "sensitive": false,
          "description": "Indicates if the call was associated with alcohol abuse."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "ECG Choice",
          "dataType": "Varchar(2000)",
          "sensitive": false,
          "description": "A freetext field indicating the ECG Choice, e.g. NSR."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "SAS Data in UCD Datamart",
      "columns": [
        {
          "name": "Police In Attendance",
          "dataType": "DateTime",
          "sensitive": false,
          "description": "Indicates if there were police at the scene."
        }
      ],
      "description": "Scottish Ambulance Service (SAS) Data in UCD Datamart"
    },
    {
      "name": "NHS24 Data in UCD Datamart",
      "columns": [
        {
          "name": "Family Name",
          "dataType": "Varchar (20)",
          "sensitive": false,
          "description": "Patient’s surname."
        }
      ],
      "description": "NHS24 Data in UCD Datamart"
    },
    {
      "name": "NHS24 Data in UCD Datamart",
      "columns": [
        {
          "name": "Call Reason",
          "dataType": "Varchar (100)",
          "sensitive": false,
          "description": "Free text field describing the initial reason for the call."
        }
      ],
      "description": "NHS24 Data in UCD Datamart"
    },
    {
      "name": "NHS24 Data in UCD Datamart",
      "columns": [
        {
          "name": "Given Name",
          "dataType": "Varchar (20)",
          "sensitive": false,
          "description": "Patient’s forename."
        }
      ],
      "description": "NHS24 Data in UCD Datamart"
    },
    {
      "name": "NHS24 Data in UCD Datamart",
      "columns": [
        {
          "name": "Disposition ID",
          "dataType": "Varchar (3)",
          "sensitive": false,
          "description": "Outcome of Call (NHS 24 IH) A code to identify the outcome of the call, i.e. where the patient was advised to go to/contact.  A one-off reference file will be provided to populate the reference table, which will include the code, description and grouping."
        }
      ],
      "description": "NHS24 Data in UCD Datamart"
    },
    {
      "name": "NHS24 Data in UCD Datamart",
      "columns": [
        {
          "name": "Protocol Title",
          "dataType": "Varchar (100)",
          "sensitive": false,
          "description": "Diagnosis The final algorithm title, which is a free text field detailing the indicator of patient’s present symptoms."
        }
      ],
      "description": "NHS24 Data in UCD Datamart"
    },
    {
      "name": "NHS24 Data in UCD Datamart",
      "columns": [
        {
          "name": "Data transfer consent",
          "dataType": "Varchar (10)",
          "sensitive": false,
          "description": "Where the patient has given consent for their data to be transferred to GP systems Yes/No/Partial"
        }
      ],
      "description": "NHS24 Data in UCD Datamart"
    },
    {
      "name": "NHS24 Data in UCD Datamart",
      "columns": [
        {
          "name": "Call Received Date Time",
          "dataType": "Date Time Format DD/MM/YYYY.hh:mm:ss",
          "sensitive": false,
          "description": "The date time the call was received by NHS 24"
        }
      ],
      "description": "NHS24 Data in UCD Datamart"
    },
    {
      "name": "NHS24 Data in UCD Datamart",
      "columns": [
        {
          "name": "Call ID",
          "dataType": "Number (8)",
          "sensitive": false,
          "description": "A unique call reference number assigned by NHS 24."
        }
      ],
      "description": "NHS24 Data in UCD Datamart"
    },
    {
      "name": "NHS24 Data in UCD Datamart",
      "columns": [
        {
          "name": "Service Provider",
          "dataType": "Varchar (20)",
          "sensitive": false,
          "description": "Health Board of Treatment (NHS 24 OOH) The Health Board area which dealt with the call during the Out of Hours period (including Public Holidays and PLT). A reference file will be provided containing the character field and description."
        }
      ],
      "description": "NHS24 Data in UCD Datamart"
    },
    {
      "name": "NHS24 Data in UCD Datamart",
      "columns": [
        {
          "name": "Partner Area Code",
          "dataType": "Varchar (2)",
          "sensitive": false,
          "description": "Health Board of Treatment (NHS 24 IH) The code of the Health Board area which dealt with the call.   Note: the Partner Area Code field is selected by the member of staff who received the call and is dependent on the individual’s geographic knowledge.  Validation carried out on the Partner Area Code over all records in 2010 shows a 98% accuracy level. A reference file will be provided containing the character field and description."
        }
      ],
      "description": "NHS24 Data in UCD Datamart"
    },
    {
      "name": "NHS24 Data in UCD Datamart",
      "columns": [
        {
          "name": "Call Type",
          "dataType": "Varchar (20)",
          "sensitive": false,
          "description": "The type of call. Only Clinical and Dental calls will be included."
        }
      ],
      "description": "NHS24 Data in UCD Datamart"
    },
    {
      "name": "NHS24 Data in UCD Datamart",
      "columns": [
        {
          "name": "Gender",
          "dataType": "Varchar (10)",
          "sensitive": false,
          "description": "Patient’s current gender (Male, Female, Unknown)."
        }
      ],
      "description": "NHS24 Data in UCD Datamart"
    },
    {
      "name": "NHS24 Data in UCD Datamart",
      "columns": [
        {
          "name": "Postcode",
          "dataType": "Varchar (10)",
          "sensitive": false,
          "description": "The location of the patient at the time of the call, which may not be their home postcode."
        }
      ],
      "description": "NHS24 Data in UCD Datamart"
    },
    {
      "name": "NHS24 Data in UCD Datamart",
      "columns": [
        {
          "name": "Outcome Code",
          "dataType": "Varchar (5)",
          "sensitive": false,
          "description": "Outcome of Call (NHS 24 OOH) A code describing the action NHS 24 has recommended if the call was made out of hours (including Public Holidays and Protected Learning Time).  A one-off reference file will be provided to populate the reference table, which will include the code, description and grouping. Null will be defaulted to ‘No Outcome Code’."
        }
      ],
      "description": "NHS24 Data in UCD Datamart"
    },
    {
      "name": "NHS24 Data in UCD Datamart",
      "columns": [
        {
          "name": "Date/Time call Completed",
          "dataType": "Date Time Format DD/MM/YYYY.hh:mm:ss",
          "sensitive": false,
          "description": "The Date/Time the call was closed.  Note: the data item was referred to as the first time the call was completed because it is possible that the patient may call again and their original Call ID will be reopened. Only a single record will be submitted for each Call ID."
        }
      ],
      "description": "NHS24 Data in UCD Datamart"
    },
    {
      "name": "NHS24 Data in UCD Datamart",
      "columns": [
        {
          "name": "DOB",
          "dataType": "Date Time Format DD/MM/YYYY.hh:mm:ss",
          "sensitive": false,
          "description": "Patient’s birth date. The time component will be removed during file processing."
        }
      ],
      "description": "NHS24 Data in UCD Datamart"
    },
    {
      "name": "NHS24 Data in UCD Datamart",
      "columns": [
        {
          "name": "Call Origin",
          "dataType": "Varchar (20)",
          "sensitive": false,
          "description": "Where the call has originated from e.g. SAS (Cat 'C'), Other A reference list will be provided.  Null will be defaulted to ‘General NHS 24 Call’"
        }
      ],
      "description": "NHS24 Data in UCD Datamart"
    },
    {
      "name": "NHS24 Data in UCD Datamart",
      "columns": [
        {
          "name": "CHI Number",
          "dataType": "Varchar (10)",
          "sensitive": false,
          "description": "Patient's CHI number. The CHI number will be zero padded."
        }
      ],
      "description": "NHS24 Data in UCD Datamart"
    }
  ],
  "tissuesSampleCollection": [
    {
      "materialType": "None/not available"
    }
  ]
}

Copied to clipboard