I have a terminology relationship question.
It is best demonstrated by an example
Neomycin (athena CID: 21605153) is member of several ATC classes
(such as S02AA07,D06AX04,S01AA03,A07AA01)
This is reflected by relationships with ID 'ATC - RxNorm'
21603795 1378509 ATC - RxNorm
21603016 1733765 ATC - RxNorm
21602252 1776430 ATC - RxNorm
21605128 19008339 ATC - RxNorm
21601686 1319998 ATC - RxNorm
This is great knowledge in CDM vocabulary. (and great relationship ID)
I am a grateful for such mapping.
Some ingredient concepts are now in RxNorm Extension.
To map RxNorm Extension ingredients to their ATC class - what relationship can be used?
(for eample for last concept of dapoxetine - the answer should be G04BX14 )
(I suspect the answer will be: no volunteer did that yet. (and that is OK answer. just confirmation of that is perfectly fine answer)
(I prefer to use relationships (and not concept_ancestor table, but solution using that is fine too)
current relationships for 21014127,Dapoxetine have no similar relationship in the style of "ATC - RxNorm Extension".
What I see is
CONCEPT_ID_1 CONCEPT_ID_2 RELATIONSHIP_ID
1 21014127 21015690 Has brand name
2 21014127 21066484 RxNorm ing of
3 21014127 21105795 RxNorm ing of
4 21014127 21086130 RxNorm ing of
5 21014127 21014127 Maps to
6 21014127 21014127 Mapped from
I am using version 24-APR-17.
(on a related note, our public server seems not to have RxNorm extension concepts at all)