Developing Quality Indicators & Dashboards for Dementia

Adam CookSouth East Coast Quality Observatory

The Quality Observatory

• Team of 12• Provision of benchmarking

– Over 50 tools and products developed• Skills development

– Analytical– Measurement and interpretation

• Data quality improvement• World Class Commissioning support• Developing meaningful clinical metrics• Focus on measurement for improvement rather than

judgement

-

100

200

300

400

500

600

700

800

900

1,000

Apr-04

May-04

Jun-04Jul-04A

ug-04S

ep-04O

ct-04N

ov-04D

ec-04Jan-05Feb-05M

ar-05A

pr-05M

ay-05Jun-05Jul-05A

ug-05S

ep-05O

ct-05N

ov-05D

ec-05Jan-06Feb-06M

ar-06A

pr-06M

ay-06Jun-06Jul-06A

ug-06S

ep-06O

ct-06N

ov-06D

ec-06Jan-07Feb-07M

ar-07A

pr-07M

ay-07Jun-07Jul-07A

ug-07S

ep-07O

ct-07N

ov-07D

ec-07Jan-08Feb-08M

ar-08

AAW

Bexhill

Brighton

Crawley

EAMES

East Surrey

Eastbourne

G & W

Hastings

Horsham

Mid Sussex

N Surrey

SD & Weald

SHaWoking

Western Sx

Inpatient All1

Select currency from pivot table on "Data" sheet to change all Charts to that currency

% Delayed transfers of Care by Type - source SITREPS 7/1/02-31/08/03

-20.00

0.00

20.00

40.00

60.00

80.00

100.00

07/0

1/02

07/0

2/02

07/0

3/02

07/0

4/02

07/0

5/02

07/0

6/02

07/0

7/02

07/0

8/02

07/0

9/02

07/1

0/02

07/1

1/02

07/1

2/02

07/0

1/03

07/0

2/03

07/0

3/03

07/0

4/03

07/0

5/03

07/0

6/03

07/0

7/03

07/0

8/03

%Other Reasons

%Patient Family choice

%Await Domiciliary package

%Await Residential

%Await Further NHS care

%Await Public Funding

%AwaitAss >7days

%AwaitAss<7 days

% Delayed transfers of Care by Type - source SITREPS 7/1/02-31/08/03

-20.00

0.00

20.00

40.00

60.00

80.00

100.00

%Aw aitAss<7 days

%Aw aitAss >7days

%Aw ait Public Funding

%Aw ait Further NHS care

%Aw ait Residential

%Aw ait Domiciliary package

%Patient Family choice

%Other Reasons

Developing dementia metrics• Undertaken jointly with the NHS Information Centre

– Dementia and Stroke– Commenced October 2007– Regular meetings with a wide range of clinicians across South East Coast

• Aim to develop metrics from existing electronic data sources to evidence– The quality of care provided– Whether national standards and recommendations were met– Whether agreed pathways are adhered to– Cost effectiveness of treatment– Variation between different providers– The impact of care in one part of the system further down the pathway– Where ‘best’ is delivered

• Provide a balance of measures to prompt questions and discussion• Aimed to influence:-

– Influence national developments and recommendations– The priority given to new data collections or mandatory collection of new fields on

information systems– Linked to the National Dementia Strategy working group

The first meeting…

• Describing data sets that were available: -– QOF– Programme budget– Acute Trust inpatient data– Mental Health inpatient data– Prescribing data– PCT population data– MHMDS (not used due to data quality issues – valuable for future)

• Critical step as many clinicians were unaware of available data sources

• Brainstorming: -– Areas to focus on– Potential indicators

The wish list………

• Actual numbers diagnosed compared to prevalence definite• Mapping the different types of activity within a system e.g. acute

Trust admissions, community contacts, admission to acute mental health beds, day care attendances

• Information on CT/MRI scans• The impact of memory assessment services• Duration of condition pre-diagnosis• Age at diagnosis• Impact of prescribed drugs• The cost of care in different areas

The Reality……• Data sets not available to support all measures

– Outpatients– Scans

• Some information held in patients notes• Data quality poor in some areas• Some data sets available in theory, but difficult to obtain

– E.g. prescribing data• However, some indicators could be produced

– Spend on organic mental disorders– % practices that can produce a dementia register– % patients reviewed within past 15 months– Information on admissions to provider units– Comparison of predicted numbers vs numbers on register by GP practice

• Combining these created a compelling story….• Combination of SHA and CHKS analysis

0

500

1,000

1,500

2,000

2,500

3,000

3,500

4,000

Brig

hton

and

Hov

e C

ityTe

achi

ng P

CT

Eas

t Sus

sex

Dow

ns a

nd W

eald

PC

T

Eas

tern

and

Coa

stal

Ken

tTe

achi

ng P

CT

Has

tings

and

Rot

her P

CT

Med

way

Tea

chin

g P

CT

Sur

rey

PC

T

Wes

t Ken

t PC

T

Wes

t Sus

sex

Teac

hing

PC

T

'000

s

200607200506200405

by Area 5b - Organic Mental DisordersProgramme Budget Year on Year Net Expenditure / Unified Weighted 100,000 Pop.

PCT Spend - dementia

Apparent disinvestment

QOF register - dementia• Utilised Alzheimer’s Society Dementia UK prevalence model• Comparison with numbers on dementia registers• Analysis to GP practice level (using practice profiles)

Acute Admissions

Numbers of Admissions, Beddays and estimated costs for admissions with Dementia (ICD10 F00-F03) in 2007/08

Trust Admissions Beddays Cost @ £300 per day Admissions Beddays Cost @ £300 per dayDartford & Gravesham 221 3290 987,000.00£ 24 430 129,000.00£ East Kent Hospitals 933 6869 2,060,700.00£ 91 875 262,500.00£ Maidstone & Tunbridge Wells 496 6081 1,824,300.00£ 44 1114 334,200.00£ Medway 389 4909 1,472,700.00£ 58 1138 341,400.00£ Kent 2039 21149 6,344,700.00£ 217 3557 1,067,100.00£

Ashford & St Peter's 526 3481 1,044,300.00£ 40 340 102,000.00£ Frimely Park 319 4814 1,444,200.00£ 30 816 244,800.00£ Royal Surrey County 270 3682 1,104,600.00£ 23 638 191,400.00£ Surrey & Sussex 457 4853 1,455,900.00£ 40 780 234,000.00£ Surrey 1572 16830 5,049,000.00£ 133 2574 772,200.00£

Brighton & Sussex University Hospitals 544 4857 1,457,100.00£ 55 653 195,900.00£ East Sussex 676 8690 2,607,000.00£ 57 1546 463,800.00£ Royal West Sussex 273 2119 635,700.00£ 27 293 87,900.00£ Worthing & Southlands 308 3635 1,090,500.00£ 2 8 2,400.00£ Sussex 1801 19301 5,790,300.00£ 141 2500 750,000.00£

SEC 5412 57280 17,184,000.00£ 491 8631 2,589,300.00£

Source: SUS Admitted Patient Care Finished Episode Extract

In 1st three diagnostic positions In Primary diagnostic position only

Challenging for local commissioners

• “You can’t use the Programme Budget data – it’s wrong”• Disinvestment + evidencing relatively low levels of

diagnosis• Significant sums being spent in secondary care• Could money be spent more effectively??• Analysis has influenced the service models developed by

local PCTs• Were commissioners aware of their ‘story’• Prompted lots of discussion and debate

Are there inter-relationships?

Surrey PCT

0102030405060708090

100Predicted prevalence across health economy (%)

Actual (QMAS) relative to predicted prevalence

Predicted prevalence per 1000 population

Bed days per 10,000 populationAdmissions per 10,000 population

Average Length of Stay

Spend on mental health per 100,000 population (£M)

West Kent PCT

0

10

20

30

40

50

60

70

80

90

100Predicted prevalence across health economy (%)

Actual (QMAS) relative to predicted prevalence

Predicted prevalence per 1000 population

Bed days per 10,000 populationAdmissions per 10,000 population

Average Length of Stay

Spend on mental health per 100,000 population (£M)

Monitoring Tool – provider based

Most recent 100 Admissions with a diagnosis of Dementia (any position)

by LoS

0

10

20

30

40

50

60

70

80

1 8 15 22 29 36 43 50 57 64 71 78 85 92 99

PatientsAverage LoSLower Confidence LimitUpper Confidence Limit

Top Ten Primary Dianoses (where primary Diagnosis not Dementia)

0

20

40

60

80

100

120N39

J18

S72

J22

S01

J44

R54

R55

I63

R07

LoS Distribution

0

50

100

150

200

250

300

0 days

1 day

2 days

3-7 days

1-2 w

eeks

2-3 w

eeks

3-4 w

eeks

1-2 m

onths

2-3 m

onths

3-4 m

onths

4-5 m

onths

5-6 m

onths

6-12 m

onths

1-2 ye

ars

2-3 ye

ars

3-4 ye

ars

4-5 ye

ars

5+ ye

ars

1st 3 Diagnoses Primary Diagnosis

Numbers of Diagnoses of Dementia by Location of Diagnosis

0

20

40

60

80

100

120

140

2005

/06

Q1

2005

/06

Q2

2005

/06

Q3

2005

/06

Q4

2006

/07

Q1

2006

/07

Q2

2006

/07

Q3

2006

/07

Q4

2007

/08

Q1

2007

/08

Q2

2007

/08

Q3

2007

/08

Q4

2008

/09

Q1

Primary Others

Average LoS for Dementia Diagnoses

0

20

40

60

80

100

120

140

160

180

2005

/06

Q1

2005

/06

Q2

2005

/06

Q3

2005

/06

Q4

2006

/07

Q1

2006

/07

Q2

2006

/07

Q3

2006

/07

Q4

2007

/08

Q1

2007

/08

Q2

2007

/08

Q3

2007

/08

Q4

2008

/09

Q1

1st 3 Diagnoses Primary Diagnosis

Total Beddays used by patients with a dignosis of Dementia

0

200

400

600

800

1,000

1,200

1,400

1,600

1,800

2,000

2005

/06

Q1

2005

/06

Q2

2005

/06

Q3

2005

/06

Q4

2006

/07

Q1

2006

/07

Q2

2006

/07

Q3

2006

/07

Q4

2007

/08

Q1

2007

/08

Q2

2007

/08

Q3

2007

/08

Q4

2008

/09

Q1

1st 3 Diagnoses Primary Diagnosis

£Cost PbR Tariff 07/08 (where no tariff estimated cost £300 per day)

£-

£50,000.00

£100,000.00

£150,000.00

£200,000.00

£250,000.00

£300,000.00

£350,000.00

£400,000.00

£450,000.00

2005

/06

Q1

2005

/06

Q2

2005

/06

Q3

2005

/06

Q4

2006

/07

Q1

2006

/07

Q2

2006

/07

Q3

2006

/07

Q4

2007

/08

Q1

2007

/08

Q2

2007

/08

Q3

2007

/08

Q4

2008

/09

Q1

1st 3 Diagnoses Primary Diagnosis

Numbers of Diagnoses of Dementia by Discharge Destination

0

100

200

300

400

500

600

700

800

900

1,000

Not

Rec

orde

d

Usu

al p

lace

of r

esid

ence

Tem

pora

ry p

lace

of r

esid

ence

NH

S -

high

sec

urity

psy

chia

tric

NH

S -

med

ium

sec

ure

unit

NH

S -

gene

ral w

ard

NH

S -

mat

erni

ty w

ard

NH

S -

mal

e w

ard

NH

S -

car

e ho

me

LA re

side

ntia

l acc

omm

odat

ion

Pat

eint

die

d

Non

-NH

S m

ediu

m s

ecur

e un

it

Non

-NH

S/L

A C

are

Hom

e

Non

-NH

S h

ospi

tal

Non

-NH

S/L

A h

ospi

ce

1st 3 Diagnoses Primary Diagnosis

Dementia as one of the first three diagnoses in Secondary Care (2005/06 - 2008/09 Q1): Medway

Monitoring Tool – commissioner based

Monitoring Tool – social care based

nww.sec.nhs.uk/qualityobservatory

Bi-monthly newsletter

Contact details

• nww.sec.nhs.uk/qualityobservatory– Register as a user

• Adam Cook– 01293 778846– Adam.cook@southeastcoast.nhs.uk