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|
SELECT * FROM concept WHERE concept_code = ‘A10BD01’
SELECT * FROM concept_relationship WHERE concept_id_1 = 21600767 and relationship_id = ‘Map to’
- I downloaded vocabulary from Athena and loaded Psql server, CDM V6.
Please guide me in right direction?