Download
1 / 1
10 likes | 106 Vues
This project focuses on creating a computerized tool using Excel PivotTable for pharmacy managers at VA Puget Sound to efficiently manage daily outpatient prescription verification workload. By assessing, prioritizing, and distributing pending orders, this system ensures timely verification and compliance with VHA Handbook guidelines. The tool uses data from the Pending Outpatient Orders file to categorize and log orders, helping managers track and address potential bottlenecks. Since its implementation in 1996, the system has consistently met order verification targets, improving operational efficiency.
E N D
Screen shots VA Puget Sound: 490 beds, . 2 Divisions, 7 CBOCs, University-affiliated teaching/research hospital Average daily outpatient pending workload: 3,300 orders, 1,545,365 prescription fills in FY 10. Objective: To create a computerized tool that pharmacy managers can use to efficiently and effectively manage daily outpatient prescription verification workload. Using a Pivot Table to Help ManageDaily Outpatient Prescription Verification WorkloadDance Smith, PharmD, Frank Yunker, PharmD, MBAVA Puget Sound Health Care System • Methods: • Create Excel PivotTable • Obtain data from Pending Outpatient Orders file via FileMan sort/print template • Paste FileMan data into PivotTable • Update table • Review results • Number of pending orders > 2 days old • Identify type, location, and routing • Assess orders to prioritize verification • Distribute pending workload to point of care pharmacists • Right side of PivotTable used to log related metrics important to outpatient operations • Archive data for QA • Background: • VHA Handbook 1108.05 requires verification of routine mail prescriptions within 2 working days and reports to facility directors for backlogs > 7 days. • VistA Rx menu (PSO RX) provides the total number of unverified outpatient prescriptions. • The optional Order Summary breaks down the number of pending orders by institution (or clinic), number of patients, and route (Mail/Window/Administered in Clinic). • No Vista report breaks down pending orders by length of time in pending. • No Vista report provides the data necessary to assess the significance of a verification delay. • Results : • Successfully utilized since 1996 • Consistently meet order verification target times.
