Inpatient and Daycase Activity Stays By Health Board Residence

$179 / year

This dataset includes information split by location for health board of residence, hospital and council area, specialty, age and sex, and Scottish Index of Multiple Deprivation (SIMD) for the length of stays in the specific hospital. Measures include emergency admissions, elective admissions, transfers, inpatients, day cases, and total inpatients and day cases activity stays for acute hospital care services.


The quarterly acute hospital activity publication provides data on outpatient activity, inpatient and day case activity and beds for National Health Service (NHS) Scotland. This data release covers the period from the quarter ending March 2013 to the quarter ending March 2018. The aim of this dataset is to summarize the completeness of the data used in the publication and provide details of known issues with national data affecting this release. NHS Ayrshire & Arran has suggested that there may be some affected records before January 2016. The Board is used to implement a change to ensure that no additional records are generated when patients are transferred to discharge lounges, which should take place in the near future. The data used NHS Ayrshire & Arran also suggested that the decreases in elective inpatient admissions can be attributed to winter pressures:

NHS Borders: Decreases were observed in elective inpatient admissions, whilst increases were seen in internal transfer activity. NHS Borders has suggested that inpatients falls are in General Surgery and Orthopaedics.

NHS Dumfries & Galloway: Dumfries & Galloway Royal Infirmary (Y104H) moved location in December 2017, and inpatient and day case (SMR01) episodes are now recorded under a new code Y146H.

NHS Fife: Decreases were observed in elective inpatient admissions and day cases. Internal transfer activity has increased.

NHS Forth Valley: Decreases were seen in elective inpatient admissions and day cases.

NHS Greater Glasgow & Clyde: Decreases in elective and emergency inpatient admissions, and day cases whilst internal transfer activity increased. NHS Greater Glasgow and Clyde have advised that their backlog of SMR01s / completeness levels will be impacting on their submitted data / activity.

NHS Highland: Decreases in elective inpatient admissions and internal transfers whilst day case activity increased. NHS Highland has suggested that the increases in day cases are due to the way in which Ambulatory Emergency Care patients are now reported in SMR01.

NHS Lanarkshire: Decreases in elective admissions and day case activity.

NHS Lothian: Increases were observed in internal transfers. NHS Lothian has observed at the source records for some of these internal transfer patients in Trakcare and identified admission records which are not being included when submitted to the Information Services Division (ISD).

NHS Orkney: Increases in elective admissions, emergency admissions and day cases.

NHS Shetland: Decreases in all inpatient and daycase activity elective admissions, emergency admissions and day cases.

NHS Tayside: Decreases in elective inpatient admissions and day case activity.

NHS Western Isles: Increases in elective and emergency admissions whilst declines were witnessed in day case and transfer activity.

Golden Jubilee: Decreases were observed in elective and emergency admissions. However, it should be noted that any changes are based on relatively small numbers which will impact on the percentage change.

This data has been used to assess the performance of these services, to plan for future needs, to look at quality improvement, to see how services are changing over time and many other uses. There were just under 250,000 (249,503) hospital admissions from 1 January to 31 March 2018. Of these, 47% (118,372) were emergency admissions; 12% (29,259) elective admissions; 40% (99,415) day cases and 1% (2,457) transfers.

Date Created


Last Modified




Update Frequency


Temporal Coverage

1st January 2013 to 30th September 2019

Spatial Coverage



John Snow Labs; Information Services Division (ISD) Scotland;

Source License URL

Source License Requirements


Source Citation



Daycase And Transfer Activity, Scotland Hospital Admissions, Scotland Hospital Stays, Inpatient and Daycase Hospitals, Scotland Inpatient Activity, Scotland Emergency Admissions, Scotland Elective Admissions

Other Titles

Acute Hospital Care Performance Measure Stays Comparison for Inpatient and Daycase Activity, Acute Hospitals' Quality of Care Comparison for Inpatient Stays By Health Board Residence, Hospital Care Inpatient Stays Data By Sex, Age, SIMD and Specialty

Quarter_DateIndicates the final date of the
Quarter_CoverageIndicates the quarter period in text format.string-
Health_Board_CodeIndicates either the 9 digit health board code or "scot" for Scotland. For the residence data files, the Health board code and name is in relation to the health board of residence. For the treatment data files, the Health board code and name is in relation to the health board of treatment.string-
Health_Board_NameIndicates the health board name.string-
Location_CodeIndicates either the 5 digit hospital code; 9 digit health board or council code; or “scot” for Scotland.string-
Location_NameIndicates the name of the location.string-
MeasureIndicates inpatient/admissions type: elective inpatients; emergency inpatients; transfers; all daycases; all inpatients; all inpatients and daycases.string-
Inpatient_And_Daycase_Activity_VariablesIndicates the variables of inpatient and daycase activity for health board residence.string-
Variable_CodeIndicates the variable code of inpatient and daycase activity for health board residence.string-
Variable_DescriptionIndicates the variable description of inpatient and daycase activity for health board residence.string-
Variable_RatingIndicates the variable rating of inpatient and daycase activity for health board residence.integerlevel : Ordinal
StaysIndicates the number of stays.integerlevel : Ratio
Length_of_StayIndicates the total length of stay.integerlevel : Ratio
Average_Length_of_StayIndicates the average length of stay.string-
Quarter DateQuarter CoverageHealth Board CodeHealth Board NameLocation CodeLocation NameMeasureInpatient And Daycase Activity VariablesVariable CodeVariable DescriptionVariable RatingStaysLength of StayAverage Length of Stay
2013-12-31Oct - Dec-13S08000015NHS Ayrshire & ArranS12000008East AyrshireElective InpatientsAll98040794
2014-03-31Jan - Mar-14S08000015NHS Ayrshire & ArranS12000008East AyrshireElective InpatientsAll95537654
2014-06-30Apr - Jun-14S08000015NHS Ayrshire & ArranS12000008East AyrshireElective InpatientsAll93537914
2014-09-30Jul - Sep-14S08000015NHS Ayrshire & ArranS12000008East AyrshireElective InpatientsAll102040644
2014-12-31Oct - Dec-14S08000015NHS Ayrshire & ArranS12000008East AyrshireElective InpatientsAll105542604
2015-03-31Jan - Mar-15S08000015NHS Ayrshire & ArranS12000008East AyrshireElective InpatientsAll93635694
2015-06-30Apr - Jun-15S08000015NHS Ayrshire & ArranS12000008East AyrshireElective InpatientsAll92532644
2015-09-30Jul - Sep-15S08000015NHS Ayrshire & ArranS12000008East AyrshireElective InpatientsAll88528563
2015-12-31Oct - Dec-15S08000015NHS Ayrshire & ArranS12000008East AyrshireElective InpatientsAll86537804
2016-03-31Jan - Mar-16S08000015NHS Ayrshire & ArranS12000008East AyrshireElective InpatientsAll82531454