Main Tables Materialized Views Indexes Constraints DDL scrips
Description Columns Primary key Check Constraints Foreign keys Unique Keys Options Indexes Referenced by Triggers Partitions

MIMIC2V26.CENSUSEVENTS

Description:

Events which record ICU transfers

DDL script

Columns

NameTypeNullableDefault valueComment
CENSUS_IDNUMBER(7)N Table record unique identifier, the census event id. Tracks movement between ICU rooms
SUBJECT_IDNUMBER(7)N The patient for the census event.
INTIMETIMESTAMP(6) WITH TIME ZONEN The time when the patient entered the ICU.
OUTTIMETIMESTAMP(6) WITH TIME ZONEN The time when the patient left the ICU.
CAREUNITNUMBER(7)Y The originating care unit for the event.
DESTCAREUNITNUMBER(7)Y The destination ICU
DISCHSTATUSVARCHAR2(20)Y The discharge status of the patient.
LOSNUMBER(38)Y Length of stay in minutes
ICUSTAY_IDNUMBER(7)Y The ICU Stay this records refers to.

Primary key:

Constraint NameColumns
MIMIC2V26.CENSUSEV_PKCENSUS_ID

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
MIMIC2V26.CENSUSEV_FK2_D_CAREUNDESTCAREUNIT MIMIC2V26.D_CAREUNITS MIMIC2V26.D_CAREUNITS_PK NO ACTION
MIMIC2V26.CENSUSEV_FK_D_CAREUNCAREUNIT MIMIC2V26.D_CAREUNITS MIMIC2V26.D_CAREUNITS_PK NO ACTION
MIMIC2V26.CENSUSEV_FK_D_PATIENSUBJECT_ID MIMIC2V26.D_PATIENTS MIMIC2V26.D_PATIENTS_PK NO ACTION
MIMIC2V26.CENSUSEV_FK_ICUSTAYICUSTAY_ID MIMIC2V26.ICUSTAYEVENTS MIMIC2V26.ICUSTAYEV_PK NO ACTION

Options:

OptionSettings
TablespaceMIMIC2_DAT
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumnsDDL script
MIMIC2V26.CENSUSEVENTS_01NORMALNONUNIQUEDESTCAREUNIT DDL script
MIMIC2V26.CENSUSEVENTS_O2NORMALNONUNIQUESUBJECT_ID DDL script
MIMIC2V26.CENSUSEVENTS_O3NORMALNONUNIQUEICUSTAY_ID DDL script
MIMIC2V26.CENSUSEVENTS_O4NORMALNONUNIQUECAREUNIT DDL script
MIMIC2V26.CENSUSEVENTS_U1FUNCTION-BASED NORMALNONUNIQUESUBJECT_ID , SYS_EXTRACT_UTC("INTIME") DDL script
MIMIC2V26.CENSUSEV_PKNORMALUNIQUECENSUS_ID DDL script