Physical locations for patients throughout their hospital stay.
- patients on
- admissions on
icustaystable is derived from this table.
|Name||Postgres data type|
Identifiers which specify the patient:
subject_id is unique to a patient,
hadm_id is unique to a patient hospital stay,
stay_id is unique to a patient stay in a hospital unit,
transfer_id is unique to a patient physical location.
eventtype describes what transfer event occurred: ‘admit’ for an admission, ‘transfer’ for an intra-hospital transfer and ‘discharge’ for a discharge from the hospital.
careunit contains the care unit in which the patient currently resides.
outtime of the transfer event correspond to the
intime provides the date and time the patient was transferred into the current care unit (
careunit) from the previous care unit.
outtime provides the date and time the patient was transferred out of the current physical location.
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.