Accident and Emergency (A&E) Data Mart
The Accident and Emergency (A&E) data mart was launched to NHS Boards in January 2011 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 data mart is queried using Business Objects XI (BOXI).
To find out more about accessing the A&E data mart or to discuss training requirements please telephone the SHIS helpline on 0131 275 7050 or e-mail the team at nss.isdaeshis@nhs.net
Accessing the Data Mart
PC Specification
A&E is a web-based system so there is no requirement for additional software or set up in order to run A&E on your personal computer. There is, however, a minimum specification that needs to be met in order for the system to function correctly. Most computers running Windows XP will be able to open A&E however you may have to alter some of your Internet Explorer settings. If you have any questions about the compatibility of your pc or the Internet Explorer setting required, please email the team at nss.isdaeshis@nhs.net and we can send you a list of PC requirements.
Java Virtual Machine
Java Virtual Machine (JVM) is a piece of software that sits on your computer which is necessary in order to provide access to the functionality to build your own queries in A&E i.e. WebIntelligence Java Report Panel (WebI). It is important that the correct version is installed. Versions 1.4.2_08 and 1.5.0_xx are suitable for Internet Explorer (IE) 6, while version 1.6.0_02 and above are suitable for IE7.If you have any questions about Java Virtual Machine compatibility of your local machine, please email the team at nss.isdaeshis@nhs.net
Caldicott approval for access to A&E Data Mart
All prospective A&E data mart users must obtain the approval of their local Caldicott Guardian before they can be given access to the data mart. Each user must provide ISD with a signed 'Access to Data Form' before this can be granted. Once authorisation is granted, the user will be given a username and password which will allow them access to A&E. Email the team at nss.isdaeshis@nhs.net for further information.
Manuals
Data manual
This data manual contains information on the dimensions and measures contained in the A&E data mart.
AE2 Data Manual v1.0.pdf 
[457kb]
Training Exercises
Here are 11 worked examples that will aid users when accessing the A&E BusinessObjects environment. The exercises are arranged in accordance with the complexity of the analysis.
Training Exercises [128kb]
To find out more about accessing the A&E data mart or to discuss training requirements please telephone the SHIS helpline on 0131 275 7050 or e-mail the team at nss.isdaeshis@nhs.net
