This wiki has undergone a migration to Confluence found Here
<meta name="googlebot" content="noindex">

Difference between revisions of "Using rxNorm with FHIR"

From HL7Wiki
Jump to navigation Jump to search
Line 15: Line 15:
 
= Filter properties =
 
= Filter properties =
  
* Identifier Type Type =     CUI|AUI       restrict to only one type  -- or should all filters only return CUIs?
+
{|
* Semantic Type   STY in/=   [COL:]Value   default column is TUI
+
! Description
* Source           SAB in/=  Value        value comes from (select RSAB from rxnsab)  (e.g. source = RXNORM)
+
! Property Name
* Term Type       TTY in/=   Value         value of TTY column in rxnconso
+
! Property Operators
 +
! Value
 +
! Comments
 +
 
 +
|- Identifier Type  
 +
| Type  
 +
| =  
 +
| CUI|AUI  
 +
| restrict to only one type  -- or should all filters only return CUIs?
 +
 
 +
|- Semantic Type
 +
| STY  
 +
| in/=
 +
| [COL:]Value
 +
| default column is TUI
 +
 
 +
|- Source        
 +
| SAB  
 +
| in/=
 +
| Value    
 +
| value comes from (select RSAB from rxnsab)  (e.g. source = RXNORM)
 +
 
 +
|- Term Type  
 +
| TTY  
 +
| in/=
 +
| Value  
 +
| value of TTY column in rxnconso
 +
 
 +
|}
  
 
= RxNorm Relationships =
 
= RxNorm Relationships =
  
 
[[File:RxNormRel.png]]
 
[[File:RxNormRel.png]]

Revision as of 12:58, 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

select Str from rxnconso where RXAUI = :code or (RXCUI = :code and SAB = 'RXNORM')

Filter properties

Description Property Name Property Operators Value Comments
Type = AUI restrict to only one type -- or should all filters only return CUIs?
STY in/= [COL:]Value default column is TUI
SAB in/= Value value comes from (select RSAB from rxnsab) (e.g. source = RXNORM)
TTY in/= Value value of TTY column in rxnconso

RxNorm Relationships

RxNormRel.png