File Listings 2015
The following links provide short cuts to the 2015 data files for technical users:
Reports - Excel files designed for viewing (note: some files include macros)
Downloads - Excel files designed for further data analysis
SFRs - Excel files giving access to the source data
For important information about the 2015 data see Summary of Changes
[35kb]. File listings for previous years are also available from the Costs Archive.
Colour Key:
| Hospital sector |
| Community sector |
| Laboratory |
| Special Boards |
| Multiple sectors |
Reports 2015
The full range of Costs Book tables in MS Excel, designed for on-screen viewing.
All Reports [3.4mb] - use Save option to download ZIP file
 |
R100 | - executive summary, for Scotland and each board |
|
R100T | - expenditure and activity figures for the last 5 years, for Scotland and each board |
|
R086 | - NHS Board operating costs and capital expenditure |
|
R300s | - net expenditure, by board of treatment, by care type |
|
R020 | - hospital summary (excluding long stay hospitals) |
|
R020LS | - hospital summary - long stay hospitals |
|
R025 | - board level aggregate of hospital running cost |
|
R04X | - specialty summary - all specialties (excluding long stay), by patient type, by board |
|
R04LSX | - specialty summary - long stay specialties, by patient type, by board |
|
R04opX | - total specialty outpatient expenditure and activity summary, by board |
| Hospital Level | Board Level | ||
|
R040 | R040X | - specialty costs and activity - inpatients in all specialties (excluding long stay), by speciality |
|
R040LS | R040LSX | - specialty costs and activity- inpatients in long stay specialties, by speciality |
|
R042 | R042X | - specialty costs and activity - daycases, by specialty |
|
R044 | R044X | - specialty costs and activity - consultant outpatients, by specialty |
|
R045 | R045X | - specialty costs and activity - nurse led clinics, by specialty |
|
R046 | R046X | - costs and activity at AHP outpatient clinics, by profession1 |
|
R048 | R048X | - specialty costs and activity - day patients, by specialty |
|
R060 | R060X | - expenditure on services provided by AHPs1 |
|
R070 | R070X | - expenditure on catering, domestic and portering services |
|
R080 | R080X | - expenditure on linen services |
|
R090 | R090X | - expenditure on property overheads |
|
R110 | R110X | - expenditure on management and administration expenses |
|
R120 | R120X | - expenditure and activity - radiology services |
|
R130 | R130X | - expenditure and activity - laboratory services |
|
R140 | R140X | - number of theatres, expenditure and usage |
|
R141X | - average theatre running costs | |
|
R142X | - average theatre running costs and usage, by specialty | |
|
R500 | - summary of expenditure on main community services, by board |
|
R510 | - community AHP services by board1 |
|
R520 | - other community services by board |
|
R550 | - summary of expenditure on community staff and supplies, by board |
| |
|
|
|
R600 | - pharmacy drugs expenditure, by NHS sector, by board |
|
R610 | - pharmacy drugs expenditure for the hospital sector, by hospital |
| |
|
|
|
R700 | - staff expenditure summary by sector, by board |
|
R710 | - hospital staff profile - expenditure and WTEs by main staff groupings, by board |
|
R720 | - hospital staff profile - expenditure and WTEs by specialty |
|
R730 | - community staff profile - expenditure and WTEs by main staff groupings, by board |
|
R740 | - laboratory staff profile - expenditure and WTEs by main staff groupings, by board |
| |
|
|
|
R810 | - expenditure on pharmaceutical services, by NHS sector, by board |
|
R820 | - expenditure on dental services, by NHS sector, by board |
|
R830 | - expenditure on ophthalmic services, by NHS sector, by board |
| |
|
|
|
R910 | - Scottish Ambulance Service, expenditure and statistics, by board area |
|
R920 | - National Services Scotland, expenditure and staff numbers, by division |
|
R921 | - Scottish Breast Screening Programme, expenditure and statistics, by region |
Note: the links above open MS Excel workbooks, the largest of which is approximately 360kb.
Download Reports 2015
A range of data tables in MS Excel designed for download and further analysis.
All Downloads [2.5mb] - use Save option to download ZIP file
| |
R300s | - Provision of Health Care |
|
R020 | - Hospital Summary (excluding Long Stay Hospitals) |
|
R020(LS) | - Hospital Summary - Long Stay Hospitals |
|
R025 | - Hospital Running Costs - Board Level Aggregate |
|
R040 (&LS) | - Specialty Group Costs - Inpatients |
|
R042 | - Specialty Costs - Day Cases | |
R044 | - Specialty Costs - Consultant Outpatient Clinics |
|
R045 | - Specialty Costs - Nurse Led Clinics |
|
R046 | - Specialty Costs - AHP Outpatient Clinics1 |
|
R048 | - Specialty Costs - Day Patients |
|
R060 | - Expenditure on Services Provided by AHPs1 |
|
R070-R110 | - Overheads |
|
R120 | - Radiology |
|
R130 | - Laboratories |
|
R140 | - Theatres |
|
R500s | - Community Health Services |
Note: the links above open MS Excel workbooks, the largest of which is approximately 620kb.
Scottish Financial Returns (SFRs) 2015
The source data files in MS Excel for browsing or to download for further analysis.
All SFRs [3.4mb] - use Save option to download ZIP file
|
SFR 5.1A | - hospital summary statistics |
|
SFR 5.1B | - hospital staff & pay |
|
SFR 5.2 | - hospital running costs |
|
SFR 5.3 | - specialty analysis, inpatients |
|
SFR 5.5 | - specialty analysis, daycases | |
SFR 5.7 | - specialty analysis, outpatient consult clinics |
|
SFR 5.7n | - specialty analysis, nurse led clinics |
|
SFR 5.8 | - AHP outpatient clinics, by profession1 |
|
SFR 5.9 | - specialty analysis, day patients |
|
SFR 5.10 | - theatres summary |
|
SFR 5.11 | - radiology services |
| |
|
|
|
SFR 8.1 | - community staff & pay |
|
SFR 8.2 | - community running costs |
|
SFR 8.3 | - community services |
|
SFR 8.4 | - family health services |
| |
|
|
|
SFR 24.0 | - NHS services provided by sub contracting |
|
SFR 27s | - laboratory services |
| |
|
|
|
SFRs | - full list of blank templates for 2014/15 |
Note: the links above open MS Excel workbooks, the largest of which is approximately 1.2mb.
1 Note that the current figures are recorded against a historical and inaccurate list of AHPs and are therefore not an accurate representative of current AHP service delivery. Development work is underway to update the data collected to accurately reflect the AHP professions.
