| Name | Type | Nullable | Default value | Comment |
|---|
| ICUSTAY_ID | NUMBER(7) | Y | | Unique ICU stay identifier |
| SUBJECT_ID | NUMBER(7) | Y | | Unique subject identifier |
| GENDER | VARCHAR2(1) | Y | | Subject's gender "M" or "F" |
| DOB | DATE | N | | Subject's date of birth |
| DOD | DATE | Y | | Subject's date of death |
| EXPIRE_FLG | VARCHAR2(1) | Y | | Subject is dead (including in hospital and after discharge). Valid for 1 year after date of discharge. |
| SUBJECT_ICUSTAY_TOTAL_NUM | NUMBER(38) | Y | | Subject's total ICU stays |
| SUBJECT_ICUSTAY_SEQ | NUMBER(38) | Y | | Overall order of subject's ICU stays |
| HADM_ID | NUMBER(7) | Y | | Hospital admission ID |
| HOSPITAL_TOTAL_NUM | NUMBER(38) | Y | | Subject's number of hospital admissions |
| HOSPITAL_SEQ | NUMBER(38) | Y | | Order of subject's hospital admissions |
| HOSPITAL_FIRST_FLG | CHAR(1) | Y | | Flag to indicate a subject's first hospital admission |
| HOSPITAL_LAST_FLG | CHAR(1) | Y | | Flag to indicate a subject's last hospital admission |
| HOSPITAL_ADMIT_DT | DATE | Y | | Hopsital admission date |
| HOSPITAL_DISCH_DT | DATE | Y | | Hopsital discharge date |
| HOSPITAL_LOS | NUMBER(38) | Y | | Hospital length of stay (minutes) |
| HOSPITAL_EXPIRE_FLG | CHAR(1) | Y | | Subject death during hospital admission |
| ICUSTAY_TOTAL_NUM | NUMBER(38) | Y | | Number of ICU stays during a subject's admission |
| ICUSTAY_SEQ | NUMBER(38) | Y | | Order of subject's ICU stays within an admission |
| ICUSTAY_FIRST_FLG | CHAR(1) | Y | | Flag to indicate a subject's first ICU stay (within an admission) |
| ICUSTAY_LAST_FLG | CHAR(1) | Y | | Flag to indicate a subject's last ICU stay (within an admission) |
| ICUSTAY_INTIME | TIMESTAMP(6) WITH TIME ZONE | N | | Time that the subject was admitted to the ICU |
| ICUSTAY_OUTTIME | TIMESTAMP(6) WITH TIME ZONE | N | | Time that the subject was discharged from the ICU |
| ICUSTAY_ADMIT_AGE | NUMBER(38) | Y | | Age of subject on admission to the ICU (Years, to 4 decimal places) |
| ICUSTAY_AGE_GROUP | VARCHAR2(7) | Y | | Age grouping: >=15 -> 'adult', <=1 -> 'neonate', else -> 'middle' |
| ICUSTAY_LOS | NUMBER(38) | N | | Length of ICU stay (minutes) |
| ICUSTAY_EXPIRE_FLG | CHAR(1) | Y | | Died in ICU (assumed from icustay_outtime > hospital discharge AND died in hospital) |
| ICUSTAY_FIRST_CAREUNIT | VARCHAR2(20) | Y | | First careunit location |
| ICUSTAY_LAST_CAREUNIT | VARCHAR2(20) | Y | | Last careunit location |
| ICUSTAY_FIRST_SERVICE | VARCHAR2(110) | Y | | First careunit location |
| ICUSTAY_LAST_SERVICE | VARCHAR2(110) | Y | | Last careunit location |
| HEIGHT | NUMBER(38) | Y | | The first entered height of the patient |
| WEIGHT_FIRST | NUMBER(38) | Y | | The first entered weight of the patient |
| WEIGHT_MIN | NUMBER(38) | Y | | The minimum entered weight of the patient |
| WEIGHT_MAX | NUMBER(38) | Y | | The maximum entered weight of the patient |
| SAPSI_FIRST | NUMBER(38) | Y | | The first (available) SAPS-I score of the patient |
| SAPSI_MIN | NUMBER(38) | Y | | The minimum (available) SAPS-I score of the patient |
| SAPSI_MAX | NUMBER(38) | Y | | The maximum (available) SAPS-I score of the patient |
| SOFA_FIRST | NUMBER(38) | Y | | The first (available) SOFA score of the patient |
| SOFA_MIN | NUMBER(38) | Y | | The minimum (available) SOFA score of the patient |
| SOFA_MAX | NUMBER(38) | Y | | The maximum (available) SOFA score of the patient |
| MATCHED_WAVEFORMS_NUM | NUMBER(38) | Y | | The number of waveforms matched to this subject |