Skip to content
Return to search

Scotland Accident and Emergency

Description

This dataset includes data items from the national A&E DataMart, the Community Health Index (CHI) database and derived chronic conditions items based on linked hospital admissions data

Related tags

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": "82",
    "gatewayPid": "b7c41ee3-3504-49e7-9916-0518e2a3f663",
    "issued": "2024-10-08T11:28:21.108Z",
    "modified": "2024-10-08T11:28:21.108Z",
    "version": "5.0.0",
    "revisions": [
      {
        "version": "4.0.0",
        "url": "https://healthdatagateway.org//dataset/82?version=4.0.0"
      },
      {
        "url": "https://healthdatagateway.org//dataset/82?version=5.0.0",
        "version": "5.0.0"
      }
    ]
  },
  "summary": {
    "abstract": "This dataset includes data items from the national A&E DataMart, the Community Health Index (CHI) database and derived chronic conditions items based on linked hospital admissions data",
    "contactPoint": "phs.edris@phs.scot",
    "keywords": "Accident & Emergency",
    "datasetType": "Health and disease",
    "datasetSubType": "Not applicable",
    "populationSize": -1,
    "description": "The A&E datamart was established in June 2007 to monitor the compliance of each NHS Board against the 4 hour wait standard. In July 2010 the A&E data mart was extended further to collect items such as diagnosis, several injury fields and an alcohol involved flag, which will be used to identify whether the patient’s alcohol consumption was a factor in the attendance. The collection of the new fields has been driven by a variety of SG policy decisions and interest from a number of organisations. Although there is now the facility to submit these additional fields, completeness and quality of the data is generally poor and further development is needed to improve it. There are two types of data submitted to the A&E datamart: episode and aggregate level data. All hospitals with Emergency Departments submit episode level data containing a detailed record for each patient attendance. Some smaller sites with minor injury units or community hospitals only submit aggregate files containing monthly summary attendance and compliance figures only. This is because they do not have the information systems and support to enable collection of detailed patient based information. Sites that submit episode level data account for around 97% of all attendances at A&E. This linked version of the dataset includes only A&E data submitted at episode level.  Additional items are included to enable further analysis: chronic conditions flags, based on historic hospital admissions data; a care home flag derived from the CHI database",
    "shortTitle": "Scotland Accident and Emergency",
    "title": "Scotland Accident and Emergency",
    "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",
    "datasetCompleteness": "https://publichealthscotland.scot/our-areas-of-work/acute-and-emergency-services/urgent-and-unscheduled-care/accident-and-emergency/metadata/data-quality/"
  },
  "provenance": {
    "origin": {
      "purpose": "Care",
      "collectionSituation": "Secondary care - Accident and Emergency",
      "imageContrast": "Not stated"
    },
    "temporal": {
      "startDate": "2011-01-01T22:00:00Z",
      "timeLag": "1-2 months",
      "accrualPeriodicity": "Monthly",
      "distributionReleaseDate": "2024-07-28T23:00:00Z"
    }
  },
  "accessibility": {
    "access": {
      "deliveryLeadTime": "Not applicable",
      "jurisdiction": "GB",
      "dataController": "Public Health Scotland",
      "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": "Collaboration required;,;Institution-specific restrictions;,;Not for profit use",
      "resourceCreator": {
        "name": "National Services Scotland;,;Public Health Scotland"
      }
    },
    "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/accident-and-emergency-data-mart-ae2/ ,   https://www.researchdata.scot/media/3nhajpvr/scotland-accident-and-emergency-variables_220824.pdf"
  },
  "structuralMetadata": [
    {
      "name": "Header Record",
      "columns": [
        {
          "name": "Extract Type",
          "dataType": "3 characters",
          "sensitive": false,
          "description": "There are two options; AEE for episode files AES for aggregate files."
        }
      ],
      "description": "The header record is the first line of a file and consists of several items that are used to identify the file, allowing the file to be validated before it is loaded into the data mart.  The header record must be present in all files, both episode and aggregate level, with each item separated by a comma.  The header record must contain ALL of the following items;"
    },
    {
      "name": "Header Record",
      "columns": [
        {
          "name": "Extract Month",
          "dataType": "6 digits",
          "sensitive": false,
          "description": "The year and month the data relates to in the format CCYYMM (e.g. 201802 for data from February 2018)."
        }
      ],
      "description": "The header record is the first line of a file and consists of several items that are used to identify the file, allowing the file to be validated before it is loaded into the data mart.  The header record must be present in all files, both episode and aggregate level, with each item separated by a comma.  The header record must contain ALL of the following items;"
    },
    {
      "name": "Header Record",
      "columns": [
        {
          "name": "Submission",
          "dataType": "1 to 4 digits",
          "sensitive": false,
          "description": "A number identifying the sequence of submission from a single location.  The submission number must be incremented each time a new file is submitted, even when a file is resubmitted."
        }
      ],
      "description": "The header record is the first line of a file and consists of several items that are used to identify the file, allowing the file to be validated before it is loaded into the data mart.  The header record must be present in all files, both episode and aggregate level, with each item separated by a comma.  The header record must contain ALL of the following items;"
    },
    {
      "name": "Header Record",
      "columns": [
        {
          "name": "Sending Location Code",
          "dataType": "5 characters",
          "sensitive": false,
          "description": "The location code identifying the location where the data was sent from (e.g. G107H for the Glasgow Royal Infirmary)."
        }
      ],
      "description": "The header record is the first line of a file and consists of several items that are used to identify the file, allowing the file to be validated before it is loaded into the data mart.  The header record must be present in all files, both episode and aggregate level, with each item separated by a comma.  The header record must contain ALL of the following items;"
    },
    {
      "name": "Header Record",
      "columns": [
        {
          "name": "Date of Extract",
          "dataType": "8 digits",
          "sensitive": false,
          "description": "The date the extract was taken in the format CCYYMMDD (e.g. 20180301 for the 1st March 2018)."
        }
      ],
      "description": "The header record is the first line of a file and consists of several items that are used to identify the file, allowing the file to be validated before it is loaded into the data mart.  The header record must be present in all files, both episode and aggregate level, with each item separated by a comma.  The header record must contain ALL of the following items;"
    },
    {
      "name": "Header Record",
      "columns": [
        {
          "name": "Record Count",
          "dataType": "1 to 8 digits",
          "sensitive": false,
          "description": "The number of records in the file."
        }
      ],
      "description": "The header record is the first line of a file and consists of several items that are used to identify the file, allowing the file to be validated before it is loaded into the data mart.  The header record must be present in all files, both episode and aggregate level, with each item separated by a comma.  The header record must contain ALL of the following items;"
    },
    {
      "name": "Aggregate File",
      "columns": [
        {
          "name": "Location code",
          "dataType": "5 characters",
          "sensitive": false,
          "description": "The hospital location code"
        }
      ],
      "description": "Note: In aggregate files ONLY new and unplanned return attendances should be counted in the attendance figures (planned returns and recalls should be excluded)."
    },
    {
      "name": "Aggregate File",
      "columns": [
        {
          "name": "Number of Attendances",
          "dataType": "6 digits",
          "sensitive": false,
          "description": "The number of A&E attendances"
        }
      ],
      "description": "Note: In aggregate files ONLY new and unplanned return attendances should be counted in the attendance figures (planned returns and recalls should be excluded)."
    },
    {
      "name": "Aggregate File",
      "columns": [
        {
          "name": "Number Meeting Target",
          "dataType": "6 digits",
          "sensitive": false,
          "description": "The number of A&E attendances seen within 4 hours"
        }
      ],
      "description": "Note: In aggregate files ONLY new and unplanned return attendances should be counted in the attendance figures (planned returns and recalls should be excluded)."
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Place of Incident",
          "dataType": "2 to 3 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Diagnosis2",
          "dataType": "2 digits",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Significant Facility",
          "dataType": "2 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Time Since Injury",
          "dataType": "2 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Patient Management Type",
          "dataType": "2 digits",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Healthcare Professional (HCP) Number",
          "dataType": "5 to 8 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Procedure3",
          "dataType": "2 to 3 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Case Reference Number",
          "dataType": "6 to 14 characters",
          "sensitive": false,
          "description": "Mandatory"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Disease3",
          "dataType": "6 character ICD10 code",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Date and Time of Discharge, Admission or Transfer",
          "dataType": "(CCYYMMDDhhmmss)",
          "sensitive": false,
          "description": "Mandatory"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Patient Postcode",
          "dataType": "8 character postcode",
          "sensitive": false,
          "description": "Mandatory"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Procedure2",
          "dataType": "2 to 3 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Disease1",
          "dataType": "6 character ICD10 code",
          "sensitive": false,
          "description": "Mandatory \n(at least 1 of these 3) (Diagnosis1 / Disease1  / Diagnosis1 Text )"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Investigation Type1",
          "dataType": "2 to 3 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Alcohol Involved",
          "dataType": "2 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Data Item",
          "dataType": "Format",
          "sensitive": false,
          "description": "Type"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Discharge Type",
          "dataType": "2 to 3 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Arrival Date and Time",
          "dataType": "(CCYYMMDDhhmmss)",
          "sensitive": false,
          "description": "Mandatory"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Objects/Substances Involved  in Producing Injury",
          "dataType": "2 to 3 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Referred To 2",
          "dataType": "2 to 3 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Intent of Injury",
          "dataType": "2 to 3 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Patient Year of Birth",
          "dataType": "4 digits",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Diagnosis1",
          "dataType": "2 digits",
          "sensitive": false,
          "description": "Mandatory \n(at least 1 of these 3) (Diagnosis1 / Disease1  / Diagnosis1 Text )"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Procedure1",
          "dataType": "2 to 3 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Nature of Injury",
          "dataType": "2 to 3 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Referred To 3",
          "dataType": "2 to 3 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Impairment",
          "dataType": "2 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Diagnosis1 Text",
          "dataType": "100 characters",
          "sensitive": false,
          "description": "Mandatory \n(at least 1 of these 3) (Diagnosis1 / Disease1  / Diagnosis1 Text )"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "CHI Number",
          "dataType": "10 characters",
          "sensitive": false,
          "description": "Mandatory"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Ethnicity",
          "dataType": "2 to 6 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Activity when Injured",
          "dataType": "2 to 3 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Investigation Type3",
          "dataType": "2 to 3 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Disease2",
          "dataType": "6 character ICD10 code",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Investigation Type2",
          "dataType": "2 to 3 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Arrival Mode",
          "dataType": "2 characters",
          "sensitive": false,
          "description": "Mandatory"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Attendance Category",
          "dataType": "2 digits",
          "sensitive": false,
          "description": "Mandatory"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Date and Time of Event",
          "dataType": "(CCYYMMDDhhmmss)",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Triage Category",
          "dataType": "2 digits",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Diagnosis3",
          "dataType": "2 digits",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Reason for Wait",
          "dataType": "2 to 3 characters",
          "sensitive": false,
          "description": "Mandatory"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Alleged Perpetrator of Violence",
          "dataType": "2 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Diagnosis3 Text",
          "dataType": "100 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Sexual Orientation",
          "dataType": "2 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Location Code",
          "dataType": "5 characters",
          "sensitive": false,
          "description": "Mandatory"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Referred To 1",
          "dataType": "2 to 3 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Date and Time of First Full Clinical Assessment",
          "dataType": "(CCYYMMDDhhmmss)",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Common Preventive Measures",
          "dataType": "2 to 3 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "External Cause of Injury",
          "dataType": "2 to 3 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Presenting Complaint",
          "dataType": "100 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Religion",
          "dataType": "2 to 6 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Bodily Location of Injury",
          "dataType": "2 to 3 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Date and Time of Completion of Treatment",
          "dataType": "(CCYYMMDDhhmmss)",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Patient Flow",
          "dataType": "1 digit",
          "sensitive": false,
          "description": "Mandatory"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Discharge Destination",
          "dataType": "2 to 3 characters",
          "sensitive": false,
          "description": "Mandatory"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Referral Source",
          "dataType": "2 to 3 characters",
          "sensitive": false,
          "description": "Mandatory"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    },
    {
      "name": "Episode File",
      "columns": [
        {
          "name": "Diagnosis2 Text",
          "dataType": "100 characters",
          "sensitive": false,
          "description": "Optional"
        }
      ],
      "description": "A full list of the codes and definitions for each of the episode level data items is given in the document A&E Data Recording Manual. The Data Recording manual and the AE2 User guide can be both found on the ISD web pages: \n \nhttp://www.isdscotland.org/Products-and-Services/Data-Support-and-Monitoring/Accidentand-Emergency/"
    }
  ],
  "tissuesSampleCollection": [
    {
      "materialType": "None/not available"
    }
  ]
}

Copied to clipboard

Additional information

  • Documentation
    Documentation
  • Language
    English
  • Geographic Area
    Scotland

Related resources

Available resource files can be downloaded below.

File name

Scotland Accident And Emergency Variables 220824

Type

.PDF

Requesting access to this data

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

  • Publisher
    Public Health Scotland
  • Contact
    phs.edris@phs.scot

Find out how to apply to access this dataset

Synthetic data

Synthetic data is not yet available for this dataset. 

Key Details

  • Formal release or publication date
    28/07/2024
  • Start time period of data covered by this dataset
    01/01/2011
  • End time period of data covered by this dataset
    No information available
  • Documentation
    The A&E datamart was established in June 2007 to monitor the compliance of each NHS Board against the 4 hour wait standard. In July 2010 the A&E data mart was extended further to collect items such as diagnosis, several injury fields and an alcohol involved flag, which will be used to identify whether the patient’s alcohol consumption was a factor in the attendance. The collection of the new fields has been driven by a variety of SG policy decisions and interest from a number of organisations. Although there is now the facility to submit these additional fields, completeness and quality of the data is generally poor and further development is needed to improve it. There are two types of data submitted to the A&E datamart: episode and aggregate level data. All hospitals with Emergency Departments submit episode level data containing a detailed record for each patient attendance. Some smaller sites with minor injury units or community hospitals only submit aggregate files containing monthly summary attendance and compliance figures only. This is because they do not have the information systems and support to enable collection of detailed patient based information. Sites that submit episode level data account for around 97% of all attendances at A&E. This linked version of the dataset includes only A&E data submitted at episode level. Additional items are included to enable further analysis: chronic conditions flags, based on historic hospital admissions data; a care home flag derived from the CHI database
  • Geographic Area
    United Kingdom,Scotland
  • Landing page
  • Language
    English
  • The dataset type
    PHYSICAL
  • Update frequency
    monthly