Management Reports Output Reports Menu Outpatient Pharmacy main

Management Reports

Output Reports Menu • Outpatient Pharmacy main menu: Output Reports Action Profile (132 COLUMN PRINTOUT) Alpha Drug List and Synonyms AMIS Report CMOP Controlled Substance Rx Dispense Report Commonly Dispensed Drugs Cost Analysis Reports. . . Daily AMIS Report Drug List By Synonym Free Text Dosage Report Inactive Drug List Prescriptions on Hold Management Reports Menu. . . Medication Profile Monthly Drug Cost Narcotic Prescription List Non-Formulary List Non-VA Meds Usage Report Poly Pharmacy Report Released and Unreleased Prescription Report

Action Profile (80 or 132 COLUMN PRINTOUT, Action or Information) • Lists medications due for renewal or refill • Some sites use this in their paper charting for providers to order meds (by printing “Action” version which has check boxes and blanks for initials) • Is obsolete in EHR sites Select Output Reports Option: ACTION Profile (132 COLUMN PRINTOUT) Action or Informational (A or I): A// Informational By Patient, Clinic or Clinic Group (P/C/G): P// atient Do you want this Profile to print in 80 column or 132 column: 132// Select PATIENT NAME: DEMO, CAROL <A> F 02 -22 -1991 XXX-XX-4789 Select PATIENT NAME: Profile Expiration/Discontinued Cutoff: (0 -9999): 120// DEVICE: 0; 132; 999 VT Press Return to Continue or "^" to Exit: CI 140557

Informational Rx Profile Run Date: MAY 19, 2010 Page: 1 Sorted by drug classification for Rx's currently active and for those Rx's that have been inactive less than 120 days. Site: DEMO HOSPITAL ----------------------------------------Name : DEMO, CAROL ID#: 140557 DOB : FEB 22, 1991 Address : 6110 RAPE RD MIMS, FLORIDA 32754 Phone : 555 -3312 WEIGHT(Kg): 115. 91 (03/21/2007) HEIGHT(cm): 154. 94 (03/21/2007) DISABILITIES: ALLERGIES: DEMEROL 100 MG/ML CARTRIDGE, LISINOPRIL, MORPHINE SULFATE, ADVERSE REACTIONS: ----------------------------------------Medication/Supply Rx# Status Classification: AM 111 - PENICILLINS, AMINO DERIVATIVES AMOX/CLAV 250/125 MG TAB (30'S) PREPACK Qty: 30 for 10 Days 1337608 Expired Sig: TAKE 1 TABLET BY MOUTH THREE TIMES A DAY FOR 10 DAYS FOR INFECTION TREATMENT; TAKE UNTIL FINISHED Filled: 03 -02 -2010 Remaining Refills: 0 Clinic: UNKNOWN Price: $0. 00 Classification: HS 502 - ORAL HYPOGLYCEMIC AGENTS, ORAL GLYBURIDE= 5 MG TABLETS Qty: 30 for 30 Days 1337609 Active Sig: TAKE ONE (1) TABLET BY MOUTH DAILY FOR BLOOD SUGAR CONTROL Filled: 03 -02 -2010 Remaining Refills: 11 Clinic: PHARMACY Price: $0. 54 *** NO RESULTS FOR POC A 1 C SINCE 05 -19 -09 METFORMIN= 500 MG *PLAIN* TABS Qty: 60 for 30 Days 1337610 Active Sig: TAKE ONE (1) TABLET BY MOUTH TWICE A DAY TAKE WITH FOOD FOR DIABETES TREATMENT Filled: 03 -02 -2010 Remaining Refills: 11 Clinic: PHARMACY Price: $0. 00 ----------------PENDING ORDERS----------------No pending orders for this patient! Expiration Date Provider 04 -01 -2010 USER, ASTUDENT 03 -03 -2011 NIESEN, MARY ANN

Alpha Drug List and Synonyms • Prints a list from the drug file with the synonyms • Might be useful for file troubleshooting or for training new pharmacists ALPHABETIC DRUG LIST AND SYNONYMS MAY 19, 2010 23: 21 PAGE 1 DEA, PRICE PER SPECIAL DISPENSE GENERIC NAME HDLG N/F UNIT Synonym ----------------------------------------00409198530 ACETAMINOPHEN 120 MG SUPP Apap Tylenol 059439011612 ACETAMINOPHEN 160 MG/5 ML SOLN Tylenol Apap 000904198520 ACETAMINOPHEN 325 MG TAB Apap Tylenol 051079000220 4 0. 1180 9 0. 0061 9 P 0. 0390

AMIS Report • Tallies prescription counts • Tracks new/refill, controlled rx, outpatient/inpatient, mail/window • Statistics compiled nightly and added to a file • When running monthly/quarterly reports, recompile the data prior to running report using the option – Outpatient Pharmacy Manager: MAIN: Recompile AMIS Data

Sample AMIS Report A M I S R E P O R T FROM 04 -19 -10 TO 04 -20 -10 DIVISION: HARD LABOR DATE INPAT SC A&A OTHER NVA CNTLD METHA PAT REQ FEE STAFF NEW REFILL WINDOW MAIL -------------------------------------------------------------04 -19 -10 0 0 24 0 184 0 647 354 293 623 24 04 -20 -10 0 0 143 0 519 300 219 503 16 ------- ------- ------- -------SUB-TOTALS 0 0 0 38 0 327 0 1166 654 512 1126 40 Interpretation: – New + Refill = Total RX – Window + Mail = Total RX – Fee + Staff = Total RX

Commonly Dispensed Drugs • Counts medication fills by drug and quantity over a period of time • Useful for inventory management Select Output Reports Option: Commonly Dispensed Drugs STARTING DATE: -90 (FEB 18, 2010) ENDING DATE: T (MAY 19, 2010) DO NOT PRINT DRUG IF COUNT IS LESS THAN : (1 -100): 20// 1 DEVICE: HOME// 0; 80; 999 MOST COMMONLY DISPENSED DRUGS FROM 02 -18 -10 THRU 05 -19 -10 MINIMUM DRUG COUNT OF 1 Pg: 1 ENTRY NUMBER DRUG QUANTITY FILLS ---------------------------------------Division: DEMO HOSPITAL 348 CARBAMAZEPINE 200 MG *PLAIN* TAB 60 2 263 ACETAMINOPHEN 325 MG TAB 50 1 85832 AMOX/CLAV 250/125 MG TAB (30'S) PREPACK 30 1 83611 AMOXICILLIN 250 MG/5 ML SUSP (150 ML) 150 1 84490 AMOXICILLIN= 250 MG CAP 30 1 1342 FOLIC ACID= 1 MG TAB 30 1 83870 GLYBURIDE= 5 MG TABLETS 30 1 84852 METFORMIN= 500 MG *PLAIN* TABS 60 1

Cost Analysis Reports. . . • Options print cost reports and statistics • Useful formulary, inventory and workload management • Accurate reports depend on having correct acquisition costs in drug file Select Output Reports Option: COST Analysis Reports Clinic Costs Division Costs by Drug Costs by Division by Provider Drug Costs by Provider High Cost Rx Report Patient Status Costs Pharmacy Cost Statistics Menu. . . Provider by Drug Costs Provider Costs Request Statistics

Sample reports Drug Costs by Clinic for the period: APR 2010 to MAY 20, 2010 Run Date: MAY 19, 2010 Page: 1 Orign Total Avg Cost Clinic Fills Refil Fills Cost per Fill ----------------------------------------A CLINIC 1 0 1 3. 00 ---------------Total 1 0 1 3. 00 Drug Costs by Division by Drug for the period: APR 2010 to MAY 20, 2010 Run Date: MAY 19, 2010 Page: 1 Orgin Total Avg Cost Drug Fills Refills Fills Qty Cost per Fill ---------------------------------------------------------Division: DEMO HOSPITAL ACETAMINOPHEN 325 MG TAB 1 0 1 50. 00 1. 95 CARBAMAZEPINE 200 MG *PLAIN* TAB 1 0 1 60. 00 3. 00 ---------------------Total for DEMO HOSPITAL 2 0 2 110. 00 4. 95 2. 48 --------------------- Total for all divisions ------2 0 -----2 -------110. 00 -----4. 95 -----2. 48

Drug Costs by Drug for the period: APR 2010 to MAY 20, 2010 Run Date: MAY 19, 2010 Page: 1 Orign Total Avg Cost Drug Fills Refil Fills Cost per Fill ----------------------------------------ACETAMINOPHEN 325 MG TAB 1 0 1 1. 95 CARBAMAZEPINE 200 MG *PLAIN* TAB 1 0 1 3. 00 -----------Total 2 0 2 4. 95 2. 48 Drug Costs by Division for the period: APR 2010 to MAY 20, 2010 Run Date: MAY 19, 2010 Page: 1 Orign Total Avg Cost Division Fills Refil Fills Cost per Fill ----------------------------------------DEMO HOSPITAL 2 0 2 4. 95 2. 48 ---------------Total 2 0 2 4. 95 2. 48 ---------------Drug Costs by Division by Provider for the period: APR 2010 to MAY 20, 2010 Run Date: MAY 19, 2010 Page: 1 Orign Total Avg Cost Division by Provider Fills Refil Fills Cost per Fill ----------------------------------------Division: DEMO HOSPITAL NIESEN, MARY ANN 1 0 1 1. 95 USER, ASTUDENT 1 0 1 3. 00 ---------------Total for DEMO HOSPITAL 2 0 2 4. 95 2. 48 -----------------Total 2 0 2 4. 95 2. 48

Drug Costs by Drug by Provider for the period: APR 2010 to MAY 20, 2010 Run Date: MAY 19, 2010 Page: 1 Orign Total Avg Cost Drug by Provider Fills Refil Fills Cost per Fill ----------------------------------------DRUG: ACETAMINOPHEN 325 MG TAB NIESEN, MARY ANN 1 0 1 1. 95 ---------------Total for ACETAMINOPHEN 325 MG TAB 1 0 1 1. 95 ---------------DRUG: CARBAMAZEPINE 200 MG *PLAIN* TAB USER, ASTUDENT 1 0 1 3. 00 ---------------Total for CARBAMAZEPINE 200 MG *PL 1 0 1 3. 00 -----------------Total 2 0 2 4. 95 2. 48 High Cost Drug Report: Fills That Cost at Least $. 5 for the Period: APR 20, 2010 to MAY 20, 2010 Page 1 Run Date: MAY 19, 2010 Rx # Drug QTY Un. Cost Total Cost ----------------------------------------1337616 CARBAMAZEPINE 200 MG *PLAIN* TAB 60 0. 050 3. 00 ----------------------------------------No. of Fills = 1 Total Cost = 3. 00 ----------------------------------------(* indicates a refill, % indicates a partial)

Drug Costs by Patient Status for the period: APR 2010 to MAY 20, 2010 Run Date: MAY 20, 2010 Page: 1 Orign Total Avg Cost Patient Status Fills Refil Fills Cost per Fill ----------------------------------------OUTPATIENT 2 0 2 4. 95 2. 48 ---------------Total 2 0 2 4. 95 2. 48 Pharmacy Cost Statistics Menu Option: PHARMACY Statistics START WITH FILLED DATE: FIRST// -30 (APR 20, 2010) GO TO FILLED DATE: LAST// DEVICE: VT Right Margin: 80// PHARMACY STATISTICS MAY 20, 2010 00: 39 PAGE 1 AVE FILLED FILLS MAIL WINDOW REQUESTS TOTAL COST/FILL ----------------------------------------MAY TOTAL 7, 2010 1 0 ------1 0 1 ------1 3. 0000 3. 00 ------3. 0000 3. 00 Drug Costs by Provider by Drug for the period: APR 2010 to MAY 20, 2010 Run Date: MAY 20, 2010 Page: 1 Orign Total Avg Cost Provider by Drug Fills Refil Fills Cost per Fill ----------------------------------------Provider: NIESEN, MARY ANN ACETAMINOPHEN 325 MG TAB 1 0 1 1. 95 -----------Total for NIESEN, MARY ANN 1 0 1 1. 95 -----------

Drug Costs by Provider for the period: APR 2010 to MAY 20, 2010 Run Date: MAY 20, 2010 Page: 1 Orign Total Avg Cost Provider Fills Refil Fills Cost per Fill ----------------------------------------NIESEN, MARY ANN 1 0 1 1. 95 USER, ASTUDENT 1 0 1 3. 00 ---------------Total 2 0 2 4. 95 2. 48 REQUEST STATISTICS MAY 20, 2010 00: 44 PAGE 1 AVE FILLED DATE REQUESTS COST/REQUEST FILLS/REQUEST ----------------------------------------MAY TOTAL 7, 2010 1 ------1 3. 00 -----3. 00 1. 00 -----1. 00

Daily AMIS Report • Lists RX totals for day specified. Also lists cumulative totals: monthly and quarterly Daily/Monthly/Quarterly AMIS report for MAY 2010 Division: SOME INDIAN HOSPITAL Page: 1 05 -19 -10 Monthly Totals Quarterly Totals -----------------------------------------------INPAT SC A&A OTHER NVA CNTLD METHA PAT REQ FEE STAFF NEW REFILL WINDOW MAIL Sub Totals 0 0 0 0 43 0 0 86 0 2312 0 6358 3597 2761 5509 849 86 0 0 212 0 6341 0 17423 10221 7202 15151 2272 ===== 0 ===== 21515 ===== 58908

Drug List By Synonym • Prints drug file by listing synonym and associated drug • Might help someone learn synonyms • Could be helpful in cleaning up drug file DRUG LIST BY SYNONYM MAY 20, 2010 00: 51 PAGE 1 SYNONYM GENERIC NAME N/F ------------------------------------00000101 000003362412 N/F 000006408400 INJECTION 000006778203 000006778433 INJECTION 000008092355 000011834109 000023050650 DROPS N/F DIPHEN/MAALOX/LIDO 1: 1: 1 ATAZANAVIR 150 MG CAPSULE ANTIVENIN, SPIDER BITE PHYTONADIONE 10 MG/ML INJECTION PHYTONADIONE 1 MG/0. 5 ML PANTOPRAZOLE 40 MG INJECTION DIMERCAPROL 100 MG/ML INJECTION POLYVINYL ALCOHOL/POVIDONE

Free Text Dosage Report • Provides a list of drugs for those prescriptions where the dosage field has a free text entry • Also identifies providers prescribing those drugs • Might be helpful in identifying medications where dosages might need to be created Free Text Dosage Entry Report for the Period: MAY 13, 2010 to MAY 20, 2010 Drug Free Text Entry Provider: Count ------------------------------------ACCU-CHEK COMFORT CURVE STRIP USER, ASTUDENT: 1 (85978) ACETAMINOPHEN 325 MG TABLET 100 (85041) USER, ASTUDENT: 1 Count 1 strip 1 1 TABLET 1 1 to 2 tablets 1 1 -2 TABLET(S) 2 MILLER, JOHN MD: 1 USER, ASTUDENT: 1 NIESEN, MARY ANN: 1

Inactive Drug List • Lists inactive entries in the drug file • Also lists dates they were inactivated and synonyms INACTIVE DRUG LIST NUMBER MAY 20, 2010 INACTIVE DATE 01: 06 PAGE 1 GENERIC NAME Synonym --------------------------------------85578 84291 85895 85722 85506 00677 -1647 -10 2, 3, DIDEOXYINOSINE, POWER, PAC Videx Ddi 000087661443 50/50 INSULIN INJ ABCIXIMAB IV 2 MG/ML Reopro ACARBOSE 000026286251 OCT 22, 2003 SEP 7, 1999 AUG 3, 2005 OCT 20, 2003

List Prescriptions on Hold • Allows sorting by date, division and hold reason • Useful to determine common causes for RX going on hold and developing strategy to minimize instances PRESCRIPTIONS ON HOLD MAY 20, 2010 01: 11 PAGE 1 RX # PATIENT DRUG ISSUE DATE --------------------------------------DIVISION: DEMO HOSPITAL HOLD REASON: REFILL TOO SOON HOLD DATE: AUG 17, 2009 1337603 CLAUSON, DAPHE DAWNE CARVEDILOL CR 20 MG CAP AUG 17, 2009 PROVIDER: USER, LSTUDENT LAST FILL: ACTIVITY LOG AUG 17, 2009 14: 38 RX placed in a HOLD status (08 -17 -09) HOLD COMMENTS:

Management Reports Menu. . . • Menu for management reports • Used for periodic, monthly, quarterly, and annual reports • Cover a variety of pharmacy functions • Daily and monthly reports have same report options Daily Management Report Menu. . . Date Range Recompile Data Initialize Daily Compile (Starts up a Taskman task) Monthly Management Report Menu. . . One Day Recompile Data Purge Data (purges old data from compiled file)

(Daily/Monthly)Management Report Menu All Reports Cost of Prescriptions Count of Prescriptions Intravenous Admixture Type of Prescriptions Filled (132 columns) Sample report: Type of Prescriptions Filled O U T P A T I E N T P H A R M A C Y TYPE OF PRESCRIPTIONS FILLED FROM 04/10 TO 04/10 M A N A G E M E N T R E P O R T PAGE 1 DIVISION: ANOTHER INDIAN HOSPITAL FEE TOT WD PARTIC % OF FEE DATE FEE STAFF & STAFF NEW REFILLS WD MAIL & MAIL PHARM FL BY VA INVEST ---------------------------------------------------------04/10 0 11342 6817 4525 11342 9897 0 0 ===== ====== ===== DIV TOTAL 0 11342 6817 4525 11342 9897 0 0. 0 FEE+STAFF=NEW+REFILL=TOTAL FILLS WD=WINDOW

Medication Profile • • • Lists medications dispensed over a specified date range Can be sorted by drug, or for a specific drug Allows for short or long display of meds and instructions Can be printed for multiple patients Useful for tracking dose changes over time Superceded by some EHR reports Select Output Reports Option: MEDication Profile Select PATIENT NAME: DEMO, CAROL <A> F 02 -22 -1991 XXX-XX-4789 LONG or SHORT: SHORT// Sort by DATE, CLASS or MEDICATION: DATE// All Medications or Selection (A/S): All// DEVICE: HOME// VT Right Margin: 80// CI 140557

DEMO, CAROL 6110 RAPE RD MIMS FLORIDA 32754 CANNOT USE SAFETY CAPS. WEIGHT(Kg): 115. 91 (03/21/2007) DISABILITIES: ID#: 140557 DOB: FEB 22, 1991 PHONE: 555 -3312 ELIG: HEIGHT(cm): 154. 94 (03/21/2007) ALLERGIES: DEMEROL 100 MG/ML CARTRIDGE, LISINOPRIL, MORPHINE SULFATE, ADVERSE REACTIONS: Medication Profile Sorted by ISSUE DATE REF Rx# Drug ST REM Issued Last Fill ---------------------------------------1337608 AMOX/CLAV 250/125 MG TAB (30'S) PREPACK E 0 03 -02 -10 QTY: 30 SIG: TAKE 1 TABLET BY MOUTH THREE TIMES A DAY FOR 10 DAYS FOR INFECTION TREATMENT; TAKE UNTIL FINISHED 1337609 GLYBURIDE= 5 MG TABLETS A 11 03 -02 -10 QTY: 30 SIG: TAKE ONE (1) TABLET BY MOUTH DAILY FOR BLOOD SUGAR CONTROL 1337610 METFORMIN= 500 MG *PLAIN* TABS A 11 03 -02 -10 QTY: 60 SIG: TAKE ONE (1) TABLET BY MOUTH TWICE A DAY TAKE WITH FOOD FOR DIABETES TREATMENT 1337613 FOLIC ACID= 1 MG TAB A 11 03 -02 -10 QTY: 30 SIG: TAKE ONE (1) TABLET BY MOUTH DAILY 1337483 AMOXICILLIN= 500 MG CAP E 0 05 -07 -08 QTY: 30 SIG: TAKE ONE (1) CAPSULE BY MOUTH THREE TIMES A DAY FOR 10 DAYS FOR INFECTION TREATMENT; TAKE UNTIL FINISHED

Monthly Drug Cost • Lists drugs in alphabetical order and lists monthly costs associated with each drug • Can be limited to certain drugs or by a minimum number of fills • Totals based on acquisition costs MONTHLY DRUG COST REPORT FOR APR 2010 PAGE: 42 MINIMUM REFILLS OF 0 AT A MINIMUM COST OF $0 DIVISION TOTAL DRUG FILLED QUANITY COST N/F ------------------------------------------------------------TIMOLOL MALEATE 0. 5% OPHTHALMIC SOLUTION 1 5. 48 *** N/F *** TIZANIDINE 2 MG TABLET 2 60 2. 28 *** N/F *** TOBRAMYCIN 0. 3% OPHTH OINTMENT 3. 5 GM 3 10. 5 113. 5155 TOBRAMYCIN 0. 3% OPHTH SOLUTION 15 ML 4 20 3. 04 TOLTERODINE 2 MG TABLET 2 120 153. 48 TOPIRAMATE 25 MG TABLET 1 360 433. 08 *** N/F *** TRAMADOL 50 MG TABLET 7 530 10. 84 TRAVOPROST 0. 004% OPHTHALMIC SOLN. 5 ML 23 120 349. 2 TRAZODONE 100 MG TABLET 8 330 23. 73 TRAZODONE 50 MG TABLET 28 1094 49. 23 ZOLPIDEM 10 MG TABLET ZOLPIDEM 5 MG TABLET SUB-TOTALS 4 -----11001 1 30 130 -----794378. 79 122. 43 3. 38 -----265486. 214767 GRAND TOTALS ===== 11001 ===== 794378. 79 ===== 265486. 214767

Narcotic Prescription List • Lists narcotic RX dispensed over specified date range. • 132 columns • Drug selection controlled via DEA field in drug file NARCOTIC PRESCRIPTIONS RX # DRUG MAY 20, 2010 00: 58 QTY PROVIDER PAGE 1 FILL DATE PATIENT ID# ---------------------------------------------50021237 APAP 300 MG & CODEINE 30 MG TABL 20 PAYNE, I. M. A. MAY 19, 2009 FROST, JACQUELINE J 526132250 1654957 APAP 300 MG & CODEINE 30 MG TABL 20 ACHE, TOOTH MAY 19, 2009 FLAKE, SNOW LYNN 526956326

Non-Formulary List • Lists from the drug file: drugs marked non-formulary • Good resource for training new staff and for reminding old staff of what’s not on the formulary NON-FORMULARY DRUG LIST NUMBER MAY 20, 2010 PRICE PER DISPENSE UNIT DEA, SPECIAL HDLG 02: 00 PAGE 1 GENERIC NAME Synonym ----------------------------------------403 ACEBUTOLOL 200 MG CAP 6 0. 3350 Sectral 335 ACEBUTOLOL 400 MG CAP 6 0. 3330 Sectral 418 ACYCLOVIR 800 MG TAB 6 P 0. 1110 Zov 8 000172426870 Zovirax 84262 ACYCLOVIR ORAL SUSP. 200 MG/5 ML 6 P 0. 2120 Zovirax 000472008216 84466 ADALIMUMAB 335. 1800 Humira

Non-VA Meds Usage Report • Displays medications entered through Outside Meds functionality in EHR • Drug selection for this report controlled by having “X” in the application packages field in drug file • Sortable by any combination of: – Patient Name – Orderable Item – Date Documented – Status – Order Checks

Non-VA Meds Usage Report Page: 1 Sorted by PATIENT NAME Date Range: 03/18/2011 - 06/16/2011 Run Date: Jun 16, 2011@10: 25: 01 ------------------------------------------------------DEMO, PATIENT (ID: 1958) Patient Phone #: 555 -7402 Non-VA Med: LISINOPRIL Dispense Drug: LISINOPRIL 10 MG TABLET Dosage: 10 MG Schedule: EVERY DAY Med Route: BY MOUTH Status: ACTIVE CPRS Order #: 821569 Documented By: DEMO, USER Documented Date: 05/01/2011 Clinic: 01 GENERAL CLINIC Start Date: 10/01/2008 ===============================

Poly Pharmacy Report • Lists patients whose total # of active medications exceeds a threshold number • Default is 7 but can be set by a parameter to any number • This report is useful to identify patients with high risk of medication misadventure caused by multiple potential drug interactions • Poly pharmacy patients also have more difficulty managing their medications due to the sheer number of pills they have to organize and take every day • 132 columns

Poly Pharmacy Report 11 -21 -2009 to 05 -20 -2010 for 180 Days for 7 or More Active Prescriptions and/or Outsided Meds Page 647 Patient ID# Active Rx's Class Drug Status Last Filled Provider Rx Number ---------------------------------------------------------PATIENT, DEMO MARIAN (8876) 12 CN 103 ACETAMINOPHEN 500 MG A APR 15, 2010 PROVIDER, TEST DO 982303 ASPIRIN 81 MG E. C. TAB A APR 15, 2010 PROVIDER, TEST DO 982305 CN 609 FLUOXETINE 20 MG CAP A APR 15, 2010 PROVIDER, TEST DO 982307 CV 100 METOPROLOL 50 MG TAB A APR 15, 2010 PROVIDER, TEST DO 982310 CV 200 AMLODIPINE 10 MG A APR 15, 2010 PROVIDER, TEST DO 982304 CV 702 FUROSEMIDE 40 MG TAB A APR 15, 2010 PROVIDER, TEST DO 982308 CV 800 LISINOPRIL 10 MG TAB A APR 15, 2010 PROVIDER, TEST DO 982309 GA 900 OMEPRAZOLE 20 MG CAP A APR 15, 2010 PROVIDER, TEST DO 982311 OP 105 DORZOLAMIDE 2%-TIMOLOL 0. 5% A APR 15, 2010 PROVIDER, TEST MD 923864 A OP 219 POLYMYXIN/TRIMETHOPRIM OPH SOLN A FEB 22, 2010 PROVIDER, TEST PA 975485 TN 410 FERROUS SULFATE 325 MG TAB A APR 15, 2010 PROVIDER, TEST DO 982306 TN 430 POTASSIUM CHLORIDE 10 m. EQ TAB A APR 15, 2010 PROVIDER, TEST DO 982312 --------------------------------------------------------Total Number of Patients: 736 Total Number of Rxs: 7660 Average Rxs per Patient: 10

Released and Unreleased Prescription Report • Lists RX filled by a date range • Shows whether or not RX were released Release/Unreleased Report for IHS HOSPITAL MAY 13, 2010 to MAY 20, 2010 Page: 1 Fill/ Date Rx # Refill Released Status Copay ----------------------------------------1567788 A 1611710 1597791 A 1505999 E 1613309 A 1622750 1623751 1623753 1624926 1624929 1624935 1625617 Refill Refill Refill #2 #4 #5 #7 #7 #1 #5 #5 #3 #6 #7 #3 MAY MAY MAY 13, 2010 13, 2010 13, 2010 Yes Yes Yes No Yes Yes Yes Active Active Active

Reports on IHS Specific Options Menu • Developed for IHS by IHS, reports and options AAC APS AWP CDUR CMP CSM DPL DRRR DSLL DUER ERR FPN IHS INLI LMRS LPAT MDF MEDI OUT PREP PSL RPT RR RTS SUM TDDR VBP IMPORT ENTRIES FROM AAC FILE (Imports acquisition costs) AWP/PMI UPDATE STATUS AWP Manual Update (Runs the AWP update routine) Controlled Drug Use Report Chronic Medication Profile Controlled Substance Management Report Daily Prescription Log Drug Recall Report Drug Storage Location List Drug Utilization Evaluation Report PRINT ERRORS FROM IMPORT OF AAC FIND PROBLEM NDC'S IN DRUG FILE IHS Pharmacy Site Parameters (Sets IHS pharmacy parameters) Inventory List Label/Pro Monitor Reprint (Slave Printers Only!) Pharmacy Last Patch Lister Multiple Drug File Menu. . . Print Patient Instruction Sheet Outside Rx Menu. . . Pharmacy Prepack Main Menu. . . PRINT SIGNATURE LABEL (Print/Reprint summary label) Pharmacy Package Maintenance Reports. . . Process Refill Requests (Starts Refill option) Return To Stock Report Summary label Print (prints summary labels) Total Drugs Dispensed Report Verify by Patient

AWP/PMI UPDATE STATUS • Used to determine date of last update of AWP pricing and PMI sheets • PDED is not accurate because this is obsolete and PMI sheets now delivered with NDF patches AVERAGE WHOLESALE PRICE (AWP) >>> UPDATE STATUS <<< Last AWP monthly update occurred on. . . . APR 5, 2011 (last AWP patch) Most recent 'manual' AWP update was ran on. . . MAY 11, 2011@22: 15: 03 Total number of DRUGS updated with AWP. . . . 1235 >>> ACTIVE DRUGS STATUS <<< The Total Number of Active Drugs. . . . . 1765 PATIENT DRUG EDUCATION DATABASE (PDED) >>> UPDATE STATUS <<< (ignore this. PDED obsolete) The last quarterly PDED update occurred on. . . JAN 5, 2009 PATIENT DRUG EDUCATION DATABASE WILL EXPIRE ON. . . . APR 1, 2009

CDUR Controlled Drug Use Report • • • Lists all CS prescriptions for a date range Should be run daily, signed, and kept for 2 years 132 columns Can be printed by division, DEA class Can be sorted by date (if using multiple dates) or by drug Check with your site to see how they like to print it Pharmacy Controlled Drug List by Division 132 Character Format! *** Date Range Selection *** Begin with DATE: MAY 20, 2010//-1 (MAY 19, 2010) End with DATE: MAY 20, 2010// (MAY 20, 2010) Would you like all pharmacy divisions? Yes// YES Select one of the following: 1 Date 2 Drug Sort Report by: // 2 Drug Select one of the following: 1 C-2'S 2 C-3'S to C 5'S 3 All Drug Class Types: // 3 All DEVICE: HOME// 0; 132

CDUR Controlled Drug Use Report IHS HOSPITAL CONTROLLED DRUG USE LIST (By Drug Order) DATE OF LISTING: 03/17/2009 Drug Class: C-II through C-V All Divisions for: IHS HOSP Division: IHS HOSPITAL Page 10 This list will include all Prescriptions for any controlled medications dispensed from 03/16/2009 through 03/17/2009 RX # DRUG QTY PHYSICIAN DATE FILLED PATIENT CHART # CLERK -------------------------------------------------------------1677093 TEMAZEPAM 15 MG CAPSULES 30 HYDE, MR MD 03/16/2009 RUNNING DEER, MA 6351 JMA ---------------------SUB-TOTAL # OF RX's : 1 TOTAL QTY : 30 -------------------------------------------------------------TOTAL # OF PRESCRIPTIONS : 19 TOTAL # NEW RX'S : 18 TOTAL # REFILLS : 1 TOTAL # PARTIALS : SATELLITE HC CONTROLLED DRUG USE LIST (By Drug Order) DATE OF LISTING: 03/17/2009 Drug Class: C-II through C-V All Divisions for: IHS HOSP Division: SATELLITE HC Page 11 This list will include all Prescriptions for any controlled medications dispensed from 03/16/2009 through 03/17/2009 RX # DRUG QTY PHYSICIAN DATE FILLED PATIENT CHART # CLERK -------------------------------------------------------------50099967 APAP 300 MG & CODEINE 30 MG TABLET** ---------------------SUB-TOTAL # OF RX's : 1 TOTAL QTY : 20 20 JECKYL, A 03/16/2009 DOE, JULENE K 11671 CAK --------------------------------------------------------------TOTAL # OF PRESCRIPTIONS : 1 TOTAL # NEW RX'S : 1 TOTAL # REFILLS : 0 TOTAL # PARTIALS : 0

Chronic Medication Profile • • Lists only chronic medications Works for sites who diligently mark prescriptions EHR may have made this obsolete Designed to be filed in the paper chart, blanks for dates of refills to be entered CHRONIC MEDICATION PROFILE DATE : 03 -20 -09 SITE: IHS HOSPITAL PATIENT, MARLA CHART # 11123 DOB: 01 -01 -64 REACTIONS: ASPIRIN, METHOTREXATE, REGLAN RX# DRUG QTY 1657430 ALBUTEROL MDI HFA 6. 7 1663583 ERYTHROMYCIN 0. 5% OP OINT 3. 5 1663958 FOLIC ACID 1 MG TABLET** 30 1665718 LUBRICANT, OCULAR 3. 5 GM 1659347 METHOTREXATE 2. 5 MG TABLET** 24 Page 1 LAST FILLED | | 03 -16 -09 |_____|_____| | | 02 -18 -09 |_____|_____| | | 04 -20 -10 |_____|_____| | | 04 -29 -10 |_____|_____| | | 04 -20 -10 |_____|_____|

Controlled Substance Management Report • Lists controlled substances dispensed over a date range • Similar to CDUR but with more management style functionality *** Date Range Selection *** Begin with DATE: MAY 20, 2010//-1 (MAY 19, 2010) End with DATE: MAY 20, 2010// (MAY 20, 2010) Would you like all pharmacy divisions? Yes// YES Select one of the following: 1 C-II 2 C-II through C-V 3 C-III through C-V Drug Class Types: // 3 C-III through C-V Select one of the following: 1 Summary 2 Detail Report Type: // 2 Detail Select one of the following: 1 Drug Name 2 Fill Date 3 Drug Schedule/Drug Name 4 Patient 5 Prescriber Sort report by: // 1 Drug Name Select one of the following: 1 Standard Report 2 Data Export Output Mode: 1// Standard Report Would you like dosing information included? No// NO DEVICE: HOME//

Controlled Substance Management Report • APSP 1011 will add “Refills Left” as a field in the report Controlled Substance Management Report (Detail) 06/16/2011 16: 18 Page: 1 Report Criteria: Inclusive Dates: 05/17/2011 to 06/16/2011 Pharmacy Division: All Drug Class: C-II through C-V Sorted by: Drug Name, Fill Date ----------------------------------------------------------------------------------Date Disp. Type Patient HRN Rx Number Drug Name Qty Days Supply Drug Schedule Prescriber DEA Number Pharmacist Dosage Ordered -----------------------------------------------------------------------------------Pharmacy Division: DEMO HOSPITAL 05/17/2011 F DEMO, PATIENT 999999 3498713 DIAZEPAM 5 MG TAB 15 10 C-IV DEMO, DOCTOR AD 1234567 DEMO, PHARMACIST Dosing: TAKE ONE-HALF (1/2) TABLET BY MOUTH 3 TIMES A DAY **MAY CAUSE DROWSINESS** *AVOID ALCOHOL* 05/17/2011 F DEMO, PATIENT 999999 99900001 OXYCODONE 5 MG/APAP 325 MG TAB DEMO, DOCTOR AD 1234567 DEMO, PHARMACIST Dosing: TAKE 1 TABLET BY MOUTH EVERY 6 HOURS IF NEEDED FOR PAIN 20 10 C-II

Controlled Substance Management Report sub-totals Drug Name # of fills DIAZEPAM 5 MG TAB 1 OXYCODONE 5 MG/APAP 325 MG TAB 1 Total fills (new, refill, and partial): 2 Report Totals Drug Name # of fills DIAZEPAM 5 MG TAB 1 OXYCODONE 5 MG/APAP 325 MG TAB Total fills (new, refill, and partial): 2 1

Daily Prescription Log • Lists all RX dispensed over a specified date range • Use (or not) determined by business practices DAILY PRESCRIPTION ACTIVITY REPORT Print Date: 03/21/2009 08: 35 Pharmacy Division: IHS HOSPITAL. . . . . For Rx's dispensed from 03/20/2009 to 03/20/2009 Rx #: 1041967 Name: PATIENT, JANE D Chart #: 13274 DRUG: APAP 300 MG & CODEINE 30 MG TABLET**Qty: 20 Provider: PROVIDER, BETA Division: IHS HOSPITAL NEW RX D/Time: 03/20/2009 08: 13 Rx #: 1041968 Name: PATIENT, JANE D DRUG: SALSALATE 750 MG TABLET** Qty: 120 Division: IHS HOSPITAL NEW RX Chart #: 13274 Provider: PROVIDER, BETA D/Time: 03/20/2009 08: 13 Rx #: 1040969 Name: PATIENT, JOSE YAZZIE DRUG: ASPIRIN 81 MG TAB, EC Qty: 30 Division: IHS HOSPITAL NEW RX Chart #: 1342 Provider: PROVIDER, ALPHA D/Time: 03/20/2009 08: 17 Rx #: 1040970 Name: PATIENT, JOSE YAZZIE DRUG: CALCIUM 600 MG/VIT D 400 IU TAB Qty: 60 Division: IHS HOSPITAL NEW RX Chart #: 1342 Provider: PROVIDER, ALPHA D/Time: 03/20/2009 08: 17

Drug Recall Report • Lists prescriptions for specific medications dispensed over a specified time • Prints information needed to contact patients in the event of a drug recall • Can be sorted by division SELLS HOSP DRUG RECALL LIST Page 1 DATE OF LISTING: 05/20/2010 All Divisions for: IHS HOSP Division: IHS HOSPITAL CONFIDENTIAL PATIENT INFORMATION This list will include all Outpatients dispensed one or any combination of the following drug(s) from 05/06/2009 through 05/20/2009 DILTIAZEM ER 300 MG CAPS, HOME PATIENT CHART DATE QTY PHONE NAME NUMBER DISPENSED ________________________________________ 110 381 -3768 PATIENT, XAVIER 2312 05/12/2009 30 ADDRESS: PO BOX 102 HOMETOWN 12334 110 381 -2085 PATIENT, JANE GREY 114 05/19/2009 30 ADDRESS: PO BOX 285 HOMETOWN 12334

Drug Storage Location List • Lists drugs (either all or CS) and displays dispensing location and storage location • Those fields are found in the drug file Outpatient Pharmacy Inventory Location For "All Drugs" Division: IHS HOSPITAL Drug Name -----ACARBOSE 25 MG TAB ACARBOSE 50 MG TABLET ACCU-CHECK AVIVA STRIP 50/BOX ACETAMINOPHEN (TYLENOL) 325 MG TABLET** ACETAMINOPHEN 120 MG SUPP, RTL ACETAMINOPHEN 160 MG/5 ML SUSP, ORAL ACETAMINOPHEN 160 MG/5 ML U/D ACETAMINOPHEN 325 MG SUPP, RTL ACETAMINOPHEN 325 MG TAB U/D ACETAMINOPHEN 650 MG SUPP, RTL ACETAMINOPHEN 80 MG CHEW TAB Page 1 Dispensing Location ----------- MAY 20, 2010 Storage Location ----

DUER Drug Utilization Evaluation Report • Lists prescriptions for specific drug over specified • Similar to Drug Recall report but different format • Quick way to find out which patients take a specific drug IHS HOSP DRUG USE EVALUATION LIST DATE OF LISTING: 05/20/2010 Division: SATELLITE HC Page 4 This list will include all Outpatients dispensed one or any combination of the following drug(s) from 04/20/2010 through 05/20/2010 ASPIRIN 325 MG TAB, EC, PATIENT CHART DATE NAME NUMBER DISPENSED QTY MD ________________________________________ PATIENT, HYPERTENSION PATIENT, ADULT MALE 30280 33451 04/23/2010 05/17/2010 90 30 DOCTOR, ALPHA MALE DOCTOR, ALPHA FEMALE

PRINT ERRORS FROM IMPORT OF AAC • AAC installs a file from Mc. Kesson that updates acquisition costs • This report prints any errors that were generated in that process • Print this report after importing the file from Mc. Kesson and running the AAC routine

FIND PROBLEM NDC'S IN DRUG FILE • Finds NDC codes in the drug file that are not in the 5 -4 -2 format • Used a lot during the file preparation for pharmacy 7 installation • Should be run by pharmacy CAC periodically and NDC codes fixed INAPPROPRIATE NDC NUMBERS FOR ACTIVE DRUGS PAGE: 1 DRUG NUMBER PROBLEM MEPHOBARBITAL 50 MG (43) HAS NO NDC TERBUTALINE 2. 5 MG TA (44) HAS NO NDC ERGONOVINE 0. 2 MG (55) HAS NO NDC TERBUTALINE 1 MG/ML A (115) HAS NO NDC AMPICILLIN 500 MG CA (83613) HAS NO NDC ANTIVENIN, (CROTALID (83615) HAS NO NDC ASPIRIN 81 MG TAB, EC (83620) HAS INCORRECT FORMAT - 0603 -0026 -32 BENZOIN TINCTURE, CO (83627) HAS NO NDC BETAMETHASONE 6 MG/ML (83629) HAS NO NDC

Inventory List • Lists inventory levels from drug file • Select between all or CS only • Unless using the “current inventory” field, this report is of marginal value Outpatient Pharmacy Inventory Listing For "All Drugs" Division: SELLS HOSPITAL Page 1 MAY 20, 2010 Drug Name ----- Dispense Unit ----- Current Inventory ----- ADDERALL 5 MG TABS ADDERALL XR 10 MG CAP ADDERALL XR 20 MG CAP ADDERALL XR 30 MG CAP COCAINE HCL 4% TOPICAL SOLN CODEINE SULFATE 30 MG TAB DEXTROAMPHETAMINE 10 MG SR CAPSULE DEXTROAMPHETAMINE 15 MG SR CAPSULE DEXTROAMPHETAMINE 5 MG TAB FENTANYL 100 MCG/HR TRANSDERMAL PATCH FENTANYL 25 MCG/HR TRANSDERMAL PATCH TAB CAP CAP ML TAB CAP CAP TABLET PATCH 6, 009 0 0 0 99, 989 99, 993, 934 -14, 299 -5, 727 95, 009 97, 036 889 -387

Pharmacy Last Patch Lister Pharmacy Related Packages Last Patch Lister Package Version Last Patch Date Installed --------------------------------------------------------NATIONAL DRUG FILE IHS PHARMACY MODIFICATIONS ADVERSE REACTION TRACKING PHARMACY POINT OF SALE AUTOMATED DISPENSING INTERFACE IHS SCRIPTPRO INTERFACE BEX AUDIOCARE TELEPHONE REFILL 4. 0 7. 0 4. 0 1035 1010 36 39 2 1 4 05/04/2011@13: 01 04/21/2011@11: 52: 27 11/09/2010@07: 15: 10 09/08/2010 02/05/2007 10/14/2009 09/08/2010 The last EHR installation was EHR*1. 1*7 on 01/31/2011@10: 21: 54. Last AWP monthly update occurred on 04/05/2011 (this changed in APSP 1010)

Multiple Drug File Reports MDF Multiple Drug File Menu Division Drug List Print Drugs with Eligibility Designation Print Monthly Drugs Dispensed on Eligibility

Division Drug Lists all drugs marked for the selected division Select OUTPATIENT SITE NAME: DEMO CLINIC 1234 START WITH GENERIC NAME: FIRST// DEVICE: VIRTUAL TERMINAL Right Margin: 80// DRUG List MAY 18, 2011 16: 14 PAGE 1 GENERIC NAME NDC -------------------------------------------------------| 1 | AZITHROMYCIN 250 MG TAB | 00069 -3060 -30 | -------------------------------------------------------| 2 | HYDROXYCHLOROQUINE 200 MG TAB | 00781 -1407 -01 | -------------------------------------------------------| 3 | MYCOPHENOLATE MOFETIL 500 MG TA | 00004 -0260 -01 | --------------------------------------------------------

Print Drugs with Eligibility Designation Lists all drugs marked for the selected eligibility designation Select report for Drugs for Eligible or Ineligible Patients Select one of the following: E I Eligible Ineligible Enter response: Eligible// START WITH GENERIC NAME: FIRST// DEVICE: VIRTUAL TERMINAL Right Margin: 80// Drugs Designated for Patients with Eligible Status MAY 18, 2011 16: 21 PAGE 1 GENERIC NAME ----------------------------------------TACROLIMUS 0. 5 MG CAP

Print Monthly Drugs Dispensed on Eligibility Lists all drugs dispensed in selected month and eligibility status Enter Report Month: 11. 2010 (NOV 2010) Select one of the following: 0 1 Eligible In. Eligible Select Eligible/Ineligible: 0 Eligible DEVICE: VIRTUAL TERMINAL Right Margin: 80// Monthly Eligible Drug Statistics For Month: NOV 2010 MAY 18, 2011 16: 27 Page: 1 ___________________________________ Dispensed Drug Number of Orders Number of Units TACROLIMUS 0. 5 MG CAP 3 300

Print Patient Instruction Sheet • Allows for printing of individualized Patient Instruction sheets • These are NOT PMI sheets, but more Discharge Instructions Name : Txxx, Dxx A Date : MAY 20, 2010 Page: 1 ALLERGIES: METFORMIN HYDROCHLORIDE, PENICILLIN, ADVERSE REACTIONS: DEMO HOSPITAL MEDICATION INSTRUCTIONS ------------------------------------------------------------------------------------------------------------CARBAMAZEPINE 200 MG *PLAIN* TAB - TAKE ONE (1) TABLET BY MOUTH TWICE A DAY -MAY CAUSE DROWSINESS- Alcohol may intensify this effect. USE CARE when driving or when operating dangerous machinery.

Pharmacy Package Maintenance Reports • Various Fileman reports for package maintenance, e-prescribing preparation ALL Drug-Complete Listing CODE Quick Codes List DFM Drug File Maintenance Report DR Dosages Review INST Medication Instructions MDR Missing Dosages Report NSYN Drug List W/O Synonyms OISL Orderable Item Synonym List POOS Print Drug File POS fields QO'S List Drugs by VA Drug class (for QO's) ROUT Medication Routes SIGS List Drugs with Standard Sigs STSC Standard Schedules

Drug File Maintenance Report ****THIS REPORT IS 160 CHARACTERS WIDE - USE FILE CAPTURE & 0; 160; 9999 AT THE DEVICE PROMPT**** DEVICE: 0; 160; 9999 VIRTUAL TERMINAL SCB E-Rx WORKSHEET MAY 18, 2011 16: 43 PAGE 1 # GENERIC NAME VAclas DEAhdl NDC ORDun DISPu DU/OU NCPDP PKGS --------------------------------------------------------------------------------84241 ACARBOSE 50 MG TAB (SAMPLE) HS 502 9 P 00026 -2861 -51 BT TAB 100 U 2 OUX 83605 ACETAMINOPHEN 120 MG SUPP RTL CN 103 9 P 45802 -0730 -32 BX SUPP 50 AR OUX 3958 ACETAMINOPHEN 120 MG/CODEINE 12 MG ELIX CN 101 5 AB 00536 -0082 -85 ML 480 ML 84130 ACETAMINOPHEN 120 MG/CODEINE 12 MG ELIXIR CN 101 3 AB 00121 -0504 -16 BT ML 473 ML 120 MG/CODEINE 12 OXN 84564 ACETAMINOPHEN 120 MG/CODEINE 12 MG ELX U/D CN 101 3 00121 -0504 -05 CS EA 500 ML 120 MG/CODEINE 12 UN ORD ITEM ACARBOSE ACETAMINOPHEN OX ACETAMINOPHEN

Dosages Review ****THIS REPORT IS 110 CHARACTERS WIDE - USE FILE CAPTURE & 0; 110; 9999 AT THE DEVICE PROMPT**** DEVICE: 0; 110; 9999 VIRTUAL TERMINAL DOSAGES REVIEW MAY 18, 2011 16: 47 PAGE 1 NUMBER GENERIC NAME DOSES PAKGE LOCAL POS DOSAGES PAKGE ----------------------------------------------------------------------------84241 83605 ACARBOSE 50 MG TAB (SAMPLE) ACETAMINOPHEN 120 MG SUPP RTL 50 120 240 3958 ACETAMINOPHEN 120 MG/CODEINE 12 MG ELIX 84130 ACETAMINOPHEN 120 MG/CODEINE 12 MG ELIXIR IO I I 1 SUPPOSITORY(IES) 2 SUPPOSITORY(IES) Both 1 ML Both 2 MLS Both 1 TEASPOONFUL 2 TEASPOONFULS 1 TABLESPOONFUL Both

Return To Stock Report • Lists prescriptions returned to stock for a specified date range • Run when compiling data for periodic pharmacy workload reporting Returned to Stock Report Criteria: 05/20/2010 09: 58 Page: 1 (An '*' after RTS Date indicates a reissued original Rx. ) (An '*' prior to the Rx Number indicates a deleted prescription. ) (A '#' indicates that quantity is unknown for returned partial fill. ) Inclusive Dates: 04/30/2010 to 05/20/2010 Pharmacy Division: IHS HOSPITAL Type of Search: All Drugs Sorted by: RTS Date/Time --------------------------------------------------------RTS Date/Time Rx Number Act Reference Drug Name Qty Last Disp Date --------------------------------------------------------04/30/2010 1665227 ORIGINAL CITALOPRAM 40 MG TABLET** 15 04/27/2010 04/30/2010 1665228 ORIGINAL REFRESH LIQUIGEL 1% OPH 15 ML 15 04/27/2010 04/30/2010 1665265 ORIGINAL CEPHALEXIN 500 MG CAPSULE** 14 04/27/2010 04/30/2010 1523338 H ORIGINAL LEVOTHYROXINE 0. 125 MG (BROWN) TAB 30 04/30/2010 *1665859 ORIGINAL HYDROCORTISONE 2. 5% CREAM 60 04/30/2010

Total Drugs Dispensed Report • Lists all drugs dispensed over a specified time period • Can select by division • Can print according to drug name or VA drug class *** Date Range Selection *** Begin with DATE: MAY 20, 2010//-5 (MAY 15, 2010) End with DATE: MAY 20, 2010// (MAY 20, 2010) Would you like all pharmacy divisions? Yes// NO Select Pharmacy Division: BUSY// 2906 Select one of the following: 1 VA Drug Class 2 Drug Sort By: // 2 Drug Would you like all drugs? Yes// YES Suppress printing drug names in header? Yes// NO DEVICE: HOME// Virtual

BUSY "Total Drugs Dispensed" List Date of Listing: 05/20/10 By: Drug Outpatient Drugs dispensed from 05/15/2010 through 05/20/2010 Total Number of Days = 6 Drugs Selected ----> All Drugs Page 1 Number Type of Units Drug Name of Rx's Dispensed Total _______________________________________ ACCU-CHEK AVIVA TEST STRIP ACETAMINOPHEN 325 MG TAB*(TYLENOL) ACETAMINOPHEN 80 MG CHEW TAB ACETAMINOPHEN 80 MG/0. 8 ML SOLN ACETAZOLAMIDE 250 MG TAB* ACETYLCYSTEINE 20% SOLN 30 ML ADVAIR HFA 230/21 ALBUTEROL 2. 5 MG/NS (0. 083%) INH SOLN ALBUTEROL HFA-INH (PROVENTIL 6. 7 GM) ALCOHOL SWABS ALENDRONATE 70 MG TAB 23 9 1 4 1 1 1 3 27 12 4 STRIP TAB ML GM SWAB TAB 2300 860 30 60 15 20 12 273 187. 6 2200 16

RX DATA ANALYSIS REPORT • Prints workload statistics based on the time of day • Prescription counts • Helps supervisors develop staffing needs and schedules • Can be printed by division • RX processed before 9 am are not counted in adjusted % because it is assumed most of those are entry of ER charts from the night before • Part of PCC Management Reports, but can be added to pharmacy menu locally

IHS HOSP May 20, 2010 Page 1 RX ANALYSIS REPORT RX RELEASE TIME WORKLOAD DISTRIBUTION **************************************** DIVISION: IHS HOSPITAL RX RELEASE DATE RANGE: Apr 20, 2010 - May 20, 2010 Total Prescriptions Dispensed: 10561 RX COUNT ACT % TOTAL ADJ % TOTAL **AM Prescriptions Dispensed** *************** Total RX's Before 8: 00: 15 0 NA Total RX's 8: 00 - 8: 59: 517 5 NA Total RX's 9: 00 - 9: 59: 1043 10 10 Total RX's 10: 00 -10: 59: 1077 10 11 Total RX's 11: 00 -11: 59: 1039 10 10 **PM Prescriptions Dispensed** *************** Total RX's 12: 00 -12: 59: 994 9 10 Total RX's 1: 00 - 1: 59: 1062 10 11 Total RX's 2: 00 - 2: 59: 1170 11 12 Total RX's 3: 00 - 3: 59: 1044 10 10 Total RX's 4: 00 - 4: 59: 1316 12 13 Total RX's 5: 00 - 5: 59: 981 9 10 Total RX's 6: 00 - 6: 59: 303 3 3 Total RX's 7: 00 - 7: 59: 0 0 0 Total RX's 8: 00 - 8: 59: 0 0 0 Total RX's 9: 00 - 9: 59: 0 0 0 Total RX's 10: 00 -10: 59: 0 0 0 Total RX's 11: 00 -11: 59: 0 0 0 ________ 10561 100% ***SUMMARY*** ACT Total-All Hours: 10561 ADJ Total After 9: 00 AM: 10029 ACT Percent After 2: 00 PM: 46% ADJ Percent After 2: 00 PM: 48% ACT Percent After 3: 00 PM: 35% ADJ Percent After 3: 00 PM: 36% ACT Percent After 4: 00 PM: 25% ADJ Percentage After 4: 00 PM

Questions and Discussion