This wiki has undergone a migration to Confluence found Here
Using rxNorm with FHIR
Introduction
On this page, all the rules & semantics for using RxNorm with FHIR are defined.
All of these are defined in terms of the default RxNorm database created (after fixes!) by the scripts provided with RxNorm
Basics
- Namespace is http://www.nlm.nih.gov/research/umls/rxnorm
- CUIs are valid in this namespace
- should AUIs be valid too?
- The display name is
select Str from rxnconso where (RXCUI = :code and SAB = 'RXNORM')
- or maybe select Str from rxnconso where RXAUI = :code or (RXCUI = :code and SAB = 'RXNORM')
Filter properties
to make the SQL filters work, the base SQL is
Select RXCUI from rxnconso where SAB = 'RXNORM'
Description | Property Name | Property Operators | Value | Comments | SQL |
---|---|---|---|---|---|
Semantic Type | STY | in/= | [COL:]Value | default column is TUI | and RXCUI in (select RXCUI from rxnsty where [COL] = :value) |
Source | SAB | in/= | Value | value comes from (select RSAB from rxnsab) (e.g. source = RXNORM) - but is this redundant? | and RXCUI in (select RXCUI from rxnconso where SAB = :value) |
Term Type | TTY | in/= | Value | value of TTY column in rxnconso | and TTY = :value |
Contains | contains | in/= | Value | Value is either URI of value set, or a RXCUI or RXAUI | and (RXCUI in (select RXCUI from rxnconso where RXAUI in (select RXAUI1 from rxnrel where RELA = 'contains' and RXAUI2 = :value)) or RXCUI in (select RXCUI1 from rxnrel where RELA = 'contains' and RXCUI2 = :value))
|