This wiki has undergone a migration to Confluence found Here
Difference between revisions of "Using rxNorm with FHIR"
Jump to navigation
Jump to search
| Line 54: | Line 54: | ||
| value of TTY column in rxnconso | | value of TTY column in rxnconso | ||
| and TTY = :value | | and TTY = :value | ||
| + | |||
| + | |- | ||
| + | | Contains | ||
| + | | contains | ||
| + | | in/= | ||
| + | | Value | ||
| + | | Value is either URI of value set, or a RXCUI or RXAUI | ||
| + | | and (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)) | ||
| + | |||
|} | |} | ||
Revision as of 21:40, 6 July 2014
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 (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))
|
RxNorm Relationships
