Hello Chris and All,
CDRN ETL workgroup has identified several use cases that can leverage FACT_RELATIONSHIP table.
Explicitly link visits. Our use cases are Emergency Room or Outpatient visits resulting in Inpatient admissions.
We propose to use the following relationship concepts: ‘Occurs before’ (44818881) or ‘Occurs after’ (44818783).
Please note we considered and decided against combining any of these visits into one.
Explicitly link Systolic and Diastolic BP measurements.
We could not identify appropriate relationship concept, need a new one.
Use FACT_RELATIONSHIP to link records from any domain to its attributes stored in the OBSERVATION table in case OBSERVATION table does not have a foreign key to the domain in question (e.g. PERSON_ID or VISIT_OCCURRENCE_ID). Our use case is connecting diagnosis and diagnosis source which is not the first class attribute in the model. We propose to store diagnosis source in the OBSERVATION table and connect the CONDITION_OCCURRENCE and OBSERVATION records via FACT_RELATIONSHIP.
We can use relationship concept ‘Has property (SNOMED)’ (44818772) concept.
Thank you for your thoughts and consideration,