8/2/2019 Mandy Mackay
1/19
Data Quality 2012Asia Pacific Congress
Capturing and assessing a new data stream
8/2/2019 Mandy Mackay
2/19
District Health Boards (DHBs)
New Zealand has 20
District Health Boards(DHBs)
8/2/2019 Mandy Mackay
3/19
Ministry of Health
The Ministry of Healths
role is to improve,
promote and protect
the health of New
Zealanders
8/2/2019 Mandy Mackay
4/19
Capital and Coast District Health
Board (C&C DHB)
Currently C&C DHBs
region has apopulation of about
298,000 people
8/2/2019 Mandy Mackay
5/19
C&C DHB Tertiary Hospital
C&C DHB is the
leading provider of
specialist tertiary
services for theupper South and
lower North Islands,
a population of
about 900,000
8/2/2019 Mandy Mackay
6/19
C&C DHB Data Quality Team
7 people in the Data Quality team
Key responsibilities:
- National data collections
- Data correction
- Patient data updates (demographics)
- Admin staff DQ training
- Unique identifier merging (NHI)- Data Entry
8/2/2019 Mandy Mackay
7/19
National Collections Annual
Maintenance Programme (NCAMP) Year long project, every year
Agreed changes are to be implemented by DHBs
for data submission effective 1 July
8/2/2019 Mandy Mackay
8/19
New Data Element
Time
AdmitDate CCYYMMDD to be changed to
AdmitDatetime CCYYMMDDHHMM
EndDate CCYYMMDD to be changed to
EndDatetime CCYYMMDDHHMM
8/2/2019 Mandy Mackay
9/19
But Why?????
Why?
What?
When?
Where?
How?
8/2/2019 Mandy Mackay
10/19
Define
Business Process
Data RulesValidation routines of the new datetime fields will need
to be incorporated into DHB systems
Identify StakeholdersImpact to business?
8/2/2019 Mandy Mackay
11/19
Measure and Analyse
Measure
- Policy
- IT
- Business Practice
- Standards
Analyse
- Qualitative
- Quantitative
8/2/2019 Mandy Mackay
12/19
Improve
Identify Actions
Use new extract version, including time for event start and
end
Identify Timing
New extract to start from 1 July
8/2/2019 Mandy Mackay
13/19
Implement
Business Solutions
Technical SolutionsHR,3091,CCH00001.ndm,00021,20110613,TEST,V014.0
HE,HAR1628,IP,201106010800,5811,9,A1,2225,F,19801231,61,,,N,R,P60,AA,DR,201106021000,,,,,,,,,,,N,,,19,3091,,N,,00000,,00000008729412,000000
00000001, ,,,,,
HD,HAR1628,IP,201106010800,5811,9,1,13,A,A,O80,"SINGLE SPONTANEOUS
DELIVERY",,
HD,HAR1628,IP,201106010800,5811,9,2,13,B,V,Z370,"SINGLE LIVE BIRTH",,
HD,HAR1628,IP,201106010800,5811,9,3,13,O,O,9046700,"SPONTANEOUSVERTEX DELIVERY",20110601,
8/2/2019 Mandy Mackay
14/19
Control
Monitoring
Errors and Reconciliations
Reporting
Start time for admitted Emergency
Department patients
8/2/2019 Mandy Mackay
15/19
Simple right??
What went wrong?
Interpretation Assumptions
Testing
8/2/2019 Mandy Mackay
16/19
The Issue
HE,HAR1628,IM,201007061545,5814,9,D1,2100,M,19730304,21,,,Y,R,
Y22,A,DR,201202161027,,,,,,,,,,,N,,,35,3091,,N,,00000,,0000002325538
6,00000000009955, ,,,,,
HE,HAR1628,IM,201007061545,5814,9,A1,2100,M,19730304,21,,,Y,R,
Y22,AA,DR,201202161027,,,,,,,,,,,N,,,35,3091,,N,,00000,,00000023255
386,00000000009955, ,,,,,
Error messages:
Unable to delete record key field not found
Event cannot overlap existing event An event already exists for these
dates
8/2/2019 Mandy Mackay
17/19
Keep Calm and Carry On
What did we do to resolve?
Worked out what the problem was
For all open mental health events we either sent
an event end date or the event start time.
When events prior to 1 July 2011 are submitted on this new version
of the file, the time portion of the datetime field must be populated
with 00:00 if the time has not been collected for those events
8/2/2019 Mandy Mackay
18/19
Learnings
The importance of Ministry forums
Ask a lot of questions
Be prepared for the unexpected it will happen
Importance of positive working relationships
No leave for DQ staff from 1st July for 6 weeks
C&C DHB has a fantastic Data Quality team
8/2/2019 Mandy Mackay
19/19
Questions??