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 18: | Line 18: | ||
= Filter properties = | = Filter properties = | ||
+ | |||
+ | to make the SQL filters work, the base SQL is | ||
+ | |||
+ | Select RXCUI from rxnconso where SAB = 'RXNORM' | ||
{| | {| | ||
Line 25: | Line 29: | ||
! Value | ! Value | ||
! Comments | ! Comments | ||
+ | ! SQL | ||
|- | |- | ||
Line 32: | Line 37: | ||
| [COL:]Value | | [COL:]Value | ||
| default column is TUI | | default column is TUI | ||
+ | | and RXCUI in (select RXCUI from rxnsty where [COL] = :value) | ||
|- | |- | ||
Line 38: | Line 44: | ||
| in/= | | in/= | ||
| Value | | Value | ||
− | | value comes from (select RSAB from rxnsab) (e.g. source = RXNORM) | + | | value comes from (select RSAB from rxnsab) (e.g. source = RXNORM) - but is this redundant? |
+ | | and RXCUI in (select RXCUI from rxnconso where ASB = :value) | ||
|- | |- | ||
Line 46: | Line 53: | ||
| Value | | Value | ||
| value of TTY column in rxnconso | | value of TTY column in rxnconso | ||
+ | | and TTY = :value | ||
|} | |} |
Revision as of 16:52, 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 ASB = :value) |
Term Type | TTY | in/= | Value | value of TTY column in rxnconso | and TTY = :value |