260 likes | 269 Views
Data to Drive Improvement Workshop: Outpatient DCAQ. 11 September 2015 Charmaine Blaize. Outpatient DCAQ Dashboard. Shows last two years (24 months) trends of Referrals; Activity ; Waiting list changes . Most frequent data updates are hourly. Technology and Datasets used.
E N D
Data to Drive Improvement Workshop: Outpatient DCAQ 11 September 2015 Charmaine Blaize
Outpatient DCAQ Dashboard Shows last two years (24 months) trends of Referrals; Activity ; Waiting list changes. Most frequent data updates are hourly Data to Drive Improvement: NHSFV OP DCAQ Demo
Technology and Datasets used Microstrategy (BI tool) SQL to extract datasets TOPAS (Patient Administration System) Data to Drive Improvement: NHSFV OP DCAQ Demo
The Story Two main improvement initiatives (Outpatients Improvement & Clinic Utilisation improvement project) required data Easily accessible format Visible to their managers as well Creation of OP DCAQ to replace mix of adhoc and weekly spreadsheets Data to Drive Improvement: NHSFV OP DCAQ Demo
Referrals Requested Specialty - when a referral is received and it is vetted. Allocated Specialty - number of referrals per specialty after they have been vetted. Request Source - where referrals came from (e.g. GP, Ambulance etc) Data to Drive Improvement: NHSFV OP DCAQ Demo
Referrals: Requested Specialty Data to Drive Improvement: NHSFV OP DCAQ Demo
Referrals: Request Source Data to Drive Improvement: NHSFV OP DCAQ Demo
Referrals: Allocated Specialty Data to Drive Improvement: NHSFV OP DCAQ Demo
Decision Outcomes 24 month breakdown of all vetted referrals and the decision of all vetted referrals. By month and individual specialties. Data to Drive Improvement: NHSFV OP DCAQ Demo
Decision Outcomes: By Specialty Data to Drive Improvement: NHSFV OP DCAQ Demo
Current Waiting List Patient availability by Specialty and Subspecialty where applicable. Data to Drive Improvement: NHSFV OP DCAQ Demo
Current Waiting List: Specialty Data to Drive Improvement: NHSFV OP DCAQ Demo
Current Waiting List: Sub Specialty Data to Drive Improvement: NHSFV OP DCAQ Demo
Waiting List Dynamics 24 months Waiting List Activity includes: Patient Type Waiting list (WL) size Attendances Additions Removals Unavailable Data to Drive Improvement: NHSFV OP DCAQ Demo
Waiting List Dynamics: Specialty Data to Drive Improvement: NHSFV OP DCAQ Demo
Waiting List Dynamics: Sub Specialty Data to Drive Improvement: NHSFV OP DCAQ Demo
Clinic Outcomes: Overall activity of patients seen and the outcomes. E.g. Attendances, DNAs, CNWs, Patient Moved/Cancelled, Hospital Moved/Cancelled Data to Drive Improvement: NHSFV OP DCAQ Demo
Clinic Outcomes: Specialty Data to Drive Improvement: NHSFV OP DCAQ Demo
Clinic Outcomes: DNA>=2 Data to Drive Improvement: NHSFV OP DCAQ Demo
Cancelled Clinics The number of clinics cancelled per specialty and breakdown by cancellation reasons. Data to Drive Improvement: NHSFV OP DCAQ Demo
Clinic Utilisation Used for forecasting and scheduling activity for clinic availability. It can be : Historic or Future/Predicted Data to Drive Improvement: NHSFV OP DCAQ Demo
Clinic Utilisation: Specialty Data to Drive Improvement: NHSFV OP DCAQ Demo
Performance 24 month review of the number of completed waits within target and out of target. Data to Drive Improvement: NHSFV OP DCAQ Demo
Performance: Specialty Data to Drive Improvement: NHSFV OP DCAQ Demo
Performance: Sub Specialty Data to Drive Improvement: NHSFV OP DCAQ Demo
End of DemoQuestions? Contacts: Paul Woolman p.woolman@nhs.net Tracey Newman tracey.newman@nhs.net