Output Reports Menu• Outpatient Pharmacy main menu: Output Reports

Action Profile (132 COLUMN PRINTOUT)Alpha Drug List and SynonymsAMIS ReportCMOP Controlled Substance Rx Dispense ReportCommonly Dispensed DrugsCost Analysis Reports ...Daily AMIS ReportDrug List By SynonymFree Text Dosage ReportInactive Drug ListList Prescriptions on HoldManagement Reports Menu ...Medication ProfileMonthly Drug CostNarcotic Prescription ListNon-Formulary ListNon-VA Meds Usage ReportPoly Pharmacy ReportReleased 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// InformationalBy Patient, Clinic or Clinic Group (P/C/G): P// atientDo 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 CI 140557Select PATIENT NAME:Profile Expiration/Discontinued Cutoff: (0-9999): 120//DEVICE: 0;132;999 VTPress Return to Continue or "^" to Exit:

Informational Rx Profile Run Date: MAY 19,2010 Page: 1Sorted by drug classification for Rx's currently activeand for those Rx's that have been inactive less than 120 days. Site: DEMO HOSPITAL--------------------------------------------------------------------------------Name : DEMO,CAROL ID#: 140557DOB : FEB 22,1991 Address : 6110 RAPE RD MIMS, FLORIDA 32754 Phone : 555-555-3312WEIGHT(Kg): 115.91 (03/21/2007) HEIGHT(cm): 154.94 (03/21/2007)DISABILITIES:ALLERGIES: DEMEROL 100MG/ML CARTRIDGE, LISINOPRIL, MORPHINE SULFATE,ADVERSE REACTIONS:--------------------------------------------------------------------------------Medication/Supply Rx# Status Expiration Provider

DateClassification: AM111 - PENICILLINS,AMINO DERIVATIVES AMOX/CLAV 250/125MG TAB (30'S) PREPACK Qty: 30 for 10 Days 1337608 Expired 04-01-2010 USER,ASTUDENT 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.00Classification: HS502 - ORAL HYPOGLYCEMIC AGENTS,ORAL GLYBURIDE= 5MG TABLETS Qty: 30 for 30 Days 1337609 Active 03-03-2011 NIESEN,MARY ANN 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 A1C SINCE 05-19-09 METFORMIN= 500MG *PLAIN* TABS Qty: 60 for 30 Days 1337610 Active 03-03-2011 NIESEN,MARY ANN 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!

Alpha Drug List and Synonyms

ALPHABETIC DRUG LIST AND SYNONYMS MAY 19,2010 23:21 PAGE 1 DEA, PRICE PER SPECIAL DISPENSEGENERIC NAME HDLG N/F UNIT Synonym--------------------------------------------------------------------------------

00409198530 4ACETAMINOPHEN 120MG SUPP 0.1180 Apap Tylenol 059439011612ACETAMINOPHEN 160MG/5ML SOLN 9 0.0061 Tylenol Apap 000904198520ACETAMINOPHEN 325MG TAB 9P 0.0390 Apap Tylenol 051079000220

• Prints a list from the drug file with the synonyms• Might be useful for file troubleshooting or for training

new pharmacists

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

Interpretation:– New + Refill = Total RX– Window + Mail = Total RX– Fee + Staff = Total RX

A M I S R E P O R T FROM 04-19-10 TO 04-20-10 DIVISION: HARD LABORDATE INPAT SC A&A OTHER NVA CNTLD METHA PAT REQ FEE STAFF NEW REFILL WINDOW MAIL--------------------------------------------------------------------------------------------------------------------------04-19-10 0 0 0 0 0 24 0 184 0 647 354 293 623 2404-20-10 0 0 0 0 0 14 0 143 0 519 300 219 503 16 ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -------SUB-TOTALS 0 0 0 0 0 38 0 327 0 1166 654 512 1126 40

Commonly Dispensed Drugs• Counts medication fills by drug and quantity over

a period of time• Useful for inventory managementSelect Output Reports Option: Commonly Dispensed DrugsSTARTING DATE: -90 (FEB 18, 2010)ENDING DATE: T (MAY 19, 2010)DO NOT PRINT DRUG IF COUNT IS LESS THAN : (1-100): 20// 1DEVICE: HOME// 0;80;999

MOST COMMONLY DISPENSED DRUGS FROM 02-18-10 THRU 05-19-10 05-19-10 MINIMUM DRUG COUNT OF 1 Pg: 1ENTRYNUMBER DRUG QUANTITY FILLS------------------------------------------------------------------------------Division: DEMO HOSPITAL 348 CARBAMAZEPINE 200MG *PLAIN* TAB 60 2 263 ACETAMINOPHEN 325MG TAB 50 185832 AMOX/CLAV 250/125MG TAB (30'S) PREPACK 30 183611 AMOXICILLIN 250MG/5ML SUSP (150ML) 150 184490 AMOXICILLIN= 250MG CAP 30 1 1342 FOLIC ACID= 1MG TAB 30 183870 GLYBURIDE= 5MG TABLETS 30 184852 METFORMIN= 500MG *PLAIN* TABS 60 1

Cost Analysis Reports ...• Options print cost reports and statistics• Useful for formulary, inventory and workload

management• Accurate reports depend on having correct

acquisition costs in drug file

Select Output Reports Option: COST Analysis Reports

Clinic CostsDivision Costs by DrugDrug CostsDrug Costs by DivisionDrug Costs by Division by ProviderDrug Costs by ProviderHigh Cost Rx ReportPatient Status CostsPharmacy Cost Statistics Menu ...Provider by Drug CostsProvider CostsRequest Statistics

Sample reports

Drug Costs by Clinic for the period: APR 2010 to MAY 20,2010Run Date: MAY 19,2010 Page: 1 Orign Total Total Avg CostClinic Fills Refil Fills Cost per Fill--------------------------------------------------------------------------------A CLINIC 1 0 1 3.00 3.00 ----- ----- ----- ---------- --------Total 1 0 1 3.00 3.00

Drug Costs by Division by Drug for the period: APR 2010 to MAY 20,2010Run Date: MAY 19,2010 Page: 1 Orgin Total Total Total Avg CostDrug Fills Refills Fills Qty Cost per Fill------------------------------------------------------------------------------------------------------------------ Division: DEMO HOSPITALACETAMINOPHEN 325MG TAB 1 0 1 50.00 1.95 1.95CARBAMAZEPINE 200MG *PLAIN* TAB 1 0 1 60.00 3.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,2010Run Date: MAY 19,2010 Page: 1 Orign Total Total Avg CostDrug Fills Refil Fills Cost per Fill--------------------------------------------------------------------------------ACETAMINOPHEN 325MG TAB 1 0 1 1.95 1.95CARBAMAZEPINE 200MG *PLAIN* TAB 1 0 1 3.00 3.00 ----- ----- ----- ---------- --------Total 2 0 2 4.95 2.48

Drug Costs by Division by Provider for the period: APR 2010 to MAY 20,2010Run Date: MAY 19,2010 Page: 1 Orign Total Total Avg CostDivision by Provider Fills Refil Fills Cost per Fill-------------------------------------------------------------------------------- Division: DEMO HOSPITALNIESEN,MARY ANN 1 0 1 1.95 1.95USER,ASTUDENT 1 0 1 3.00 3.00 ----- ----- ----- ---------- --------Total for DEMO HOSPITAL 2 0 2 4.95 2.48 ----- ----- ----- ---------- -------- ----- ----- ----- ---------- --------Total 2 0 2 4.95 2.48

Drug Costs by Division for the period: APR 2010 to MAY 20,2010Run Date: MAY 19,2010 Page: 1 Orign Total Total Avg CostDivision 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 Drug by Provider for the period: APR 2010 to MAY 20,2010Run Date: MAY 19,2010 Page: 1

Orign Total Total Avg CostDrug by Provider Fills Refil Fills Cost per Fill-------------------------------------------------------------------------------- DRUG: ACETAMINOPHEN 325MG TABNIESEN,MARY ANN 1 0 1 1.95 1.95 ----- ----- ----- ---------- --------Total for ACETAMINOPHEN 325MG TAB 1 0 1 1.95 1.95 ----- ----- ----- ---------- -------- DRUG: CARBAMAZEPINE 200MG *PLAIN* TABUSER,ASTUDENT 1 0 1 3.00 3.00 ----- ----- ----- ---------- --------Total for CARBAMAZEPINE 200MG *PL 1 0 1 3.00 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 1Run Date: MAY 19,2010

Rx # Drug QTY Un.Cost Total Cost-------------------------------------------------------------------------------- 1337616 CARBAMAZEPINE 200MG *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,2010Run Date: MAY 20,2010 Page: 1

Orign Total Total Avg CostPatient 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 StatisticsSTART 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 AVEFILLED FILLS MAIL WINDOW REQUESTS TOTAL COST COST/FILL--------------------------------------------------------------------------------

MAY 7,2010 1 0 1 1 3.0000 3.00 ----------- ------- ------- ------- ------------ -----------TOTAL 1 0 1 1 3.0000 3.00

Drug Costs by Provider by Drug for the period: APR 2010 to MAY 20,2010Run Date: MAY 20,2010 Page: 1

Orign Total Total Avg CostProvider by Drug Fills Refil Fills Cost per Fill-------------------------------------------------------------------------------- Provider: NIESEN,MARY ANNACETAMINOPHEN 325MG TAB 1 0 1 1.95 1.95 ----- ----- ----- ---------- --------Total for NIESEN,MARY ANN 1 0 1 1.95 1.95 ----- ----- ----- ---------- --------

Drug Costs by Provider for the period: APR 2010 to MAY 20,2010Run Date: MAY 20,2010 Page: 1

Orign Total Total Avg CostProvider Fills Refil Fills Cost per Fill--------------------------------------------------------------------------------NIESEN,MARY ANN 1 0 1 1.95 1.95USER,ASTUDENT 1 0 1 3.00 3.00 ----- ----- ----- ---------- --------Total 2 0 2 4.95 2.48

REQUEST STATISTICS MAY 20,2010 00:44 PAGE 1 AVE AVEFILLED DATE REQUESTS COST/REQUEST FILLS/REQUEST--------------------------------------------------------------------------------

MAY 7,2010 1 3.00 1.00 ------- ----------- -----------TOTAL 1 3.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 0 43 86SC 0 0 0A&A 0 0 0OTHER 0 0 0NVA 0 0 0CNTLD 0 86 212METHA 0 0 0PAT REQ 0 2312 6341FEE 0 0 0STAFF 0 6358 17423NEW 0 3597 10221REFILL 0 2761 7202WINDOW 0 5509 15151MAIL 0 849 2272

Sub Totals ========= ========= ========= 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 fileDRUG LIST BY SYNONYM MAY 20,2010 00:51 PAGE 1SYNONYM GENERIC NAME N/F------------------------------------------------------------------------

000001000101 DIPHEN/MAALOX/LIDO 1:1:1000003362412 ATAZANAVIR 150 MG CAPSULE N/F000006408400 ANTIVENIN, SPIDER BITE INJECTION000006778203 PHYTONADIONE 10MG/ML INJECTION000006778433 PHYTONADIONE 1MG/0.5ML INJECTION000008092355 PANTOPRAZOLE 40MG INJECTION000011834109 DIMERCAPROL 100MG/ML INJECTION000023050650 POLYVINYL ALCOHOL/POVIDONE DROPS N/F

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,2010Drug Free Text Entry Count Provider:Count------------------------------------------------------------------------

ACCU-CHEK COMFORT CURVE STRIP (85978) 1 strip 1 USER,ASTUDENT:1

ACETAMINOPHEN 325MG TABLET 100 (85041) 1 TABLET 1 USER,ASTUDENT:1 1 to 2 tablets 1 MILLER,JOHN MD:1 1-2 TABLET(S) 2 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 MAY 20,2010 01:06 PAGE 1 INACTIVENUMBER GENERIC NAME DATE Synonym----------------------------------------------------------------------------

85578 00677-1647-10 OCT 22,2003 84291 2,3,DIDEOXYINOSINE, POWER, PAC SEP 7,1999 Videx Ddi 000087661443 85895 50/50 INSULIN INJ AUG 3,2005 85722 ABCIXIMAB IV 2MG/ML AUG 3,2005 Reopro 85506 ACARBOSE OCT 20,2003 000026286251

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 1RX # PATIENT DRUG ISSUE DATE----------------------------------------------------------------------------- DIVISION: DEMO HOSPITAL

HOLD REASON: REFILL TOO SOON HOLD DATE: AUG 17,2009

1337603 CLAUSON,DAPHE DAWNE CARVEDILOL CR 20MG 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 DataPurge Data (purges old data from compiled file)

(Daily/Monthly)Management Report MenuAll ReportsCost of PrescriptionsCount of PrescriptionsIntravenous AdmixtureType of Prescriptions Filled (132 columns)

Sample report: Type of Prescriptions FilledO U T P A T I E N T P H A R M A C Y M A N A G E M E N T R E P O R T

TYPE OF PRESCRIPTIONS FILLED PAGE 1

FROM 04/10 TO 04/10 DIVISION: ANOTHER INDIAN HOSPITAL

FEE TOT WD PARTIC % OF FEEDATE FEE STAFF & STAFF NEW REFILL FILLS WD MAIL & MAIL PHARM FL BY VA INVEST------------------------------------------------------------------------------------------------------------------04/10 0 11342 11342 6817 4525 11342 9897 0 9897 0 0.0 0 ===== ===== ===== ===== ===== ====== ===== ===== ===== ===== ===== =====DIV TOTAL 0 11342 11342 6817 4525 11342 9897 0 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 ProfileSelect PATIENT NAME: DEMO,CAROL <A> F 02-22-1991 XXX-XX-4789 CI 140557LONG or SHORT: SHORT//Sort by DATE, CLASS or MEDICATION: DATE//All Medications or Selection (A/S): All//DEVICE: HOME// VT Right Margin: 80//

DEMO,CAROL ID#: 1405576110 RAPE RD DOB: FEB 22,1991MIMS PHONE: 555-555-3312FLORIDA 32754 ELIG:CANNOT USE SAFETY CAPS.

WEIGHT(Kg): 115.91 (03/21/2007) HEIGHT(cm): 154.94 (03/21/2007)DISABILITIES:

ALLERGIES: DEMEROL 100MG/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/125MG TAB (30'S) PREPACK E 0 03-02-10 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= 5MG TABLETS A 11 03-02-10 03-02-10 QTY: 30 SIG: TAKE ONE (1) TABLET BY MOUTH DAILY FOR BLOOD SUGAR CONTROL 1337610 METFORMIN= 500MG *PLAIN* TABS A 11 03-02-10 03-02-10 QTY: 60 SIG: TAKE ONE (1) TABLET BY MOUTH TWICE A DAY TAKE WITH FOOD FOR DIABETES TREATMENT 1337613 FOLIC ACID= 1MG TAB A 11 03-02-10 03-02-10 QTY: 30 SIG: TAKE ONE (1) TABLET BY MOUTH DAILY 1337483 AMOXICILLIN= 500MG CAP E 0 05-07-08 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 TOTAL TOTAL DRUG FILLED QUANITY COST N/F------------------------------------------------------------------------------------------------------------------------ TIMOLOL MALEATE 0.5% OPHTHALMIC SOLUTION 1 5 .48 *** N/F *** TIZANIDINE 2MG TABLET 2 60 2.28 *** N/F *** TOBRAMYCIN 0.3% OPHTH OINTMENT 3.5GM 3 10.5 113.5155 TOBRAMYCIN 0.3% OPHTH SOLUTION 15ML 4 20 3.04 TOLTERODINE 2MG TABLET 2 120 153.48 TOPIRAMATE 25MG TABLET 1 360 433.08 *** N/F *** TRAMADOL 50MG TABLET 7 530 10.84 TRAVOPROST 0.004% OPHTHALMIC SOLN. 5ML 23 120 349.2 TRAZODONE 100MG TABLET 8 330 23.73 TRAZODONE 50MG TABLET 28 1094 49.23

ZOLPIDEM 10MG TABLET 1 30 122.43 ZOLPIDEM 5MG TABLET 4 130 3.38 ---------- ---------- ---------- SUB-TOTALS 11001 794378.79 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 MAY 20,2010 00:58 PAGE 1RX # DRUG QTY PROVIDER FILL DATE

PATIENT ID#------------------------------------------------------------------------------------------50021237 APAP 300MG & CODEINE 30MG TABL 20 PAYNE, I.M.A. MAY 19,2009 FROST,JACQUELINE J 5261322501654957 APAP 300MG & CODEINE 30MG 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 MAY 20,2010 02:00 PAGE 1 DEA, PRICE PER SPECIAL DISPENSENUMBER GENERIC NAME HDLG UNIT Synonym-------------------------------------------------------------------------------- 403 ACEBUTOLOL 200MG CAP 6 0.3350 Sectral 335 ACEBUTOLOL 400MG CAP 6 0.3330 Sectral 418 ACYCLOVIR 800MG TAB 6P 0.1110 Zov8 000172426870 Zovirax 84262 ACYCLOVIR ORAL SUSP. 200MG/5ML 6P 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 NAMEDate Range: 03/18/2011 - 06/16/2011 Run Date: Jun 16, 2011@10:25:01------------------------------------------------------------------------------------------------------------DEMO, PATIENT (ID:1958) Patient Phone #: 555-555-7402 Non-VA Med: LISINOPRIL Dispense Drug: LISINOPRIL 10MG TABLET Dosage: 10MG Schedule: EVERY DAY Med Route: BY MOUTH Status: ACTIVE CPRS Order #: 821569Documented By: DEMO, USER Documented Date: 05/01/2011 Clinic: 01 GENERAL CLINIC Start Date: 10/01/2008==============================================================

Non-VA Meds Usage Report

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 647Patient ID# Active Rx's Class Drug Status Last Filled Provider Rx Number-------------------------------------------------------------------------------------------------------------------

PATIENT,DEMO MARIAN (8876) 12 CN103 ACETAMINOPHEN 500MG A APR 15, 2010 PROVIDER,TEST DO 982303 ASPIRIN 81MG E.C. TAB A APR 15, 2010 PROVIDER,TEST DO 982305 CN609 FLUOXETINE 20MG CAP A APR 15, 2010 PROVIDER,TEST DO 982307 CV100 METOPROLOL 50MG TAB A APR 15, 2010 PROVIDER,TEST DO 982310 CV200 AMLODIPINE 10MG A APR 15, 2010 PROVIDER,TEST DO 982304 CV702 FUROSEMIDE 40MG TAB A APR 15, 2010 PROVIDER,TEST DO 982308 CV800 LISINOPRIL 10MG TAB A APR 15, 2010 PROVIDER,TEST DO 982309 GA900 OMEPRAZOLE 20MG CAP A APR 15, 2010 PROVIDER,TEST DO 982311 OP105 DORZOLAMIDE 2%-TIMOLOL 0.5% A APR 15, 2010 PROVIDER,TEST MD 923864A OP219 POLYMYXIN/TRIMETHOPRIM OPH SOLN A FEB 22, 2010 PROVIDER,TEST PA 975485 TN410 FERROUS SULFATE 325MG TAB A APR 15, 2010 PROVIDER,TEST DO 982306 TN430 POTASSIUM CHLORIDE 10mEQ 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/ DateRx # Refill Released Released Status Copay --------------------------------------------------------------------------------

1567788A Refill #2 MAY 13,2010 Yes Active1611710 Refill #4 MAY 13,2010 Yes Active1597791A Refill #5 MAY 13,2010 Yes Active1505999E Refill #7 MAY 13,2010 Yes Active1613309A Refill #7 MAY 13,2010 Yes Active1622750 Refill #1 No Active1623751 Refill #5 MAY 13,2010 Yes Active1623753 Refill #5 MAY 13,2010 Yes Active1624926 Refill #3 MAY 13,2010 Yes Active1624929 Refill #6 MAY 13,2010 Yes Active1624935 Refill #7 MAY 13,2010 Yes Active1625617 Refill #3 MAY 13,2010 Yes Active

Reports on IHS Specific Options Menu• Developed for IHS by IHS, reports and options

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

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 DrugSort Report by: // 2 Drug Select one of the following: 1 C-2'S 2 C-3'S to C5'S 3 AllDrug Class Types: // 3 AllDEVICE: HOME// 0;132

IHS HOSPITAL CONTROLLED DRUG USE LIST (By Drug Order) Page 10DATE OF LISTING: 03/17/2009Drug Class: C-II through C-VAll Divisions for: IHS HOSPDivision: IHS HOSPITAL

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 15MG 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) Page 11DATE OF LISTING: 03/17/2009Drug Class: C-II through C-VAll Divisions for: IHS HOSPDivision: SATELLITE HC

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 300MG & CODEINE 30MG TABLET** 20 JECKYL,A 03/16/2009 DOE, JULENE K 11671 CAK-------------------------------------------SUB-TOTAL # OF RX's : 1 TOTAL QTY : 20

----------------------------------------------------------------------------------------------------------------------------TOTAL # OF PRESCRIPTIONS : 1 TOTAL # NEW RX'S : 1 TOTAL # REFILLS : 0 TOTAL # PARTIALS : 0

CDUR Controlled Drug Use Report

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 Page 1 DOB: 01-01-64REACTIONS: ASPIRIN, METHOTREXATE, REGLANRX# DRUG QTY LAST FILLED | | | |1657430 ALBUTEROL MDI HFA 6.7 03-16-09 |_____|_____|_____| | | | |1663583 ERYTHROMYCIN 0.5% OP OINT 3.5 02-18-09 |_____|_____|_____| | | | |1663958 FOLIC ACID 1MG TABLET** 30 04-20-10 |_____|_____|_____| | | | |1665718 LUBRICANT, OCULAR 3.5GM 3.5 04-29-10 |_____|_____|_____| | | | |1659347 METHOTREXATE 2.5MG TABLET** 24 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-VDrug Class Types: // 3 C-III through C-V Select one of the following: 1 Summary 2 DetailReport Type: // 2 Detail Select one of the following: 1 Drug Name 2 Fill Date 3 Drug Schedule/Drug Name 4 Patient 5 PrescriberSort report by: // 1 Drug Name Select one of the following: 1 Standard Report 2 Data ExportOutput Mode: 1// Standard ReportWould you like dosing information included? No// NODEVICE: 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 5MG TAB 15 10 C-IV

DEMO, DOCTOR AD1234567 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 5MG/APAP 325MG TAB 20 10 C-II

DEMO, DOCTOR AD1234567 DEMO, PHARMACIST

Dosing:TAKE 1 TABLET BY MOUTH EVERY 6 HOURS IF NEEDED FOR PAIN

Controlled Substance Management Report

Report sub-totals

Drug Name # of fills

DIAZEPAM 5MG TAB 1

OXYCODONE 5MG/APAP 325MG TAB 1

Total fills (new, refill, and partial): 2

Report Totals

Drug Name # of fills

DIAZEPAM 5MG TAB 1

OXYCODONE 5MG/APAP 325MG TAB 1

Total fills (new, refill, and partial): 2

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/2009Rx #: 1041967 Name: PATIENT,JANE D Chart #: 13274DRUG: APAP 300MG & CODEINE 30MG TABLET**Qty: 20Provider: PROVIDER,BETADivision: IHS HOSPITAL NEW RX D/Time: 03/20/2009 08:13

Rx #: 1041968 Name: PATIENT,JANE D Chart #: 13274DRUG: SALSALATE 750MG TABLET** Qty: 120 Provider: PROVIDER,BETADivision: IHS HOSPITAL NEW RX D/Time: 03/20/2009 08:13

Rx #: 1040969 Name: PATIENT,JOSE YAZZIE Chart #: 1342DRUG: ASPIRIN 81MG TAB,EC Qty: 30 Provider: PROVIDER,ALPHADivision: IHS HOSPITAL NEW RX D/Time: 03/20/2009 08:17

Rx #: 1040970 Name: PATIENT,JOSE YAZZIE Chart #: 1342DRUG: CALCIUM 600MG/VIT D 400IU TAB Qty: 60 Provider: PROVIDER,ALPHADivision: IHS HOSPITAL NEW RX 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 1DATE OF LISTING: 05/20/2010All Divisions for: IHS HOSPDivision: IHS HOSPITAL CONFIDENTIAL PATIENT INFORMATIONThis list will include all Outpatients dispensed one or any combinationof the following drug(s) from 05/06/2009 through 05/20/2009DILTIAZEM ER 300MG CAPS,HOME PATIENT CHART DATE QTYPHONE NAME NUMBER DISPENSED________________________________________________________________________________110 381-3768 PATIENT,XAVIER 2312 05/12/2009 30ADDRESS: PO BOX 102 HOMETOWN 12334110 381-2085 PATIENT,JANE GREY 114 05/19/2009 30ADDRESS: 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 fileOutpatient Pharmacy Inventory Location Page 1 MAY 20,2010For "All Drugs"Division: IHS HOSPITAL Dispensing StorageDrug Name Location Location---------- ---------------------- --------ACARBOSE 25MG TABACARBOSE 50 MG TABLETACCU-CHECK AVIVA STRIP 50/BOXACETAMINOPHEN (TYLENOL) 325MG TABLET**ACETAMINOPHEN 120MG SUPP,RTLACETAMINOPHEN 160MG/5ML SUSP,ORALACETAMINOPHEN 160MG/5ML U/DACETAMINOPHEN 325MG SUPP,RTLACETAMINOPHEN 325MG TAB U/DACETAMINOPHEN 650MG SUPP,RTLACETAMINOPHEN 80MG CHEW TAB

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 Page 4DATE OF LISTING: 05/20/2010Division: SATELLITE HC

This list will include all Outpatients dispensed one or any combinationof the following drug(s) from 04/20/2010 through 05/20/2010

ASPIRIN 325MG TAB,EC,

PATIENT CHART DATENAME NUMBER DISPENSED QTY MD_______________________________________________________________________________

PATIENT,HYPERTENSION 30280 04/23/2010 90 DOCTOR,ALPHA MALEPATIENT,ADULT MALE 33451 05/17/2010 30 DOCTOR,ALPHA FEMALE

PRINT ERRORS FROM IMPORT OF AAC

• AAC installs a file from McKesson that updates acquisition costs

• This report prints any errors that were generated in that process

• Print this report after importing the file from McKesson 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 50MG (43) HAS NO NDC TERBUTALINE 2.5MG TA (44) HAS NO NDC ERGONOVINE 0.2MG (55) HAS NO NDC TERBUTALINE 1MG/ML A (115) HAS NO NDC AMPICILLIN 500MG CA (83613) HAS NO NDC ANTIVENIN, (CROTALID (83615) HAS NO NDC ASPIRIN 81MG TAB,EC (83620) HAS INCORRECT FORMAT - 0603-0026-32 BENZOIN TINCTURE, CO (83627) HAS NO NDC BETAMETHASONE 6MG/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 valueOutpatient Pharmacy Inventory Listing Page 1 MAY 20,2010For "All Drugs"Division: SELLS HOSPITAL Dispense CurrentDrug Name Unit Inventory--------- --------- ---------

ADDERALL 5 MG TABS TAB 6,009ADDERALL XR 10MG CAP CAP 0ADDERALL XR 20MG CAP CAP 0ADDERALL XR 30MG CAP CAP 0COCAINE HCL 4% TOPICAL SOLN ML 99,989CODEINE SULFATE 30MG TAB TAB 99,993,934DEXTROAMPHETAMINE 10 MG SR CAPSULE CAP -14,299DEXTROAMPHETAMINE 15 MG SR CAPSULE CAP -5,727DEXTROAMPHETAMINE 5 MG SR CAPSULE CAP 95,009DEXTROAMPHETAMINE 5 MG TAB TABLET 97,036FENTANYL 100 MCG/HR TRANSDERMAL PATCH PATCH 889FENTANYL 25 MCG/HR TRANSDERMAL PATCH PATCH -387

Pharmacy Last Patch Lister

Pharmacy Related Packages

Last Patch Lister

Package Version Last Patch Date Installed

-----------------------------------------------------------------------------------------------------------------

NATIONAL DRUG FILE 4.0 1035 05/04/2011@13:01

IHS PHARMACY MODIFICATIONS 7.0 1010 04/21/2011@11:52:27

ADVERSE REACTION TRACKING 4.0 36 11/09/2010@07:15:10

PHARMACY POINT OF SALE 1.0 39 09/08/2010

AUTOMATED DISPENSING INTERFACE 1.0 2 02/05/2007

IHS SCRIPTPRO INTERFACE 1.0 1 10/14/2009

BEX AUDIOCARE TELEPHONE REFILL 1.0 4 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 List

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 250MG TAB | 00069-3060-30 |

---------------------------------------------------------------------------------------------------------------

| 2 | HYDROXYCHLOROQUINE 200MG TAB | 00781-1407-01 |

---------------------------------------------------------------------------------------------------------------

| 3 | MYCOPHENOLATE MOFETIL 500MG 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 Eligible

I 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.5MG CAP

Print Monthly Drugs Dispensed on Eligibility

Lists all drugs dispensed in selected month and eligibility statusEnter Report Month: 11.2010 (NOV 2010)

Select one of the following:

0 Eligible

1 InEligible

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.5MG 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 200MG *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 ORD ITEM PKGS

----------------------------------------------------------------------------------------------------------------------------------------------------------------

84241 ACARBOSE 50MG TAB (SAMPLE) HS502 9P 00026-2861-51 BT TAB 100 U2 ACARBOSE OUX

83605 ACETAMINOPHEN 120MG SUPP RTL CN103 9P 45802-0730-32 BX SUPP 50 AR ACETAMINOPHEN OUX

3958 ACETAMINOPHEN 120MG/CODEINE 12MG ELIX CN101 5AB 00536-0082-85 ML 480 ML OX

84130 ACETAMINOPHEN 120MG/CODEINE 12MG ELIXIR CN101 3AB 00121-0504-16 BT ML 473 ML ACETAMINOPHEN 120MG/CODEINE 12 OXN

84564 ACETAMINOPHEN 120MG/CODEINE 12MG ELX U/D CN101 3 00121-0504-05 CS EA 500 ML ACETAMINOPHEN 120MG/CODEINE 12 UN

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 ACARBOSE 50MG TAB (SAMPLE) 50 IO

83605 ACETAMINOPHEN 120MG SUPP RTL 120 I

240 I

1 SUPPOSITORY(IES) Both

2 SUPPOSITORY(IES) Both

3958 ACETAMINOPHEN 120MG/CODEINE 12MG ELIX

84130 ACETAMINOPHEN 120MG/CODEINE 12MG ELIXIR 1 ML Both

2 MLS Both

1 TEASPOONFUL Both

2 TEASPOONFULS Both

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 05/20/2010 09:58 Page: 1Report Criteria: (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/201004/30/2010 1665228 ORIGINAL REFRESH LIQUIGEL 1% OPH 15ML 15 04/27/201004/30/2010 1665265 ORIGINAL CEPHALEXIN 500 MG CAPSULE** 14 04/27/201004/30/2010 1523338H ORIGINAL LEVOTHYROXINE 0.125 MG (BROWN) TAB 30 04/30/201004/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// NOSelect Pharmacy Division: BUSY// 2906 Select one of the following: 1 VA Drug Class 2 DrugSort By: // 2 DrugWould you like all drugs? Yes// YESSuppress printing drug names in header? Yes// NODEVICE: HOME// Virtual

BUSY "Total Drugs Dispensed" List Page 1Date of Listing: 05/20/10 By: DrugOutpatient Drugs dispensed from 05/15/2010 through 05/20/2010Total Number of Days = 6Drugs Selected ----> All Drugs

Number Type of UnitsDrug Name of Rx's Dispensed Total______________________________________________________________________________

ACCU-CHEK AVIVA TEST STRIP 23 STRIP 2300ACETAMINOPHEN 325MG TAB*(TYLENOL) 9 TAB 860ACETAMINOPHEN 80MG CHEW TAB 1 TAB 30ACETAMINOPHEN 80MG/0.8ML SOLN 4 ML 60ACETAZOLAMIDE 250MG TAB* 1 TAB 15ACETYLCYSTEINE 20% SOLN 30ML 1 ML 20ADVAIR HFA 230/21 1 GM 12ALBUTEROL 2.5MG/NS (0.083%) INH SOLN 3 ML 273ALBUTEROL HFA-INH (PROVENTIL 6.7GM) 27 GM 187.6ALCOHOL SWABS 12 SWAB 2200ALENDRONATE 70MG TAB 4 TAB 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 9am 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 HOSPITALRX RELEASE DATE RANGE: Apr 20, 2010 - May 20, 2010Total Prescriptions Dispensed: 10561 RX COUNT ACT % TOTAL ADJ % TOTAL**AM Prescriptions Dispensed********************************Total RX's Before 8:00: 15 0 NATotal RX's 8:00- 8:59: 517 5 NATotal RX's 9:00- 9:59: 1043 10 10Total RX's 10:00-10:59: 1077 10 11Total RX's 11:00-11:59: 1039 10 10**PM Prescriptions Dispensed********************************Total RX's 12:00-12:59: 994 9 10Total RX's 1:00- 1:59: 1062 10 11Total RX's 2:00- 2:59: 1170 11 12Total RX's 3:00- 3:59: 1044 10 10Total RX's 4:00- 4:59: 1316 12 13Total RX's 5:00- 5:59: 981 9 10Total RX's 6:00- 6:59: 303 3 3Total RX's 7:00- 7:59: 0 0 0Total RX's 8:00- 8:59: 0 0 0Total RX's 9:00- 9:59: 0 0 0Total RX's 10:00-10:59: 0 0 0Total RX's 11:00-11:59: 0 0 0 ________ ________ ________ 10561 100% 100% ***SUMMARY***ACT Total-All Hours: 10561 ADJ Total After 9:00 AM: 10029ACT 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