Objective To introduce an innovative use of bar code medication administration (BCMA) data, medication pass analysis, that allows for examination of nurse staffing and workload using data generated during regular nursing workflow Methods Using one year (October 1, 2014 to September 30, 2015) of BCMA data for 11 acute-care units in one Veterans Affairs Medical Center, we determined the peak time for scheduled medications and included medications scheduled for and administered within two hours of that time in analyses. We established for each staff member their daily peak-time medication pass characteristics (number of patients, number of peak-time scheduled medications, duration, start-time), generated unit-level descriptive statistics, examined staffing trends, and estimated linear mixed-effects models of duration and start-time. Results As the most frequent (39.7%) scheduled medication time, 9:00 was the peak-time medication pass; 98.3% of patients (87.3% of patient-days) had a 9:00 medication. Use of nursing roles and number of patients per staff varied across units and over time. Number of patients, number of medications, and unit-level factors explained significant variability in registered nurse (RN) medication pass duration (conditional R2 = 0.237; marginal R2 = 0.199; Intraclass correlation = 0.05). On average, an RN and a licensed practical nurse (LPN) with four patients, each with six medications, would be expected to take 70 and 74 minutes, respectively, to complete the medication pass. On a unit with median 10 patients per LPN, the median duration (127 minutes) represents untimely medication administration on more than half of staff days. With each additional patient assigned to a nurse, average start time was earlier by 4.2 minutes for RNs and 1.4 minutes for LPNs. Conclusion Medication pass analysis of BCMA data can provide health systems a means for assessing variations in staffing, workload, and nursing practice using data generated during routine patient care activities.

Healthcare systems and nursing leaders aim to make evidence-based nurse staffing decisions. Understanding how nurses use and perceive available data to support safe staffing can strengthen learning healthcare systems and support evidence-based practice, particularly given emerging data availability and specific nursing challenges in data usability. However, current literature offers sparse insight into the nature of data use and challenges in the inpatient nurse staffing management context. We aimed to investigate how nurse leaders experience using data to guide their inpatient staffing management decisions in the Veterans Health Administration, the largest integrated healthcare system in the United States. We conducted semistructured interviews with 27 Veterans Health Administration nurse leaders across five management levels, using a constant comparative approach for analysis. Participants primarily reported using data for quality improvement, organizational learning, and organizational monitoring and support. Challenges included data fragmentation, unavailability and unsuitability to user need, lack of knowledge about available data, and untimely reporting. Our findings suggest that prioritizing end-user experience and needs is necessary to better govern evidence-based data tools for improving nursing care. Continuous nurse leader involvement in data governance is integral to ensuring high-quality data for end-user nurses to guide their decisions impacting patient care.