How to add empirical therapy feature to a drug event

[jmethot (John Methot)]

@mpascualc, see this proposal by @rtmill that adds semantics to the FACT_RELATIONSHIP table via standard relationship concepts. I am helping formalize it for proposal to the CDM WG. The challenge will be to avoid explosion of the set of relationship concepts for miniscule cases. Please comment in that thread if you have thoughts to share.

Fact relationships: Searching for an extensible approach

Disclaimer: This post advocates for increased use of the FACT_RELATIONSHIP table and may not be suitable for all viewers. Problem: There is a growing list of disparate use cases that require persisting relationships between clinical events to which the existing foreign keys are insufficient. I view the overall goal simply as establishing a common convention. Not everyone will have this relational information explicitly in their data but for those that have use cases and wish to preserve it in …