documentation:cdm:drug_strength
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| documentation:cdm:drug_strength [2016/03/07 14:44] – cgreich | documentation:cdm:drug_strength [2017/09/25 14:59] (current) – clairblacketer | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ===== DRUG_STRENGTH table ===== | ===== DRUG_STRENGTH table ===== | ||
| + | **THIS IS OUTDATED. All documentation is now on the [[https:// | ||
| + | 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 |
| |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.| | ||
| Line 24: | Line 27: | ||
| * If the concentration is provided (for example ' | * If the concentration is provided (for example ' | ||
| * In case of Quantified Clinical or Branded Drugs the denominator_value contains the total amount of the solution (not the amount of the ingredient). In all other drug concept classes the denominator amount is NULL because the concentration is always normalized to the unit of the denominator. So, a product containing 960 mg in 20 mL is provided as 48 mg/mL in the Clinical Drug and Clinical Drug Component, while as a Quantified Clinical Drug it is written as 960 mg/20 mL. | * In case of Quantified Clinical or Branded Drugs the denominator_value contains the total amount of the solution (not the amount of the ingredient). In all other drug concept classes the denominator amount is NULL because the concentration is always normalized to the unit of the denominator. So, a product containing 960 mg in 20 mL is provided as 48 mg/mL in the Clinical Drug and Clinical Drug Component, while as a Quantified Clinical Drug it is written as 960 mg/20 mL. | ||
| - | * Strength | + | * If the strength is provided in % (volume or mass-percent are not distinguished) |
| - | * Sometimes, one Ingredient is listed with different units within the same drug. This is very rare, and usually this happens if there are more than one Precise Ingredient. For example, ' | + | * Sometimes, one Ingredient is listed with different units within the same drug. This is very rare, and usually this happens if there are more than one Precise Ingredient. For example, ' |
| + | * Sometimes, different ingredients in liquid drugs are listed with different units in the denominator_unit_concept_id. This is usually the case if the ingredients are liquids themselves (concentration provided as mL/mL) or solid substances (mg/mg). In these cases, the general assumptions is made that the density of the drug is that of water, and one can assume 1 g = 1 mL. | ||
| * All Drug vocabularies containing Standard Concepts have entries in the DRUG_STRENGTH table. | * All Drug vocabularies containing Standard Concepts have entries in the DRUG_STRENGTH table. | ||
documentation/cdm/drug_strength.1457361845.txt.gz · Last modified: by cgreich