Storing note data from radiology, coronary angiography, and pathology report

[jmethot (John Methot)]

Please see this proposal by @rtmill on formalizing/extending the relationship concepts used in FACT_RELATIONSHIP to represent this type of relationship. There are many use cases like this.

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 …