ISD Datamarts
Current Datamarts & Information Tools include:
- Accident & Emergency (A&E2)
- ACaDMe
- Hospital Medicines Utilisation Database (HMUD)
- National Theatres Implementation Group (NTIG)
- Outpatients (SMR00)
- Prescribing Information System (PIS)
- PRISMS
- QINRT
- SPARRA Online
- Waiting Times
Summary information for each datamart or information tool is provided below; further information on the Health Topic area can be accessed via the link at the end of each summary. More information on the datamarts including Data Manual, Users Guides, etc can be accessed via the NHS Login.
The Accident and Emergency (A&E2) datamart 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.
There is a National Comparative datamart available for A&E2, which provides information on patients who are resident or treated by the NHS in Scotland. Authorised users will have the facility to access data for all Boards not just their own.
More information: Accident & Emergency (A&E2)
ACaDMe stands for Acute Cancer Deaths and Mental Health. The ACaDMe datamart contains the linked inpatient and day case (SMR01), mental health (SMR04), cancer registration (SMR06) and deaths records from National Records of Scotland (NRS).
There is a National Comparative datamart available for ACaDMe, which provides information on patients who are resident or treated by the NHS in Scotland. Authorised users will have the facility to access data for all Boards not just their own.
More information: ACaDMe
Hospitals Medicine Utilisation Database (HMUD)
The Hospital Medicines Utilisation Database (HMUD) contains data sourced from hospital stock control systems. It facilitates the comparison of medicines use in different hospitals across Scotland. It allows comparison of medicines on different hospital sites as well as comparisons by NHS Board.
More information: Hospital Medicines Utilisation Database (HMUD)
National Theatres Implementation Group (NTIG)
The NTIG datamart contains data on theatre activity from January 2007 to the present day. There are two levels of information contained within the datamart: case level data submitted from theatre management systems and aggregate monthly data.
More information: National Theatres Implementation Group (NTIG)
The Outpatients (SMR00) datamart contains information from 1 January 1997 to present day for outpatient appointments in NHSScotland. The data within it is updated on a monthly basis.
There is a National Comparative datamart available for Outpatients (SMR00), which provides information on patients who are resident or treated by the NHS in Scotland. Authorised users will have the facility to access data for all Boards not just their own.
More information: Outpatients (SMR00)
As of 2013, access to users outside National Services Scotland (NSS) has been provided to the complete national prescribing dataset, known as the Prescribing Information System (PIS). This gives users access to prescribing and dispensing information at individual patient level, electronic messaging data and additional financial items, as well as aggregated data back to 1993; a far richer dataset than is provided through PRISMS (which is a subset of PIS).
More information: PIS
PRISMS is the Prescribing Information System for Scotland. The datamart contains information on all prescriptions dispensed in the community from April 2004 onwards. PRISMS can be interrogated to provide reports at individual prescriber, practice, locality, Community Health Partnership, NHS Boards and Scotland level.
More information: PRISMS
QINRT is the Quality Improvement National Reporting Tool for Scotland. The Healthcare Quality Strategy for Scotland and the Quality Measurement Framework identified the need for three levels of quality information to enable monitoring and assessment of progress towards the 3 Quality Ambitions and the 6 Quality Outcomes.
QINRT contains level 3 indicator reporting data and allows users to view, report and chart their compliance with nationally agreed indicators.
More information: QINRT
Scottish Patients at Risk of Readmission and Admission (SPARRA) - Online
SPARRA Online users can directly and securely access SPARRA data for their NHS Board, Community Health Partnership or GP practice.
More information: Scottish Patients at Risk of Readmission and Admission (SPARRA) - Online
The Waiting Times datamart provides access to:
- The core details relating to a waiting list record (e.g. Referral date, patient details) for ongoing and completed waits
- Appointment information (e.g. Date of Proposed Appointment/Admission)
- Details of any periods of unavailability or planned reviews
- A calculation of wait, based on ‘New Ways’ rules for how long a patient is waiting or has waited for a date of appointment or admission.
More information: Waiting Times