edstays and hospadmission not matching

[rriccilopes]

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 guys, I'm looking into ED patients. Let's take the hadm_id=26996526 for example.
So.. in the admission table, there is an admittime, dischtime, edregtime, edouttime. The edouttime is not matching the outtime from edstays. Which one should be the correct one?
Also, please help me understand the pipeline. The patient was first admitted to the ED, than discharged from the ED and admitted to the Hospital, right? When admitted to the hospital, how can I see where he was (which ward)? There are no ICUstays for that hadm_id. I see that he had labevents during that period but he was no longer in the ED.
Thanks!

[alistairewj]

Hi guys, I'm looking into ED patients. Let's take the hadm_id=26996526 for example. So.. in the admission table, there is an admittime, dischtime, edregtime, edouttime. The edouttime is not matching the outtime from edstays. Which one should be the correct one?

There are multiple times documented for when a patient leaves the ED. We tried not to modify them, but they are inconsistent. The time from edstays should match transfers, and there isn't an easy way retrospectively to decide which is "correct". At least we couldn't find one.

Also, please help me understand the pipeline. The patient was first admitted to the ED, than discharged from the ED and admitted to the Hospital, right? When admitted to the hospital, how can I see where he was (which ward)? There are no ICUstays for that hadm_id. I see that he had labevents during that period but he was no longer in the ED. Thanks!

Check out the transfers table. This table represents the admission/discharge/transfer record for all patients. It stores all inter-ward transfers once a patient is hospitalized. For convenience, we added in a row representing ED stays, though strictly speaking the ED is not a part of the hospital (it's a clinic). Either way, you can use transfers to track a patient from the ED, through any hospital wards, and then to discharge.