Page last updated: 30-NOV-2010

Costs

You are now viewing an archive version of the ISD website. To see the current version please go to www.isdscotland.org.

File Listings 2009

The following links provide short cuts to the 2009 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 infomation about the 2009 data see Summary of Changes.  File listings for previous years are also available from the Costs Archive.


Reports 2009

The full range of Costs Book tables in MS Excel, designed for on-screen viewing.

link to a zip file All Reports [2.6 MB] - use Save option to download ZIP file

link to a microsoft excel file R100 - executive summary, for Scotland and each board 
link to a microsoft excel file R100T - expenditure and activity figures for the last 5 years, for Scotland and each board
link to a microsoft excel file R086 - NHS Board operating costs and capital expenditure
link to a microsoft excel file R200s - expenditure per head of population, by NHS board of residence and by type of care
link to a microsoft excel file R300s - net expenditure, by board of treatment, by care type
link to a microsoft excel file R020 - hospital summary (excluding long stay hospitals)
link to a microsoft excel file R020LS - hospital summary - long stay hospitals
link to a microsoft excel file R025 - board level aggregate of hospital running cost
     
link to a microsoft excel file R04X - specialty summary - all specialties (exc long stay), by patient type, by board
link to a microsoft excel file R04LSX - specialty summary - long stay specialties, by patient type, by board
link to a microsoft excel file R04opX - total specialty outpatient expenditure and activity summary, by board
link to a microsoft excel file R040 - specialty costs and activity - inpatients in all specialties (exc long stay), by hospital
link to a microsoft excel file R040X - specialty costs and activity - inpatients in all specialties (exc long stay), by board
link to a microsoft excel file R040LS - specialty summary - inpatients in long stay specialties, by patient type, by hospital
link to a microsoft excel file R040LSX - specialty summary - inpatients in long stay specialties, by patient type, by board
link to a microsoft excel file R042 - specialty costs and activity - daycases, by specialty, by hospital
link to a microsoft excel file R042X - specialty costs and activity - daycases, by specialty, by board
link to a microsoft excel file R043 - specialty costs and activity - outpatient treatments, by specialty, by hospital
link to a microsoft excel file R043X - specialty costs and activity - outpatient treatments, by specialty, by board
link to a microsoft excel file R044 - specialty costs and activity - consultant outpatients, by specialty, by hospital
link to a microsoft excel file R044X - specialty costs and activity - consultant outpatients, by specialty, by board
link to a microsoft excel file R045 - specialty costs and activity - nurse led clinics, by specialty, by hospital
link to a microsoft excel file R045X - specialty costs and activity - nurse led clinics, by specialty, by board
link to a microsoft excel file R046 - costs and activity at AHP outpatient clinics, by profession, by hospital
link to a microsoft excel file R046X - costs and activity at AHP outpatient clinics, by profession, by board
link to a microsoft excel file R048 - specialty costs and activity - day patients, by specialty, by hospital
link to a microsoft excel file R048X - specialty costs and activity - day patients, by specialty, by board
     
link to a microsoft excel file R060 - expenditure on services provided by AHPs, by hospital
link to a microsoft excel file R060X - expenditure on services provided by AHPs, by board
     
link to a microsoft excel file R070 - expenditure on catering, domestic and portering services, by hospital
link to a microsoft excel file R070X - expenditure on catering, domestic and portering services, by board
link to a microsoft excel file R080  - expenditure on linen services, by hospital
link to a microsoft excel file R080X - expenditure on linen services, by board
link to a microsoft excel file R090 - expenditure on property overheads, by hospital
link to a microsoft excel file R090X - expenditure on property overheads, by board
link to a microsoft excel file R110 - expenditure on management & administration expenses, by hospital
link to a microsoft excel file R110X - expenditure on management & administration expenses, by board
     
link to a microsoft excel file R120 - expenditure and activity - radiology services, by hospital
link to a microsoft excel file R120X - expenditure and activity - radiology services, by board
link to a microsoft excel file R130 - expenditure and activity - laboratory services, by hospital
link to a microsoft excel file R130X - expenditure and activity - laboratory services, by board
link to a microsoft excel file R140 - number of theatres, expenditure and usage, by hospital
link to a microsoft excel file R140X - number of theatres, expenditure and usage, by board
link to a microsoft excel file R141X - average theatre running costs, by board
link to a microsoft excel file R142X - average theatre running costs and usage, by specialty, by board
     
link to a microsoft excel file R500 - summary of expenditure on main community services, by board
link to a microsoft excel file R510 - community AHP services by board
link to a microsoft excel file R520 - other community services by board
link to a microsoft excel file R550 - summary of expenditure on community staff and supplies, by board
     
link to a microsoft excel file R600 - pharmacy drugs expenditure, by NHS sector, by board
link to a microsoft excel file R610 - pharmacy drugs expenditure for the hospital sector, by hospital
     
link to a microsoft excel file R700 - staff expenditure summary by sector, by board
link to a microsoft excel file R710 - hospital staff profile - expenditure and WTEs by main staff groupings, by board
link to a microsoft excel file R720 - hospital staff profile - expenditure and WTEs by specialty
link to a microsoft excel file R730 - community staff profile - expenditure and WTEs by main staff groupings, by board
link to a microsoft excel file R740 - laboratory staff profile - expenditure and WTEs by main staff groupings, by board
     
link to a microsoft excel file R810 - expenditure on pharmaceutical services, by NHS sector, by board
link to a microsoft excel file R820 - expenditure on dental services, by NHS sector, by board
link to a microsoft excel file R830 - expenditure on ophthalmic services, by NHS sector, by board
     
link to a microsoft excel file R910 - Scottish Ambulance Service, expenditure and statistics, by board area
link to a microsoft excel file R920 - National Services Scotland, expenditure and staff numbers, by division
link to a microsoft excel file R921 - Scottish Breast Screening Programme, expenditure and statistics, by region


Note: the links above open MS Excel workbooks, the largest of which is approximately 821 KB.

Back to top



Download Reports 2009

A range of data tables in MS Excel designed for download and further analysis.

link to a zip file All Downloads [1.7 MB] - use Save option to download ZIP file

link to a microsoft excel file  R300s   - Provision of Health Care 
link to a microsoft excel file R020   - Hospital Summary (excluding Long Stay Hospitals) 
link to a microsoft excel file R020(LS)   - Hospital Summary - Long Stay Hospitals
link to a microsoft excel file R025   - Hospital Running Costs - Board Level Aggregate
link to a microsoft excel file R040 (&LS)    - Specialty Group Costs - Inpatients
link to a microsoft excel file R042   - Specialty Costs - Day Cases
link to a microsoft excel file R043   - Specialty Costs - Consultant Outpatient Treatment Clinics
link to a microsoft excel file R044  - Specialty Costs - Consultant Outpatient Clinics
link to a microsoft excel file R045   - Specialty Costs - Nurse Led Clinics 
link to a microsoft excel file R046   - Specialty Costs - AHP Outpatient Clinics
link to a microsoft excel file R048   - Specialty Costs - Day Patients
link to a microsoft excel file R060   - Expenditure on Services Provided by AHPs
link to a microsoft excel file R070-R110   - Overheads
link to a microsoft excel file R120   - Radiology
link to a microsoft excel file R130   - Laboratories
link to a microsoft excel file R140   - Theatres
link to a microsoft excel file R500s   - Community Health Services


Note: the links above open MS Excel workbooks, the largest of which is approximately 912 KB.

 

Scottish Financial Returns (SFRs) 2009

The source data files in MS Excel for browsing or to download for further analysis.

link to a zip file All SFRs [2.5 MB] - use Save option to download ZIP file

link to a microsoft excel file SFR 5.1A    - hospital summary statistics
link to a microsoft excel file SFR 5.1B   - hospital staff & pay
link to a microsoft excel file SFR 5.2 - hospital running costs
link to a microsoft excel file SFR 5.3   - specialty analysis, inpatients
link to a microsoft excel file SFR 5.5   - specialty analysis, daycases
link to a microsoft excel file SFR 5.6 - specialty analysis, outpatient treatment clinics
link to a microsoft excel file SFR 5.7 - specialty analysis, outpatient consult clinics 
link to a microsoft excel file SFR 5.7n - specialty analysis, nurse led clinics
link to a microsoft excel file SFR 5.8 - AHP outpatient clinics, by profession
link to a microsoft excel file SFR 5.9 - specialty analysis, day patients
link to a microsoft excel file SFR 5.10 - theatres summary
link to a microsoft excel file SFR 5.11   - radiology services
     
link to a microsoft excel file SFR 8.1 - community staff & pay
link to a microsoft excel file SFR 8.2   - community running costs
link to a microsoft excel file SFR 8.3   - community services
link to a microsoft excel file SFR 8.4   - family health services
     
link to a microsoft excel file SFR 13.0 - board expenditure on board residents
link to a microsoft excel file SFR 24.0   - NHS services provided by sub contracting
link to a microsoft excel file SFR 27s   - laboratory services
     
link to a microsoft excel file SFRs   - full list of blank templates for 2008/09


Note: the links above open MS Excel workbooks, the largest of which is approximately 2.9 MB.


Back to top


Main contact: Email Costs Team