Sidebar
documentation:cdm:drug_strength
This is an old revision of the document!
DRUG_STRENGTH table
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.
| Field | Required | Type | Description |
|---|---|---|---|
| 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 corresponding to 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 corresponding to the concentration of active ingredient. |
| denominator_unit_concept_id | No | integer | A foreign key to the Concept in the CONCEPT table representing the identifier for the denominator Unit corresponding to 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. |
Conventions
- The DRUG_STRENGTH table contains information for each active (non-deprecated) drug.
- A drug which contains multiple active Ingredients will result multiple DRUG_STRENGTH records, one for each active ingredient.
- For drugs where the absolute Ingredient content is provided (usually solid formulations) the amount_value and amount_unit_concept_id are used to define this content.
- , in situations when the ingredient is contained within a non-solid formulation
documentation/cdm/drug_strength.1416057940.txt.gz · Last modified: 2014/11/15 13:25 by cgreich
