Organisation Health Check

1
Organisation Health Check

• Vicky Spark
• Senior Information Analyst
• NHS Information Authority

2
Summary

• Background
• Details what is the OHC?
• Future developments
• What we intend to do
• What do you want us to do?
• Demonstration

3
Background

• An e-mail from Leonie Mountney
• I want a spreadsheet for the conference for
  visitors to see how their organisation is
  performing in areas like activity, waiting list,
  waiting times etc using any current data that is
  available.

4
What is the OHC?

• Excel based demonstration tool
• High level analysis by
• Hospital
• Hospital Specialty
• English data only
• 3 years of activity
• 4 years of waiting list/times
• Analysis is user defined

5
Statistics

• PAT style statistics
• Casemix adjusted
• Traffic lights
• Length of stay trend analysis
• Casemix adjusted (standardised on one year)
• Includes each years national value
• Waiting list analysis
• Outpatient Inpatient/Daycase
• Times for admission list sizes
• Activity vs waiting list
• Reference cost analysis
• Traffic lights

6
Statistics .. continued

• Calculation of traffic lights
• RAG definitions are within the s/w
• Example for RAG of Average LoS
• Very short or long LoS (RED)
• Outside 10th 90th percentiles
• Centred around the median (GREEN)
• Between 30th 70th percentiles
• Otherwise AMBER
• Not all RAG indicators are the same
• i.e. Readmissions

7
Data Sources

• NWCS extract 3 years
• 1998/99 2000/01
• Based on spells (or admissions)
• DoH sources 4 years
• 1998/99 2001/02
• Public domain information
• WWW references in last slide
• Counts of individual patients
• NSRC
• 2000/01 only
• Based on FCEs

8
References

• DoH data from
• www.doh.gov.uk/hospitalactivity
• www.doh.gov.uk/waitingtimes
• Quarterly downloads

9
Data Issues

• GIGO - data quality!
• Quirks underlying apparent variations
• DC recorded as IP?
• Excludes private practice
• Trust mergers/splits over time
• FCEs Spells

10
Availability

• Via PIANO
• Web based
• In development
• Timescales 3 months?
• CD Rom
• In development, not finished!
• Version control
• Want comments/feedback

11
Organisation Health Check Interactive
Demonstration
12
Future Developments

• What we intend to do
• Example Bed occupancy rates
• DoH source
• 4 years, 1998/99 2001/02
• Linked to activity
• Linked to waiting lists/times
• What do you want us to do?