This website places cookies on your device to help us improve our service to you. To find out more about the cookies, see our Privacy and Cookies notice
ISD Scotland better information, better decisions, better health

Data Support and Monitoring

Accident & Emergency

NHS National Services Scotland ISD Scotland & NHS National Services Scotland

Accident & Emergency Datamart

The Accident and Emergency (A&E) datamart has been in existence since June 2007. It was rebuilt and re-launched to NHS Boards in January 2011 and included some new additional fields. The datamart contains data from June 2007 to the present day on patient attendances at Emergency Department (ED), Minor Injuries Units (MIU's) and community hospital A&E's across NHS Scotland.

There are two types of data submitted: episode, which larger hospitals with ED’s usually submit which contains a detailed record for each attendance, and aggregate level which smaller sites such as MIU’s, or community hospital submit which only contains total attendance figures. The smaller sites only submit aggregate data as they do not have the information systems, and support to enable detailed patient based information.

Data Processing

Data files are received from all 14 NHS Boards via swift upload. The data submitted by Boards is either episode level data, or aggregate level data.
Checks are carried out to ensure that the files are in the correct format, and contain only valid codes for the datamart. Files that fail validation generate an error message which is returned to the Board.

For a list of the validation rules refer to Appendix A of the A&E Data Mart User Guide Download PDF file [1.42 Mb]. For a list of data fields, field formats and valid codes refer to Data Recording Manual October 2013 Download PDF file [441Kb].

Files that pass validation are loaded into the datamart; business objects reports are run to ensure all submitted files have successfully loaded and the record count for the files are as expected.

Data Quality

Once A&E files are loaded onto the datamart, a suite of data quality reports are run against the data.

The reports are:

  • Daily attendances
  • Completeness of each data item over a 4 month period
  • Use of Unknown/other
  • Discharge destination report
  • Patient flow report

These reports generally show good consistency of recording between months, however the Boards are contacted if any changes are noted. If there are any changes in data then the Boards are asked to either resubmit their data, or to ensure that the following months data contains the information that was missing. Any explanations from the Boards are recorded in the information log, so that a record is maintained.

Data Monitoring & Support

Annual site meetings are arranged with NHS Boards and provide opportunity to:

  • Update Boards on any changes that are occurring within PHI/ISD e.g. the A&E dataset review
  • Gain a greater understanding of the issues faced by Boards and how these impact on data collection
  • Update PHI/ISD of changes to services, personnel and IT systems within the Boards.

New users of the A&E datamart should access the following link for the user access webpages, so that they can be set up with an account and username:

https://useraccess.nhsnss.scot.nhs.uk/

New users will also require access to the error reporting universe within the datamart, so that they can receive the validation emails from their submission.

Contacts

Mailbox nss.isdaewaiting@nhs.net

Elaine Pauline

Elizabeth Cole

Nicola Lamond

Links to Further Information

The A&E dataset is currently under review - for more details click here Download PDF file [72KB]

Topics/Emergency Care

http://www.isdscotland.org/Health-Topics/Emergency-Care/Emergency-Department-Activity/Statistics/

Publications

http://www.isdscotland.org/Health-Topics/Emergency-Care/Publications/index.asp

NHS performs

http://www.isdscotland.org/Products-and-Services/NHS-Performs/

 

© ISD Scotland 2010
Information Services Division,
NHS National Services Scotland,
Gyle Square,
1 South Gyle Crescent,
Edinburgh EH12 9EB,
Tel: 0131 275 7050
NSS.isdSHIS@nhs.net  
Contact Us

About Information Services Division | Contact Us | Accessibility | Complaints
Copyright | Terms and Conditions | Privacy | Freedom of Information

ISD is a division of NHS NSS
Working at the very heart of the health service, NSS delivers services critical to frontline patient care and in support of the efficient and effective operation of NHS Scotland. Visit the NSS Website for more information