Print Page as PDF
DBIA2095 ICR (2095)

DBIA2095    ICR (2095)

Name Value
NUMBER 2095
IA # 2095
FILE NUMBER 50
GLOBAL ROOT PSDRUG(
DATE CREATED 1997/09/04
CUSTODIAL PACKAGE PHARMACY DATA MANAGEMENT
CUSTODIAL ISC Birmingham
USAGE Private
TYPE File
DBIC APPROVAL STATUS APPROVED
NAME DBIA2095
GENERAL DESCRIPTION 
Drug Accountability/Inventory Interface (DA) v3.0
interfaces with the DRUG (#50) file to assist Pharmacy in maintaining a
perpetual inventory. DA contains two methods of maintaining the drug balances.
The site can either interface with the Generic Inventory Package (GIP) or with
the prime vendor's electronic invoice data. The DRUG file is used to store
matches between drugs and either an item in GIP or the NDC in the prime
vendor's invoice data. It is also used to identify matched drugs when they are
received and dispensed drugs via other VISTA Pharmacy packages. When the
fields are read, it is by a direct global read. When the fields are written
to, it is by a FileMan DIE call.

Read fields:
============
GLOBAL MAP DATA DICTIONARY #50 -- DRUG FILE
--------------------------------------------------------------------------
^PSDRUG(D0,0)= (#.01) GENERIC NAME [1F] ^ ^ ^ ^ ^ (#6) FSN [6F] ^ ^ ^
==>(#51) NON-FORMULARY [9S] ^ ^ ^PSDRUG(D0,1,0)=^50.1A^^  (#9)
SYNONYM ^PSDRUG(D0,1,D1,0)= (#.01) SYNONYM [1F] ^ (#2) NDC CODE [2F] ^
==>(#1) INTENDED USE [3S] ^ (#400) VSN [4F] ^ (#401)
==>ORDER UNIT [5P] ^ (#402) PRICE PER ORDER UNIT [6N] ^
==>(#403) DISPENSE UNITS PER ORDER UNIT [7N] ^ (#404)
==>PRICE PER DISPENSE UNIT [8N] ^ (#405) VENDOR [9F] ^
^PSDRUG(D0,2)= ^ ^ (#63) APPLICATION PACKAGES' USE [3F] ^ (#31) NDC [4F] ^
^PSDRUG(D0,441,0)=^50.0441P^^  (#441) IFCAP ITEM NUMBER ^PSDRUG(D0,441,D1,0)=
(#.01) ITEM NUMBER [1P] ^ ^PSDRUG(D0,660)= ^ (#12) ORDER UNIT [2P] ^ (#13)
PRICE PER ORDER UNIT [3N]
==>^ ^ (#15) DISPENSE UNITS PER ORDER UNIT [5N] ^ (#16)
==>PRICE PER DISPENSE UNIT [6N] ^ ^ (#14.5) DISPENSE UNIT
==>[8F] ^ ^PSDRUG(D0,660.1)= (#50) CURRENT INVENTORY [1N] ^
^PSDRUG(D0,I)= (#100) INACTIVE DATE [1D] ^ ^PSDRUG(D0,ND)= (#20) NATIONAL DRUG
FILE ENTRY [1P] ^ (#21) VA PRODUCT
==>NAME ENTRY [2N] ^ (#22) PSNDF VA PRODUCT NAME ENTRY [3N] ^
==>(#23) PACKAGE SIZE [4P] ^ (#24) PACKAGE TYPE [5P] ^

Cross-references Read:
=====================
ITEM NUMBER(AB), VSN(AVSN), SYNONYM(C), VA PRODUCT NAME(VAPN), NDC(NDC)

Fields Written to:
==================
GLOBAL MAP DATA DICTIONARY #50 -- DRUG FILE
--------------------------------------------------------------------------
^PSDRUG(D0,0)= (#.01) GENERIC NAME [1F] ^ ^PSDRUG(D0,1,0)=^50.1A^^  (#9)
SYNONYM ^PSDRUG(D0,1,D1,0)= (#.01) SYNONYM [1F] ^ (#2) NDC CODE [2F] ^
==>(#1) INTENDED USE [3S] ^ (#400) VSN [4F] ^ (#401)
==>ORDER UNIT [5P] ^ (#402) PRICE PER ORDER UNIT [6N] ^
==>(#403) DISPENSE UNITS PER ORDER UNIT [7N] ^ (#404)
==>PRICE PER DISPENSE UNIT [8N] ^ (#405) VENDOR [9F] ^
^PSDRUG(D0,2)= ^ ^ ^ (#31) NDC [4F] ^ ^PSDRUG(D0,441,0)=^50.0441P^^  (#441)
IFCAP ITEM NUMBER ^PSDRUG(D0,441,D1,0)= (#.01) ITEM NUMBER [1P] ^
^PSDRUG(D0,660)=^ (#12) ORDER UNIT [2P] ^ (#13) PRICE PER ORDER UNIT [3N]
==>^ ^ (#15) DISPENSE UNITS PER ORDER UNIT [5N] ^ (#16)
==>PRICE PER DISPENSE UNIT [6N] ^^ (#14.5) DISPENSE UNIT [8F]
^PSDRUG(D0,660.1)= (#50) CURRENT INVENTORY [1N] ^


Three print templates are used to print two reports. PSADRIP and PSADRIH are
used to print the DRUG file/ITEM MASTER file Comparison Report from a selected
sort range The report contains information on packaging and pricing. PSADRIH
is the header on this report. PSADRI is used to print the Inquire/Compare DRUG
file/ITEM MASTER file report that compares the packaging and pricing between
the DRUG file and the ITEM MASTER file.
GLOBAL REFERENCE
GLOBAL REFERENCE FIELD NUMBER GLOBAL DESCRIPTION
PSDRUG(D0,0)
FIELD NUMBER ACCESS FIELD DESCRIPTION FIELD NAME LOCATION
.01 Read w/Fileman 
This is the generic name of the drug.
GENERIC NAME 0;1
51 Direct Global Read & w/Fileman 
This is used to designate the drug as non-formulary.
NON-FORMULARY 0;9 
This file holds the information related to each drug
that can be used to fill a prescription.  It is pointed to from several other
files and should be handled carefully, usually only by special individuals in
the pharmacy service. Entries are not typically deleted, but rather made
inactive by entering an inactive date.

This file must be built by Pharmacy Service BEFORE going on-line.  It is
common to use another centers file and edit it to match your center's unique
formulary.
PSDRUG(D0,1,D1,0)
FIELD NUMBER ACCESS FIELD DESCRIPTION FIELD NAME LOCATION
.01 Write w/Fileman 
This field is used as a quick code for look ups or to
locate NDCs so the drug's inventory can be incremented when orders are
received.
SYNONYM 0;1
1 Write w/Fileman 
If you designate a synonym as a quick code, then it will
not appear on the formulary listing for distribution in the hospital.  If it
is designated as a trade name, then it will appear on the listing.  This field
does not affect the ability to look-up a drug by quick code or trade name.

If the intended use is for Controlled Substances or Drug Accountability, the
synonym is used to locate NDCs so the drug's inventory can be incremented when
orders are received.
INTENDED USE 0;3
2 Write w/Fileman 
This field will contain the national drug code.
NDC CODE 0;2
400 Write w/Fileman 
This is the vendor's stock number for the NDC.
VSN 0;4
401 Write w/Fileman 
This is the NDC's unit of order.
ORDER UNIT 0;5
402 Write w/Fileman 
This is the price for one unit of order.
PRICE PER ORDER UNIT 0;6
403 Write w/Fileman 
This is the number of dispense units in one order unit.
DISPENSE UNITS PER ORDER UNIT 0;7
404 Write w/Fileman 
This is the cost of one dispense unit.
PRICE PER DISPENSE UNIT 0;8
405 Write w/Fileman 
This is the name of the vendor from which the drug was
purchased.
VENDOR 0;9 
This multiple contains the Synonym, NDC Code, Intended
Use, VSN, Order Unit, Price per Order Unit, Dispense Units per Order Unit,
Price per Dispense Unit, and Vendor fields. It is used for a quick code for
look ups or to locate NDCs to increment the drug's inventory when orders are
received.
PSDRUG(D0,2)
FIELD NUMBER ACCESS FIELD DESCRIPTION FIELD NAME LOCATION
63 Direct Global Read & w/Fileman 
This field is free text, but contains the codes of the
DHCP packages that consider this drug part of its formulary.  This field is
set through the routine ^PSGIU, and NOT through VA FileMan.
APPLICATION PACKAGES' USE 2;3
31 Write w/Fileman 
This is the National Drug Code for this drug.
NDC 2;4 
This global node contains the drug restriction, which
VISTA applications are using the drug, the primary NDC, and a pointer to the
PRIMARY DRUG file (#50.3).
PSDRUG(D0,441,0)
FIELD NUMBER ACCESS FIELD DESCRIPTION FIELD NAME LOCATION
.01 Write w/Fileman 
This field contains any or all items in the ITEM MASTER
file that relate to this drug.  This relationship will enable automated
receiving from the IFCAP Inventory module.
ITEM NUMBER 0;1 
With the "AB" cross reference this multiple will be used
when PRCP routines pass receiving data to PSA routines.
PSDRUG(D0,660)
FIELD NUMBER ACCESS FIELD DESCRIPTION FIELD NAME LOCATION
12 Write w/Fileman 
This is the order unit for this drug.
ORDER UNIT 660;2
13 Write w/Fileman 
This is the price per order unit for this drug.
PRICE PER ORDER UNIT 660;3
15 Write w/Fileman 
This is the dispense units per order unit for this drug.
DISPENSE UNITS PER ORDER UNIT 660;5
16 Write w/Fileman 
This is the dispense units per order unit for this drug.

NOTE: This field is set with a TRIGGER when the PRICE PER ORDER UNIT is set.
PRICE PER DISPENSE UNIT 660;6
14.5 Write w/Fileman 
This is the dispense unit for this drug.
DISPENSE UNIT 660;8 
This global node contains packaging, dispense unit,
pricing, reordering levels, and source data.
PSDRUG(D0,660.1)
FIELD NUMBER ACCESS FIELD DESCRIPTION FIELD NAME LOCATION
50 Write w/Fileman 
This field contains the current number of the drug in
stock.
CURRENT INVENTORY 660.1;1 
This node contains the total number of dispense units
that are in inventory for all sites using this DRUG file.
PSDRUG(D0,'I')
FIELD NUMBER ACCESS FIELD DESCRIPTION FIELD NAME LOCATION
100 Direct Global Read & w/Fileman 
This is the date the drug is inactive.
INACTIVE DATE I;1 
This global node contains the date the drug will be or
was made inactive.
PSDRUG(D0,'ND')
FIELD NUMBER ACCESS FIELD DESCRIPTION FIELD NAME LOCATION
20 Direct Global Read & w/Fileman 
This is the pointer to the National Drug file (^PSNDF).
NATIONAL DRUG FILE ENTRY 'ND';1
22 Direct Global Read & w/Fileman 
This is the index of the VA Product Name in the National
Drug file.
PSNDF VA PRODUCT NAME ENTRY 'ND';3
23 Direct Global Read & w/Fileman 
This is the pointer to the Package Size file.
PACKAGE SIZE 'ND';4
24 Direct Global Read & w/Fileman 
This is the pointer to the Package Type file.
PACKAGE TYPE 'ND';5 
This global node contains NATIONAL DRUG FILE (50.6)
links and packaging data.
STATUS Active
DURATION Till Otherwise Agreed
ID PSDRUG(
SUBSCRIBING PACKAGE
SUBSCRIBING PACKAGE ISC
DRUG ACCOUNTABILITY Birmingham