The transfers table
Table source: Hospital database.
Table purpose: Physical locations for patients throughout their hospital stay.
Number of rows: 261,897
- PATIENTS on
- ADMISSIONS on
- ICUSTAYS on
- The ICUSTAYS table is derived from this table.
- Care units are defined based off the
WARDIDbeing associated with an ICU cost center.
- ICUs in the Beth Israel have moved throughout the years, and consequently the same
WARDIDmay be considered as an ICU for patient A but not an ICU for patient B.
|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 and
ICUSTAY_ID is unique to a patient ICU stay.
DBSOURCE contains the original ICU database the data was sourced from. Patients admitted between 2001 - 2008 had their data managed by the CareVue information system, represented in this column as ‘carevue’. Patients admitted between 2008 - 2012 had their data managed by the Metavision system, represented in this column as ‘metavision’. Knowing the database source is important as the data archiving for these two databases differs in some cases.
EVENTTYPE describes what transfer event occurred: ‘admit’ for an admission, ‘transfer’ for an inter-hospital transfer and ‘discharge’ for a discharge from the hospital.
PREV_CAREUNIT contains the care unit in which the patient previously resided.
CURR_CAREUNIT contains the care unit in which the patient currently resides. The care unit is defined based upon the ward: if the ward is an ICU cost center, then the care unit defines the type of ICU. If the ward is not an ICU then in most cases the care unit is null. There are one or two exceptions to this rule. For example,
NWARD is a ward for newborns.
OUTTIME of the transfer event correspond to the
PREV_CAREUNIT for each row is provided for convenience, and is identical to the
CURR_CAREUNIT of the previous row (assuming the event is not an admission).
Care units include the following:
|CCU||Coronary care unit|
|CSRU||Cardiac surgery recovery unit|
|MICU||Medical intensive care unit|
|NICU||Neonatal intensive care unit|
|SICU||Surgical intensive care unit|
|TSICU||Trauma/surgical intensive care unit|
CURR_WARDID contain the previous and current ward in which the patient stayed. Note that the grouping of physical locations in the hospital database is referred to as a ward. Though in practice ICUs are not referred to as wards, the hospital database technically tracks ICUs as “wards with an ICU cost center”. As a result, each ICU is associated with a
WARDID, but not every
WARDID is an ICU.
INTIME provides the date and time the patient was transferred into the current care unit from the previous care unit.
OUTTIME provides the date and time the patient was transferred out of the current care unit.
LOS is the length of stay for the patient for the given ward stay, which may be within or outside of the ICU.