This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
documentation:cdm:drug_strength [2016/03/07 14:51] cgreich |
documentation:cdm:drug_strength [2017/09/25 14:59] clairblacketer |
||
---|---|---|---|
Line 1: | Line 1: | ||
===== DRUG_STRENGTH table ===== | ===== DRUG_STRENGTH table ===== | ||
+ | **THIS IS OUTDATED. All documentation is now on the [[https://github.com/OHDSI/CommonDataModel/wiki|github wiki]]. Please refer there or to the [[projects:workgroups:cdm-wg|CDM working group]] for more information** | ||
+ | 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. | 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. | ||
Line 10: | Line 13: | ||
|numerator_value|No|float|The numeric value associated with the concentration of the active ingredient contained in the product| | |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.| | |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|No|float|The amount of total liquid (or other divisible product, such as ointment, gel, spray, etc.).| | + | |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.| | |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_start_date|Yes|date|The date when the Concept was first recorded. The default value is 1-Jan-1970.| |