OHDSI Home | Forums | Wiki | Github

Searching ATC to standard concept id(RxNorm) and relationship


(Ildong Lee) #1

Dear sir,

I’m defining code set for Diabetes Drugs by using ATC. I’m facing difficulties finding the right concept id through direct coding using the SQL query tool from DB. I could find it in Athena, ATC to RxNorm ingredient(from the relationship Table) but there is no such thing in DB. I only found ATC-Rxnorm but the description of the content was a bit different and it makes me confused.

in case A10BD01,
Athena: |40030439|chlorpropamide / phenformin Oral Tablet|ATC to RxNorm|RxNorm|
|40046145|glyburide / phenformin Oral Tablet|ATC to RxNorm|RxNorm|

DB:
SELECT * FROM concept WHERE concept_code = ‘A10BD01’
SELECT * FROM concept_relationship WHERE concept_id_1 = 21600767 and relationship_id = ‘Map to’
No results.

  • I downloaded vocabulary from Athena and loaded Psql server, CDM V6.
    Please guide me in right direction?
    thank you

(Zion Jung) #2

how about this query.
SELECT * FROM concept_relationship WHERE concept_id_1 = 21600767 and relationship_id = ‘ATC - RxNorm’;


(Anna Ostropolets) #3

To get the list of RxNorm drugs please use concept_ancestor:
select * from concept_ancestor join concept on descendant_concept_id = concept_id where ancestor_concept_id=21600767;

You can check out this post.

What do you mean by ICD-10 - RxNorm relationships? These are two separate vocabs serving different domains with no relationships between them.


(Ildong Lee) #4

than you.
i tried but there is no result… appreciate your attention.


(Ildong Lee) #5

thank you for your help
i will read your post.

appreciate your attention :slight_smile:

  • in regards of ICD I got confused with KCD sorry for misconception

t