CREATE TABLE iex_strategy_work_items (
    WORK_ITEM_ID              NUMBER(18, 0) ,
    STRATEGY_ID               NUMBER(18, 0)     NOT NULL,
    WORK_ITEM_TEMPLATE_ID     NUMBER(18, 0)     NOT NULL,
    RESOURCE_ID               NUMBER(18, 0) ,
    STATUS_CODE               VARCHAR2(120) ,
    EXECUTE_START             DATE          ,
    EXECUTE_END               DATE          ,
    CREATION_DATE             TIMESTAMP(6)      NOT NULL,
    CREATED_BY                VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE          TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY           VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(128) ,
    PROGRAM_ID                NUMBER        ,
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)      NOT NULL,
    REQUEST_ID                NUMBER(18, 0) ,
    SECURITY_GROUP_ID         NUMBER        ,
    PROGRAM_APPLICATION_ID    NUMBER        ,
    PROGRAM_UPDATE_DATE       DATE          ,
    SCHEDULE_START            DATE          ,
    SCHEDULE_END              DATE          ,
    STRATEGY_TEMP_ID          NUMBER(18, 0)     NOT NULL,
    WORK_ITEM_ORDER           NUMBER(18, 0) ,
    UWQ_STATUS                VARCHAR2(960) ,
    UWQ_ACTIVE_DATE           DATE          ,
    UWQ_COMPLETE_DATE         DATE          ,
    ESCALATED_YN              VARCHAR2(4)   ,
    PRE_EXECUTION_WAIT        NUMBER        ,
    PRE_EXECUTION_TIME_UOM    VARCHAR2(960) ,
    EXECUTION_TIME_UOM        VARCHAR2(960) ,
    POST_EXECUTION_WAIT       NUMBER        ,
    XDO_TEMP_ID               NUMBER        ,
    OPTIONAL_YN               VARCHAR2(20)  ,
    OPTIONAL_WAIT_TIME        NUMBER        ,
    OPTIONAL_WAIT_TIME_UOM    VARCHAR2(240) ,
    NOTIFY_YN                 VARCHAR2(12)  ,
    ESCALATE_YN               VARCHAR2(24)  ,
    ESCALATE_WAIT_TIME        NUMBER        ,
    ESCALATE_WAIT_TIME_UOM    VARCHAR2(240) ,
    CUSTOM_WORKFLOW_TYPE      VARCHAR2(960) ,
    TEMPLATE_NAME             VARCHAR2(960) ,
    PAYMENT_SCHEDULE_ID       NUMBER        ,
    COMMENTS                  VARCHAR2(4000),
    OUTCOME_TYPE_CODE         VARCHAR2(120) ,
    WORK_ITEM_ID              NUMBER(18, 0) ,
    STRATEGY_ID               NUMBER(18, 0)     NOT NULL,
    WORK_ITEM_TEMPLATE_ID     NUMBER(18, 0)     NOT NULL,
    RESOURCE_ID               NUMBER(18, 0) ,
    STATUS_CODE               VARCHAR2(120) ,
    EXECUTE_START             DATE          ,
    EXECUTE_END               DATE          ,
    CREATION_DATE             TIMESTAMP(6)      NOT NULL,
    CREATED_BY                VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE          TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY           VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(128) ,
    PROGRAM_ID                NUMBER        ,
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)      NOT NULL,
    REQUEST_ID                NUMBER(18, 0) ,
    SECURITY_GROUP_ID         NUMBER        ,
    PROGRAM_APPLICATION_ID    NUMBER        ,
    PROGRAM_UPDATE_DATE       DATE          ,
    SCHEDULE_START            DATE          ,
    SCHEDULE_END              DATE          ,
    STRATEGY_TEMP_ID          NUMBER(18, 0)     NOT NULL,
    WORK_ITEM_ORDER           NUMBER(18, 0) ,
    UWQ_STATUS                VARCHAR2(960) ,
    UWQ_ACTIVE_DATE           DATE          ,
    UWQ_COMPLETE_DATE         DATE          ,
    ESCALATED_YN              VARCHAR2(4)   ,
    PRE_EXECUTION_WAIT        NUMBER        ,
    PRE_EXECUTION_TIME_UOM    VARCHAR2(960) ,
    EXECUTION_TIME_UOM        VARCHAR2(960) ,
    POST_EXECUTION_WAIT       NUMBER        ,
    XDO_TEMP_ID               NUMBER        ,
    OPTIONAL_YN               VARCHAR2(20)  ,
    OPTIONAL_WAIT_TIME        NUMBER        ,
    OPTIONAL_WAIT_TIME_UOM    VARCHAR2(240) ,
    NOTIFY_YN                 VARCHAR2(12)  ,
    ESCALATE_YN               VARCHAR2(24)  ,
    ESCALATE_WAIT_TIME        NUMBER        ,
    ESCALATE_WAIT_TIME_UOM    VARCHAR2(240) ,
    CUSTOM_WORKFLOW_TYPE      VARCHAR2(960) ,
    TEMPLATE_NAME             VARCHAR2(960) ,
    PAYMENT_SCHEDULE_ID       NUMBER        ,
    COMMENTS                  VARCHAR2(4000),
    OUTCOME_TYPE_CODE         VARCHAR2(120) ,
    CONSTRAINT pk_iex_strategy_work_items PRIMARY KEY (WORK_ITEM_ID, WORK_ITEM_ID)
);
