Skip navigation
Up to Discussions in Pharmacy

This Question is Possibly Answered

1 "correct" answer available (4 pts) 2 "helpful" answers available (2 pts)
3,599 Views 4 Replies Last post: Jan 15, 2009 4:35 PM by Laurie Larson RSS
jrk1128 Contributor
jrk1128
9 posts since
Nov 20, 2008
Currently Being Moderated

Jan 6, 2009 8:19 AM

Can a Listing of Formulary Drugs be produced?

On a yearly basis, Will is asked to produce a listing of formulary drugs for P&T comittee approval.

He would also like to be able to format the list as to VA classification with the Orderable item and its linked generic drugs for attachment to "Tools" in CPRS.

 

AN100 -> Antibiotics: Piperacillin/tazobactam-> piperacillin 4 gm/Tazobactam 0.5gm

                                                                      piperacillin 3 gm/Tazobactam 0.375gm

                                                                      piperacillin 2gm/Tazobactam 0.25gm

Tags: meds, openvista, pharmacy_reports, report_writer
Terry Meehan. RPh Medspherian
Terry Meehan. RPh
18 posts since
Sep 11, 2008
Currently Being Moderated
1. Jan 7, 2009 7:50 AM in response to: jrk1128
Re: Can a Listing of Formulary Drugs be produced?

What about using AHFS class, instead of VA class as the therapeutic grouping atttribute...or should that be configurable?

RxNorm classification could be another option thinking down the road.

jrk1128 Contributor
jrk1128
9 posts since
Nov 20, 2008
Currently Being Moderated
2. Jan 7, 2009 8:09 AM in response to: Terry Meehan. RPh
Re: Can a Listing of Formulary Drugs be produced?

For formulary purposes, format,content and output should be configurable, because there will be several uses for the information and where it will be used.

AHFS# or other classifications would be acceptable as long as they are loaded by Medsphere, but that should be decided before the report is run.

Roy Gryskevich Medspherian
Roy Gryskevich
21 posts since
Sep 11, 2008
Currently Being Moderated
3. Jan 15, 2009 8:02 AM in response to: jrk1128
Re: Can a Listing of Formulary Drugs be produced?

There is a Formulary information report that can be run.  It is selectable within the Pharmacy Data Management option.  This report lists all items within drug file #50 and to which package(s) they are marked.  You likely only want to report those items that are marked for the Unit Dose and IV packages.  To accomplish that, you would probably need to run a fileman report.

Laurie Larson Senior Contributor
Laurie Larson
8 posts since
Sep 12, 2008
Currently Being Moderated
4. Jan 15, 2009 4:35 PM in response to: jrk1128
Re: Can a Listing of Formulary Drugs be produced?

Currently the only way to produce this kind of report is as Roy stated, running a fileman report to only include those items in your formularly that are marked with either a U for Unit Dose or I for IV.  When doing the print fields I recommend utilizing the VA Drug Class Code which will provide you with both the VA Classification as well as the description that you are looking for.  However, those are grouped together as one item when it gets imported into an EXCEL sheet which you could still sort on, however if you want just the numerical code you would need to also include the VA Classification by itself.  Here is a brief look at this output:

 

 

Generic NameVA ClassificationVA Drug Class Code
A & D OINT 60GM                         DE350 DE350 EMOLLIENTS                       
ACARBOSE 50MG TAB UD                    HS502 HS502 ORAL HYPOGLYCEMIC AGENTS,ORAL    
ACEBUTOLOL HCL 200MG CAP                CV100 CV100 BETA BLOCKERS/RELATED            
ACETAMINOPHEN 100MG/ML DROPS 15ML       CN103 CN103 NON-OPIOID ANALGESICS            

More Like This

  • Retrieving data ...

Bookmarked By (0)