Transcript Delivering independent intelligence for health and wellbeing

Delivering independent
intelligence
for health
and wellbeing
Delivering
independent
intelligence
for health
and wellbeing
National Drug Treatment Monitoring System
Data Quality and Completeness (2009/2010)
Michelle Cook
NDTMS Data Manager
North East Public Health Observatory
Delivering independent intelligence for health and wellbeing
•
•
•
•
•
NDTMS Supplementary Reports (Data Quality)
NDTMS Data Completion Reports
TOP Exceptions Reports
TOP Reporting Tool (available to DET users)
Questions
Delivering independent intelligence for health and wellbeing
NDTMS Supplementary Reports
When are where to find them?
• Published between 20-25th each month.
• NEPHO Website - http://www.northeastpho.org.uk/ndtms/dats/
levelreport
• DATs Emailed Summary
with details of this months
focus
• Agencies sent detailed
reports to identify clients
Delivering independent intelligence for health and wellbeing
NDTMS Supplementary Reports
Overall Summary
Report
• NDTMS Supplementary
Metrics – December
09_10.xls
• Provides information by DAT
on performance for each
Metric
Delivering independent intelligence for health and wellbeing
NDTMS Supplementary Metrics
•
•
•
•
•
•
Data Load %
Data Quality %
Late Deliveries
Episode dates out of
sequence
De-active Agencies with
Dates outside agency
de-active date
De-active agencies with
incomplete discharge
data
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
Male Clients Pregnant =
Yes
Clients in effective
treatment, with no
modality start
TOP Care Co-ordinations
Field Not Complete
(Active Episodes)
Discharge Code Useage
Parental Status Code
Useage
Duplicate client episodes
Missing Discharge Data
Duplicate Open Episodes
Overlapping Episodes
Duplicate Open
Modalities
Overlapping modalities
Poly drug use
Missing DAT
Missing Drug 1
Clients Under 1 &
Greater than 100
•
•
•
•
Missing PCT
Drinking days > 28
days
Drinking units null or
greater than 75 per
day
Route of
administration is not
oral
•
•
•
•
•
Parental Status Field
Blank
Children Field Blank
DATA COMPLETENESS
(Active Episodes)
DATA COMPLETENESS
(New Episodes)
Data Completeness Health Interventions
Delivering independent intelligence for health and wellbeing
Clients in Effective Treatment with No
Modality Start
• Identifies clients who only have a triage date and no treatment modality
start date.
• These are specifically the cases that have had a triage date entered, but
have no treatment modality start date and have not been discharged
within a reasonable period of time following triage.
If a client does not have a modality then they do not count towards your PDU
numbers
Delivering independent intelligence for health and wellbeing
Clients in Effective Treatment with No
Modality Start – Agency Numbers
Delivering independent intelligence for health and wellbeing
Clients in Effective Treatment with No
Modality Start
Delivering independent intelligence for health and wellbeing
New Supplementary Reports
Pregnant Males
Discharge Code Useage
Parental Status Useage
Completion of TOP Care-Coordinator
Completion of Parental Status/Children With Fields
Completion of Healthcare Interventions
Delivering independent intelligence for health and wellbeing
Pregnant Males
Additional Data Quality work carried out by the North East since October09
Criteria: All Episodes, All ages, Drugs and Alcohol
Delivering independent intelligence for health and wellbeing
Discharge Code Useage
New Discharge Codes were introduced for Adults & YP from 1st April
2009
Criteria: all Ages, Drugs and Alcohol
• Old Code used on New Episodes (eg discharged after 1st April 09)
• New Code used on Old Episodes (eg discharged before 1st April
09)
Delivering independent intelligence for health and wellbeing
Parental Status Useage
New fields were introduced from 1st April 09
Criteria: Active Episodes triaged after 1st April 09, all ages, Drugs and alcohol
Delivering independent intelligence for health and wellbeing
Data Completion
Delivering independent intelligence for health and wellbeing
Completion of TOP Care-Coordinator
New field which was introduced from 1st April 2009
Criteria: Active Episodes, 16 or over, Drugs only
Delivering independent intelligence for health and wellbeing
Completion of Parental
Status/Children With Fields
Additional Data Quality work carried out by the North East since December09
Criteria: Triaged after 1st November09, All ages, Drugs and Alcohol
Delivering independent intelligence for health and wellbeing
Drop Box – Attributable Data Only
• Attributable data is sent Encrypted Via the Drop Box
• Agencies are expected to fix all issues before the next upload
https://www.ndtms.org.uk/cgi-bin/dropbox.cgi?boxid=2009
Delivering independent intelligence for health and wellbeing
TOP Exception Reports
• ATTRIBUTOR REPORT - Breakdown of
treatment start TOP exceptions
• Includes all clients aged 18 and over at triage,
that started treatment between 1st
November - 21st November 2009
Treatment Start
More than one
TOP forms with
provider has
TOP date outside of
TOP care
claimed TOP careA modality has started for
guidance (+/- 2 coordination for
coordination
client. Is a TOP present?
weeks)
client
responsibility
YES
NO
YES
NO
NO
YES
YES
YES
NO
NO
YES
Delivering independent intelligence for health and wellbeing
TOP Reporting Tool (DET Users)
The following reports have been developed as a
useful function to help providers better
understand their TOP data, compliance and
plan for future improvements.









Missing Treatment Start TOP
Treatment Start TOP outside Protocol
Treatment Start TOP with Inconsistent Drug Values
Treatment Start TOP with Inconsistent Drug Values II
Treatment Start TOP with Inconsistent Injecting Status Data
Client missing review TOP
Discharge Clients with Missing Treatment Exit Top
Treatment Exit Top outside Protocol
TOP Treatment Progress Tracker
Delivering independent intelligence for health and wellbeing
HOW TO REVIEW AND GENERATE TOP
REPORTS
•
Click on “Report” from the “Client List” screen (above). This will take you to
the “TOP Reporting” screen as shown above
Delivering independent intelligence for health and wellbeing
TOP Reporting Screen
1.
Select the type of report required from the drop down
“Report” menu
Delivering independent intelligence for health and wellbeing
TOP Reporting Screen
2. Enter the “Modality Range” in the start and end date fields.
Delivering independent intelligence for health and wellbeing
TOP Reporting Screen
3. Select the preferred format (either PDF or Excel) in which the
report is to be generated from the drop down menu.
Delivering independent intelligence for health and wellbeing
TOP Reporting Screen
4. Next choose to either include or exclude episodes with TOP
flag set to ignore from the drop down menu.
Delivering independent intelligence for health and wellbeing
TOP Reporting Screen
5. You can review and/or generate the report by clicking on the “Review
Report” or “Generate Report” buttons as shown on the “Top Reporting”
screen.
Delivering independent intelligence for health and wellbeing
Generate Top Report
Delivering independent intelligence for health and wellbeing
Example of TOP Report (pdf)
Delivering independent intelligence for health and wellbeing
TOP Treatment Progress Tracker
Delivering independent intelligence for health and wellbeing
TOP Progress Tracker (Opiate Use)
Delivering independent intelligence for health and wellbeing
Time Scale Chart
Delivering independent intelligence for health and wellbeing
Guidance
http://www.nepho.org.uk/ndtms/treatmentout
comeprofile
Delivering independent intelligence for health and wellbeing
QUESTIONS?