Skip Navigation Bar

Unified Medical Language System® (UMLS®)

2014AA UMLS RXNORM Source Information

This page lists specific source data elements and provides information on their representation in the UMLS Metathesaurus.


Skip to: Notes, Summary of Changes, Summary of Source-Provided Files Source-Provided File Details

Notes:

RxNorm, a standardized nomenclature for clinical drugs, is produced by the National Library of Medicine. Data files are released monthly and available by download. Within each Metathesaurus cycle, RxNorm is updated multiple times. This document reflects the latest cumulative update. The scope of RxNorm is determined by the combined scope of its source vocabularies which include the following:

Sources Description
ATC_2014_14_03_03 Anatomical Therapeutic Chemical Classification System
GS_2014_02_06 Gold Standard Drug Database
MDDB_2014_01_29 Master Drug Data Base. Medi-Span, a division of Wolters Kluwer Health
MMSL_2014_02_03 Multum MediSource Lexicon
MMX_2014_02_03 Micromedex RED BOOK
MTHFDA_2011_06_01_13_05_06 FDA National Drug Code Directory
MTHSPL_2014_02_24 FDA Structured Product Labels
NDDF_2014_02_05 FDB MedKnowledge
NDFRT_2014_02_03
National Drug File
RXNORM_13AB_140303F
RxNorm Vocabulary
VANDF_2014_01_23 Veterans Health Administration National Drug File

Note: Selected portions of MSH and SNOMEDCT are included in the RxNorm release files, however, they are not processed as part of RxNorm for the Metathesaurus except in assigning RXCUI and RXAUI attributes. All MSH or SNOMEDCT data in the Metathesaurus comes directly from that source's data files. This document describes how the RxNorm release files (RXN*RRF) are processed for representation in the UMLS Metathesaurus.  It does not cover processing of individual source vocabularies for inclusion in RxNorm. 

MTHFDA is included in each Metathesaurus release as part of RxNorm, however, it was not updated in this version. MTHFDA was last updated in 2011.

Summary of Changes

No changes were made to the RXNORM format itself or to Metathesaurus source processing for 2014AA.  Data changes include the following:

Atoms:
     Status       TTY   SAB
     Deprecated     
FN
NDFRT_2014_02_03
     Deprecated
HT
NDFRT_2014_02_03

Relationships: 
Status Relationship Inverse SAB
     New
has_member
member_of   
ATC_2014_14_03_03
     Deprecated     
active_metabolites_of    
has_active_metabolites
NDFRT_2014_02_03
     Deprecated
chemical_structure_of
has_chemical_structure   
NDFRT_2014_02_03
     Deprecated
contraindicated_with_disease
disease_with_contraindication   
NDFRT_2014_02_03
     Deprecated
contraindicating_class_of
has_contraindicating_class   
NDFRT_2014_02_03
     Deprecated
contraindicating_mechanism_of_action_of
has_contraindicating_mechanism_of   
NDFRT_2014_02_03
     Deprecated
contraindicating_physiologic_effect_of
has_contraindicating_physiologic_e   
NDFRT_2014_02_03
     Deprecated
effect_may_be_inhibited_by
may_inhibit_effect_of   
NDFRT_2014_02_03
     Deprecated
has_contraindicated_drug
drug_contraindicated_for   
NDFRT_2014_02_03
     Deprecated
has_mechanism_of_action
mechanism_of_action_of   
NDFRT_2014_02_03
     Deprecated
has_participant
participates_in   
NDFRT_2014_02_03
     Deprecated
has_pharmacokinetics
pharmacokinetics_of   
NDFRT_2014_02_03
     Deprecated
has_physiologic_effect
physiologic_effect_of   
NDFRT_2014_02_03
     Deprecated
has_product_component
product_component_of   
NDFRT_2014_02_03
     Deprecated
has_therapeutic_class
therapeutic_class_of   
NDFRT_2014_02_03
     Deprecated
induced_by
induces   
NDFRT_2014_02_03
     Deprecated
may_be_diagnosed_by
may_diagnose   
NDFRT_2014_02_03
     Deprecated
may_be_prevented_by
may_prevent   
NDFRT_2014_02_03
     Deprecated
may_be_treated_by
may_treat   
NDFRT_2014_02_03
     Deprecated
metabolic_site_of
site_of_metabolism   
NDFRT_2014_02_03

Attributes: 
Status ATN SAB
     Deprecated     
FDA_UNII_CODE     
NDFRT_2014_02_03
     Deprecated     
LEVEL     
NDFRT_2014_02_03
     Deprecated     
MESH_DEFINITION     
NDFRT_2014_02_03
     Deprecated     
MESH_DUI     
NDFRT_2014_02_03
     Deprecated     
MESH_NAME     
NDFRT_2014_02_03
     Deprecated     
MESH_UI     
NDFRT_2014_02_03
     Deprecated     
NDFRT_KIND     
NDFRT_2014_02_03
     Deprecated     
NDF_UNITS     
NDFRT_2014_02_03
     Deprecated     
NUI     
NDFRT_2014_02_03
     Deprecated     
SEVERITY     
NDFRT_2014_02_03
     Deprecated     
SNOMED_CID     
NDFRT_2014_02_03
     Deprecated     
STRENGTH     
NDFRT_2014_02_03
     Deprecated     
VANDF_RECORD     
NDFRT_2014_02_03
     Deprecated     
VA_IEN     
NDFRT_2014_02_03
     Deprecated     
VUID     
NDFRT_2014_02_03

Source Provided Files:

RXNORM  data files are released monthly and available by download.

File Name Description
RXNCONSO.RRF Concept and source information.
RXNDOC.RRF Abbreviated values.
RXNREL.RRF Relationship and merge information.
RXNSAB.RRF Source information.
RXNSAT.RRF Attribute information.
RXNSTY.RRF Semantic type information.
RXNATOMARCHIVE.RRF Archive data. Not used.
RXNCUICHANGES.RRF CUI changes. Not used.
RXNCUI.RRF Retired CUIs.
RXNCONSOOCD.RRF OCD concept and source information.
RXNASATOCD.RRF OCD simple concept and atom attribute information.
RXNSTYOCD.RRF OCD semantic type.

Source-Provided Files: Summary

  (return to top)

Documentation and Reference

File Name Description
Readme_Full_*.txt Provides information about the contents of the downloaded zip file. Lists all updated and non-updated sources. Provides information on database control files and SQL commands for use in the automation of the loading process of these files into a RDBMS (Oracle in this case).

RXN RRF files

File Name Description
RXNCONSO.RRF Concept and source information.
RXNDOC.RRF Data about RxNorm.
RXNREL.RRF Relationship and merge information.
RXNSAB.RRF Source information.
RXNSAT.RRF Attribute information.
RXNSTY.RRF Semantic type information.
RXNATOMARCHIVE.RRF Archive data. Not used.
RXNCUICHANGES.RRF Concept changes. Not used.
RXNCUI.RRF Retired CUIs.
RXNCONSOOCD.RRF OCD concept and source information.
RXNASATOCD.RRF OCD attribute information.
RXNSTYOCD.RRF OCD semantic type information.

There are separate files for the obsolete clinical drug (OCD) terms (i.e., RXNCONSOOCD.RRF, RXNASATOCD.RRF, RXNSTYOCD.RRF). These files have formats similar to existing RXN files of the same type so they have been appended to them.

Source-Provide Files: Details

  (return to top)

RxNorm uses the Rich Release Format (RRF) of the Metathesaurus. There are some fields that are not populated by RxNorm and are marked as "(no value provided)" in the description column with "Not applicable" in the representation column. There are other fields which do contain data such as the term status field (TS) but the data is not extracted because the fields are computed during Metathesaurus production. These fields are marked as "Not processed" in the Representation column.

Also, some fields such as CODE may appear in multiple RXN RRF files. These fields are redundant and are not always used within a particular RRF file but are processed within another file.

file: RXNCONSO.RRF

# Field Name Description Representation
1 RXCUI RxNorm unique identifier for concept (concept ID) MRCONSO.SCUI if SAB = "RXNORM"; MRSAT.ATN= "RXCUI"
2 LAT Language of term Not processed
3 TS Term status Not processed
4 LUI Unique identifier for term (no value provided) Not applicable
5 STT String type Not processed
6 SUI Unique identifier for string (no value provided) Not applicable
7 ISPREF Atom status - preferred (Y) or not (N) for this string within the concept Not processed
8 RXAUI Unique identifier for atom (RxNorm atom ID) MRCONSO.SAUI if SAB = "RXNORM"; MRSAT.ATN = "RXAUI"
9 SAUI Source asserted atom identifier MRCONSO.SAUI
10 SCUI Source asserted concept identifier MRCONSO.SCUI
11 SDUI Source asserted descriptor identifier MRCONSO.SDUI
12 SAB Abbreviated source name MRCONSO.SAB
13 TTY Abbreviation for term type MRCONSO.TTY
14 CODE Source asserted identifier MRCONSO.CODE
15 STR String MRCONSO.STR
16 SRL Source restriction level (no value provided) Not applicable
17 SUPPRESS Suppressible flag MRCONSO.SUPPRESS
18 CVF Content view flag Not processed

file: RXNDOC.RRF

# Field Name Description Representation
1 KEY Data element or attribute MRDOC.KEY
2 VALUE Abbreviation that is one of its values MRDOC.VALUE
3 TYPE Type of information in EXPL column MRDOC.TYPE
4 EXPL Explanation of VALUE field MRDOC.EXPL

file: RXNREL.RRF

# Field Name Description Representation
1 RXCUI1 Unique identifier of first concept MRREL.CUI1 populated by the Metathesaurus CUI of RXAUI1
2 RXAUI1 Unique identifier of first atom MRREL.AUI1 populated by the Metathesaurus AUI of RXAUI1
3 STYPE1 Name of the column in RXNCONSO.RRF that contains the identifier used for the first concept or first atom in source of the relationship (either 'AUI' or 'CUI') MRREL.STYPE1
4 REL Relationship of second concept or atom to the first concept or atom MRREL.REL
5 RXCUI2 Unique identifier of second concept MRREL.CUI2 populated by the Metathesaurus CUI of RXAUI2
6 RXAUI2 Unique identifier of second atom MRREL.AUI2 populated by the Metathesaurus AUI of RXAUI2
7 STYPE2 Name of the column in RXNCONSO.RRF that contains the identifier used for the second concept or second atom in source of the relationship (either 'AUI' or 'CUI') MRREL.STYPE2
8 RELA Additional relationship label MRREL.RELA
9 RUI Unique identifier of relationship (no value provided) Not applicable
10 SRUI Source asserted relationship identifier (no value provided) Not applicable
11 SAB Abbreviated source name MRREL.SAB
12 SL Source of relationship labels (no value provided) Not applicable
13 RG Relationship group Not processed
14 DIR Source asserted directionaltiy flag (no value provided) Not applicable
15 SUPPRESS Suppressible flag MRREL.SUPPRESS
16 CVF Content view flag Not processed

file: RXNSAB.RRF

# Field Name Description Representation
1 VCUI CUI Not processed
2 RCUI Root CUI Not processed
3 VSAB Versioned source abbreviation MRSAB.VSAB
4 RSAB Root source abbreviation MRSAB.RSAB
5 SON Official name MRSAB.SON
6 SF Source familty MRSAB.SF
7 SVER Version MRSAB.SVER
8 VSTART Meta start date Not processed
9 VEND Meta end date Not processed
10 IMETA Meta insert version Not processed
11 RMETA Meta remove version Not processed
12 SLC Source license contact MRSAB.SLC
13 SCC Source content contact MRSAB.SCC
14 SRL Source restriction level MRSAB.SRL
15 TFR Term frequency Not processed
16 CFR CUI frequency Not processed
17 CXTY Context type MRSAB.CXTY
18 TTYL Term type list Not processed
19 ATNL Attribute name list Not processed
20 LAT Language MRSAB.LAT
21 CENC Character encoding MRSAB.CENC
22 CURVER Current version Not processed
23 SABIN source in subset Not processed
24 SSN Source short name Not processed
25 SCIT Source short name MRSAB.CIT

file: RXNSAT.RRF

# Field Name Description Representation
1 RXCUI Unique identifier for concept (concept ID) MRSAT.CUI populated by the Metathesarus CUI of RXCUI
2 LUI Unique identifier for term (no value provided) Not applicable
3 SUI Unique identifier for string (no value provided) Not applicable
4 RXAUI Unique identifier for atom (RxNorm atom ID) MRSAT.METAUI populated by the Metathesaurus AUI of RXAUI
5 STYPE Name of the column in RXNCONSO.RRF or RXNREL.RRF that contains the identifier to which the attribute is attached MRSAT.STYPE
6 CODE Source asserted identifier Not processed
7 ATUI Unique identifier for attribute Not processed
8 SATUI Source asserted attribute identifier Not processed
9 ATN Attribute name MRSAT.ATN
10 SAB Abbreviated source name MRSAT.SAB
11 ATV Attribute value MRSAT.ATV
12 SUPPRESS Suppressible flag MRSAT.SUPPRESS
13 CVF Content view flag Not processed

Note: Attributes with SAB=MSH plus ATNs UMLSCUI and UMLSAUI are not processed.

file: RXNSTY.RRF

# Field Name Description Representation
1 RXCUI Unique identifier for concept (concept ID) MRSTY.CUI populated by the Metathesaurus CUI of RXCUI
2 TUI Unique identifier for semantic type Not applicable
3 STN Semantic type tree number Not applicable
4 STY Semantic type MRSTY.STY
5 ATUI Unique identifier for attribute Not applicable
6 CVF Content view flag Not applicable

Note: STYs are subject to editing.

file: RXNATOMARCHIVE.RRF

This file is created by RxNorm for use in tracking the archival of names (atoms) no longer provided by RxNorm drug source providers, or atoms no longer used by the RxNorm system. Only atoms with SAB = "RXNORM" will be in the archive. This information is not processed for the Metathesaurus as part of RxNorm.

file: RXNCUICHANGES.RRF

This file provides information about changes to the concept_id (RXCUI) for atoms in RxNorm from release to release. It is not cumulative. This information is not processed for the Metathesaurus as part of RxNorm.

file: RXNCUI.RRF

This file of retired CUIs will show each RxNorm Concept Unique Identifier (RXCUI) that existed in a prior release but is not present in the current release. The file includes mappings to current RXCUIs as synonymous or to one or more related current RXCUIs where possible.

#
Field Name Description Representation
1 RXCUI1 Unique identifier of retired concept MRREL.CUI1 populated by the Metathesaurus CUI of RXCUI1
2 VSAB_START Version Source Abbreviation of the first RxNorm release RXCUI1 appeared in Not processed
3 VSAB_END Version Source Abbreviation of the last RxNorm release RXCUI1 appeared in Not processed
4 Cardinality The number of RXCUIs that RXCUI1 was moved or split to Not processed
5 RXCUI2 Unique identifier of synonymous concept for RXCUI1 MRREL.CUI2 populated by the Metathesaurus CUI of RXCUI2

file: RXNCONSOOCD.RRF

This file contains information about RxNorm "OCD" term type atoms only. For field name, description, and representation information see RXNCONSO.RRF.

file: RXNSATOCD.RRF

This file lists each "OCD" concept, atom, or relationship attribute that does not have a sub-element structure. For field name, description, and representation information see RXNSAT.RRF.

file: RXNSTYOCD.RRF

This file lists each semantic type assigned to each "OCD" concept. For field name, description, and representation information see RXNSTY.RRF.