DRUG_STRENGTH

Table Description

The DRUG_STRENGTH table contains structured content about the amount or concentration and associated units of a specific ingredient contained within a particular drug product. This table is supplemental information to support standardized analysis of drug utilization.

CDM Field	User Guide	ETL Conventions	Datatype	Required	Primary Key	Foreign Key	FK Table	FK Domain
drug_concept_id	The Concept representing the Branded Drug or Clinical Drug Product.		integer	Yes	No	Yes	CONCEPT
ingredient_concept_id	The Concept representing the active ingredient contained within the drug product.	Combination Drugs will have more than one record in this table, one for each active Ingredient.	integer	Yes	No	Yes	CONCEPT
amount_value	The numeric value or the amount of active ingredient contained within the drug product.		float	No	No	No
amount_unit_concept_id	The Concept representing the Unit of measure for the amount of active ingredient contained within the drug product.		integer	No	No	Yes	CONCEPT
numerator_value	The concentration of the active ingredient contained within the drug product.		float	No	No	No
numerator_unit_concept_id	The Concept representing the Unit of measure for the concentration of active ingredient.		integer	No	No	Yes	CONCEPT
denominator_value	The amount of total liquid (or other divisible product, such as ointment, gel, spray, etc.).		float	No	No	No
denominator_unit_concept_id	The Concept representing the denominator unit for the concentration of active ingredient.		integer	No	No	Yes	CONCEPT
box_size	The number of units of Clinical Branded Drug or Quantified Clinical or Branded Drug contained in a box as dispensed to the patient.		integer	No	No	No
valid_start_date	The date when the Concept was first recorded. The default value is 1-Jan-1970.		date	Yes	No	No
valid_end_date	The date when then Concept became invalid.		date	Yes	No	No
invalid_reason	Reason the concept was invalidated. Possible values are D (deleted), U (replaced with an update) or NULL when valid_end_date has the default value.		varchar(1)	No	No	No