This page is part of the FHIR Specification (v0.5.0: DSTU 2 Ballot 2). The current version which supercedes this version is 5.0.0. For a full list of available versions, see the Directory of published versions . Page versions: R4B R4 R3 R2
Source | RxNorm is made available by the US National Library of Medicine at http://www.nlm.nih.gov/research/umls/rxnorm |
System | The URI http://www.nlm.nih.gov/research/umls/rxnorm identifies the RxNorm code system |
Version | Where a version is used, it should be the date of release, encoded as in the download files, e.g. "07092014" |
Code | The code value for an RxNorm code is a Concept Identifier (CUI), and only CUIs for which there is an SAB=RXNORM |
Display | The correct display for CUI is the String description for it associated with the source RXNORM |
Filter Properties | Several properties are defined as described below |
The RxNorm scripts are able to populate a MySQL database that contains the data from RxNorm. This page provides SQL statements that describe how to implement the features of the RxNorm terminology correctly against this database. These are provided for implementer convenience, and do not imply that any particular approach be used in implementations.
For example, the correct display name for a CUI is 'Select STR from rxnconso where RXCUI = :code and SAB = 'RXNORM' and TTY <> 'SY'.
The use of RxNorm codes and display names in this specification is pursuant to HL7's status as a licensee of the NLM UMLS. This license does not convey the right to use RxNorm to any users of this specification; implementers must acquire a license to use RxNorm in their own right.
The license for RxNorm places restrictions on the distribution of the UMLS Metathesaurus or subsets of it. We are seeking a clarification of what constitutes a "subset of the metathesaurus" in order to make it clear what the status of an RxNorm value set is.
This section documents the property filters that can be used with the RxNorm code system in value set composition statements.
The base SQL statement for returning a list of CUIS that conform to these filters is:
Select RXCUI from rxnconso where SAB = 'RXNORM' and TTY <> 'SY'
Description | Allows to choose a set of CUIs based on their Semantic Type |
Property Name | STY |
Operations Allowed | = / in |
Values Allowed | [column:]value |
Comments | If not column is specified, the default column is TUI |
SQL | and RXCUI in (select RXCUI from rxnsty where [:column] = :value) |
Description | Allows for selection of the set of concepts that have mappings to a particular rxnorm source |
Property Name | SAB |
Operations Allowed | = / in |
Values Allowed | Values from RxNorm SAB table (e.g. select RSAB from rxnsab) |
SQL | and RXCUI in (select RXCUI from rxnconso where SAB = :value) |
Description | Allows for selection of a concept based on its designated type |
Property Name | TTY |
Operations Allowed | = / in |
Values Allowed | TTY values from the RxNorm Concept table (e.g. select distinct TTY from rxnconso) |
SQL | and TTY = :value |
Description | Allows for selection of a concept based on its relationships |
Property Name | [REL] |
Operations Allowed | = / in |
Values Allowed | CUI:[RXCUI] or AUI:[RXAUI] must be a valid CUI or AUI. Note that a CUI does not need to have a SAB=RXNORM entry to be used here |
Comments | [REL] (:rel) is one of SY, SIB, RN, PAR, CHD, RB or RO |
SQL |
for CUI:
and (RXCUI in (select RXCUI from rxnconso where RXCUI in (select RXCUI1 from rxnrel where REL = :rel and RXCUI2 = :value))for AUI: and (RXCUI in (select RXCUI from rxnconso where RXAUI in (select RXAUI1 from rxnrel where REL = :rel and RXAUI2 = :value)) |
Description | Allows for selection of a concept based on the type of its relationships |
Property Name | [RELA] |
Operations Allowed | = / in |
Values Allowed | CUI:[RXCUI] or AUI:[RXAUI] must be a valid CUI or AUI. Note that a CUI does not need to have a SAB=RXNORM entry to be used here |
Comments | [RELA] (:rela) is one of the relationship types below |
SQL |
for CUI:
and (RXCUI in (select RXCUI from rxnconso where RXCUI in (select RXCUI1 from rxnrel where RELA = :rel and RXCUI2 = :value))for AUI: and (RXCUI in (select RXCUI from rxnconso where RXAUI in (select RXAUI1 from rxnrel where RELA = :rel and RXAUI2 = :value)) |
Relationship Types
Implicit value sets are those whose specification can predicted based on the grammar of the underlying code system, and the known structure of the URL that refers to them. RxNorm does not (yet) have any defined implicit value sets.
The value set identifier http://www.nlm.nih.gov/research/umls/rxnorm/vs is a value set that contains all RxNorm CUIs.