This table had the field denominator_value added with version 5.0.1 (5-Apr-2016) of the OMOP CDM.
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.
|drug_concept_id||Yes||integer||A foreign key to the Concept in the CONCEPT table representing the identifier for Branded Drug or Clinical Drug Concept.|
|ingredient_concept_id||Yes||integer||A foreign key to the Concept in the CONCEPT table, representing the identifier for drug Ingredient Concept contained within the drug product.|
|amount_value||No||float||The numeric value associated with the amount of active ingredient contained within the product.|
|amount_unit_concept_id||No||integer||A foreign key to the Concept in the CONCEPT table representing the identifier for the Unit for the absolute amount of active ingredient.|
|numerator_value||No||float||The numeric value associated with the concentration of the active ingredient contained in the product|
|numerator_unit_concept_id||No||integer||A foreign key to the Concept in the CONCEPT table representing the identifier for the numerator Unit for the concentration of active ingredient.|
|denominator_value (V5.0.1)||No||float||The amount of total liquid (or other divisible product, such as ointment, gel, spray, etc.).|
|denominator_unit_concept_id||No||integer||A foreign key to the Concept in the CONCEPT table representing the identifier for the denominator Unit for the concentration of active ingredient.|
|valid_start_date||Yes||date||The date when the Concept was first recorded. The default value is 1-Jan-1970.|
|valid_end_date||Yes||date||The date when the concept became invalid because it was deleted or superseded (updated) by a new Concept. The default value is 31-Dec-2099.|
|invalid_reason||No||varchar(1)||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.|