All, I am looking for guidance on how to track procedure revisions or re-operations in the OMOP data model.When a patient has for example hip surgery this event is tracked in the PROCEDURE_OCCURANCE. In the event where there is an issue with the original procedure and either a revision or re-operation is required the revision or reoperation is again stored in the PROCEDURE_OCCURANCE table but I want to track the fact that this is a revision and link back to the original procedure. Is the recommended way to create this relationship to use the FACT_RELATIONSHIP table with a relationship of “revision of” or something link that?
Thanks for any feedback.
Best Regards,
Colin