STANDARD DATA DICTIONARY #129.22 -- RXNORM RELATED CONCEPTS FILE 3/24/25 PAGE 1
STORED IN ^ETSRXN(129.22, (1481632 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 Related Concepts file contains a subset of the data distributed by NLM in the RXNREL.RRF file. This file follows the
general format of the MRREL.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 one row in this table for each
relationship between concepts or atoms known to RxNorm. In addition, explicit SY RELs are provided which give the UMLS
Metathesaurus CUI and AUI as the RXCUI2 and RXAUI2 fields.
Note that for asymmetrical relationships there is one row for each direction of the relationship. Note also the direction of REL -
the relationship which the SECOND concept or atom (with Concept Unique Identifier RXCUI2 and Atom Unique Identifier (RXAUI2) HAS TO
the FIRST concept or atom (with Concept Unique RXCUI1 and Atom Unique Identifier RXAUI1).
DD ACCESS: @
WR ACCESS: @
DEL ACCESS: @
LAYGO ACCESS: @
AUDIT ACCESS: @
PRIMARY KEY: A (#129)
Uniqueness Index: D (#1474)
File, Field: 1) RXCUI1 (129.22,.01) 2) UNIQUE RECORD ID (129.22,91)
CROSS
REFERENCED BY: RXCUI1(B)
INDEXED BY: RXCUI1 & UNIQUE RECORD ID (D)
LAST MODIFIED: OCT 5,2017@17:58:15
129.22,.01 RXCUI1 0;1 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:
Unique identifier of the first concept.
CROSS-REFERENCE: 129.22^B
1)= S ^ETSRXN(129.22,"B",$E(X,1,30),DA)=""
2)= K ^ETSRXN(129.22,"B",$E(X,1,30),DA)
RECORD INDEXES: D (#1474)
129.22,.02 RELATIONSHIP (REL) 0;2 FREE TEXT
INPUT TRANSFORM: K:$L(X)>4!($L(X)<1) X
MAXIMUM LENGTH: 4
LAST EDITED: JAN 24, 2017
HELP-PROMPT: Answer must be 1-4 characters in length.
DESCRIPTION:
Relationship of the second concept or atom to the first concept or atom.
129.22,.03 RXCUI2 0;3 FREE TEXT
INPUT TRANSFORM: K:$L(X)>8!($L(X)<1) X
MAXIMUM LENGTH: 8
LAST EDITED: APR 18, 2017
HELP-PROMPT: Answer must be 1-8 characters in length.
DESCRIPTION:
Unique identifier of the second concept
129.22,.04 SECONDARY RELATIONSHIP (RELA) 0;4 FREE TEXT
INPUT TRANSFORM: K:$L(X)>100!($L(X)<1) X
MAXIMUM LENGTH: 100
LAST EDITED: APR 18, 2017
HELP-PROMPT: Answer must be 1-100 characters in length.
DESCRIPTION:
Additional (i.e more specific) relationship label.
129.22,.05 SOURCE (SAB) 0;5 FREE TEXT
INPUT TRANSFORM: K:$L(X)>20!($L(X)<1) X
MAXIMUM LENGTH: 20
LAST EDITED: JAN 25, 2017
HELP-PROMPT: Answer must be 1-20 characters in length.
DESCRIPTION:
Abbreviation of the source of relationship.
129.22,.06 SUPPRESSION_FLAG (SUPPRESS) 0;6 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 = N, Y, or E.
Reflects the suppressible status of the attribute.
N - Attribute is not suppressed.
Y - Attribute is suppressed by RxNorm
editors.
E - Attribute is an unquantified, non-
prescribable drug with related
quantified prescribable drugs.
129.22,.07 CONTENT_VIEW_FLAG (CVF) 0;7 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.22,91 UNIQUE RECORD ID VA;1 FREE TEXT (Required) (Key field)
INPUT TRANSFORM: K:$L(X)>50!($L(X)<1) X
MAXIMUM LENGTH: 50
LAST EDITED: APR 18, 2017
HELP-PROMPT: Answer must be 1-50 characters in length.
DESCRIPTION: This field is a unique ID for every row and will be used to keep the records in the central
repository in sync with the records in this file. During initial population, it will be derived
from the line number in the RXNREL.RRF file.
RECORD INDEXES: D (#1474)
File #129.22
Record Indexes:
D (#1474) RECORD REGULAR IR LOOKUP & SORTING
Unique for: Key A (#129), File #129.22
Short Descr: Uniqueness Index for Key 'A' of File #129.22
Description: This index is the uniqueness index for Primary Key 'A' for the file.
Set Logic: S ^ETSRXN(129.22,"D",X(1),X(2),DA)=""
Kill Logic: K ^ETSRXN(129.22,"D",X(1),X(2),DA)
Whole Kill: K ^ETSRXN(129.22,"D")
X(1): RXCUI1 (129.22,.01) (Subscr 1)
X(2): UNIQUE RECORD ID (129.22,91) (Subscr 2)
INPUT TEMPLATE(S):
PRINT TEMPLATE(S):
SORT TEMPLATE(S):
FORM(S)/BLOCK(S):