Decide on where to house condition/episode modifiers.

[mgurley]

A modified measurement table or a new modifier table or something else.

• MEASUREMENT with polymorphic key
  • Pros
  • Not a new redundant structure.
  • Some modifiers can be recorded independent of a diagnosis.
  • Cons
    • Nullable foreign key.
• MODIFIER table
  • Pros
  • Constrained by a domain to distinguish which measurements are modifiers.
  • No nullable foreign key.
  • Cons
    • Some modifiers can be recorded independent of a diagnosis.
    • Add new redundant structure.
• Other option?

[mgurley]

MODIFIER table is recommended in the Oncology/Episode of Care Combined Proposal https://github.com/OHDSI/CommonDataModel/issues/239