Documentation
Common Data Model (CDM)
Convert Database to CDM (ETL)
Tool Specific Documentation
Common Data Model (CDM)
Convert Database to CDM (ETL)
Tool Specific Documentation
This is an old revision of the document!
We propose to abolish the effective_drug_dose field from the DRUG_EXPOSURE table or renaming it to drug_strength_value and possibly adding a effective_drug_form field.
We need to have a way to define drug_strength if we have no product information, but only ingredients or drug forms, or if like in chemotherapies or pediatric preparations the drug strength is not defined by the product.
Currently, this information is stored as:
drug_concept_id - contains the ingredient quantity or effective drug_dose - value nowhere or dose_unit_concept_id - unit
This works well for ingredients and uni-ingredient drug forms. We should however define a single way of doing it.
Also, we have a problem with multi-ingredient drug forms, because we only have one field.
Calculation of daily or total dose of a DRUG_EXPOSURE record.