SUS and Public Health Progress and Potential

1
SUS and Public HealthProgress and Potential

• Roger Dewhurst
• 21 February 2006

2
Design of SUS
3
Components of a secondary uses service
Service Activities
Receive / Request Data

• Reformat
• Validate
• completeness
• coverage
• consistency

• Derive new
• Data items
• Classify
• Construct
• Linkage

Produce Tabulations And Reports (Graphs)
Construct Indicators Complex Reports
Forecasts Maps
Interpret (link to Targets)
4
SUS Architecture
Secure Environment with role based access control
CREATE DATA MARTS
Transit Marts
Data

• Produce group
• pseudonyms
• Create data views

• Analysis Marts
• Produce group
• pseudonyms
• Create cubes
• Derive additional
• data items
• Construct indicators

Analysis
Local Data ?
Manage Metadata Technical / Business
5
Content of SUS

• Analysis Potential

6
Building the SUS Warehouse Stage 1

• ANALYSIS POTENTIAL
• Comparative provider performance
• Length of stay by case mix, admission method,
  discharge destination etc.
• Readmissions
• Outpatient / AE conversion rates
• Outpatient follow up ratios

Person Event Level Data

• CARE SPELLS
• Admitted patient care
• spells within a single
• provider
• Costed at tariff

• CARE EVENTS
• Admitted patient care
• episodes
• Outpatients
• AE attendances

7
Building the SUS Warehouse Stage 2
Population Data
QOF

• ANALYSIS POTENTIAL
• Population Level Linkage
• Practice / Area
• Access / incidence rates
• Prevalence rates (for QOF conditions) compared
  with service access / use
• Age Standardisation etc.
• Ecological fallacies as limited person level
  linkage

Practice / Area Profiles
Person Level Data

• PERSON DETAILS
• DoB, Gender
• Address
• Registration

8
Building the SUS Warehouse Stage 3
Population Data
QOF

• ANALYSIS POTENTIAL
• Linkage at person level
• Additional elective care analysis
• Patient choices and elapse times for treatment
• Additional analysis of some national audit
  datasets

Practice / Area Profiles
Person Level Data

• PERSON DETAILS
• D o B, Gender
• Address
• Registration

• CARE SPELLS
• Admitted patient care
• spells within a single
• provider
• Costed at tariff
• National Audit spells

• CARE EVENTS
• Booked appointments
• Admitted patient care
• episodes
• Outpatients
• AE attendances
• National Audits

9
Building the SUS Warehouse Stage 4
Population Data

• ANALYSIS POTENTIAL
• Comprehensive linkage at person level
• Prescribing effectiveness
• Link chronic condition, drugs dispensed,
  treatment spells
• Assessment and treatment elapse times
• Overall cost profiles
• Cohort identification and analysis
• Additional analysis filtered by area population
  characteristics

Practice / Area Demographic Profiles
QOF
Area Population Characteristics
Person Level Data

• PERSON DETAILS
• D o B, Gender
• Address
• Registration

• PERSON
• CHARACTERISTICS
• Chronic conditions
• Risk factors

• CARE SPELLS
• Admitted patient care
• spells within a single
• provider
• Costed at tariff
• Pathway construction
• Repeat dispensing
• Prescriptions
• National audit spells

• CARE EVENTS
• Booked appointments
• Prescriptions
• Admitted patient care
• episodes
• Outpatients
• AE attendances
• National audits

10
Spatial analysis potential
11
Geographical analysis within SUSStandard
geographies
GIS used as component of presentation layer
12
Geographical analysis within SUSLocal
geographies
13
Geographical analysis within SUSComplex analysis