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 | The Unit corresponding to the numeric value of the amount of the active ingredient contained within the product. |
| numerator_value | No | float | The numeric value associated with the concentration of the active ingredient contained within the product |
| numerator_unit_concept_id | No | integer | The numerator unit corresponding to the numeric value of the concentration of the active ingredient contained within the product. |
| denominator_unit_concept_id | No | integer | The denominator unit corresponding to the numeric value of the concentration of the active ingredient contained within the product. |
| 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
- A clinical drug concept which contains multiple active ingredients will result in one drug strength record for each active ingredient.
- , in situations when the ingredient is contained within a solid formulation.
- , in situations when the ingredient is contained within a non-solid formulation
documentation/cdm/drug_strength.1416057480.txt.gz · Last modified: 2014/11/15 13:18 by cgreich
