OHDSI Home | Forums | Wiki | Github

Ingredient Drugs that have Units?


(Erica Voss) #1

Question, should ingredient drugs have units associated to them? Am I doing this query incorrectly to find units?

Run on 20190617.

Query:

SELECT c1.CONCEPT_ID, c1.CONCEPT_NAME, c1.CONCEPT_CLASS_ID, 
	c3.CONCEPT_NAME AS UNIT_CONCEPT_NAME
FROM CONCEPT c1
	LEFT OUTER JOIN DRUG_STRENGTH ds
		ON ds.DRUG_CONCEPT_ID = c1.CONCEPT_ID
	LEFT OUTER JOIN CONCEPT c3
		ON c3.CONCEPT_ID = ds.AMOUNT_UNIT_CONCEPT_ID
WHERE c1.CONCEPT_ID = 742185

Result:
image


(Anna Ostropolets) #2

Yes, they should. As you can see, in this case drug_concept_id=ingredient_concept_id.
On of the uses of unit-ingredient pair is to populate Quantity field in DRUG_EXPOSURE. If you have ingredient as your exposure, you can put the overall dose of exposure in the Quantity and use the unit from DRUG_STRENGTH.


t