This wiki has undergone a migration to Confluence found Here
Talk:Using rxNorm with FHIR
Jump to navigation
Jump to search
Suggestion for REL and RELA
It will always be the case that the value set designer knows whether the specified UI is a CUI or an AUI. Further, it will never be the case that a given UI matches both a CUI and an AUI. For these reasons, I'd suggest replacing REL and RELA with the following.
Description | Property Name | Property Operators | Value | Comments | SQL clause for '=' operator |
---|---|---|---|---|---|
Relationship (A) | [REL] | in/= | [CUI:]Value | REL (:rel) is one of SY, SIB, RN, PAR, CHD, RB or RO, and Value is a RXCUI. | and RXCUI in (select RXCUI1 from rxnrel where REL = :rel and RXCUI2 = :value) |
Relationship (A) | [REL] | in/= | AUI:Value | REL (:rel) is one of SY, SIB, RN, PAR, CHD, RB or RO, and Value is a RXAUI. | and RXCUI in (select RXCUI from rxnconso where RXAUI in (select RXAUI1 from rxnrel where REL = :rel and RXAUI2 = :value)) |
Relationship (B) | [RELA] | in/= | [CUI:]Value | RELA (:rela) is one of the relationship types immediately below, and Value is a RXCUI | and RXCUI in (select RXCUI1 from rxnrel where RELA = :rela and RXCUI2 = :value) |
Relationship (B) | [RELA] | in/= | AUI:Value | RELA (:rela) is one of the relationship types immediately below, and Value is a RXAUI | and RXCUI in select RXCUI from rxnconso where RXAUI in (select RXAUI1 from rxnrel where RELA = :rela and RXAUI2 = :value)) |
Sdeerwester (talk) 17:40, 17 July 2014 (UTC)