CREATE TABLE irc_auto_sync_to_hr_tracking (
    AUTO_SYNC_TRACKING_ID    NUMBER(18, 0) ,
    AUTO_SYNC_ID             NUMBER(18, 0)     NOT NULL,
    REQUEST_NUMBER           VARCHAR2(256) ,
    CONTENT_ID               VARCHAR2(240) ,
    CONTENT_UPLOAD_ERROR     VARCHAR2(4000),
    HDL_SUBMIT_ERROR         VARCHAR2(4000),
    HDL_PROCESSING_ERROR     CLOB          ,
    OFFER_ACCEPT_ERROR       VARCHAR2(4000),
    HDL_INPUT_JSON           CLOB          ,
    GHR_API_INPUT_JSON       CLOB          ,
    GHR_API_OUTPUT_JSON      CLOB          ,
    GHR_API_ERROR            VARCHAR2(4000),
    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) ,
    AUTO_SYNC_TRACKING_ID    NUMBER(18, 0) ,
    AUTO_SYNC_ID             NUMBER(18, 0)     NOT NULL,
    REQUEST_NUMBER           VARCHAR2(256) ,
    CONTENT_ID               VARCHAR2(240) ,
    CONTENT_UPLOAD_ERROR     VARCHAR2(4000),
    HDL_SUBMIT_ERROR         VARCHAR2(4000),
    HDL_PROCESSING_ERROR     CLOB          ,
    OFFER_ACCEPT_ERROR       VARCHAR2(4000),
    HDL_INPUT_JSON           CLOB          ,
    GHR_API_INPUT_JSON       CLOB          ,
    GHR_API_OUTPUT_JSON      CLOB          ,
    GHR_API_ERROR            VARCHAR2(4000),
    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_irc_auto_sync_to_hr_tracking PRIMARY KEY (AUTO_SYNC_TRACKING_ID, AUTO_SYNC_TRACKING_ID)
);
