CREATE TABLE hrt_profile_item_sync_details (
    PROFILE_SYNC_LOG_ID            NUMBER(18, 0)    NOT NULL,
    PROFILE_ITEM_ID                NUMBER(18, 0),
    PROFILE_ITEM_SYNC_DETAIL_ID    NUMBER(18, 0),
    BUSINESS_GROUP_ID              NUMBER(18, 0),
    SOURCE_PROFILE_ID              NUMBER(18, 0),
    SOURCE_PROFILE_ITEM_ID         NUMBER(18, 0),
    SYNC_STATUS                    VARCHAR2(256),
    OBJECT_VERSION_NUMBER          NUMBER(9, 0)     NOT NULL,
    CREATION_DATE                  TIMESTAMP(6)     NOT NULL,
    CREATED_BY                     VARCHAR2(256)    NOT NULL,
    LAST_UPDATED_BY                VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE               TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN              VARCHAR2(128),
    PROFILE_SYNC_LOG_ID            NUMBER(18, 0)    NOT NULL,
    PROFILE_ITEM_ID                NUMBER(18, 0),
    PROFILE_ITEM_SYNC_DETAIL_ID    NUMBER(18, 0),
    BUSINESS_GROUP_ID              NUMBER(18, 0),
    SOURCE_PROFILE_ID              NUMBER(18, 0),
    SOURCE_PROFILE_ITEM_ID         NUMBER(18, 0),
    SYNC_STATUS                    VARCHAR2(256),
    OBJECT_VERSION_NUMBER          NUMBER(9, 0)     NOT NULL,
    CREATION_DATE                  TIMESTAMP(6)     NOT NULL,
    CREATED_BY                     VARCHAR2(256)    NOT NULL,
    LAST_UPDATED_BY                VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE               TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN              VARCHAR2(128),
    CONSTRAINT pk_hrt_profile_item_sync_details PRIMARY KEY (PROFILE_ITEM_SYNC_DETAIL_ID, PROFILE_ITEM_SYNC_DETAIL_ID)
);
