Re: [Hardhats-members] I need help with pharmacy issues.

MPA Fri, 29 Apr 2005 10:11:16 -0700

Kevin,

Rick M is looking at simple patch to be included with a patching project he is involved with.

Mark

Kevin Toppenberg wrote:

Mark,
Thanks for your feedback.  The looping you describe
would be helpful for stuff like setting the
out-of-service date on all pills, but it will not help
with creating the appropriate links between File50 and
PHARMACY ORDERABLE ITEM file.
I like your idea about the automatic update etc.  I
had talked to someone (perhaps you?) about a
commercial service for maintaining one's drug file.  I
don't know if that ever got off the ground.
Thanks for the info about the National Drug File
patches.  I'll need to get those.  The question then
becomes how those entries get into my Drug50 file.  I
used the menu option to copy from the National Drug
File to my local Drug50 file, but I don't think it
really did anything, because I see that there are
15,000 records inthe National Drug file, and only
5,000 in my Drug50 file.
Is Jim's patch open-source?
Thanks
Kevin
--- MPA <[EMAIL PROTECTED]> wrote:
Kevin,
I suspect that this is what you have done, if not this is how I approach editing issues in many of the pharmacy files I work on (or any file), please beware that this method is not always appropriate for some editing.

Since the Drug file (50) points to Pharmacy Orderable Item file (50.7) you can use FM to edit File50 based on parameters in a edit loop as follows: Lets say that you wanted to manual edit the Generic Name field and the Inactive Date field of all drugs that are Tablets After you do the ^LOOP in the Select prompt you just need to enter either "Pharmacy Orderable Item:" or "2.1:" which will then put you in File 50.7 to select the next parameter. The ".02" field is Dosage Form.

The ^LOOP along with the "///" stuff convention allows one to force values into fields quickly and painlessly. (I didn't give an example of this for I didn't want to edit any fields in my database, just be careful in the /// stuff you can get in trouble quickly.) If you wanted to change the INACTIVE DATE to today for all drugs that had Tablet in the Dosage form field of file 50.7 you would just need to change the THEN EDIT FIELD prompt to:

EDIT WHICH FIELD: ALL//INACTIVE DATE///T - Then when LOOPING FM will put todays date into the INACTIVE DATE field of all drugs that meet the criteria.

There are Drug files out there that will have all this done for a user. The soon to be released VistAOfficeEHR will have it and a couple of other places (the HUI has done a couple of nice things related to meds maybe somebody there will comment). We will have our File50 cleaned up to about 2500 items (estimated) and are working on an auto update service to add new medications to File50 as the are released by the FDA along with herbals and some supplies as they reach market so they would be available to a MD for medication entry. We are also trying to address some drug safety issues like TALLman lettering, look alike sound alike, PMI sheets plus addressing NDC and GCN codes to name a few.

The National Drug File is updated via the patch stream you just need to get the appropriate patch last month the VA released the following to NDF patches. You would just install them via the patch process, we use something Jim work on that he calls Simple Patch, pertly straight forward.
  National Drug File - PSN
                PSN-4_SEQ-90_PAT-95.TXT
                PSN-4_SEQ-91_PAT-97.TXT
Hope this is what you are looking for now.
Mark
*EXAMPLE*
VA FileMan 22.0
Select OPTION: ENTER OR EDIT FILE ENTRIES
INPUT TO WHAT FILE: DRUG//
EDIT WHICH FIELD: ALL// GENERIC NAME
THEN EDIT FIELD: INACTIVE DATE
THEN EDIT FIELD:
Select DRUG GENERIC NAME: *^LOOP*
EDIT ENTRIES BY: GENERIC NAME// *2.1:*
PHARMACY ORDERABLE ITEM FIELD: *.02*  DOSAGE FORM
START WITH DOSAGE FORM: FIRST// *TAB*
GO TO DOSAGE FORM: LAST// *TABX*
 WITHIN DOSAGE FORM, EDIT ENTRIES BY:
...HMMM, JUST A MOMENT PLEASE...
ZZAZATHIOPRINE 50MG TAB 10-06-00 USE ENTRY WITH CORRECT SPELLING GENERIC NAME: ZZAZATHIOPRINE 50MG TAB Replace INACTIVE DATE: OCT 6,2000//

ZZBUSULFAN 2MG TAB AN100 10-06-00 NONE IN STOCK GENERIC NAME: ZZBUSULFAN 2MG TAB// INACTIVE DATE: OCT 6,2000//
  ZZMELPHALAN 2MG TAB         AN100       03-09-01
GENERIC NAME: ZZMELPHALAN 2MG TAB// ^
WANT TO STOP LOOPING? Yes//   (Yes)
   LOOP ENDED!
Select DRUG GENERIC NAME:
Kevin Toppenberg wrote:
I have been spending a fair amount of time lately figuring out the small portion of the pharmacy

package
that allows one to order a drug from CPRS.
I have put my understanding of four key files here:
http://openforum.worldvista.org/~forum/index.php?title=Pharmacy_Issues

-- especially the first two sections. Following these steps, I have been able to get a few drugs to show up in CPRS, and I can successfully order them

for
a patient.
Feeling that I was ready to try to get *all* the
drugs
available, I have worked on the following steps
1. Scan through all the VA DRUG CLASSes to see if
there are some general classes I don't want (for
example, bandages, investigational etc.)
2. Scan through all drugs in the DRUG file (#50),
and

exclude all those belonging to an excluded class,

or
with invalid records.
3. Group entries differing only by dose -- i.e.
AMOXICILLIN 250 and AMOXICILLIN 500 are combined.
My plan was to then to create one PHARMACY
ORDERABLE
ITEM record and link relevent entries from the DRUG
file to it.
The problem I have run up against is that records
in

the DRUG file don't appear to have the drug form

(i.e.

tablet, capsule, elixer) stored as a separate

field.

Instead, it is stored as free text in the name--and the nominclature is inconsistent. I have to have

this

information when creating the PHARMACY ORDERABLE

ITEM

record. The information IS in the VA PRODUCT file, but I can't see how to find the associated record

in
that file, given an entry in the DRUG file.
But the big picture of all this is that I am having trouble doing this manually. I know that there is
a

"proper" way to do this, namely with option PSA

DRUG

ENTER/EDIT. The problem with this, though, is that

it

wants the user to carefully pick through the

details

of every drug. I don't have the time to do this. There are 5000+ entries in the DRUG file. At 1 minute/drug, we're talking about 80+ solid hours of work. Plus, it keeps asking me for national-drug-codes that I have no effecient way of supplying.

In a pharmacy situation, one must be that careful

with

tracking drug quantity on hand etc. etc., but I

just
want the names to be available in CPRS so I can
indicate what my patient is taking.
=== message truncated ===
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
-------------------------------------------------------
SF.Net email is sponsored by: Tell us your software development plans!
Take this survey and enter to win a one-year sub to SourceForge.net
Plus IDC's 2005 look-ahead and a copy of this survey
Click here to start!  http://www.idcswdc.com/cgi-bin/survey?id=105hix
_______________________________________________
Hardhats-members mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hardhats-members


-------------------------------------------------------
This SF.Net email is sponsored by: NEC IT Guy Games.
Get your fingers limbered up and give it your best shot. 4 great events, 4
opportunities to win big! Highest score wins.NEC IT Guy Games. Play to
win an NEC 61 plasma display. Visit http://www.necitguy.com/?r=20
_______________________________________________
Hardhats-members mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hardhats-members

Re: [Hardhats-members] I need help with pharmacy issues.

Reply via email to