Summary of Proposal

  1. Add records for Ingredients and Drug forms containing standard units for each ingredient.
  2. Define convention for quantity: Either as number of product unites, or as amount of ingredient. See below.
  3. Remove effective_drug_dose.
  4. Introduce verbatim_end_date. drug_exposure_end_date would no longer be nullable, and contain the verbatim, start_date+days_supply or a value that was determined through some ETL heuristic