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.POE_ORDER

Description:

POE Orders. Each row in this table indicates a POE order with start and stop dates and instructios for administration. The POE_MED table contains the individual medications which comprise the order

DDL script

Columns

NameTypeNullableDefault valueComment
POE_IDNUMBER(15)N Unique POE identifier
SUBJECT_IDNUMBER(7)N Unique subject identifier
HADM_IDNUMBER(7)N Unique hospital admission identifier
ICUSTAY_IDNUMBER(7)Y Unique ICU stay identifier
START_DTTIMESTAMP(6) WITH TIME ZONEY Start date of the POE order
STOP_DTTIMESTAMP(6) WITH TIME ZONEY Stop date of the POE order
ENTER_DTTIMESTAMP(6) WITH TIME ZONEN Entry date of the POE order
MEDICATIONVARCHAR2(255)Y Medication
PROCEDURE_TYPEVARCHAR2(50)Y Procedure type
STATUSVARCHAR2(50)Y Status
ROUTEVARCHAR2(50)Y Route
FREQUENCYVARCHAR2(50)Y Frequency of dose
DISPENSE_SCHEDVARCHAR2(255)Y Dispensing schedule
IV_FLUIDVARCHAR2(255)Y IV fluid used
IV_RATEVARCHAR2(100)Y IV Rate
INFUSION_TYPEVARCHAR2(15)Y Infusion type
SLIDING_SCALECHAR(1)Y Sliding scale
DOSES_PER_24HRSNUMBER(38)Y Doses per 24hr period
DURATIONNUMBER(38)Y Duration of order
DURATION_INTVLVARCHAR2(15)Y Interval between doses
EXPIRATION_VALNUMBER(38)Y Expiration value
EXPIRATION_UNITVARCHAR2(50)Y Expiration unit
EXPIRATION_DTTIMESTAMP(6) WITH TIME ZONEY Expiration date
LABEL_INSTRVARCHAR2(1000)Y Instructions on label
ADDITIONAL_INSTRVARCHAR2(1000)Y General additional instructions
MD_ADD_INSTRVARCHAR2(4000)Y Additional instructions from MD
RNURSE_ADD_INSTRVARCHAR2(1000)Y Additional instructions from a registered nurse

Primary key:

Constraint NameColumns
MIMIC2V26.POE_ORDER_PKPOE_ID

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
MIMIC2V26.POE_ORDER_FK_ADMISSHADM_ID MIMIC2V26.ADMISSIONS MIMIC2V26.ADMISSIONS_PK NO ACTION
MIMIC2V26.POE_ORDER_FK_D_PATIENSUBJECT_ID MIMIC2V26.D_PATIENTS MIMIC2V26.D_PATIENTS_PK NO ACTION
MIMIC2V26.POE_ORDER_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.POE_ORDER_O1NORMALNONUNIQUESUBJECT_ID , HADM_ID DDL script
MIMIC2V26.POE_ORDER_O2NORMALNONUNIQUESUBJECT_ID DDL script
MIMIC2V26.POE_ORDER_O3NORMALNONUNIQUEHADM_ID DDL script
MIMIC2V26.POE_ORDER_O4NORMALNONUNIQUEICUSTAY_ID DDL script
MIMIC2V26.POE_ORDER_PKNORMALUNIQUEPOE_ID DDL script

Referenced by:

TableConstraint
MIMIC2V26.POE_MED MIMIC2V26.POE_MED_POE_ORDER_FK1