Use of an Administrative Data Set to Determine Optimal Scheduling of an Alcohol Intervention Worker

Abstract

BackgroundBrief alcohol interventions are efficacious in reducing alcohol-related consequences among emergency department (ED) patients. Use of non-clinical staff may increase alcohol screening and intervention; however, optimal scheduling of an alcohol intervention worker (AIW) is unknown. ObjectivesDetermine optimal scheduling of an AIW based on peak discharge time of alcohol-related ED visits. MethodsDischarge times for consecutive patients with an alcohol-related diagnosis were abstracted from an urban ED’s administrative data set from September 2005 through August 2007. Queuing theory was used to identify optimal scheduling. Data for weekends and weekdays were analyzed separately. Stationary independent period-by-period analysis was performed for hourly periods. An M/M/s queuing model, for Markovian inter-arrival time/Markovian service time/and potentially more than one server, was developed for each hour assuming: 1) a single unlimited queue; 2) 75% of patients waited no longer than 30min for intervention; 3) AIW spent an average 20min/patient. Estimated average utilization/hour was calculated; if utilization/hour exceeded 25%, AIW staff was considered necessary. ResultsThere were 2282 patient visits (mean age 38 years, range 11–84 years). Weekdays accounted for 45% of visits; weekends 55%. On weekdays, one AIW from 6:00 a.m.–9:00 a.m. (max utilization 42%/hour) would accommodate 28% of weekday alcohol-related patients. On weekends, 5:00 a.m.–11:00 a.m. (max utilization 50%), one AIW would cover 54% of all weekend alcohol-related visits. During other hours the utilization rate falls below 25%/hour. ConclusionsEvaluating 2 years of discharge data revealed that 30h of dedicated AIW time—18 weekend hours (5:00 a.m.–11:00 a.m.), 12 weekday hours (6:00 a.m.–9:00 a.m.)—would allow maximal patient alcohol screening and intervention with minimal additional burden to clinical staff.