CREATE TABLE hrc_txn_console_entry (
    CONSOLE_ENTRY_ID                NUMBER(18, 0) ,
    TRANSACTION_ID                  NUMBER(18, 0)     NOT NULL,
    OBJECT_NAME                     VARCHAR2(1200),
    PROCESS_CATEGORY                VARCHAR2(800) ,
    CONSOLE_TXN_STATUS              VARCHAR2(120)     NOT NULL,
    STATUS_CATEGORY                 VARCHAR2(120)     NOT NULL,
    CHANGE_EFFECTIVE_DATE           DATE          ,
    TASK_ID                         VARCHAR2(400) ,
    TASK_STATE                      VARCHAR2(400) ,
    TASK_OUTCOME                    VARCHAR2(400) ,
    TASK_APPROVERS                  VARCHAR2(1200),
    OVERRIDE_INITIATOR_USER_NAME    VARCHAR2(256) ,
    OVERRIDE_IDENTIFICATION_KEY     VARCHAR2(400) ,
    SR_NUMBER                       VARCHAR2(800) ,
    TXN_GROUP_ID                    NUMBER(18, 0) ,
    HRC_TXN_CUSTOM_VARCHAR_1        VARCHAR2(800) ,
    HRC_TXN_CUSTOM_VARCHAR_2        VARCHAR2(800) ,
    HRC_TXN_CUSTOM_VARCHAR_3        VARCHAR2(800) ,
    HRC_TXN_CUSTOM_VARCHAR_4        VARCHAR2(800) ,
    HRC_TXN_CUSTOM_NUMBER_1         NUMBER(18, 0) ,
    HRC_TXN_CUSTOM_NUMBER_2         NUMBER(18, 0) ,
    HRC_TXN_CUSTOM_NUMBER_3         NUMBER(18, 0) ,
    HRC_TXN_CUSTOM_NUMBER_4         NUMBER(18, 0) ,
    HRC_TXN_CUSTOM_DATE_1           DATE          ,
    HRC_TXN_CUSTOM_DATE_2           DATE          ,
    CREATED_BY                      VARCHAR2(256)     NOT NULL,
    CREATION_DATE                   TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_DATE                TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY                 VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN               VARCHAR2(128) ,
    OBJECT_VERSION_NUMBER           NUMBER(9, 0)      NOT NULL,
    CONSOLE_ENTRY_ID                NUMBER(18, 0) ,
    TRANSACTION_ID                  NUMBER(18, 0)     NOT NULL,
    OBJECT_NAME                     VARCHAR2(1200),
    PROCESS_CATEGORY                VARCHAR2(800) ,
    CONSOLE_TXN_STATUS              VARCHAR2(120)     NOT NULL,
    STATUS_CATEGORY                 VARCHAR2(120)     NOT NULL,
    CHANGE_EFFECTIVE_DATE           DATE          ,
    TASK_ID                         VARCHAR2(400) ,
    TASK_STATE                      VARCHAR2(400) ,
    TASK_OUTCOME                    VARCHAR2(400) ,
    TASK_APPROVERS                  VARCHAR2(1200),
    SR_NUMBER                       VARCHAR2(800) ,
    HRC_TXN_CUSTOM_VARCHAR_1        VARCHAR2(800) ,
    HRC_TXN_CUSTOM_VARCHAR_2        VARCHAR2(800) ,
    HRC_TXN_CUSTOM_VARCHAR_3        VARCHAR2(800) ,
    HRC_TXN_CUSTOM_VARCHAR_4        VARCHAR2(800) ,
    HRC_TXN_CUSTOM_NUMBER_1         NUMBER(18, 0) ,
    HRC_TXN_CUSTOM_NUMBER_2         NUMBER(18, 0) ,
    HRC_TXN_CUSTOM_NUMBER_3         NUMBER(18, 0) ,
    HRC_TXN_CUSTOM_NUMBER_4         NUMBER(18, 0) ,
    HRC_TXN_CUSTOM_DATE_1           DATE          ,
    HRC_TXN_CUSTOM_DATE_2           DATE          ,
    CREATED_BY                      VARCHAR2(256)     NOT NULL,
    CREATION_DATE                   TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_DATE                TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY                 VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN               VARCHAR2(128) ,
    OBJECT_VERSION_NUMBER           NUMBER(9, 0)      NOT NULL,
    OVERRIDE_INITIATOR_USER_NAME    VARCHAR2(256) ,
    OVERRIDE_IDENTIFICATION_KEY     VARCHAR2(400) ,
    TXN_GROUP_ID                    NUMBER(18, 0) ,
    CONSTRAINT pk_hrc_txn_console_entry PRIMARY KEY (CONSOLE_ENTRY_ID, CONSOLE_ENTRY_ID)
);
