1
Toward dynamic assessment of supply-demand balance at the bedside: An exploration of data sources and methods
Dana Womack, PhD, RN Department of Medical Informatics Oregon Health & Science University
supply-demand balance at the bedside: An exploration of data sources - - PowerPoint PPT Presentation
1 Toward dynamic assessment of supply-demand balance at the bedside: An exploration of data sources and methods Dana Womack, PhD, RN Department of Medical Informatics Oregon Health & Science University 2 When Im really stretched
1
Dana Womack, PhD, RN Department of Medical Informatics Oregon Health & Science University
2
—Intensive care RN
3
3
3
4
4
Image: www.omnicell.com Image: www.vocera.com Image: www.wnyc.org/story/213967-pager Image: www.kronos.com
5
5
Adapted from Woods D, Branlat M. Basic patterns in how adaptive systems fail. In: Resilience Engineering in Practice: A Guidebook; 2011. p. 127-44.
Degraded system performance
Extra effort exerted to sustain target performance
Performance declines as adaptive capacity is exhausted
Escalating Control Escalating Disturbance
6
6
Image: https://loveandworktour.files.wordpress.com/2015/08/walking-against-the-wind.jpg
7
7
Image: https://loveandworktour.files.wordpress.com/2015/08/walking-against-the-wind.jpg
Adaptation
8
8
9
9
Nurse call Phone
Medications Time & attendance
CRISP-DM Data Mining Process Business understanding Data understanding Modeling Data preparation Evaluation
Focus groups Frontline RNs Data Gathering: Interview guide Analysis
three qualitative researchers
association
‒ Definition ‒ Generation ‒ Selection
by unplanned overtime
(proxy measure of strain)
10
10
Unit Beds RNs/shift
(mean)
Ratio
(day shift)
Distinct RNs, including floats Distinct patients Medical ICU 16 11 1:1-2 156 1,464 Medical- surgical 20 6 1:4 105 1,485 Per shift Per year
11
11
12
12
Empty nurses’ station
13
13
Degraded system performance
14
14
15
15
Patient
Lab Pharmacy Imaging Documentation Surgery Others Electronic health record Integrated
Team
Paging
Medication dispensing Phone
Time & attendance Nurse call Others Non-integrated 2 patient care units 366 shifts >400,000 records Ambient data
16
16
17
17
Exemplary data from a single medical-surgical work shift
Medication log files Phone transactions Shift ID Consistent staff IDs Disparate staff IDs
18
RN name
Duplicate records Lack of start/end time for regular staff RN name only – outdated, inconsistent format Dispensing role not indicated
Manual ID mapping
No patient-room link No RN-room link
19
19
Medication count Hour of day
Medical-surgical unit 366 day shifts
20
20
RN 1 RN 2 RN 3 RN 4 RN 5 RN 6
Received med help
Gave med help
Nurse
Medication count
Meds given to RN’s
pts
Managers do not have access to this info today due to lack of data integration Key:
21
21
22
22
Unplanned overtime >30 min. to <3 hours Overtime ≤ 30 min. excluded from definition
Count, RN instances Overtime duration in hours, MICU
Frequency of unplanned overtime by unit, FY 2016 Unit % Hours % Shifts MICU 1.16% 52% Med-surg 0.17% 8%
Overtime >3 hours: likely an extra shift
23
23
Cross-assignment meds (help) Aggregate minutes spent on phone
No overtime Unplanned overtime
Source: MICU Shifts: 366 day shifts
No overtime Unplanned overtime
24
24
Image: https://loveandworktour.files.wordpress.com/2015/08/walking-against-the-wind.jpg
Activity & workplace characteristics % IV push medications % patients assigned to same RN as yesterday Differences in activity across RNs, patients % Experienced, non-float RNs Adaptive Strategies Aggregate minutes on phone # cross-assignment med admin (helping)
25
25
26
26
Define features that reflect activity & adaptation Feature definition, generation Feature selection Machine learning classification Train & test a support vector machine (SVM) algorithm Identify features that differ by
X 4
0-12 Full shift 0-10 0-8 0-6 Hour 0-4
25% Test 92 shifts 75% data for training 274 MICU shifts
Repeat for multiple timeframes, to assess ability to predict outcome during a work shift
4-fold cross validation train & test Predict unplanned
Present Absent
27
27
MICU Shift hour 1 2 3 4 Accuracy
Kappa Sensitivity | Specificity
Hours 1-4 7am – 11 am 53.7% 54.2% 51.6% 50% 52 52.4% .4% .41 .41 – .62 .62 .05 .05 .46 .46 | | .59 .59 Hours 1 - 6 7am – 1 pm 61.1% 57.7% 59.7% 58.1 59 59.2% .2% .47 .47 – .68 .68 .16 .16 .57 .57 | | .60 .60 Hours 1 – 8 7am – 3 pm 60% 59.4% 58.9% 52.5% 57 57.7% .7% .46 .46 – .67 .67 .15 .15 .52 .52 |.63 |.63 Hours 1 – 10 7am – 5 pm 64.9% 59.1% 66.5% 54.6% 61 61.3% .3% .50 .50 – .71 .71 .22 .22 .58 .58 | | .65 .65 Hours 1 – 12 7am – 7pm 63.3% 70.3% 59.4% 61.1% 63.5% .5% .55 .55 – .74 .74 .30 .30 .58 .58 – .68 .68 Closed training: 72 72.3% .3% .68 .68 - .77 .77 .45 .45 .64 .64 | .77 .77
4-fold train-test Overall results (mean) Shift hours
28
28
29
29
‒ Environmental & behavioral
‒ Produced in real-time, provides granular observability of work
‒ Unplanned overtime predicted 8 – 10 hours into a shift (MICU)
30
30
31
31
delivery research
32
32
2.
3.
real-time data displays
33
33
National Library of Medicine Pre-doctoral trainee funding Training Grant T15-LM007088. Dissertation advisory committee
Helpful discussions & suggestions
Hospital Information providers
Hospital Leaders
Collaborative qualitative data analysis
And many others – thank you!
34
34
Contact info: womacda@ohsu.edu
35
35
36
36
Activity features Shift Hour % IV push medications 4, 6, 8, 10, 12 Sum, aggregate phone minutes 4, 6, 8, 10, 12 Sum, dispensed medications 4, 6, 8 Skewness, medications across RNs 4, 6, 8, 12
4, 6 Sum, nurse call minutes 8 Sum, cross-assignment meds 10, 12 Sum, within-assignment medications Sum, cross-assignment medications % non-float RNs with 2+ yrs. experience % Pts. assigned to same RN in past week % pts present on unit yesterday % analgesic medications 12