1 / 61

Management Reports

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

calvin
Download Presentation

Management Reports

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Management Reports

  2. 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 • 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

  3. 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 CI 140557 Select PATIENT NAME: Profile Expiration/Discontinued Cutoff: (0-9999): 120// DEVICE: 0;132;999 VT Press Return to Continue or "^" to Exit:

  4. 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-555-3312 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/Supply Rx# Status Expiration Provider Date Classification: 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.00 Classification: 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!

  5. 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 4 ACETAMINOPHEN 120MG SUPP 0.1180 Apap Tylenol 059439011612 ACETAMINOPHEN 160MG/5ML SOLN 9 0.0061 Tylenol Apap 000904198520 ACETAMINOPHEN 325MG TAB 9P 0.0390 Apap Tylenol 051079000220

  6. 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

  7. 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 LABOR DATE 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 24 04-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

  8. 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 05-19-10 MINIMUM DRUG COUNT OF 1 Pg: 1 ENTRY NUMBER DRUG QUANTITY FILLS ------------------------------------------------------------------------------ Division: DEMO HOSPITAL 348 CARBAMAZEPINE 200MG *PLAIN* TAB 60 2 263 ACETAMINOPHEN 325MG TAB 50 1 85832 AMOX/CLAV 250/125MG TAB (30'S) PREPACK 30 1 83611 AMOXICILLIN 250MG/5ML SUSP (150ML) 150 1 84490 AMOXICILLIN= 250MG CAP 30 1 1342 FOLIC ACID= 1MG TAB 30 1 83870 GLYBURIDE= 5MG TABLETS 30 1 84852 METFORMIN= 500MG *PLAIN* TABS 60 1

  9. 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 Costs Division Costs by Drug Drug Costs Drug Costs by Division 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

  10. Sample reports Drug Costs by Clinic for the period: APR 2010 to MAY 20,2010 Run Date: MAY 19,2010 Page: 1 Orign Total TotalAvg Cost Clinic 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,2010 Run Date: MAY 19,2010 Page: 1 Orgin Total TotalTotalAvg Cost Drug Fills Refills Fills Qty Cost per Fill ----------------------------------------------------------------------------------------------- Division: DEMO HOSPITAL ACETAMINOPHEN 325MG TAB 1 0 1 50.00 1.95 1.95 CARBAMAZEPINE 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

  11. Drug Costs by Division for the period: APR 2010 to MAY 20,2010 Run Date: MAY 19,2010 Page: 1 Orign Total 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 Total Avg Cost Division by Provider Fills Refil Fills Cost per Fill -------------------------------------------------------------------------------- Division: DEMO HOSPITAL NIESEN,MARY ANN 1 0 1 1.95 1.95 USER,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 Drug for the period: APR 2010 to MAY 20,2010 Run Date: MAY 19,2010 Page: 1 Orign Total Total Avg Cost Drug Fills Refil Fills Cost per Fill -------------------------------------------------------------------------------- ACETAMINOPHEN 325MG TAB 1 0 1 1.95 1.95 CARBAMAZEPINE 200MG *PLAIN* TAB 1 0 1 3.00 3.00 ----- ----- ----- ---------- -------- Total 2 0 2 4.95 2.48

  12. Drug Costs by Drug by Provider for the period: APR 2010 to MAY 20,2010 Run Date: MAY 19,2010 Page: 1 Orign Total Total Avg Cost Drug by Provider Fills Refil Fills Cost per Fill -------------------------------------------------------------------------------- DRUG: ACETAMINOPHEN 325MG TAB NIESEN,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* TAB USER,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 1 Run 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)

  13. Drug Costs by Patient Status for the period: APR 2010 to MAY 20,2010Run Date: MAY 20,2010 Page: 1Orign Total TotalAvg 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 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 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,2010 Run Date: MAY 20,2010 Page: 1 Orign Total Total Avg Cost Provider by Drug Fills Refil Fills Cost per Fill -------------------------------------------------------------------------------- Provider: NIESEN,MARY ANN ACETAMINOPHEN 325MG TAB 1 0 1 1.95 1.95 ----- ----- ----- ---------- -------- Total for NIESEN,MARY ANN 1 0 1 1.95 1.95 ----- ----- ----- ---------- --------

  14. Drug Costs by Provider for the period: APR 2010 to MAY 20,2010 Run Date: MAY 20,2010 Page: 1 Orign Total Total Avg Cost Provider Fills Refil Fills Cost per Fill -------------------------------------------------------------------------------- NIESEN,MARY ANN 1 0 1 1.95 1.95 USER,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 AVE FILLED DATE REQUESTS COST/REQUEST FILLS/REQUEST -------------------------------------------------------------------------------- MAY 7,2010 1 3.00 1.00 ------- ----------- ----------- TOTAL 1 3.00 1.00

  15. 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 86 SC 0 0 0 A&A 0 0 0 OTHER 0 0 0 NVA 0 0 0 CNTLD 0 86 212 METHA 0 0 0 PAT REQ 0 2312 6341 FEE 0 0 0 STAFF 0 6358 17423 NEW 0 3597 10221 REFILL 0 2761 7202 WINDOW 0 5509 15151 MAIL 0 849 2272 Sub Totals ========= ========= ========= 0 21515 58908

  16. 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 ------------------------------------------------------------------------ 000001000101 DIPHEN/MAALOX/LIDO 1:1:1 000003362412 ATAZANAVIR 150 MG CAPSULE N/F 000006408400 ANTIVENIN, SPIDER BITE INJECTION 000006778203 PHYTONADIONE 10MG/ML INJECTION 000006778433 PHYTONADIONE 1MG/0.5ML INJECTION 000008092355 PANTOPRAZOLE 40MG INJECTION 000011834109 DIMERCAPROL 100MG/ML INJECTION 000023050650 POLYVINYL ALCOHOL/POVIDONE DROPS N/F

  17. 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 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

  18. 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 INACTIVE NUMBER 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

  19. 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 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:

  20. 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)

  21. (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 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 FEE DATE 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

  22. 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 • Superseded by some EHR reports Select Output Reports Option: MEDication Profile Select PATIENT NAME: DEMO,CAROL <A> F 02-22-1991 XXX-XX-4789 CI 140557 LONG or SHORT: SHORT// Sort by DATE, CLASS or MEDICATION: DATE// All Medications or Selection (A/S): All// DEVICE: HOME// VT Right Margin: 80//

  23. DEMO,CAROL ID#: 140557 6110 RAPE RD DOB: FEB 22,1991 MIMS PHONE: 555-555-3312 FLORIDA 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

  24. 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 TOTALTOTAL 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

  25. 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 1 RX # DRUG QTY PROVIDER FILL DATE PATIENT ID# ------------------------------------------------------------------------------------------ 50021237 APAP 300MG & CODEINE 30MG TABL 20 PAYNE, I.M.A. MAY 19,2009 FROST,JACQUELINE J 526132250 1654957 APAP 300MG & CODEINE 30MG TABL 20 ACHE, TOOTH MAY 19,2009 FLAKE, SNOW LYNN 526956326

  26. 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 DISPENSE NUMBER 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

  27. 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

  28. Non-VA Meds Usage Report 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-555-7402 Non-VA Med: LISINOPRIL Dispense Drug: LISINOPRIL 10MG TABLET Dosage: 10MG 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 ==============================================================

  29. 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

  30. 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 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 DO982312 ----------------------------------------------------------------------------------------------------------------- Total Number of Patients: 736 Total Number of Rxs: 7660 Average Rxs per Patient: 10

  31. 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 Released Status Copay -------------------------------------------------------------------------------- 1567788A Refill #2 MAY 13,2010 Yes Active 1611710 Refill #4 MAY 13,2010 Yes Active 1597791A Refill #5 MAY 13,2010 Yes Active 1505999E Refill #7 MAY 13,2010 Yes Active 1613309A Refill #7 MAY 13,2010 Yes Active 1622750 Refill #1 No Active 1623751 Refill #5 MAY 13,2010 Yes Active 1623753 Refill #5 MAY 13,2010 Yes Active 1624926 Refill #3 MAY 13,2010 Yes Active 1624929 Refill #6 MAY 13,2010 Yes Active 1624935 Refill #7 MAY 13,2010 Yes Active 1625617 Refill #3 MAY 13,2010 Yes Active

  32. 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

  33. 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

  34. 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 C5'S 3 All Drug Class Types: // 3 All DEVICE: HOME// 0;132

  35. CDUR Controlled Drug Use Report IHS HOSPITAL CONTROLLED DRUG USE LIST (By Drug Order) Page 10 DATE OF LISTING: 03/17/2009 Drug Class: C-II through C-V All Divisions for: IHS HOSP Division: 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 11 DATE OF LISTING: 03/17/2009 Drug Class: C-II through C-V All Divisions for: IHS HOSP Division: 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

  36. 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-64 REACTIONS: ASPIRIN, METHOTREXATE, REGLAN RX# 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 |_____|_____|_____|

  37. 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//

  38. 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

  39. 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

  40. 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 300MG & CODEINE 30MG TABLET**Qty: 20Provider: PROVIDER,BETA Division: IHS HOSPITAL NEW RX D/Time: 03/20/2009 08:13 Rx #: 1041968 Name: PATIENT,JANE D Chart #: 13274 DRUG: SALSALATE 750MG TABLET** Qty: 120 Provider: PROVIDER,BETA Division: IHS HOSPITAL NEW RX D/Time: 03/20/2009 08:13 Rx #: 1040969 Name: PATIENT,JOSE YAZZIE Chart #: 1342 DRUG: ASPIRIN 81MG TAB,EC Qty: 30 Provider: PROVIDER,ALPHA Division: IHS HOSPITAL NEW RX D/Time: 03/20/2009 08:17 Rx #: 1040970 Name: PATIENT,JOSE YAZZIE Chart #: 1342 DRUG: CALCIUM 600MG/VIT D 400IU TAB Qty: 60 Provider: PROVIDER,ALPHA Division: IHS HOSPITAL NEW RX D/Time: 03/20/2009 08:17

  41. 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 300MG 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

  42. 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 Page 1 MAY 20,2010 For "All Drugs" Division: IHS HOSPITAL Dispensing Storage Drug Name Location Location ---------- ---------------------- -------- ACARBOSE 25MG TAB ACARBOSE 50 MG TABLET ACCU-CHECK AVIVA STRIP 50/BOX ACETAMINOPHEN (TYLENOL) 325MG TABLET** ACETAMINOPHEN 120MG SUPP,RTL ACETAMINOPHEN 160MG/5ML SUSP,ORAL ACETAMINOPHEN 160MG/5ML U/D ACETAMINOPHEN 325MG SUPP,RTL ACETAMINOPHEN 325MG TAB U/D ACETAMINOPHEN 650MG SUPP,RTL ACETAMINOPHEN 80MG CHEW TAB

  43. 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 4 DATE OF LISTING: 05/20/2010 Division: SATELLITE HC 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 325MG TAB,EC, PATIENT CHART DATE NAME NUMBER DISPENSED QTY MD _______________________________________________________________________________ PATIENT,HYPERTENSION 30280 04/23/2010 90 DOCTOR,ALPHA MALE PATIENT,ADULT MALE 33451 05/17/2010 30 DOCTOR,ALPHA FEMALE

  44. 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

  45. 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

  46. 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 Page 1 MAY 20,2010 For "All Drugs" Division: SELLS HOSPITAL Dispense Current Drug Name Unit Inventory --------- --------- --------- ADDERALL 5 MG TABS TAB 6,009 ADDERALL XR 10MG CAP CAP 0 ADDERALL XR 20MG CAP CAP 0 ADDERALL XR 30MG CAP CAP 0 COCAINE HCL 4% TOPICAL SOLN ML 99,989 CODEINE SULFATE 30MG TAB TAB 99,993,934 DEXTROAMPHETAMINE 10 MG SR CAPSULE CAP -14,299 DEXTROAMPHETAMINE 15 MG SR CAPSULE CAP -5,727 DEXTROAMPHETAMINE 5 MG SR CAPSULE CAP 95,009 DEXTROAMPHETAMINE 5 MG TAB TABLET 97,036 FENTANYL 100 MCG/HR TRANSDERMAL PATCH PATCH 889 FENTANYL 25 MCG/HR TRANSDERMAL PATCH PATCH -387

  47. 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)

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

  49. 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 | ---------------------------------------------------------------------------------------------------------------

  50. 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

More Related