next up previous contents
Next: 6.1.6.2 Primary key(s) Up: 6.1.6 CENSUSEVENTS Previous: 6.1.6 CENSUSEVENTS   Contents

6.1.6.1 Columns

Column Name Data Type Nullable Default value Comments
CENSUS_ID NUMBER N   Table record unique identifier, the census event id.
SUBJECT_ID NUMBER N   The partient for the census event.
INTIME DATE N   The time when the patient entered the ICU.
OUTTIME DATE Y   The time when the patient left the ICU.
CAREUNIT NUMBER Y   The originating care unit for the event.
DESTCAREUNIT NUMBER Y   The destination ICU
DISCHSTATUS VARCHAR2 Y   The discharge status of the patient.
LOS NUMBER Y   Length of Stay in minutes
ICUSTAY_ID NUMBER N   The ICU Stay this records refers to.

next up previous contents
Next: 6.1.6.2 Primary key(s) Up: 6.1.6 CENSUSEVENTS Previous: 6.1.6 CENSUSEVENTS   Contents
djscott 2010-08-24