Page last updated: 24-NOV-2009

Costs

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

 

2008 2007 2006 2005 2004 2003 2002 2001 2000

File Listings 2007

The following links provide short cuts to the 2007 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 


File listings for previous years are also available from the Costs Archive.


Reports 2007

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

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 - acute, by patient type, by board
link to a microsoft excel file R04LSX - specialty summary - non-acute, 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 acute specialties, by hospital
link to a microsoft excel file R040X - specialty costs and activity - inpatients in acute specialties, by board
link to a microsoft excel file R040LS - specialty summary - inpatients in non-acute, by patient type, by hospital
link to a microsoft excel file R040LSX - specialty summary - inpatients in non-acute, 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 discipline, by hospital
link to a microsoft excel file R046X - costs and activity at AHP outpatient clinics, by discipline, 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 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 830 KB.

Back to top



Download Reports 2007

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

link to a microsoft excel file  R300s [295 KB] - Provision of Health Care 
link to a microsoft excel file R020 [137 KB] - Hospital Summary (excluding Long Stay Hospitals) 
link to a microsoft excel file R020(LS) [246 KB] - Hospital Summary - Long Stay Hospitals
link to a microsoft excel file R025 [54 KB] - Hospital Running Costs - Board Level Aggregate
link to a microsoft excel file R040 (&LS) [1.6 MB] - Specialty Group Costs - Inpatients
link to a microsoft excel file R042 [805 KB] - Specialty Costs - Day Cases
link to a microsoft excel file R043 [143 KB]  - Specialty Costs - Consultant Outpatient Treatment Clinics
link to a microsoft excel file R044 [1.8 KB] - Specialty Costs - Consultant Outpatient Clinics
link to a microsoft excel file R045 [360 KB] - Specialty Costs - Nurse Led Clinics 
link to a microsoft excel file R046 [1 MB] - Specialty Costs - AHP Outpatient Clinics
link to a microsoft excel file R048 [320 KB] - Specialty Costs - Day Patients
link to a microsoft excel file R060 [164 KB] - Expenditure on Services Provided by AHPs
link to a microsoft excel file R070-R110 [703 KB] - Overheads
link to a microsoft excel file R120 [87 KB] - Radiology
link to a microsoft excel file R130 [62 KB] - Laboratories
link to a microsoft excel file R140 [73 KB] - Theatres
link to a microsoft excel file R500s [104 KB] - Community Health Services
 

 

Scottish Financial Returns (SFRs) 2007

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

link to a microsoft excel file SFR 5.1A [1.6 MB]   - hospital summary statistics
link to a microsoft excel file SFR 5.1B [849 KB] - hospital staff & pay
link to a microsoft excel file SFR 5.2 [5.6 MB] - hospital running costs
link to a microsoft excel file SFR 5.3 [3.4 MB] - specialty analysis, inpatients
link to a microsoft excel file SFR 5.5 [720 KB] - specialty analysis, daycases
link to a microsoft excel file SFR 5.6 [60 KB] - specialty analysis, outpatient treatment clinics
link to a microsoft excel file SFR 5.7 [2 MB] - specialty analysis, outpatient consult clinics 
link to a microsoft excel file SFR 5.7n [602 KB] - specialty analysis, nurse led clinics
link to a microsoft excel file SFR 5.8 [1.22 MB] - AHP outpatient clinics, by discipline
link to a microsoft excel file SFR 5.9 [588 KB] - specialty analysis, day patients
link to a microsoft excel file SFR 5.10 [100 KB] - theatres summary
link to a microsoft excel file SFR 5.11 [92 KB] - radiology services
     
link to a microsoft excel file SFR 8.1 [33 KB] - community staff & pay
link to a microsoft excel file SFR 8.2 [97 KB] - community running costs
link to a microsoft excel file SFR 8.3 [116 KB] - community services
link to a microsoft excel file SFR 8.4 [64 KB] - family health services
     
link to a microsoft excel file SFR 13.0 [421 KB] - board expenditure on board residents
link to a microsoft excel file SFR 24.0 [229 KB] - NHS services provided by sub contracting
link to a microsoft excel file SFR 27s [649 KB] - laboratory services
     
link to a microsoft excel file SFRs [282 KB] - full list of blank templates for 2006/07


Back to top


Main contact: Email Costs Team