Accident and Emergency (A&E) 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. It contains data from June 2007 to the present day on patient attendances at Emergency Departments, Minor Injuries Units and community hospital A&E's across NHS Scotland.
The A&E data mart gives authorised users access to data including demographic information, attendances, waiting times and patient flow for all patients treated within their NHS board and their residents treated elsewhere in NHS Scotland.
The data mart hold two levels of information, episodic patient level (only available for A&E departments with the IT capacity to submit patient level data to ISD) and aggregate monthly data (this contains total attendances and compliance with the four hour wait standard). The A&E data mart allows users to create adhoc reports as well as run the standard reports created by ISD's Unscheduled Care Team. The datamart is queried using Business Objects XI (BOXI).
The A&E data mart is part of the NHS National Services Scotland (NSS) Corporate Data Warehouse. The Data Warehouse contains multiple data marts, each of which represents a functional area e.g. acute, prescribing, etc.
For further information on A&E2, including requesting access, training and documentation see the NHS Login section.
Note this area is restricted and requires a username and password. If you are unable to access this area and would like more information please contact the helpline.
ISD Datamarts Product Support helpdesk:
Tel: 0131 275 7050