How we describe "drug_type_concept_id" in terms of discharging order

Vocabulary Users
1

I like to describe “drug_type_concept_id” to ETL “drugs in terms of discharging order entry”, by the way there’re no matched concept_id for that in ATHENA. (so, how can i do ?)

In addition to first question, what’s difference between below 2 drug_concept_ids ? (does it contain meanings for “drug formulation” ?)

40163553 [Warfarin Sodium 5 MG] (class : Clinical Drug Comp)
40163554 [Warfarin Sodium 5 MG Oral Tablet] (class : Clinical Drug)

Thank you.

2

In addition to first question, what’s difference between below 2 drug_concept_ids ? (does it contain meanings for “drug formulation” ?)

40163553 [Warfarin Sodium 5 MG] (class : Clinical Drug Comp)
40163554 [Warfarin Sodium 5 MG Oral Tablet] (class : Clinical Drug)

40163553 is at the ingredient and strength level.
40163554 is at the ingredient, strength and form level. So it is more granular and at a lower level in terms of hierarchy.

40163554 consists of 40163553
40163553 constitutes 40163554

Run below queries and you will find out:

SELECT * FROM concept_relationship where concept_id_1 = 40163553 and concept_id_2 = 40163554
SELECT * FROM concept_relationship where concept_id_1 = 40163554 and concept_id_2 = 40163553

For your first question, I don’t see a matching concept.

1 Like