STANDARD DATA DICTIONARY #129.2 -- RXNORM CONCEPT NAMES AND SOURCES FILE 6/27/25 PAGE 1
STORED IN ^ETSRXN(129.2, (378276 ENTRIES) SITE: WWW.BMIRWIN.COM UCI: VISTA,VISTA (VERSION 1.0)
DATA NAME GLOBAL DATA
ELEMENT TITLE LOCATION TYPE
-----------------------------------------------------------------------------------------------------------------------------------
RxNorm is a standardized nomenclature for clinical drugs. RxNorm is produced by the National Library of Medicine (NLM). In this
context, a clinical drug is a pharmaceutical product given to (or taken by) a patient with a therapeutic or diagnostic intend. The
name of the drug in RxNorm combines its ingredients, dosage strength and form.
The RxNorm Concept Names and Sources file contains a subset of the data distributed by NLM in the RXNCONSO.RRF file. This file
follows the general format of the MRCONSO.RRF file of the Metathesaurus in NLM's Unified Medical Language System (UMLS). Some of
the Metathesaurus fields are not provided by RxNorm and are marked as "(no value provided)". There is exactly one row in this file
for each atom (each occurrence of each unique string or concept name within each source vocabulary) in RxNorm, i.e., there is
exactly one row for each unique RXAUI in RxNorm. Every string or concept name in RxNorm appears in this file, connected to its
language, source vocabularies, and its concept identifier (RXCUI).
DD ACCESS: @
WR ACCESS: @
DEL ACCESS: @
LAYGO ACCESS: @
AUDIT ACCESS: @
PRIMARY KEY: A (#127)
Uniqueness Index: D (#976)
File, Field: 1) RXCUI (129.2,.01) 2) RXAUI (129.2,.07)
CROSS
REFERENCED BY: RXCUI(B)
INDEXED BY: SOURCE (SAB) & CODE & TERM_TYPE (TTY) (C), RXCUI & RXAUI (D)
LAST MODIFIED: OCT 5,2017@17:58:15
129.2,.01 RXCUI 0;1 FREE TEXT (Required) (Key field)
INPUT TRANSFORM: K:$L(X)>8!($L(X)<1) X
MAXIMUM LENGTH: 8
LAST EDITED: MAR 21, 2017
HELP-PROMPT: Answer must be 1-8 characters in length.
DESCRIPTION:
RxNorm Unique identifier for concept (concept ID)
CROSS-REFERENCE: 129.2^B
1)= S ^ETSRXN(129.2,"B",$E(X,1,30),DA)=""
2)= K ^ETSRXN(129.2,"B",$E(X,1,30),DA)
RECORD INDEXES: D (#976)
129.2,.02 SOURCE (SAB) 0;2 FREE TEXT
INPUT TRANSFORM: K:$L(X)>20!($L(X)<1) X
MAXIMUM LENGTH: 20
LAST EDITED: MAR 06, 2017
HELP-PROMPT: Answer must be 1-20 characters in length.
DESCRIPTION: The abbreviation of the source the concept was found in. Some examples of potential sources would
be the VA National Drug File (VANDF), National Drug File (NDFRT), RxNorm Concept Library (RXNORM)
RECORD INDEXES: C (#975)
129.2,.03 TERM_TYPE (TTY) 0;3 FREE TEXT
INPUT TRANSFORM: K:$L(X)>20!($L(X)<1) X
MAXIMUM LENGTH: 20
LAST EDITED: MAR 06, 2017
HELP-PROMPT: Answer must be 1-20 characters in length.
DESCRIPTION: The type of term (ingredient, drug class, generic drug, clinical drug, etc.) associated with the
concept in the original source file.
RECORD INDEXES: C (#975)
129.2,.04 CODE 0;4 FREE TEXT
INPUT TRANSFORM: K:$L(X)>50!($L(X)<1) X
MAXIMUM LENGTH: 50
LAST EDITED: MAR 06, 2017
HELP-PROMPT: Answer must be 1-50 characters in length.
DESCRIPTION: "Most useful" source asserted identifier (if the source vocabulary has more than one identifier),
or a RxNorm -generated source entry identifier (if the source vocabulary has none.)
RECORD INDEXES: C (#975)
129.2,.05 SUPPRESSION_FLAG (SUPPRESS) 0;5 FREE TEXT
INPUT TRANSFORM: K:$L(X)>1!($L(X)<1) X
MAXIMUM LENGTH: 1
LAST EDITED: MAR 29, 2017
HELP-PROMPT: Answer must be 1 character in length.
DESCRIPTION: Suppressible flag. Values = O, Y, N, or E.
Reflects the suppressible status of the attribute.
N - Attribute is not suppressed.
O - Attribute is suppressed at source level.
Y - Attribute is suppressed by RxNorm
editors.
E - Attribute is an unquantified, non-
prescribable drug with related
quantified prescribable drugs.
129.2,.06 CONTENT_VIEW_FLAG (CVF) 0;6 FREE TEXT
INPUT TRANSFORM: K:$L(X)>50!($L(X)<1) X
MAXIMUM LENGTH: 50
LAST EDITED: JAN 25, 2017
HELP-PROMPT: Answer must be 1-50 characters in length.
DESCRIPTION:
This fields denotes whether or not a concept is currently prescribable.
129.2,.07 RXAUI 0;7 FREE TEXT (Required) (Key field)
INPUT TRANSFORM: K:$L(X)>8!($L(X)<1) X
MAXIMUM LENGTH: 8
LAST EDITED: APR 13, 2017
HELP-PROMPT: Answer must be 1-8 characters in length.
DESCRIPTION:
This field is the unique identifier for the atom (RxNorm Atom ID)
RECORD INDEXES: D (#976)
129.2,1 TEXT (STR) 1;1 FREE TEXT
INPUT TRANSFORM: K:$L(X)>3000!($L(X)<1) X
MAXIMUM LENGTH: 3000
LAST EDITED: JAN 25, 2017
HELP-PROMPT: Answer must be 1-3000 characters in length.
DESCRIPTION:
Free Text string containing the concept
129.2,91 ACTIVATION DATE VA;1 DATE
INPUT TRANSFORM: S %DT="EX" D ^%DT S X=Y K:Y<1 X
LAST EDITED: MAR 21, 2017
HELP-PROMPT: Enter the date that this RXCUI was activated
DESCRIPTION: This field holds the date that this RXCUI record was added to the database and will be based on the
date that the RXCONSO file was distributed.
File #129.2
Record Indexes:
C (#975) RECORD REGULAR IR LOOKUP & SORTING
Short Descr: Sort/Lookup by Source, Code, and Term Type
Description: This index cross-references the RxNorm Concepts by SOURCE (SAB), CODE, and TERM_TYPE (TTY).
Set Logic: S ^ETSRXN(129.2,"C",$E(X(1),1,30),$E(X(2),1,30),$E(X(3),1,30),DA)=""
Kill Logic: K ^ETSRXN(129.2,"C",$E(X(1),1,30),$E(X(2),1,30),$E(X(3),1,30),DA)
Whole Kill: K ^ETSRXN(129.2,"C")
X(1): SOURCE (SAB) (129.2,.02) (Subscr 1) (Len 30) (forwards)
X(2): CODE (129.2,.04) (Subscr 2) (Len 30) (forwards)
X(3): TERM_TYPE (TTY) (129.2,.03) (Subscr 3) (Len 30) (forwards)
D (#976) RECORD REGULAR IR LOOKUP & SORTING
Unique for: Key A (#127), File #129.2
Short Descr: Uniqueness Index for Key 'A' of File #129.2
Description: This index is the uniqueness index for Primary Key 'A' for the file.
Set Logic: S ^ETSRXN(129.2,"D",X(1),X(2),DA)=""
Kill Logic: K ^ETSRXN(129.2,"D",X(1),X(2),DA)
Whole Kill: K ^ETSRXN(129.2,"D")
X(1): RXCUI (129.2,.01) (Subscr 1)
X(2): RXAUI (129.2,.07) (Subscr 2)
INPUT TEMPLATE(S):
PRINT TEMPLATE(S):
SORT TEMPLATE(S):
FORM(S)/BLOCK(S):