Identification of time stamps for intraoperative and postoperative period for cardiac surgery patients in MIMIC-IV

Prerequisites

• Put an X between the brackets on this line if you have done all of the following:
  • Checked the online documentation: https://mimic.mit.edu/
  • Checked that your issue isn't already addressed: https://github.com/MIT-LCP/mimic-code/issues?utf8=%E2%9C%93&q=

Description

1. Could you help me identify the time stamps for start and end of surgical procedure (e.g. cardiac surgery) in MIMIC-IV.
   The surgical procedure is identified by icd_code from procedures_icd table however, the surgical procedure's start and end times are not explicitly mentioned in the procedureevents table. There are multiple events in the procedureevents table such as 'OR received', 'invasive ventilation', 'chest intubation' etc. Is there a way to find the timestamps so as to find the duration of surgery (corresponding to the icd_code from procedures_icd table)? With such timestamps one can also identify other events strictly during the surgery such as blood loss volume.
2. Usually patients have extended ICU stay post-surgery for close monitoring of patient's condition, however, I note that MAX(procedureevents.endtime) for a given patient is similar to icustays.outtime. How does one identify the postoperative period in ICU?

Start with the MIMIC-IV documentation and the procedures_icd, procedureevents, and icustays tables named in the issue. Compare their available timestamps and definitions to determine whether surgical and postoperative periods can be identified; done means providing a documented, reproducible interpretation or confirming that the requested timestamps are unavailable.