Home   Package List   Routine Alphabetical List   Global Alphabetical List   FileMan Files List   FileMan Sub-Files List   Package Component Lists   Package-Namespace Mapping  
Info |  Desc |  Accessed By FileMan Db Calls |  Pointer To FileMan Files |  Fields
Print Page as PDF
Global: ^ECX(728.113

Package: DSS Extracts

Global: ^ECX(728.113


Information

FileMan FileNo FileMan Filename Package
728.113 IV EXTRACT DATA DSS Extracts

Description

Accessed By FileMan Db Calls, Total: 3

Package Total Routines
DSS Extracts 3 ECXPHAI    ECXPIV1    ECXPURG    

Pointer To FileMan Files, Total: 4

Package Total FileMan Files
DSS Extracts 1 DSS EXTRACT LOG(#727)[10]    
Pharmacy Data Management 1 DRUG(#50)[3]    
Registration 1 PATIENT(#2)[1]    
Scheduling 1 HOSPITAL LOCATION(#44)[13]    

Fields, Total: 17

Field # Name Loc Type Details
.01 SEQUENCE NUMBER 0;1 NUMBER
************************REQUIRED FIELD************************

  • 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.
1 DFN 0;2 POINTER TO PATIENT FILE (#2) PATIENT(#2)

  • 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
2 ORDER NUMBER 0;3 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.
3 DRUG 0;4 POINTER TO DRUG FILE (#50) DRUG(#50)

  • 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
4 DATE/TIME 0;5 DATE

  • 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
5 TRANSACTION TYPE 0;6 SET
  • '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
6 ADDITIVE STRENGTH 0;7 FREE TEXT

  • 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
7 ADDITIVE STRENGTH UNITS 0;8 FREE TEXT

  • 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
8 SOLUTION VOLUME 0;9 NUMBER

  • 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
9 PROVIDER 0;10 FREE TEXT

  • 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
10 EXTRACT NUMBER 1;1 POINTER TO DSS EXTRACT LOG FILE (#727) DSS EXTRACT LOG(#727)

  • 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.
11 TYPE 0;11 FREE TEXT

  • 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).
12 COST 0;12 NUMBER

  • 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).
13 CLINIC 0;13 POINTER TO HOSPITAL LOCATION FILE (#44) HOSPITAL LOCATION(#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.
14 ORDER DATE 0;14 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).
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).
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.
Info |  Desc |  Accessed By FileMan Db Calls |  Pointer To FileMan Files |  Fields