Transcript Using data for planning and funding Hutt Valley DHB NGO

Using data for planning and funding
Hutt Valley DHB
NGO Information development workshop
Michelle van der Raaij
Service Analyst
Planning & Funding
May 2012
Our purpose
We got into
this
to help people
The big questions
Are we really helping
people?
How do we know we are
doing a good job?
The big questions
How do we know we
are doing a good
job?
Are we really helping
people?
The data helps us answer
the big questions
 Planning
 Funding
 Contract
monitoring
 Service management
 Service quality
Using data –
a journey with our providers

Started collecting client NHI level data in
2008
Excel spreadsheet templates
Tailoring the data to the kind of service e.g.

Feeding back the data:


day service, work rehab, community support,
residential
regular contract meetings with Providers


Discussion about the story behind the
numbers
Supporting service improvement and
development
What data do we collect?

Excel spreadsheet templates








NHI (or unique identifier)
Contacts
Contact hours
Beddays used
Work hours
Attendances at group sessions
“Drop-ins”
Outcomes
What data do we collect?
Day service template
MHCS16C
Activity-Based Rehabilitation Service/Day Activity & Living Skills
ATTENDANCES at house programme and drop-in centre
Total unique individuals
Total General attendances at
facility
Total Attendances at
programmes
Total YTD
107
Jul-09
126
Aug-09
129
Sep-09
132
Oct-09
110
Nov-09
104
Dec-09
132
4378
709
720
873
628
705
743
1417
232
200
278
183
219
305
Jul-09
Client Information
Client NHI
NHI UNKNOWN
AAA1234
BBB5678
Ethnicity
o
o
o
Total Attendances YTD
Date of birth
6/11/1965
18/08/1954
Age as at
1/07/09
General
attendance at Attendances at
facility
programmes
43
2
2
5
0
54
24
4
Total days
facility was
open
Total
programme
sessions
provided
21
37
Jul-09
General
attendance at
facility
5
Attendances at
programmes
What data do we collect?
Tailoring report for use of management
Current progress of clients
Automatically calculated please check cell
references
number of clients
Staff activity
Month of service
Day activity
centre
volunteering
Community Contracts/T Paid partvolunteering
emping
time work
Paid fulltime work Grand Total
21
15
10
9
2
43
(Multiple Items)Excludes hours with staff activity of coordination and promotion
6
Select the number of the month (e.g. 7 = July) ALL = YTD
Sum of Activity time (hours
Work&placement
mins)
Day activity
centre
Community Contracts/
volunteering volunteering Temping
NHI
AAA1234
12.50
Paid parttime work
Paid full- Grand
time work Total
12.50
0
0
Using the data for Planning
 Mapping
services
 How many people are using
services?
 Where are the gaps?
Hutt Valley DHB Mental Health Basic Service Map
Older People
Adult
Youth
Infant/ Child
Youth One Stop Shop
(NGO)
(eg Vibe NGO)
(eg
Incredible
Years)
Dementia/
Psychogeriatrics
Infant, Adolescent and Youth Community Services
Older Persons Community
Adult Community (including Maori/ Pacific) (DHB)
(including Maori & Pacific) (DHB)
(DHB)
(NGO/ DHB
Health of Older
People services)
(DHB in AT&R)
SecondarySubRegional
Addictions Community, Day Programmes and Residential
Rehab (DHB & NGO)
SecondaryLocal
Crisis Assessment & Treatment (DHB)
Phone Line (triage and support, peer support) (NGO)
Inpatient (Acute/ ICU & Acute Day Service ) (DHB)
Inpatient (Acute/ ICU & Acute Day Service ) (DHB)
TertiaryRegional Specialist
Key
Opioid Substitution (PHO)
Parent
Education
Respite (Planned and Crisis) (DHB & NGO)
Day Service (NGO)
Employment Support (NGO)
Peer Support/ Advocacy (NGO)
Residential (NGO)
Intensive Clinical Support (DHB)
Community Support (including flexible support- NGO)
Refugee and Migrant (NGO)
Rangatahi Youth Services (DHB)
Medical Detoxification (DHB)
Opioid Substitution (DHB)
Early Intervention Service (DHB)
Rangatahi – Inpatient (DHB)
Refugee and Migrant (NGO)
Regional Speciality Services:
Maternal MH
Specialist Psychotherapy/
Personality Disorder
Dual Diagnosis Addictions/ MH
Dual Diagnosis MH/ Intellectual Disability
(DHB)
AOD Addictions Community, Day Programmes and
Residential Rehab (NGO)
Primary
Primary MH (PHO, NGO)
MH Longterm care
for older persons
Manor Park
(NGO)
Multisystemic therapy (NGO)
Eating Disorders Service (DHB)
Regional Rehabilitation (DHB)
Forensic – Community (Courts/ Prisons)
Forensic residential (DHB)
Forensic Step-Down Residential (NGO)
Managed and
provided by
HVDHB
Regional
Management
based in
HVDHB
Managed
and
provided by
CCDHB
Managed by
CCDHB
Produced November 2011
HVDHB P&F MH
Michelle Van Der Raaij, Simon
Phillips, Anne Bateman
Child & Youth
Local community
Maori Child & Youth
Pacific Child & Youth
Youth
Adult
Day service
Maori Adult
Take 5, MASH,
Friends who care
394
210
Peer support & Advocacy
134
Work rehab
200
Community support
Te Paepae Arahi
55
25
Oasis
MH Solutions
RichmondNZ
60
28 Vakaola
126
28
Planned respite
Te Paepae Arahi
Te Paepae Arahi
RichmondNZ
27
Residential
53
Older Adult
Vakaola
Valley Transitionz
Earthlink
Q-nique
Community support
Pacific Adult
8
Q-nique
3
Manor Park
Q-nique
subregional community
Q-nique
49
Planned respite
Residential
192
AOD
18
AOD residential
Regional community
27
AOD
Q-nique
265
RichmondNZ
The Salvation Army
9
AOD residential
Local Specialist
43
Nova, Odyssey,
The Salvation Army
Te Waireka
333
AOD
319
120
776
HVDHB
HVDHB
HVDHB
193
consult/liaison
HVDHB
240
day service
HVDHB
crisis
1443
HVDHB
Regional Specialist
Eating disorder service
200
data to be
obtained
1734
HVDHB
inpatient
HVDHB
266
HVDHB
HVDHB
Community MH
Care NZ
Q-nique
20
HVDHB
278
HVDHB
beds
3
59
HVDHB
community
HVDHB
Hutt Valley people using specialist Mental Health services
in 2009/10 contracted by Hutt Valley DHB:
5,116 people (4% of total population)
HV people using HVDHB MH&A
services = 3,456 people
Using HVDHB Provider Arm ONLY
= 2,871 people
HV people using
CCDHB Provider
Arm services ONLY
= 452
HV people using local NGO services =
1,560 people
using Provider
Arm and local
NGO services =
569 people
using local NGO
services ONLY = 989
people
HV people using
regional NGO
addiction services
ONLY = 217
Using the data for Funding
 Are
the resources being used fully?
 Are we getting value for money?
 Could more people be seen?
 Are all the hours/beds available
being used?
 Are people getting a good service?
Using the data:
setting targets





What have we contracted for?
What is the service model?
FTE = 30 contact hours for 52 weeks or
adjust to service model
Available beds – what is the target
occupancy?
Length of stay in service - beds
Using the data:
Data quality improvement +
Service management =
more people receive service
Youth Community Support work: Clients seen and contact hours vs target
300
35
30
250
150
15
100
10
Actual contact hours
Total Avail hrs (30h/52w)
Clients seen
Jan-12
Oct-11
Jul-11
Apr-11
Jan-11
Oct-10
Jul-10
Apr-10
Jan-10
Oct-09
Jul-09
0
Apr-09
0
Jan-09
5
Oct-08
50
Jul-08
contact hours
20
unique clients seen
25
200
Using the data:
Adjusting funding to match what is being
delivered
Adult Community Support work: Total contact hours (Direct & indirect)
900
800
700
600
500
400
300
200
100
CCDHB
CCDHB Available hours (30hx52w)
HVDHB
HVDHB Available hours (30hx52w)
Mar-12
Jan-12
Nov-11
Sep-11
Jul-11
May-11
Mar-11
Jan-11
Nov-10
Sep-10
Jul-10
May-10
Mar-10
Jan-10
Nov-09
Sep-09
Jul-09
May-09
Mar-09
Jan-09
Nov-08
Sep-08
Jul-08
0
Using the data:
benchmarking outcomes
Outcomes for AOD Youth FY 2011/12 YTD
90%
80%
in period
70%
treatment
% of total people who completed
100%
60%
50%
40%
30%
20%
10%
0%
Percent of cases
completing treatment
Percent of youth living at
home
Percent of youth in
school/working
Outcomes measures
Target
Team South
Team East
Team North
Percent of youth with no
new arrests
Using the data:
For regional planning
2011/12 YTD Jul 11 - Mar 12 AOD residential
Provider
Provider A
Provider
Provider
Provider
Provider
Total
B
S
T
H
No. beds
% occupancy
used
91%
10.4
3.9
17.8
5.1
6.2
43.5
49%
74%
40%
52%
64%
ALOS
No.
(mths)
clients
4.8
28
7
132
25
42
234
12.3
1.8
1.2
1.2
Using the data:
meeting population need
70%
Ethnicity of Central Region AOD Residential Service Users vs
Target population with 12 month prevalence of substance use disorder
(TRH 2006) 2011/12 YTD
60%
50%
40%
30%
20%
10%
0%
Maori
Pacific
Target
Service users
Other
Future plans – using the data





Move to PRIMHD as the main data source
Continue to support providers to use the
data
Continue to use data to inform planning &
funding
Use data to recognise better service
performance
Support development of outcome measures
to inform service quality improvement