For a database regarding blood products, I would like to link transfusions, SNOMED concepts recorded in procedure_occurrence, to details of the units used, ISBT concepts in device_exposure.
To accomplish this it appears that I should use the fact_relationship table, using concepts 44818787 and 44818885, “Has procedure device (SNOMED)” and " Procedure device of (SNOMED)", respectively.
Would this be an appropriate approach? Is there a better way?
Thanks!
Gerry