| Name | Type | Nullable | Default value | Comment |
|---|
| CENSUS_ID | NUMBER(7) | N | | Table record unique identifier, the census event id. Tracks movement between ICU rooms |
| SUBJECT_ID | NUMBER(7) | N | | The patient for the census event. |
| INTIME | TIMESTAMP(6) WITH TIME ZONE | N | | The time when the patient entered the ICU. |
| OUTTIME | TIMESTAMP(6) WITH TIME ZONE | N | | The time when the patient left the ICU. |
| CAREUNIT | NUMBER(7) | Y | | The originating care unit for the event. |
| DESTCAREUNIT | NUMBER(7) | Y | | The destination ICU |
| DISCHSTATUS | VARCHAR2(20) | Y | | The discharge status of the patient. |
| LOS | NUMBER(38) | Y | | Length of stay in minutes |
| ICUSTAY_ID | NUMBER(7) | Y | | The ICU Stay this records refers to. |