CREATE TABLE anc_wfm_interface_header (
    WFM_IFACE_HDR_ID         NUMBER(18, 0),
    HEADER_ID                NUMBER(18, 0)    NOT NULL,
    ENTERPRISE_ID            NUMBER(18, 0)    NOT NULL,
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)     NOT NULL,
    PERSON_ID                NUMBER(18, 0)    NOT NULL,
    PER_ABS_ENTRY_ID         NUMBER(18, 0)    NOT NULL,
    PER_ABS_TYPE_ENTRY_ID    NUMBER(18, 0)    NOT NULL,
    START_DATETIME           TIMESTAMP(6)     NOT NULL,
    END_DATETIME             TIMESTAMP(6) ,
    ABSENCE_TYPE_ID          NUMBER(18, 0)    NOT NULL,
    TRANSACTION_ID           NUMBER(18, 0),
    USER_OPERATION           VARCHAR2(80)     NOT NULL,
    DML_OPERATION            VARCHAR2(80)     NOT NULL,
    STATUS_TIME              TIMESTAMP(6)     NOT NULL,
    PROCESS_STATUS           NUMBER(3, 0) ,
    CREATED_BY               VARCHAR2(256)    NOT NULL,
    CREATION_DATE            TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY          VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE         TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN        VARCHAR2(128),
    WFM_IFACE_HDR_ID         NUMBER(18, 0),
    HEADER_ID                NUMBER(18, 0)    NOT NULL,
    ENTERPRISE_ID            NUMBER(18, 0)    NOT NULL,
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)     NOT NULL,
    PER_ABS_ENTRY_ID         NUMBER(18, 0)    NOT NULL,
    PER_ABS_TYPE_ENTRY_ID    NUMBER(18, 0)    NOT NULL,
    TRANSACTION_ID           NUMBER(18, 0),
    USER_OPERATION           VARCHAR2(80)     NOT NULL,
    DML_OPERATION            VARCHAR2(80)     NOT NULL,
    STATUS_TIME              TIMESTAMP(6)     NOT NULL,
    PROCESS_STATUS           NUMBER(3, 0) ,
    CREATED_BY               VARCHAR2(256)    NOT NULL,
    CREATION_DATE            TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY          VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE         TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN        VARCHAR2(128),
    PERSON_ID                NUMBER(18, 0)    NOT NULL,
    START_DATETIME           TIMESTAMP(6)     NOT NULL,
    END_DATETIME             TIMESTAMP(6) ,
    ABSENCE_TYPE_ID          NUMBER(18, 0)    NOT NULL,
    CONSTRAINT pk_anc_wfm_interface_header PRIMARY KEY (WFM_IFACE_HDR_ID, WFM_IFACE_HDR_ID)
);
