Drug Queries‎ > ‎

D28: Find drug strength

This query is designed to display strength and units of measure of clinical, generic or branded drug

Input:
 Parameter  Example  Mandatory  Notes
 Drug Concept ID  42801011  Yes Concept ID for clinical name ‘Moexipril hydrochloride 15 MG Oral Tablet’.

Sample query run:
The following are sample runs of the query to extract ingredient dose. The input parameters are highlighted in blue.
SELECT drug_concept_id,
       cd.concept_name AS drug_name,
       ingredient_concept_id,
       ci.concept_name AS ingredient_name,
       amount_value,
       amount_unit,
       concentration_value,
       concentration_enum_unit,
       concentration_denom_unit,
       d.valid_start_date,
       d.valid_end_date,
       d.invalid_reason
FROM drug_strength d, 
     concept cd,
     concept ci
WHERE drug_concept_id = 42801011
  AND drug_concept_id = cd.concept_id
  AND ingredient_concept_id = ci.concept_id
Output:
Output field list:
 Field  Description
 Drug_Concept_ID  Concept ID of drug (clinical/generic or branded)
 Drug_Name  Name of drug
 Ingredient_Concept_ID  Concept ID of the ingredient
 Ingredient_Name  Name of the ingredient
 Amount_Value  Numerical value of drug amount
 Amount_Unit  Unit of measure
 Concentration_Value  Numerical value of concentration
 Concentration_Enum_Unit  Enumerated unit of measure of concentration
 Concentration_Denom_Unit  Denominated unit of measure of concentration
 Valid_Start_Date  Valid record as of specific start date
 Valid_End_Date  Valid record until specific end date
 Invalid_Reason  Reason why record is no longer valid

Sample output record:
 Field  Value
 Drug_Concept_ID  42801011
 Drug_Name  Moexipril hydrochloride 15 MG Oral Tablet
 Ingredient_Concept_ID  1310756
 Ingredient_Name  moexipril
 Amount_Value  15
 Amount_Unit  mg
 Concentration_Value  
 Concentration_Enum_Unit  
 Concentration_Denom_Unit  
 Valid_Start_Date  7/2/2012
 Valid_End_Date  12/31/2099
 Invalid_Reason  
Comments