Inconsistence issue regarding the ventilation and dialysis duration between chartevents.csv and procedureevents.csv

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

Hi,

I am trying to extract the ventilation and dialysis duration information from MIMIC-IV dataset. I saw the sql file which extracted the ventilation duration (by using some logic to determine the duration) and dialysis (no duration) information using chartevents.csv. I noticed that procedureevents.csv contains the start and end time for those, but seems a little bit inconsistent with what extracted from chartevents.csv. I was wondering why not extract from procedureevents.csv directly? Is it because the records from procedureevents.csv are incomplete or inaccurate? Thank you.

Start by reviewing the SQL extraction logic mentioned in the issue and compare its ventilation and dialysis results with the start and end times in chartevents.csv and procedureevents.csv. Check the online MIMIC documentation first, then determine whether the discrepancy reflects incomplete or inaccurate procedureevents.csv records; done means documenting a supported explanation.