STANDARD DATA DICTIONARY #50.416 -- DRUG INGREDIENTS FILE 3/24/25 PAGE 1 STORED IN ^PS(50.416, (5490 ENTRIES) SITE: WWW.BMIRWIN.COM UCI: VISTA,VISTA (VERSION 4.0) DATA NAME GLOBAL DATA ELEMENT TITLE LOCATION TYPE ----------------------------------------------------------------------------------------------------------------------------------- Per VHA Directive 2005-044, this file has been "locked down" by Data Standardization (DS). The file definition (i.e. data dictionary) shall not be modified. All additions, changes and deletions to entries in the file shall be done by Enterprise Reference Terminology (ERT) using the Master File Server (MFS), provided by Common Services (CS). Creating and/or editing locally defined fields in the file are not permitted. Use of locally defined fields that were created prior to VHA Directive 2005-044 shall not be supported. This file contains individual generic drugs which are components of various drug products. DD ACCESS: @ RD ACCESS: pP WR ACCESS: @ DEL ACCESS: @ LAYGO ACCESS: @ POINTED TO BY: PRIMARY INGREDIENT field (#2) of the DRUG INGREDIENTS File (#50.416) ACTIVE INGREDIENTS field (#.01) of the ACTIVE INGREDIENTS sub-field (#50.6814) of the VA PRODUCT File (#50.68) INGREDIENT 1 field (#1) of the DRUG INTERACTION File (#56) INGREDIENT 2 field (#2) of the DRUG INTERACTION File (#56) CAUSATIVE AGENT field (#2) of the DRUG ALLERGIES sub-field (#100.517) of the ORDER CHECK INSTANCES File (#100.05) DRUG INGREDIENT field (#.01) of the DRUG INGREDIENTS sub-field (#100.5174) of the DRUG ALLERGIES sub-field (#100.517) of the ORDER CHECK INSTANCES File (#100.05) GMR ALLERGY field (#1) of the PATIENT ALLERGIES File (#120.8) DRUG INGREDIENT field (#.01) of the DRUG INGREDIENTS sub-field (#120.802) of the PATIENT ALLERGIES File (#120.8) DRUG INGREDIENT field (#.01) of the DRUG INGREDIENTS sub-field (#120.824) of the GMR ALLERGIES File (#120.82) CROSS REFERENCED BY: DRUG IDENTIFIER(APD), NAME(APS), PRIMARY INGREDIENT(APS), VUID(AVUID), NAME(B), NAME(P), PRIMARY INGREDIENT(P) INDEXED BY: VUID & MASTER ENTRY FOR VUID (AMASTERVUID), NAME & PRIMARY INGREDIENT (P1) LAST MODIFIED: MAY 30,2017@16:08:35 50.416,.01 NAME 0;1 FREE TEXT (Required) (audited) INPUT TRANSFORM: K:$L(X)>64!($L(X)<3)!'(X'?1P.E)!($E(X,$L(X))=" ") X K:$G(^("VUID")) X LAST EDITED: OCT 20, 2005 HELP-PROMPT: Answer must be 3-64 characters in length. DESCRIPTION: This is the drug ingredient name. TECHNICAL DESCR: AUDIT: YES, ALWAYS PRE-LOOKUP: I $G(DIC(0))["L",'$D(XUMF) K X D EN^DDIOL("Entries Must be edited via the Master File Server (MFS). ","","!?5,$C(7)") DELETE TEST: 1,0)= I $G(^PS(50.416,DA,"VUID")) LAYGO TEST: .01,0)= D:'$D(PSNDF) EN^DDIOL("ADDITIONS ARE NOT ALLOWED") I $D(PSNDF) 1,0)= D:'$D(XUMF) EN^DDIOL("Entries must be added via the Master File Server (MFS).","","!?5,$C(7)" ) I $D(XUMF) DELETE AUTHORITY: ^ WRITE AUTHORITY: ^ NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY PROGRAMMER CROSS-REFERENCE: 50.416^B 1)= S ^PS(50.416,"B",$E(X,1,64),DA)="" 2)= K ^PS(50.416,"B",$E(X,1,64),DA) CROSS-REFERENCE: 50.416^P 1)= Q 2)= Q CROSS-REFERENCE: 50.416^APS^MUMPS 1)= I $P(^PS(50.416,DA,0),"^",2)]"" S ^PS(50.416,"APS",$P(^PS(50.416,DA,0),"^",2),DA)="" 2)= I $P(^PS(50.416,DA,0),"^",2)]"" K ^PS(50.416,"APS",$P(^PS(50.416,DA,0),"^",2),DA) 3)= DO NOT DELETE-used for drug interactions This cross-reference is used in Outpatient Pharmacy for drug-drug interactions. It stores the secondary ingredients with their Primary Ingredient. RECORD INDEXES: P1 (#223) 50.416,1 DRUG IDENTIFIER 1;0 Multiple #50.4161 (Add New Entry without Asking) LAST EDITED: JAN 14, 1997 DESCRIPTION: This field contains products from the National Drug file which contain this ingredient. TECHNICAL DESCR: The first number is the Internal Entry Number (IEN) from the VA Generic file (#50.6) followed by an "A". The second number is the Internal Entry Number (IEN) of the particular product from the VA Product file (#50.68) which contains this ingredient. DELETE AUTHORITY: ^ WRITE AUTHORITY: ^ 50.4161,.01 DRUG IDENTIFIER 0;1 FREE TEXT (audited) INPUT TRANSFORM: K:X[""""!($A(X)=45) X I $D(X) K:$L(X)>30!($L(X)<3)!'(X?1.N1"A"1.N) X LAST EDITED: APR 24, 1990 HELP-PROMPT: Answer must be 3-30 characters in length. DESCRIPTION: This is the drug identifier. AUDIT: YES, ALWAYS UNEDITABLE CROSS-REFERENCE: 50.4161^B 1)= S ^PS(50.416,DA(1),1,"B",$E(X,1,30),DA)="" 2)= K ^PS(50.416,DA(1),1,"B",$E(X,1,30),DA) CROSS-REFERENCE: 50.416^APD^MUMPS 1)= S ^PS(50.416,"APD",X,$S(+$P(^PS(50.416,DA(1),0),"^",2):+$P(^(0),"^",2),1:DA(1)))="" 2)= K ^PS(50.416,"APD",X,$S(+$P(^PS(50.416,DA(1),0),"^",2):+$P(^(0),"^",2),1:DA(1))) 3)= DO NOT DELETE. This cross-reference stores the drug identifier for look-up purposes. Cross-reference by VA Products containing Ingredient. In the form of: ^PS(50.416,"APD",Drug Identifier,DA) 50.416,2 PRIMARY INGREDIENT 0;2 POINTER TO DRUG INGREDIENTS FILE (#50.416) (audited) LAST EDITED: JUL 20, 2005 DESCRIPTION: This is the primary ingredient. AUDIT: YES, ALWAYS DELETE AUTHORITY: ^ WRITE AUTHORITY: ^ CROSS-REFERENCE: 50.416^APS 1)= S ^PS(50.416,"APS",$E(X,1,30),DA)="" 2)= K ^PS(50.416,"APS",$E(X,1,30),DA) This cross reference is used to screen on primary ingredients. CROSS-REFERENCE: 50.416^P 1)= Q 2)= Q RECORD INDEXES: P1 (#223) 50.416,3 INACTIVATION DATE 2;1 DATE INPUT TRANSFORM: S %DT="EX" D ^%DT S X=Y K:Y<1 X LAST EDITED: NOV 01, 1998 DESCRIPTION: This is the date when this drug ingredient was made inactive. WRITE AUTHORITY: ^ 50.416,4 CODING SYSTEM 4;0 Multiple #50.4164 DESCRIPTION: This multiple stores the coding system(s) associated with the codes identifying this Drug Ingredients. 50.4164,.01 CODING SYSTEM 0;1 FREE TEXT (audited) INPUT TRANSFORM: K:$L(X)>10!($L(X)<3) X LAST EDITED: NOV 04, 2016 HELP-PROMPT: Answer must be 3-10 characters in length. DESCRIPTION: This field indicates the coding system associated with the codes identifying this Drug Ingredients. Example; RxNorm, SNOMED-CT, UMLS. AUDIT: YES, ALWAYS CROSS-REFERENCE: 50.4164^B 1)= S ^PS(50.416,DA(1),4,"B",$E(X,1,30),DA)="" 2)= K ^PS(50.416,DA(1),4,"B",$E(X,1,30),DA) 50.4164,.02 CODE 1;0 Multiple #50.41641 DESCRIPTION: This multiple stores the code(s) representing this Drug Ingredients within this coding system. 50.41641,.01 CODE 0;1 FREE TEXT (audited) INPUT TRANSFORM: K:$L(X)>30!($L(X)<1) X LAST EDITED: SEP 19, 2016 HELP-PROMPT: Answer must be 1-30 characters in length. DESCRIPTION: This code represents this Drug Ingredients within this coding system. For example; Cetirizine RxCUI=20610. The entry would be 20610. AUDIT: YES, ALWAYS CROSS-REFERENCE: 50.41641^B 1)= S ^PS(50.416,DA(2),4,DA(1),1,"B",$E(X,1,30),DA)="" 2)= K ^PS(50.416,DA(2),4,DA(1),1,"B",$E(X,1,30),DA) 50.416,99.98 MASTER ENTRY FOR VUID VUID;2 SET (Required) '1' FOR YES; '0' FOR NO; LAST EDITED: MAY 11, 2005 DESCRIPTION: This field identifies the Master entry for a VUID associated with a Term/Concept. WRITE AUTHORITY: ^ UNEDITABLE RECORD INDEXES: AMASTERVUID (#610) 50.416,99.99 VUID VUID;1 FREE TEXT (Required) INPUT TRANSFORM: S X=+X K:$L(X)>20!($L(X)<1)!'(X?1.20N) X LAST EDITED: FEB 08, 2006 HELP-PROMPT: Answer must be 1-20 characters in length. DESCRIPTION: VHA Unique ID (VUID). A unique meaningless integer assigned to reference terms VHA wide. WRITE AUTHORITY: ^ NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY PROGRAMMER CROSS-REFERENCE: 50.416^AVUID 1)= S ^PS(50.416,"AVUID",$E(X,1,30),DA)="" 2)= K ^PS(50.416,"AVUID",$E(X,1,30),DA) 3)= XXX--CAN'T BE ALTERED EXCEPT PROGRAMMER This cross-reference is by VUID. RECORD INDEXES: AMASTERVUID (#610) 50.416,99.991 EFFECTIVE DATE/TIME TERMSTATUS;0 DATE Multiple #50.4169 (Add New Entry without Asking) DESCRIPTION: Describes the pair Status and Effective Date/Time for each reference term. 50.4169,.01 EFFECTIVE DATE/TIME 0;1 DATE (Required) INPUT TRANSFORM: S %DT="ESTX" D ^%DT S X=Y K:Y<1 X LAST EDITED: MAY 11, 2005 DESCRIPTION: This is the date/time when the Status of the reference term was established. WRITE AUTHORITY: ^ UNEDITABLE NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY PROGRAMMER CROSS-REFERENCE: 50.4169^B 1)= S ^PS(50.416,DA(1),"TERMSTATUS","B",$E(X,1,30),DA)="" 2)= K ^PS(50.416,DA(1),"TERMSTATUS","B",$E(X,1,30),DA) 50.4169,.02 STATUS 0;2 SET (Required) '1' FOR ACTIVE; '0' FOR INACTIVE; LAST EDITED: MAY 11, 2005 DESCRIPTION: The Status of a reference term is either 'ACTIVE' or 'INACTIVE'. If the term 'ACTIVE', then the term will be accessible by end-users to document a particular patient event. If 'INACTIVE', then the term will only be accessible by the application to display legacy data. WRITE AUTHORITY: ^ UNEDITABLE FILES POINTED TO FIELDS DRUG INGREDIENTS (#50.416) PRIMARY INGREDIENT (#2) File #50.416 Record Indexes: AMASTERVUID (#610) RECORD REGULAR IR SORTING ONLY Short Descr: This cross-reference identifies the Master entry for a VUID. Description: If multiple entries have the same VUID in the file, this cross-reference can be used to identify the Master entry for a VUID associated with a Term/Concept. Set Logic: S ^PS(50.416,"AMASTERVUID",$E(X(1),1,30),X(2),DA)="" Kill Logic: K ^PS(50.416,"AMASTERVUID",$E(X(1),1,30),X(2),DA) Whole Kill: K ^PS(50.416,"AMASTERVUID") X(1): VUID (50.416,99.99) (Subscr 1) (Len 30) (forwards) X(2): MASTER ENTRY FOR VUID (50.416,99.98) (Subscr 2) (forwards) P1 (#223) RECORD MUMPS IR LOOKUP & SORTING Short Descr: CROSS REFERENCE ON PRIMARY INGREDIENT Description: Set Logic: I X2(1)'="",X2(2)="" S ^PS(50.416,"P",X2(1),DA)="" Kill Logic: I X2(1)=""!(X2(2)'="")!(X1(1)'=X2(1)) K ^PS(50.416,"P",X1(1),DA) Whole Kill: K ^PS(50.416,"P") X(1): NAME (50.416,.01) (forwards) X(2): PRIMARY INGREDIENT (50.416,2) (forwards) INPUT TEMPLATE(S): PRINT TEMPLATE(S): SORT TEMPLATE(S): FORM(S)/BLOCK(S):