NHS Tayside and Fife Accident & Emergency Dataset (PHS/National)
Summary
Abstract
Accident and Emergency Statistics. There are two types: episode and aggregate level data.
-
Contact point
-
Digital object identifier (DOI)Not available
Keywords
Publisher
-
NameHealth Informatics Centre - University of Dundee
-
Logo
Not available
-
DescriptionNot available
-
Contact pointNot available
Documentation
Description
Accident and Emergency Statistics. 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, they are still under development and PHS are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E.
-
Associated media
- Not available
-
Is part of
- Not available
-
Landing page
Coverage
Spatial
-
Spatial coverage
United Kingdom, Scotland, Tayside Region, United Kingdom, Scotland, Fife
-
Geographic levelsNot available
Temporal
-
Start date01/06/2007
-
End dateNot available
-
FrequencyMonthly
-
Distribution release date24/09/2021
Provenance
-
PurposeCare
-
SourceEpr
-
Collection situationSecondary care - Accident and Emergency
Access and governance
-
Conditions of accessGeneral 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 useDisclosure control
-
Resource creatorPHS/ NHS Tayside & Fife
-
Is referenced byNot available
Access
-
Access rights
-
Access serviceHIC has implemented a remote-access Trusted Research Environment to protect data confidentiality, satisfy public concerns about data loss and reassure Data Controllers about HIC’s secure management and processing of their data. Data is not released externally to data users for analysis on their own computers but placed on a server at HIC, within a restricted, secure IT environment, where the data user is given secure remote access to carry out their analysis. Full details are available via the following link: https://www.dundee.ac.uk/hic/safe-haven
-
JurisdictionGB-SCT
-
Data controllerLocal NHS boards
-
Data processorUniversity of Dundee, Health Informatics Centre
Format and standards
-
LanguageEnglish
-
FormatCsv, database
Enrichment and linkage
-
Related datasets
- Not available
-
Linkage opportunityNot 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
{ "summary": { "title": "NHS Tayside and Fife Accident & Emergency Dataset (PHS/National)", "abstract": "Accident and Emergency Statistics. There are two types: episode and aggregate level data.", "keywords": "Accident & Emergency;,;HIC;,;Tayside;,;Fife;,;Scotland", "publisher": { "name": "Health Informatics Centre - University of Dundee", "gatewayId": "5baa31c1-0280-4482-b8b7-a4953869f184" }, "inPipeline": "Not available", "shortTitle": "NHS Tayside and Fife Accident & Emergency Dataset (PHS/National)", "datasetType": "Health and disease", "description": "Accident and Emergency Statistics. 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, they are still under development and PHS are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E.", "contactPoint": "hicsupport@dundee.ac.uk", "datasetSubType": "Not applicable", "populationSize": 739000 }, "coverage": { "spatial": "United Kingdom,Scotland,Tayside Region;,;United Kingdom,Scotland,Fife", "followUp": "Unknown", "typicalAgeRange": "0-150" }, "required": { "issued": "2024-10-08T11:28:32.89151Z", "version": "4.0.0", "modified": "2024-10-08T11:28:32.891522Z", "gatewayId": "126", "revisions": [ { "url": "https://web.prod.hdruk.cloud//dataset/126?version=1.0.0", "version": "1.0.0" } ], "gatewayPid": "d8d3fa61-8a4d-41c1-b0d9-0da3b7d8843e" }, "provenance": { "origin": { "source": "EPR", "purpose": "Care", "imageContrast": "Not stated", "collectionSituation": "Secondary care - Accident and Emergency" }, "temporal": { "timeLag": "2-4 weeks", "startDate": "2007-06-01", "accrualPeriodicity": "Monthly", "distributionReleaseDate": "2021-09-24" } }, "observations": [ { "observedNode": "Persons", "measuredValue": 739000, "observationDate": "2021-09-24", "measuredProperty": "COUNT", "disambiguatingDescription": "739,000 patients in the dataset" }, { "observedNode": "Events", "measuredValue": 2801000, "observationDate": "2021-11-10", "measuredProperty": "Count", "disambiguatingDescription": "2,801,000 events in the dataset" } ], "accessibility": { "usage": { "resourceCreator": { "name": "PHS/ NHS Tayside & Fife" }, "dataUseLimitation": "General research use", "dataUseRequirement": "Disclosure control" }, "access": { "accessRights": "https://www.dundee.ac.uk/hic/governance-service", "jurisdiction": "GB-SCT", "accessService": "HIC has implemented a remote-access Trusted Research Environment to protect data confidentiality, satisfy public concerns about data loss and reassure Data Controllers about HIC’s secure management and processing of their data.\n\nData is not released externally to data users for analysis on their own computers but placed on a server at HIC, within a restricted, secure IT environment, where the data user is given secure remote access to carry out their analysis.\n\nFull details are available via the following link:\nhttps://www.dundee.ac.uk/hic/safe-haven", "dataProcessor": "University of Dundee, Health Informatics Centre", "dataController": "Local NHS boards", "deliveryLeadTime": "2-4 weeks", "accessRequestCost": "Quotation available on request", "accessServiceCategory": "TRE/SDE" }, "formatAndStandards": { "formats": "CSV;,;Database", "languages": "en", "vocabularyEncodingSchemes": "LOCAL" } }, "structuralMetadata": [ { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "ARRIVAL_TIME_DATE", "dataType": "datetime", "sensitive": false, "description": "This field represents the date the patient arrived at A&E.." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "COT_TIME_DATE", "dataType": "datetime", "sensitive": false, "description": "This field represents the Completion Of Treatment Time and Date." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "DAT_TIME_DATE", "dataType": "datetime", "sensitive": false, "description": "This field represents the date and time of Discharge, Admission or Transfer." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "HB_TREATMENT_CODE", "dataType": "varchar(1)", "sensitive": false, "description": "This field represents the Health Board where treatment was received. F NHS FIFE T NHS TAYSIDE." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "HB_TREATMENT_DESC", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for HB_TREATMENT_CODE." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "TREATMENT_LOCATION_CODE", "dataType": "varchar(6)", "sensitive": false, "description": "This field represents the location where treatment was carried out. Each location in Scotland, at which events pertinent to the Scottish Health Service take place, is allocated a location code. The code is a five character code and is maintained jointly by ISD and General Register Office (Scotland). F704H VICTORIA HOSPITAL F805H QUEEN MARGARET HOSPITAL T101H NINEWELLS HOSPITAL T202H PERTH ROYAL INFIRMARY T205H ST MARGARET'S HOSPITAL T207H ABERFELDY COTTAGE HOSPITAL T208H IRVINE MEMORIAL HOSPITAL T209H BLAIRGOWRIE & RATTRAY COTTAGE HOSPITAL T304H ARBROATH INFIRMARY T305H BRECHIN INFIRMARY T316H CRIEFF COMMUNITY HOSPITAL T319H WHITEHILLS HEALTH AND COMMUNITY CARE CENTRE T320H PITLOCHRY COMMUNITY HOSPITAL T357C LINKS HEALTH CENTRE." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "TREATMENT_LOCATION_NAME", "dataType": "varchar(300)", "sensitive": false, "description": "This field represents the description for TREATMENT_LOCATION_CODE." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "SENDING_LOCATION_CODE", "dataType": "varchar(6)", "sensitive": false, "description": "Sending Location is a five character alpha-numeric code used in data processing to identify the NHS organisation where an SMR submission has been sent from. Sending Location is used in conjunction with the Episode Record Key and SMR record type to provide a unique code for each SMR record on the national file. ." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "PAT_MARITAL_STATUS_CODE", "dataType": "varchar(1)", "sensitive": false, "description": "This field represents the marital statement of the patient A Never married nor registered civil partnership B Married C Registered civil partnership D Separated, but still married E Separated, but still in civil partnership F Divorced G Dissolved civil partnership H Widowed J Surviving civil partner Y Other Z Not known ." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "PAT_MARITAL_STATUS_DESC", "dataType": "varchar(28)", "sensitive": false, "description": "This field represents the description for PAT_MARITAL_STATUS_CODE." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "PAT_ETHNIC_GROUP_CODE", "dataType": "varchar(2)", "sensitive": false, "description": "This field represents the current ethnicity classification (2011 Census categories). Group A - White 1A Scottish 1B Other British 1C Irish 1K Gypsy/ Traveller 1L Polish 1Z Other white ethnic group Group B - Mixed or multiple ethnic groups 2A Any mixed or multiple ethnic groups Group C - Asian, Asian Scottish or Asian British 3F Pakistani, Pakistani Scottish or Pakistani British 3G Indian, Indian Scottish or Indian British 3H Bangladeshi, Bangladeshi Scottish or Bangladeshi British 3J Chinese, Chinese Scottish or Chinese British 3Z Other Asian, Asian Scottish or Asian British Group D - African 4D African, African Scottish or African British 4Y Other African Group E - Caribbean or Black 5C Caribbean, Caribbean Scottish or Caribbean British 5D Black, Black Scottish or Black British 5Y Other Caribbean or Black Group F - Other ethnic group 6A Arab, Arab Scottish or Arab British 6Z Other ethnic group Group G - Refused/Not provided by patient 98 Refused/Not provided by patient Group H - Not Known 99 Not Known ." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "PAT_ETHINC_GROUP_DESC", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for PAT_ETHINC_GROUP_CODE." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "PAT_DEATH_INDICATOR", "dataType": "char(1)", "sensitive": false, "description": "This field indicates whether the patient is dead. Y Or N." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "PAT_DATE_OF_DEATH", "dataType": "datetime", "sensitive": false, "description": "This field represents the patients date of death." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "ARRIVAL_MODE_CODE", "dataType": "varchar(2)", "sensitive": false, "description": "This field represents the substantive means by which a patient arrived at an A&E department. 01 Ambulance (road) 02 Ambulance (air) 03 Ambulance + A&E retrieval team 04 Out of hours transport 05 Private transport 06 Public transport 07 Walking 08 Police/prison transport 98 Other 99 Not known." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "ARRIVAL_MODE_DESC", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for ARRIVAL_MODE_CODE." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "AE_REFERRAL_SOURCE_CODE", "dataType": "varchar(3)", "sensitive": false, "description": "This field represents one of a group of organisations, professionals and other individuals who make a referral to an A&E department. 01 Self referral 01A Self referral - Patient 01B Associated Person eg. parent, friend, employer, neighbour. 02 Healthcare professional/service/organisation 02A Healthcare professional/service/organisation - GP 02B Healthcare professional/service/organisation - out of hours service 02C Healthcare professional/service/organisation - 999 emergency services 02D Healthcare professional/service/organisation - NHS24 02E Healthcare professional/service/organisation - Minor injuries unit 02F Healthcare professional/service/organisation - same hospital 02G Healthcare professional/service/organisation - other hospital 02H Healthcare professional/service/organisation - other healthcare professional 02J Healthcare professional/service/organisation - GP referral for admission 03 Local authority 03A Local authority - education 03B Local authority - social services 03C Local authority - police 03D Local authority - other local authority dept. 03E Local Authority - care/nursing home 04 Private professional/agency/organisation 04A Private - care/nursing home 05 Other agency 05A Other agency - prison/penal establishment 05B Other agency - judicial 05C Other agency - voluntary organisation 05D Other agency - armed forces 98 Other 99 Not known." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "AE_REFERRAL_SOURCE_DESC", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for AE_REFERRAL_SOURCE_CODE." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "PLACE_OF_INCIDENT_CODE", "dataType": "varchar(3)", "sensitive": false, "description": "This field represents where the person was when the incident started. This refers to the high level type of area, building or place where the injury event commenced. 01 Place of residence 01A Place of residence - home 01B Place of residence - residential institution 02 Transport area 02A Transport area - public highway, street or road 02B Transport area - other transport area 03 Business area (exl. Recreation & sports areas) 03A Business area - industrial or construction area 03B Business area - farm or other place of primary production 03C Business area - commercial area - non recreational 04 School, educational area 05 Sports & Recreational area 05A Sports & Recreational area - sports and athletic area 05B Sports & Recreational area - recreational area, cultural area or public building 05C Sports & Recreational area - countryside / open nature area 06 Medical service area/ healthcare area 98 Other specified 99 Not known." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "PLACE_OF_INCIDENT_DESC", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for PLACE_OF_INCIDENT_CODE." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "DISCHARGE_DESTINATION_CODE", "dataType": "varchar(3)", "sensitive": false, "description": "This field represents the immediate destination of the patient on discharge from the A&E department. 00 Death 01 Private Residence 01A Usual place of residence 01B Not usual place of residence e.g. staying with relatives or friends 02 Residential institution 02A Usual place of residence 02B Not usual place of residence 03 Temporary residence 03A Holiday accommodation 03B Student accommodation 03C Legal establishment /prison 03D No fixed abode 03Z Other temporary residence 04 Admission to same NHS healthcare provider / hospital 04A A&E Ward Includes A&E observation ward, A&E short stay ward, etc 04B Assessment unit 04C Medical Ward Includes medical admissions unit, coronary care unit 04D Surgical Ward Includes surgical admissions unit, orthopaedic ward 04Z Other Ward 05 Transfer to same/other hospital 05A Psychiatric hospital 05B Other specialist centre e.g. eye hospital, paediatric hospital 05C Community hospital 05D Transferred to Out of Hours (triaged in A&E) 05E Transferred to Out of Hours (not triaged in A&E) 05F Advised to attend GP/Primary Care 05G A&E 05H NHS24 05Z Other NHS hospital 06 Private healthcare provider 98 Other 99 Other." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "DISCHARGE_DESTINATION_DESC", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for DISCHARGE_DESTINATION_CODE." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "REFERRED_TO_1_CODE", "dataType": "varchar(3)", "sensitive": false, "description": "This field represents the professionals, services or organisations a patient may be referred on to for the purpose of further investigation and/or ongoing care following an attendance at an A&E department. 01 - Clinic 01A A&E Clinic 01B Fracture Clinic 01Z Other Clinic 02 - Healthcare Professional/Service or Organisation 02A GP 02B Practice Nurse 02C Community Nurse Excludes Community Psychiatric Nurse 02D Specialist nurse 02E Physiotherapist 02F Other AHP 02G Dentist 02H Mental Health Service Includes Community Psychiatric Nurse 02J Community pharmacy 02Z Other 03 - Local Authority 03A Education 03B Social Work 03Z Other Includes Police 04 - Private Agency / Organisation 05 - Other Agency Includes voluntary agency 06 - Drug/alcohol service May be provided by health service, local authority, private or voluntary agency 98 - Other 99 - Not Known." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "REFERRED_TO_1_DESC", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for REFERRED_TO_1_CODE." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "ATTENDANCE_CATEGORY_CODE", "dataType": "varchar(2)", "sensitive": false, "description": "This field represents a record of whether a patient is making a first or follow-up attendance at a particular A&E department. 01 New 02 Return - planned 03 Return - unplanned 04 Recall." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "ATTENDANCE_CATEGORY_DESC", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for ATTENDANCE_CATEGORY." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "REASON_FOR_LONG_WAIT_CODE", "dataType": "varchar(3)", "sensitive": false, "description": "This field represents the reason(s) for keeping the patient in the A&E department if the patient waited longer than 4 hours between arriving at the A&E department and admission, discharge or transfer. 00 - No Delay Patient's whose stay in A&E is < 4 hours 01 - Wait for a bed 02 - Wait for transport Commissioned by A&E 03 - Wait for treatment - Refers to the initial A&E treatment 03A To commence 03B To be completed 05 - Wait for diagnostic test(s) 05A To be performed 05B Awaiting results Refers to results which will determine the next step in the patient journey 06 - Wait for first assessment 07 - Clinical reason(s) In the judgement of the senior emergency department doctor and/ or nurse involved, the patient's condition mandates a stay in the emergency department of greater than four hours, i.e. where the patient is too ill to be moved 98 - Other reason (specify)." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "REASON_FOR_LONG_WAIT_DESC", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for REASON_FOR_LONG_WAIT_CODE." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "PATIENT_FLOW_CODE", "dataType": "varchar(3)", "sensitive": false, "description": "This field represents the patients’ predominant need for ongoing assessment to determine the next step in their care pathways. NULL NULL 1 Flow 1: Minor Injury & Illness 2 Flow 2: Acute assessment - includes major injuries 3 Flow 3: Medical Admissions 4 Flow 4: Surgical Admissions 5 Flow 5: Out of Hospital Care." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "PATIENT_FLOW_DESC", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for PATIENT_FLOW_CODE." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "AE_PRESENTING_COMPLAINT_TEXT", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the main complaint that that the patient presents with at the Emergency Department." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "ALCOHOL_INVOLVED_CODE", "dataType": "varchar(3)", "sensitive": false, "description": "This field represents a subjective judgement about whether or not the person’s alcohol consumption constituted a factor in this attendance at the Emergency Department. 01 Yes 02 No." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "ALCOHOL_INVOLVED_DESC", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for ALCOHOL_INVOLVED_CODE." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "TRIAGE_CATEGORY_CODE", "dataType": "varchar(2)", "sensitive": false, "description": "This field represents the category assigned to a patient as a result of an initial assessment by medical or nursing staff in an A&E department. 00 Not triaged 01 Immediate resuscitation 02 Very urgent 03 Urgent 04 Standard 05 Non-urgent." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "TRIAGE_CATEGORY_DESC", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for TRIAGE_CATEGORY_CODE." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "PAT_MGT_CATEGORY_CODE", "dataType": "varchar(2)", "sensitive": false, "description": "This field represents a retrospective classification of the patient according to the clinical management received during their A&E attendance. 01 Resuscitation Patients underwent resuscitation, regardless of outcome 02 Major Patients required a longer period of assessment and observation in addition to diagnostics and treatment 03 Minor Patients treated and discharged relatively quickly and who may have had straightforward diagnostic assessment eg. Single plain X-ray 99 Not Known ." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "PAT_MGT_CATEGORY_DESCRIPTION", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for PAT_MGT_CATEGORY_CODE." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "TIME_BAND_SINCE_EVENT_CODE", "dataType": "varchar(2)", "sensitive": false, "description": "This field represents the time since the event. 01 Up to 6 hours 02 6 to 12 hours 03 12 to 24 hours 04 24 to 48 hours 05 Over 48 hours." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "TIME_BAND_SINCE_EVENT_DESC", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for TIME_BAND_SINCE_EVENT_CODE." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "BODILY_LOCATION_OF_INJURY_CODE", "dataType": "varchar(3)", "sensitive": false, "description": "This field represents the bodily location of the injury chiefly responsible for occasioning the attendance of the person at the health care facility. 00 None 01 Intracranial/brain 01A Focal 01B Diffuse 01C Extradural 01D Subdural 01Z Other intracranial 02 Head 02A Scalp 02B Frontal 02C Parietal 02D Occipital 02E Temporal 02F Cranial nerves 02Z Other head 03 Face 03A Orbit 03B Maxilla 03C Zygoma 03D Cheek 03E Upper lip 03F Lower lip 03G Temporomandibular joint 03H Mandible 03Z Other face 04 Eye 04A Upper eyelid 04B Lower eyelid 04C Periorbital area 04D Cornea 04E Sclera 04F Conjunctiva 04G Lens 04H Intraorbital tissue 04Z Other eye 05 Nose 05A Skin 05B Nasal bones 05C Nasal septum 05D Nasal cavity 05Z Other nose 06 Ear 06A Pinna 06B Lobe 06C Ear canal/external auditory canal 06D Ear drum/tympanic membrane 06E Middle ear 06F Inner ear 06Z Other ear 07 Oral cavity 07A Oral mucosa 07B Tongue 07C Teeth 07D Tonsil 07E Epiglottis 07F Uvula 07G Gingiva 07H Palate 07J Vallecula 07Z Other oral cavity 08 Neck 08A Skin and superficial area 08B Larynx and trachea 08C Oesophagus (cervical) 08D Blood vessels 08E Vertebra/spine (cervical) 08F Cervical cord 08G Brachial plexus 08Z Other neck 09 Thorax 09A Skin and superficial fascia 09B Front wall of chest 09C Back wall of chest 09D Breast 09E Ribs 09F Sternum 09G Vertebrae/spine (thoracic) 09H Spinal cord (thoracic) 09J Major blood vessels 09K Heart and pericardium 09L Oesophagus (thoracic) 09M Trachea (thoracic) 09N Bronchus 09P Lungs 09Q Diaphragm 09Z Other thorax 10 Abdomen 10A Skin 10B Abdominal wall 10C Stomach 10D Small bowel 10E Large bowel 11 Back 11A Skin 11B Buttocks 11C Lumbar spine 11D Lumbar spinal cord 11E Nerves of lumbar plexus 11Z Other back 12 Genitalia / Reproductive organs 12A Foreskin 12B Penis 12C Testes 12D Scrotum 12E Vulva 12F Vagina 12G Uterus & adnexa 12Z Other genitalia 13 Anorectal 13A Rectum 13B Anus 14 Pelvis 14A Sacrum 14B Coccyx 14C Sacro-iliac joint 14D Pubic ramus 14E Ilium 14F Acetabulum 14G Pubic symphysis 14H Cauda equina 14Z Other pelvis 15 Shoulder 15A Skin 15B Clavicle 15C Scapula 15D Head of humerus 15E Neck of humerus 15F Tuberosity of humerus 15G Shoulder joint 15H Acromioclavicular joint 15J Sternoclavicular joint 15K Sub-acromial bursa 15L Rotator cuff 15M Deltoid 15N Other muscle 15Z Other shoulder 16 Axilla 16A Skin 16B Axillary blood vessels 16C Nerves 16Z Other axilla 17 Upper arm 17A Skin 17B Shaft of humerus 17C Distal end of humerus 17D Radial nerve 17E Blood vessels 17F Biceps 17G Triceps 17H Other muscle 17Z Other upper arm 18 Elbow 18A Skin 18B Supracondylar 18C Lateral epicondyle 18D Medial epicondyle 18E Head of radius 18F Neck of radius 18G Olecranon 18H Elbow joint 18J Biceps tendon 18K Nerves 18L Blood vessels 18Z Other elbow 19 Forearm 19A Skin 19B Radius 19C Ulna 19D Radius and ulna 19E Nerves 19F Blood vessels 19G Muscles / tendons 19Z Other forearm 20 Wrist 20A Skin 20B Radius 20C Ulna 20D Radius and ulna 20E Tubercle of scaphoid 20F Scaphoid 20G Other carpal bones 20H Carpal ligaments 20J Wrist joint 20K Nerves 20L Artery 20M Tendons 20Z Other wrist 21 Hand 21A Skin of dorsum 21B Skin of palm 21C Metacarpal 21D Metacarpophalangeal joint 21E Other carpal bones 21F Carpometacarpal joint 21G Nerves 21H Artery 21J Muscles 21Z Other hand 22 Thumb 22A Distal phalanx 22B Interphalangeal joint 22C Proximal phalanx 22D Metacarpophalangeal joint 22E Metacarpal 22F Carpometacarpal joint 22G Trapezium 22H Muscles 22J Artery 22K Nerves 23 Finger 23A Index finger 23B Middle finger 23C Ring finger 23D Little finger 23E Digital arteries 23F Digital nerves 24 Hip 24A Skin 24B Neck of femur 24C Trochanter 24D Hip joint 25 Thigh 25A Skin 25B Shaft of femur 25C Distal end of femur 25D Muscles 25E Blood vessels 25F Nerves 25Z Other thigh 26 Knee 26A Skin 26B Patella 26C Femoral condyle 26D Proximal end of tibia 26E Knee joint 26F Ligaments 26G Cartilage 26H Medial meniscus 26J Lateral meniscus 26K Nerves 26L Blood vessels 26M Quadriceps tendon 26Z Other knee 27 Lower leg 27A Skin 27B Tibia 27C Fibula 27D Tibia and fibula 27E Achilles tendon 27F Muscles 27G Blood vessels 27H Nerves 27Z Other lower leg 28 Ankle 28A Skin 28B Ligaments 28C Lateral malleolus 28D Medial malleolus 28E Talus 28F Ankle joint 28Z Other bones 29 Foot 29A Skin 29B 1st metatarsal 29C 2nd metatarsal 29D 3rd metatarsal 29E 4th metatarsal 29F 5th metatarsal shaft /neck / head 29G 5th metatarsal base 29H Calcaneus 29J Other bones 29K Joints 29L Blood vessels 29M Tendons / muscles 29N Nerves 30 Toes 30A Big toe 30B 2nd toe 30C 3rd toe 30D 4th toe 30E 5th toe 31 Multiple body regions." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "BODILY_LOCATION_OF_INJURY_DESC", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for BODILY_LOCATION_OF_INJURY_CODE." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "AE_NATURE_OF_INJURY_CODE", "dataType": "varchar(3)", "sensitive": false, "description": "The nature of the injury chiefly responsible for occasioning the attendance of the person at the health care facility. NULL NULL 00 None 01 Wound 01A Abrasion 01B Contusion 01C Blisters 01D Laceration 01E Incision 01F Needlestick 01G Bite - animal 01H Bite - human 01J Bite/sting - insect 01K Flap laceration 01L Degloving wound 01M Penetrating wound 01N Skin avulsion 01Z Other 02 Bone and joint injury 02A Closed fracture 02B Open fracture 02C Dislocation of joint 02D Fracture dislocation 03 Soft tissue injury 03A Crush injury 03B Ligament avulsion 03C Ligament tear 03D Ligament rupture 03E Ligament strain 03F Muscle avulsion 03G Muscle tear 03H Muscle rupture 03J Muscle strain 03K Tendon dislocation 03L Tendon rupture 03M Tendon subluxation 03N Tendon strain 03P Tendon division 03Q Neuropraxia 03R Nerve complression 03S Complete transaction of nerve 03T Partial division of nerve 03U Nerve contusion 03V Nerve entrapment 03Z Other Soft tissue injury 04 Head injury 04A Concussion 04B Extradural haemorrhage 04C Subdural haemorrhage 04D Traumatic Cerebal oedema 04Z Other head injury 05 Dental injury 05A Avulsion 05B Fracture 05Z Other dental injury 06 Vascular injury 06A Arterial haemorrhage 06B Arterial contusion 06C Arterial avulsion 06D Arterial perforation 06E Arterial rupture 06F Arterial transection 06G Venous haemorrhage 06H Venous contusion 06J Venous avulsion 06K Venous rupture 06L Venous transaction 06Z Other vascular 07 Visceral injury 07A Traumatic haemothorax 07B Traumatic pneumothorax 07C Pulmonary contusion 07D Traumatic haemopneumothorax 07E Traumatic haemopericardium 07F Cardiac contusion 07G Pneumomediastinum 07H Rupture Refer bodily location for specific visceral organs 07J Perforation Refer bodily location for specific visceral organs 07K Avulsion Refer bodily location for specific visceral organs 08 Burn 08A 1st Degree/ Superficial 08B 2nd Degree/ Partial thickness 08C 3rd Degree/ Full thickness 09 Scald 10 Corrosion 10A 1st Degree 10B 2nd Degree 10C 3rd Degree 11 Injury related to heat exposure 11A Heat rash Heat rash is a skin irritation caused by excessive sweating during hot, humid weather 11B Heat cramps Painful muscle spasms in the abdomen, arms, or legs following strenuous activity. Often are caused by a lack of salt in the body 11C Heat exhaustion A warning that the body is getting too hot. The body temperature is usually normal and the pulse is normal or raised 11D Heat/sunstroke Heat stroke occurs when the body becomes unable to control its temperature. Can be life threatening 11Z Other injuries related to heat exposure 12 Hypothermia 13 Frostbite 13A Superficial 13B With tissue necrosis 13Z Other frostbite 14 Poisoning 15 Electric shock 16 Multiple injuries 98 Other nature of injury." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "AE_NATURE_OF_INJURY_CODE_DESC", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for AE_NATURE_OF_INJURY_CODE." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "EXTERNAL_CAUSE_OF_INJURY_CODE", "dataType": "varchar(3)", "sensitive": false, "description": "This field represents the event, circumstance or condition associated with the occurrence of injury, poisoning or violence. 00 - None 01 - Transport 02 - Falls 03 - Poisons & drugs 04 - Thermal 05 - Contact with object or animal 06 - Contact with person 07 - Crushing force 08 - Piercing/penetrating force 09 - Mechanical threat to breathing 10 - Drowning/near drowning 11 - Foreign body 12 - Complication of medical/surgical care 98 - Other external cause 99 - Not known ." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "EXTERNAL_CAUSE_OF_INJURY_DESC", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for EXTERNAL_CAUSE_OF_INJURY_CODE." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "INTENT_OF_INJURY_CODE", "dataType": "varchar(3)", "sensitive": false, "description": "This field represents the role of human intent in the occurrence of the injury as assessed by the treating practitioner. 01 Unintentional Includes accidental injury event. Injuries to children under age five years who harm themselves should be regarded as unintentional, except in the case of a child who bangs his or her head in anger or frustration. Includes injuries resulting from animal attacks, unless the animal was used as a weapon by a person intent on inflicting injury. 02 Deliberate self-harm 02A Self-mutilation 02B Child intentional self-harm Includes injuries to children under age five years who harm themselves by banging his or her head in anger or frustration. 02C Attempted suicide Includes suicide, parasuicide (incomplete suicide attempt) 02Z Other self-harm 03 Assault 03A Sexual 03B Use of bodily force Excludes sexual assault 03C By use of objects /substances Objects/substances involved in producing injury 03D Indirect involvement Includes injuries sustained by a bystander to a violent event, or by a non-combatant in a conflict. 03Z Other 98 Other intent 98A Legal/political Includes legal intervention, operations of war, terrorism or civil conflict. 98B Complications of medical or surgical care Only if relevant to nature of injury 98Z Other Includes euthanasia 99 Not known Includes unspecified intent and injury resulting from unknown event ." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "INTENT_OF_INJURY_DESC", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for INTENT_OF_INJURY_CODE." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "ACTIVITY_WHEN_INJURED_CODE", "dataType": "varchar(3)", "sensitive": false, "description": "This field represents the type of activity the injured person was engaged in when the injury occurred. The codes are: 01 Work 01A Work - Paid 01B Work - Unpaid 02 Education 03 Organized sports 04 Leisure play, exercise or physical activity 05 Travelling 05A Travelling - Work related 05B Travelling - Commuting 05Z Travelling - Other 98 Other specified activity 98A Vital Activity 98B Being taken care of 98C Religious/spiritual activities 98D General home activities not elsewhere classified 99 Not known." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "ACTIVITY_WHEN_INJURED_DESC", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for ACTIVITY_WHEN_INJURED_CODE." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "PROCEDURE_1_CODE", "dataType": "varchar(3)", "sensitive": false, "description": "This field represents the broad coding of types of procedure which may be performed upon a patient during attendance at an A&E department. 00 - None 01 - Wound care 01A Toilet only 01B Debridement 01C Removal of foreign material 01D Dressing 01E Wound closure 01Z Other wound care 02 - Burn care 02A Toilet only 02B Debridement 02C Removal of slough 02D Dressing 02Z Other burn care 03 - Limb immobilisation 03A Plaster immobilisation 03B Splint immobilisation 03Z Other limb immobilisation 04 - Procedure on bones & joints 04A Reduction of dislocation 04B Manipulation of fracture 04C Joint aspiration / injection 04Z Other procedure on bones & joints 05 - Airway management 05A Nasopharyngeal airway 05B Laryngeal mask 05C Intubation 05D Surgical airway 05Z Other airway management 06 - Ventilation 06A Manual 06B Mechanical 07 - Circulatory support 07A External cardiac massage 07B Cardio-version including defibrillation 07C Temporary pacing 07D Fluid resuscitation 07E Blood transfusion 07Z Other circulatory support 08 - Vascular access 08A Central venous access (including femoral) 08B Arterial line 08C Intra-osseous access 08Z Other vascular access 09 - Pleural cavity procedures 09A Aspiration 09B Insertion of chest drain 09Z Other pleural cavity procedures 10 - Decontamination 11 - Other specific procedures 11A Removal of foreign body from orifice 11B Gastric lavage 11C Urinary catheterisation 11D Incision & drainage 98 - Other 99 - Not Known." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "PROCEDURE_1_DESC", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for PROCEDURE_1_CODE." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "PROCEDURE_2_CODE", "dataType": "varchar(3)", "sensitive": false, "description": "This field represents the broad coding of types of procedure which may be performed upon a patient during attendance at an A&E department. 00 - None 01 - Wound care 01A Toilet only 01B Debridement 01C Removal of foreign material 01D Dressing 01E Wound closure 01Z Other wound care 02 - Burn care 02A Toilet only 02B Debridement 02C Removal of slough 02D Dressing 02Z Other burn care 03 - Limb immobilisation 03A Plaster immobilisation 03B Splint immobilisation 03Z Other limb immobilisation 04 - Procedure on bones & joints 04A Reduction of dislocation 04B Manipulation of fracture 04C Joint aspiration / injection 04Z Other procedure on bones & joints 05 - Airway management 05A Nasopharyngeal airway 05B Laryngeal mask 05C Intubation 05D Surgical airway 05Z Other airway management 06 - Ventilation 06A Manual 06B Mechanical 07 - Circulatory support 07A External cardiac massage 07B Cardio-version including defibrillation 07C Temporary pacing 07D Fluid resuscitation 07E Blood transfusion 07Z Other circulatory support 08 - Vascular access 08A Central venous access (including femoral) 08B Arterial line 08C Intra-osseous access 08Z Other vascular access 09 - Pleural cavity procedures 09A Aspiration 09B Insertion of chest drain 09Z Other pleural cavity procedures 10 - Decontamination 11 - Other specific procedures 11A Removal of foreign body from orifice 11B Gastric lavage 11C Urinary catheterisation 11D Incision & drainage 98 - Other 99 - Not Known." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "PROCEDURE_2_DESC", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for PROCEDURE_2_CODE." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "PROCEDURE_3_CODE", "dataType": "varchar(3)", "sensitive": false, "description": "This field represents the broad coding of types of procedure which may be performed upon a patient during attendance at an A&E department. 00 - None 01 - Wound care 01A Toilet only 01B Debridement 01C Removal of foreign material 01D Dressing 01E Wound closure 01Z Other wound care 02 - Burn care 02A Toilet only 02B Debridement 02C Removal of slough 02D Dressing 02Z Other burn care 03 - Limb immobilisation 03A Plaster immobilisation 03B Splint immobilisation 03Z Other limb immobilisation 04 - Procedure on bones & joints 04A Reduction of dislocation 04B Manipulation of fracture 04C Joint aspiration / injection 04Z Other procedure on bones & joints 05 - Airway management 05A Nasopharyngeal airway 05B Laryngeal mask 05C Intubation 05D Surgical airway 05Z Other airway management 06 - Ventilation 06A Manual 06B Mechanical 07 - Circulatory support 07A External cardiac massage 07B Cardio-version including defibrillation 07C Temporary pacing 07D Fluid resuscitation 07E Blood transfusion 07Z Other circulatory support 08 - Vascular access 08A Central venous access (including femoral) 08B Arterial line 08C Intra-osseous access 08Z Other vascular access 09 - Pleural cavity procedures 09A Aspiration 09B Insertion of chest drain 09Z Other pleural cavity procedures 10 - Decontamination 11 - Other specific procedures 11A Removal of foreign body from orifice 11B Gastric lavage 11C Urinary catheterisation 11D Incision & drainage 98 - Other 99 - Not Known." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "PROCEDURE_3_DESC", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for PROCEDURE_3_CODE." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "DIAGNOSIS_1_CODE", "dataType": "varchar(2)", "sensitive": false, "description": "This field represents the working diagnosis(es) on discharge from A&E, or where no working diagnosis is made, the main symptom, abnormal finding, or problem. 00 Nothing abnormal detected 01 Trauma/ injury/ poisoning Refer to Injury Surveillance Dataset 02 Alcohol &/or substance use problems 03 Cardiovascular 04 Dental Does not include dental injury - refer to Injury Surveillance Dataset 05 Dermatology Does not include skin injury - refer to Injury Surveillance Dataset 06 Endocrine/metabolic 07 ENT Does not include foreign bodies - refer to Injury Surveillance Dataset 08 Gastrointestinal 09 Gynaecological 10 Haematology 11 Infection It may be necessary to notify communicable diseases.Excludes infections specific to particular anatomical site or physiological system, e.g. skin, respiratory system. 12 Musculoskeletal 13 Neurology 14 Obstetrics 15 Ophthalmology Does not include foreign bodies or eye injury - refer to Injury Surveillance Dataset 16 Psychiatry 17 Respiratory 18 Genito-urinary 19 Social circumstances 99 Diagnosis not known ." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "DIAGNOSIS_1_DESC", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for DIAGNOSIS_1." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "DIAGNOSIS_1_TEXT", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents a free text description of diagnosis e.g. 'Foreign body in ear', 'PSYCHOTIC ILLNESS'. Sometimes this is populated when CODE and DESC are not." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "DIAGNOSIS_2_CODE", "dataType": "varchar(2)", "sensitive": false, "description": "This field represents the working diagnosis(es) on discharge from A&E, or where no working diagnosis is made, the main symptom, abnormal finding, or problem. 00 Nothing abnormal detected 01 Trauma/ injury/ poisoning Refer to Injury Surveillance Dataset 02 Alcohol &/or substance use problems 03 Cardiovascular 04 Dental Does not include dental injury - refer to Injury Surveillance Dataset 05 Dermatology Does not include skin injury - refer to Injury Surveillance Dataset 06 Endocrine/metabolic 07 ENT Does not include foreign bodies - refer to Injury Surveillance Dataset 08 Gastrointestinal 09 Gynaecological 10 Haematology 11 Infection It may be necessary to notify communicable diseases.Excludes infections specific to particular anatomical site or physiological system, e.g. skin, respiratory system. 12 Musculoskeletal 13 Neurology 14 Obstetrics 15 Ophthalmology Does not include foreign bodies or eye injury - refer to Injury Surveillance Dataset 16 Psychiatry 17 Respiratory 18 Genito-urinary 19 Social circumstances 99 Diagnosis not known ." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "DIAGNOSIS_2_DESC", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for DIAGNOSIS_2." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "DIAGNOSIS_2_TEXT", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents a free text description of diagnosis e.g. 'Foreign body in ear', 'PSYCHOTIC ILLNESS'. Sometimes this is populated when CODE and DESC are not." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "DIAGNOSIS_3_CODE", "dataType": "varchar(2)", "sensitive": false, "description": "This field represents the working diagnosis(es) on discharge from A&E, or where no working diagnosis is made, the main symptom, abnormal finding, or problem. 00 Nothing abnormal detected 01 Trauma/ injury/ poisoning Refer to Injury Surveillance Dataset 02 Alcohol &/or substance use problems 03 Cardiovascular 04 Dental Does not include dental injury - refer to Injury Surveillance Dataset 05 Dermatology Does not include skin injury - refer to Injury Surveillance Dataset 06 Endocrine/metabolic 07 ENT Does not include foreign bodies - refer to Injury Surveillance Dataset 08 Gastrointestinal 09 Gynaecological 10 Haematology 11 Infection It may be necessary to notify communicable diseases.Excludes infections specific to particular anatomical site or physiological system, e.g. skin, respiratory system. 12 Musculoskeletal 13 Neurology 14 Obstetrics 15 Ophthalmology Does not include foreign bodies or eye injury - refer to Injury Surveillance Dataset 16 Psychiatry 17 Respiratory 18 Genito-urinary 19 Social circumstances 99 Diagnosis not known ." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "DIAGNOSIS_3_DESC", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for DIAGNOSIS_3." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "DIAGNOSIS_3_TEXT", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents a free text description of diagnosis e.g. 'Foreign body in ear', 'PSYCHOTIC ILLNESS'. Sometimes this is populated when CODE and DESC are not." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "DISEASE_1_CODE", "dataType": "varchar(6)", "sensitive": false, "description": "This field represents the Disease/ailment of the patient This code is a ICD10 code.." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "DISEASE_1_DESC", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for DISEASE_1_CODE ." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "DISEASE_2_CODE", "dataType": "varchar(6)", "sensitive": false, "description": "This field represents the Disease/ailment of the patient This code is a ICD10 code.." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "DISEASE_2_DESC", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for DISEASE_2_CODE." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "DISEASE_3_CODE", "dataType": "varchar(6)", "sensitive": false, "description": "This field represents the Disease/ailment of the patient This code is a ICD10 code.." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "DISEASE_3_DESC", "dataType": "varchar(100)", "sensitive": false, "description": "This field represents the description for DISEASE_3_CODE." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "WAIT_TO_TREATMENT_MIN", "dataType": "numeric(38,0)", "sensitive": false, "description": "This field represents the time in minutes before patient was treated. Note that there is also an (unreleased) field called WAIT_TO_ASSESSMENT_MIN which appears to be unpopulated.." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "WAIT_TO_DISCHARGE_MIN", "dataType": "numeric(38,0)", "sensitive": false, "description": "This field represents the time in minutes before the patient was discharged." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "NUMBER_OF_ATTENEDANCES", "dataType": "nvarchar(384)", "sensitive": false, "description": "This field represents the number of attendances." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "PROCHI", "dataType": "varchar(10)", "sensitive": false, "description": "Anonymised patient identifier" } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "CASE_REFERENCE_NO", "dataType": "varchar(14)", "sensitive": false, "description": "This field indicates the case number." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "POSTCODE_CHI", "dataType": "varchar(9)", "sensitive": false, "description": "This field should only be extracted when anonymised as it contains a postcode." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." }, { "name": "Accident and Emergency (ISD T+F)", "columns": [ { "name": "PAT_AGE", "dataType": "numeric(38,0)", "sensitive": false, "description": "This field represents the patients age." } ], "description": "Accident and Emergency Statistics. 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, they are still under development and ISD are working with the NHS Boards to support data collection and quality. 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 94% of all attendances at A&E." } ] }
Copied to clipboard