I’m new here, and was hoping for some help.
I’m interested in representing surgeries data. Surgeries are currently represented in PROCEDURE_OCCURRENCE table. But I would like in addition to procedure_datetime, also end time of procedure.
I see two alternatives:
- Add a column procedure_end_datetime to PROCEDURE_OCCURRENCE table.
- Use VISIT_DETAIL table which already have visit_detail_end_datetime for each surgery.
First options sounds to me more adequate to represent clinical procedures which have a duration, but requires to (slightly) edit the CDM. Where the second option is already ‘ready to use’, but conceptually, a procedure is not a visit so it does not seem to be the best representation.
What do you think?