STANDARD DATA DICTIONARY #728.113 -- IV EXTRACT DATA FILE 3/24/25 PAGE 1
STORED IN ^ECX(728.113, *** NO DATA STORED YET *** SITE: WWW.BMIRWIN.COM UCI: VISTA,VISTA (VERSION 3.0)
DATA NAME GLOBAL DATA
ELEMENT TITLE LOCATION TYPE
-----------------------------------------------------------------------------------------------------------------------------------
This file holds data from the IV module of the Inpatient Medications package to be extracted by the DSS software. Data is entered
into this file by routine ECXPIV1 which is called by statistics options in the IV module. Data is deleted from this file after it
is extracted in a form to be shipped to the commercial software.
Data in this file should not be entered, edited, or deleted through direct access via VA FileMan.
CROSS
REFERENCED BY: ORDER NUMBER(A), EXTRACT NUMBER(AC), SEQUENCE NUMBER(AINV), ORDER NUMBER(AREV)
728.113,.01 SEQUENCE NUMBER 0;1 NUMBER (Required)
Sequence Number
INPUT TRANSFORM: K:+X'=X!(X>100000)!(X<1)!(X?.E1"."1N.N) X S:$D(X) DINUM=X
LAST EDITED: SEP 19, 1996
HELP-PROMPT: Enter a number between 1 and 999999999, 0 decimal digits.
DESCRIPTION:
The record number for this extract entry.
TECHNICAL DESCR:
The internal entry number (IEN) for this record. This entry is DINUMed.
UNEDITABLE
NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY PROGRAMMER
CROSS-REFERENCE: 728.113^AINV^MUMPS
1)= S ^ECX(728.113,"AINV",-X,DA)=""
2)= K ^ECX(728.113,"AINV",-X,DA)
3)= DO NOT DELETE.
This is an inverse entry cross reference. It is used to find the last entry in the file. It is
essential for the management of the data held in this file.
728.113,1 DFN 0;2 POINTER TO PATIENT FILE (#2)
Patient Number
LAST EDITED: SEP 19, 1996
HELP-PROMPT: Enter the name of the patient for this extract record.
DESCRIPTION:
Enter the name of the patient receiving medication for this extract record.
TECHNICAL DESCR: Derived from the NAME field (.01) in the PHARMACY PATIENT file (#55) which is DINUMed to the
PATIENT file (#2). This data represents the patient DFN.
UNEDITABLE
728.113,2 ORDER NUMBER 0;3 NUMBER
Order Number
INPUT TRANSFORM: K:+X'=X!(X>99999)!(X<1)!(X?.E1"."1N.N) X
LAST EDITED: NOV 18, 1996
HELP-PROMPT: Enter a number between 1 and 99999, 0 decimal digits.
DESCRIPTION:
This is the internal entry number of the order.
TECHNICAL DESCR: Derived from the ORDER NUMBER field (.01) within the IV multiple (100) of the PHARMACY PATIENT file
(#55).
UNEDITABLE
CROSS-REFERENCE: 728.113^A^MUMPS
1)= S ^ECX(728.113,"A",$P($P(^ECX(728.113,DA,0),"^",5),"."),$P(^ECX(728.113,DA,0),"^",2),X,DA)=""
2)= K ^ECX(728.113,"A",$P($P(^ECX(728.113,DA,0),"^",5),"."),$P(^ECX(728.113,DA,0),"^",2),X,DA)
3)= DO NOT DELETE
This cross reference, DATE/TIME, DFN, ORDER NUMBER is used to extract data from this file into the
IV DETAIL EXTRACT file (#727.819).
CROSS-REFERENCE: 728.113^AREV^MUMPS
1)= S ^ECX(728.113,"AREV",9999999-($P($P(^ECX(728.113,DA,0),"^",5),".")),$P(^ECX(728.113,DA,0),"^",
2),X,DA)=""
2)= K ^ECX(728.113,"AREV",9999999-($P($P(^ECX(728.113,DA,0),"^",5),".")),$P(^ECX(728.113,DA,0),"^",
2),X,DA)
3)= DO NOT DELETE
This inverse cross reference, DATE/TIME, DFN, ORDER NUMBER is used to identify dates prior to the
START DATE selected for the IV DETAIL EXTRACT.
728.113,3 DRUG 0;4 POINTER TO DRUG FILE (#50)
Drug
LAST EDITED: SEP 19, 1996
HELP-PROMPT: Enter the drug dispensed.
DESCRIPTION:
This is the item dispensed as identified in the local DRUG file (#50).
TECHNICAL DESCR: A pointer to the DRUG file (#50).
For an IV additive, DRUG is derived from the GENERIC DRUG field (1) in the IV ADDITIVES file
(#52.6) for the ADDITIVE (.01) identified in the ADDITIVE multiple (1) within the IV multiple (100)
of the PHARMACY PATIENT file (#55).
For an IV solution, DRUG is derived from the GENERIC DRUG field (1) in the IV SOLUTIONS file
(#52.7) for the SOLUTION (.01) identified in the SOLUTION multiple (3) within the IV multiple (100)
of the PHARMACY PATIENT file (#55).
UNEDITABLE
728.113,4 DATE/TIME 0;5 DATE
Date/Time
INPUT TRANSFORM: S %DT="ESTX" D ^%DT S X=Y K:Y<1 X
LAST EDITED: NOV 01, 1996
HELP-PROMPT: Enter the date/time this drug was dispensed.
DESCRIPTION:
This is the date/time of the transaction.
TECHNICAL DESCR: DATE/TIME is calculated and stored in the DATE OF TRANSACTION field (3) within the TRANSACTION
NUMBER multiple (1) of the IV STATS file (#50.8).
UNEDITABLE
728.113,5 TRANSACTION TYPE 0;6 SET
Transaction Type
'1' FOR DISPENSED;
'2' FOR RETURNED;
'3' FOR DESTROYED;
'4' FOR CANCELED;
LAST EDITED: SEP 19, 1996
HELP-PROMPT: Enter the status of the IV transaction.
DESCRIPTION:
This is the type of the transaction.
TECHNICAL DESCR: TRANSACTION TYPE defines the status of the IV order: 1 for dispensed, 2 for returned, 3 for
destroyed, or 4 for canceled. This data comes from the STATUS field (2) within the TRANSACTION
NUMBER multiple (1) of the IV STATS file (#50.8).
UNEDITABLE
728.113,6 ADDITIVE STRENGTH 0;7 FREE TEXT
Additive Strength
INPUT TRANSFORM: K:$L(X)>30!($L(X)<1) X
LAST EDITED: SEP 19, 1996
HELP-PROMPT: Your answer must be 1 to 30 characters in length.
DESCRIPTION:
This is the amount of the additive used in the manufacturing of this IV order.
TECHNICAL DESCR: Derived from the STRENGTH field (.02) within the ADDITIVE multiple (1) within the IV multiple (100)
of the PHARMACY PATIENT file (#55).
UNEDITABLE
728.113,7 ADDITIVE STRENGTH UNITS 0;8 FREE TEXT
Additive Strength Units
INPUT TRANSFORM: K:$L(X)>20!($L(X)<1) X
LAST EDITED: SEP 19, 1996
HELP-PROMPT: Your answer must be 1 to 20 characters in length.
DESCRIPTION:
This is the units in which the strength of this additive is measured.
TECHNICAL DESCR: Derived from the DRUG UNIT field (2) in the IV ADDITIVES file (#52.6) for the ADDITIVE (.01)
identified in the ADDITIVE multiple (1) within the IV multiple (100) in the PHARMACY PATIENT file
(#55).
UNEDITABLE
728.113,8 SOLUTION VOLUME 0;9 NUMBER
Solution Volume
INPUT TRANSFORM: K:+X'=X!(X>10000)!(X<1)!(X?.E1"."1N.N) X
LAST EDITED: SEP 19, 1996
HELP-PROMPT: Enter a number between 1 and 10000, 0 decimal digits.
DESCRIPTION:
The volume (in MLs) of this solution in this order.
TECHNICAL DESCR: Derived from the VOLUME field (1) within the SOLUTION multiple (3) within the IV multiple (100) of
the PHARMACY PATIENT file (#55).
UNEDITABLE
728.113,9 PROVIDER 0;10 FREE TEXT
Provider
INPUT TRANSFORM: K:$L(X)>12!($L(X)<1) X
LAST EDITED: SEP 19, 1996
HELP-PROMPT: Your answer must be 1 to 12 characters in length.
DESCRIPTION:
This is the provider responsible for this medication order.
TECHNICAL DESCR: Derived from the PROVIDER field (.06) within the IV multiple (100) of the PHARMACY PATIENT file
(#55). Provider is a pointer to the NEW PERSON file (#200).
UNEDITABLE
728.113,10 EXTRACT NUMBER 1;1 POINTER TO DSS EXTRACT LOG FILE (#727)
Extract Number
LAST EDITED: SEP 19, 1996
HELP-PROMPT: Enter the extract number for this medication dispensing action.
DESCRIPTION:
Pointer to the corresponding entry in the DSS EXTRACT LOG file (#727).
TECHNICAL DESCR: This entry and the corresponding cross reference are set when data is extracted from this file into
the IV DETAIL EXTRACT file (#727.819). The cross reference on this field is used to control
extracting data from this file and also used to permit purging of data in this file.
CROSS-REFERENCE: 728.113^AC
1)= S ^ECX(728.113,"AC",$E(X,1,30),DA)=""
2)= K ^ECX(728.113,"AC",$E(X,1,30),DA)
3)= DO NOT DELETE.
This cross reference is essential to manage the transfer of data from this file to the IV DETAIL
EXTRACT file (#727.819) and utimately to the commercial DSS software. It is also used to control
purging of this file.
728.113,11 TYPE 0;11 FREE TEXT
Type
INPUT TRANSFORM: K:$L(X)>5!($L(X)<1) X
LAST EDITED: SEP 19, 1996
HELP-PROMPT: Your answer must be 1 to 5 characters in length.
DESCRIPTION: The type of IV dispensed - A for admixture, C for chemotherapy, H for hyperal, P for piggyback, or
S for syringe.
TECHNICAL DESCR:
Derived from the TYPE field (.04) within the IV multiple (100) of the PHARMACY PATIENT file (#55).
728.113,12 COST 0;12 NUMBER
Cost
INPUT TRANSFORM: K:+X'=X!(X>99999)!(X<0)!(X?.E1"."4N.N) X
LAST EDITED: SEP 19, 1996
HELP-PROMPT: Enter a number between 0 and 99999, 3 decimal digits.
DESCRIPTION:
Cost of this item.
TECHNICAL DESCR: For an IV additive, COST is derived from the AVERAGE DRUG COST PER UNIT field (7) in the IV
ADDITIVES file (#52.6) for the ADDITIVE (.01) identified in the ADDITIVE multiple (1) within the IV
multiple (100) of the PHARMACY PATIENT file (#55).
For an IV solution, COST is derived from the AVERAGE DRUG COST field (7) in the IV SOLUTIONS file
(#52.7) for the SOLUTION (.01) identified in the SOLUTION multiple (3) within the IV multiple (100)
of the PHARMACY PATIENT file (#55).
728.113,13 CLINIC 0;13 POINTER TO HOSPITAL LOCATION FILE (#44)
LAST EDITED: JUL 13, 1998
DESCRIPTION: If the patient is an outpatient, this holds a pointer to the clinic where the outpatient visit was
held.
728.113,14 ORDER DATE 0;14 DATE
Order Date
INPUT TRANSFORM: S %DT="ESTX" D ^%DT S X=Y K:Y<1 X
LAST EDITED: OCT 14, 2005
HELP-PROMPT: Enter the date/time the order was made.
DESCRIPTION:
This is the date/time the medication was ordered.
TECHNICAL DESCR: Derived from the START DATE/TIME field (#.02) in the IV Multiple (file 55.01) of the PHARMACY
PATIENT file (#55).
728.113,15 IV ROOM 0;15 FREE TEXT
INPUT TRANSFORM: K:$L(X)>30!($L(X)<1) X
LAST EDITED: OCT 14, 2005
HELP-PROMPT: Answer must be 1-30 characters in length.
DESCRIPTION:
IV room where IV was prepared for administration.
TECHNICAL DESCR: The value is resolved by retrieving the value from Pharmacy Patient file (#55), IV Sub file
(#55.01), IV Room field (#.22) which is a pointer to IV ROOM file (#59.5).
728.113,16 VERIFICATION DATE 0;16 DATE
INPUT TRANSFORM: S %DT="ESTXR" D ^%DT S X=Y K:Y<1 X
LAST EDITED: OCT 14, 2005
DESCRIPTION: This is the date the order was acknowledged (through OE/RR) by the nurse if it exist, otherwise
this is the date and time the order was entered.
TECHNICAL DESCR: This value is retrieved from Pharmacy Patient file (#55), IV Subfile (#55.01), DATE VERIFIED BY
NURSE field (#17) if exist. Otherwise it uses LOGIN DATE/TIME field (#.21) and if it does not exist
it leaves it null.
FILES POINTED TO FIELDS
DRUG (#50) DRUG (#3)
DSS EXTRACT LOG (#727) EXTRACT NUMBER (#10)
HOSPITAL LOCATION (#44) CLINIC (#13)
PATIENT (#2) DFN (#1)
INPUT TEMPLATE(S):
PRINT TEMPLATE(S):
SORT TEMPLATE(S):
FORM(S)/BLOCK(S):