CREATE TABLE hrc_dl_source_key_audit (
    SOURCE_KEY_AUDIT_ID        NUMBER(18, 0) ,
    FUSION_GUID                VARCHAR2(256)     NOT NULL,
    SURROGATE_ID               NUMBER(18, 0)     NOT NULL,
    INTEGRATION_OBJECT_NAME    VARCHAR2(1024)    NOT NULL,
    OLD_SOURCE_OWNER           VARCHAR2(1024)    NOT NULL,
    OLD_SOURCE_ID              VARCHAR2(4000)    NOT NULL,
    NEW_SOURCE_OWNER           VARCHAR2(1024)    NOT NULL,
    NEW_SOURCE_ID              VARCHAR2(4000)    NOT NULL,
    REASON                     VARCHAR2(4000),
    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) ,
    SOURCE_KEY_AUDIT_ID        NUMBER(18, 0) ,
    FUSION_GUID                VARCHAR2(256)     NOT NULL,
    SURROGATE_ID               NUMBER(18, 0)     NOT NULL,
    INTEGRATION_OBJECT_NAME    VARCHAR2(1024)    NOT NULL,
    OLD_SOURCE_OWNER           VARCHAR2(1024)    NOT NULL,
    OLD_SOURCE_ID              VARCHAR2(4000)    NOT NULL,
    NEW_SOURCE_OWNER           VARCHAR2(1024)    NOT NULL,
    NEW_SOURCE_ID              VARCHAR2(4000)    NOT NULL,
    REASON                     VARCHAR2(4000),
    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) ,
    CONSTRAINT pk_hrc_dl_source_key_audit PRIMARY KEY (SOURCE_KEY_AUDIT_ID, SOURCE_KEY_AUDIT_ID)
);
