Annual Inpatient and Daycase Activity

Inpatients refer to people who are admitted to an available staffed bed in a hospital (either electively or as an emergency) and either: remain overnight whatever the original intention; or are expected to remain overnight but are discharged earlier. Day cases refer to episodes where a person makes a planned admission to an available staffed bed in a hospital for clinical care, and requires the use of a bed (or trolley in lieu of a bed). For the purposes of national data, a day case episode refers to a patient who is admitted as a day case and is discharged on the same day as planned.

For further information on procedures, see the Operations/Procedures section of the Public Health Scotland website.

Further information on outpatient activity can be found in the recent annual publication.

The date of the next release can be found on our list of forthcoming publications.

As part of making our open data output align better with our annual publication tables, we will be adding health board of treatment column and qualifier columns (HB, HBQF) to the “Inpatient and Day case” and “Outpatient” files which have a breakdown by Location of Treatment. These new columns will be in the position of the location columns and location and remaining columns will move two columns to the right.

In our next annual open data, we will be adding the specialty grouping column and qualifier column (SpecialtyGrouping, SpecialtyGroupingQF) to the “Beds”, “Inpatient and Day case” and “Outpatient” files which have a breakdown by Specialty. These new columns will be in the two positions to the right of theSpecialtyNameQF column and the remaining columns will move two columns to the right.

As part of making our open data output align better with our annual publication tables, we will be applying column ordering to the Inpatient, Outpatient and Beds files in the next annual open data release consistent with the publication excel tables.

Data and Resources

Additional Info

Field Value
Source Inpatient data is sourced from SMR01
Author Secondary Care Team
Version 1.0
Last Updated September 28, 2021, 13:38 (BST)
Created September 24, 2020, 13:51 (BST)
Contact Address Public Health Scotland, Gyle Square, 1 South Gyle Crescent, Edinburgh EH12 9EB
Subject Hospital Care
Frequency Annual
Time frame of data and timeliness Data is published from financial year ending 31 March 2011 to financial year ending 31 March 2020.
Coverage Covers all NHS Boards in Scotland since financial year ending 31 March 2011.
Completeness At the time of extract, the completeness of SMR01 for 2019/20 was 96%. For the completeness of SMR01 in other years see https://www.opendata.nhs.scot/dataset/scottish-morbidity-record-completeness
Accuracy Please refer to Appendix A2 of the report: https://publichealthscotland.scot/publications/acute-hospital-activity-and-nhs-beds-information-annual/
Continuity of data Data is available since financial year ending 31 March 2011. Daycases have been included in the average length of stay and average length of episode calculations. This decision was taken to make the methodology more consistent with the quarterly publication. There are known issues with the quality of data presented such as inpatient and daycase completeness. For more information, please see the data issues and completeness document. https://publichealthscotland.scot/media/4999/data-issues-and-completeness-sep20.pdf A review of stays by specialty has been undertaken prior to the September 2020 publication. As a result, there may be some differences when comparing with previous publications. For further information, please refer to the Specialty Spells document https://publichealthscotland.scot/media/5000/specialty-spells-methodology.pdf which accompanies this publication. The number of emergency admissions presented in the Inpatient and Day Case Activity tables may differ from that presented in the ‘Table 3 - Multiple Emergency Admissions' table. This is due to the recording of Ambulatory Emergency Care cases as daycases on SMR01 (see above for more information). For tables split by inpatient/daycases, these cases will be counted under the daycase figure, but for tables counting emergency admissions only, these cases will appear within the emergency admissions figure. Change to Council Area/NHS Board codes:There has been two minor boundary changes to council area since early 2018. As a result, the following geographies are impacted and new 9-digit codes have been generated: Council Areas, Electoral Wards, Health Boards, Health and Social Care Partnerships, Police Divisions, Fire and Rescue, Postcodes and LAU1. Further details on these changes and the affected geography codes are detailed in the Geography Codes and Labels dataset metadata: https://www.opendata.nhs.scot/dataset/geography-codes-and-labels. Hospital/location code changes: Dumfries & Galloway Royal Infirmary (Y104H) moved location in December 2017, and activity is now recorded under a new code, Y146H. The name remains “Dumfries & Galloway Royal Infirmary”. To ensure that no activity is missed, and to allow trends to be presented, the two hospital codes Y146H and Y104H (for SMR01 and SMR00 activity) are combined in our analyses under Y146H. The old site (Y104H) still exists and is now a treatment centre named “Mountainhall Treatment Centre”. This new activity will be reported separately under a new code (Y177C) which came into effect in December 2017. From 1st December 2018, Stirling Community Hospital closed along with all its wards and the Bellfield Centre opened. The Bellfield Centre provides short-term inpatient care, assessment or rehabilitation for people who require additional support following an operation or illness. Within the Bellfield Centre there is one new NHS ward, the Wallace Suite. Most of the beds are converting to partnership controlled intermediate beds. This may impact on NHS Forth Valley’s bed figures. Balfour Hospital (R101H) moved location between April and November 2019. Both the hospital name and code have changed to “The Balfour” and R103H respectively. For inpatient and beds activity, both hospital codes have been added together. For outpatient activity, both hospital locations are reported separately whilst this move is still in transition. “Prince and Princess of Wales Hospice” and “Prince & Princess of Wales Hospice” – new location has been built in 2018 with different location codes. The new location code is G604V; the old one G414V). Geographical coding changes have been applied to make the coding of ‘Other’ locations e.g. when patients have no fixed abode and are resident outside Scotland/UK to be consistent with PHS Open Data Geography Codes. https://www.opendata.nhs.scot/dataset/non-standard-geography-codes-and-labels/resource/32164b83-c9ec-495a-ac9f-dbeeb6ed5e59
Concepts and definitions Please see the Glossary section within the report and the excel data tables which accompany this publication. https://publichealthscotland.scot/publications/acute-hospital-activity-and-nhs-beds-information-annual/ Further details are also available on the Health and Social Care Data Dictionary: https://www.ndc.scot.nhs.uk/Data-Dictionary/. For detailed information on the data sources and clinical coding used within Hospital Care analysis please refer to the SMR Datasets, ISD(S)1 data collection and Terminology Services web pages: https://www.isdscotland.org/Products-and-Services/Terminology-Services/. Please see the Hospital Locations Lookup (https://www.opendata.nhs.scot/dataset/annual-hospital-beds-information/resource/1ac6f087-acb3-481f-be93-528ef0c55ade) for location codes used in this annual publication, including those that are not present in the Current NHS Hospitals lookup.
Disclosure Disclosure control methods have been applied to the data in order to protect patient confidentiality, therefore some figures may not be additive. The PHS protocol on Statistical Disclosure Protocol is followed. https://publichealthscotland.scot/publications/statistical-disclosure-control-protocol/
Revision statement All revisions to data within this release are planned and are due to incomplete data returns at the time of publication. All tables will be revised annually. In general, these revisions have minimal effect on the statistics. If data providers discover that data submitted for publication is incorrect, and/or missing/incomplete and is significant, this can be re-submitted and published in subsequent releases. Any changes will be highlighted within the notes on the affected table. Please see the PHS revisions policy for further details. https://beta.isdscotland.org/media/4106/isd-revisions-policy-v04.pdf
Official statistics designation The UK Statistics Authority has designated these statistics as National Statistics signifying compliance with the Code of Practice for Statistics, available on the UK Statistics Authority website. http://www.statisticsauthority.gov.uk/assessment/code-of-practice
Relevance and key uses of the statistics To compare areas and activity across Scotland and view trends over time. To allow NHS Board employees to compare activity levels nationally, e.g. NHS clinical consultants interested in their specialty figures by NHS Board, NHS information managers planning capacity, to assist in the development of Service Agreements between NHS Boards. To investigate the implications of common systemic diseases in Scotland as a basis for assessing health demands in the future. To assess whether patients were treated within or outwith their own NHS Board. To allow members of the public to readily access information on the number of hospital admissions for specific diagnoses or procedures that may be of personal interest to them. To assist students and universities conducting medical studies for research purposes. Private companies interested in hospital activity levels in Scotland such as pharmaceutical companies, consultancy companies employed by NHS Trusts in England, advertising/media companies on behalf of clients.
Format csv
Language English
Links

Annual Publication

NHS England Outcomes and Performance, Hospital Episode Statistics (HES)

NHS Wales Hospital Activity

Northern Ireland Hospital Statistics and Research

Hospital Locations Lookup

comments powered by Disqus