File name
Scotland Accident and Emergency - variables
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.
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
[{"id": "", "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", "dataElementsCount": 3, "dataElements": [{"id": "", "description": "The hospital location code", "name": "Location code", "type": "PrimitiveType"}, {"id": "", "description": "The number of A&E attendances", "name": "Number of Attendances", "type": "PrimitiveType"}, {"id": "", "description": "The number of A&E attendances seen within 4 hours", "name": "Number Meeting Target", "type": "PrimitiveType"}]}, {"id": "", "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", "dataElementsCount": 56, "dataElements": [{"id": "", "description": "Optional", "name": "Place of Incident", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Diagnosis2", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Significant Facility", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Time Since Injury", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Patient Management Type", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Healthcare Professional (HCP) Number", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Procedure3", "type": "PrimitiveType"}, {"id": "", "description": "Mandatory", "name": "Case Reference Number", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Disease3", "type": "PrimitiveType"}, {"id": "", "description": "Mandatory", "name": "Date and Time of Discharge, Admission or Transfer", "type": "PrimitiveType"}, {"id": "", "description": "Mandatory", "name": "Patient Postcode", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Procedure2", "type": "PrimitiveType"}, {"id": "", "description": "Mandatory \n(at least 1 of these 3) (Diagnosis1 / Disease1 / Diagnosis1 Text )", "name": "Disease1", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Investigation Type1", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Alcohol Involved", "type": "PrimitiveType"}, {"id": "", "description": "Type", "name": "Data Item", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Discharge Type", "type": "PrimitiveType"}, {"id": "", "description": "Mandatory", "name": "Arrival Date and Time", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Objects/Substances Involved in Producing Injury", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Referred To 2", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Intent of Injury", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Patient Year of Birth", "type": "PrimitiveType"}, {"id": "", "description": "Mandatory \n(at least 1 of these 3) (Diagnosis1 / Disease1 / Diagnosis1 Text )", "name": "Diagnosis1", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Procedure1", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Nature of Injury", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Referred To 3", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Impairment", "type": "PrimitiveType"}, {"id": "", "description": "Mandatory \n(at least 1 of these 3) (Diagnosis1 / Disease1 / Diagnosis1 Text )", "name": "Diagnosis1 Text", "type": "PrimitiveType"}, {"id": "", "description": "Mandatory", "name": "CHI Number", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Ethnicity", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Activity when Injured", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Investigation Type3", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Disease2", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Investigation Type2", "type": "PrimitiveType"}, {"id": "", "description": "Mandatory", "name": "Arrival Mode", "type": "PrimitiveType"}, {"id": "", "description": "Mandatory", "name": "Attendance Category", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Date and Time of Event", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Triage Category", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Diagnosis3", "type": "PrimitiveType"}, {"id": "", "description": "Mandatory", "name": "Reason for Wait", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Alleged Perpetrator of Violence", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Diagnosis3 Text", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Sexual Orientation", "type": "PrimitiveType"}, {"id": "", "description": "Mandatory", "name": "Location Code", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Referred To 1", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Date and Time of First Full Clinical Assessment", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Common Preventive Measures", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "External Cause of Injury", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Presenting Complaint", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Religion", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Bodily Location of Injury", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Date and Time of Completion of Treatment", "type": "PrimitiveType"}, {"id": "", "description": "Mandatory", "name": "Patient Flow", "type": "PrimitiveType"}, {"id": "", "description": "Mandatory", "name": "Discharge Destination", "type": "PrimitiveType"}, {"id": "", "description": "Mandatory", "name": "Referral Source", "type": "PrimitiveType"}, {"id": "", "description": "Optional", "name": "Diagnosis2 Text", "type": "PrimitiveType"}]}, {"id": "", "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", "dataElementsCount": 6, "dataElements": [{"id": "", "description": "There are two options; AEE for episode files AES for aggregate files.", "name": "Extract Type", "type": "PrimitiveType"}, {"id": "", "description": "The year and month the data relates to in the format CCYYMM (e.g. 201802 for data from February 2018).", "name": "Extract Month", "type": "PrimitiveType"}, {"id": "", "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.", "name": "Submission", "type": "PrimitiveType"}, {"id": "", "description": "The location code identifying the location where the data was sent from (e.g. G107H for the Glasgow Royal Infirmary).", "name": "Sending Location Code", "type": "PrimitiveType"}, {"id": "", "description": "The date the extract was taken in the format CCYYMMDD (e.g. 20180301 for the 1st March 2018).", "name": "Date of Extract", "type": "PrimitiveType"}, {"id": "", "description": "The number of records in the file.", "name": "Record Count", "type": "PrimitiveType"}]}]
Copied to clipboard
Available resource files can be downloaded below.
Scotland Accident and Emergency - variables
This is a secure dataset that can only be accessed by researchers from approved organisations.