CREATE TABLE gtg_rpt_usr_asgmt_dtl (
    ID                    NUMBER(19, 0) ,
    OBJECT_ID             VARCHAR2(80)  ,
    JOB_ID                NUMBER(19, 0)     NOT NULL,
    OBJECT_NAME           VARCHAR2(2000),
    STATUS                VARCHAR2(80)  ,
    ERROR_MESSAGE         VARCHAR2(4000),
    ASSIGNMENT_NAME       VARCHAR2(2000),
    AUTHORIZATION         VARCHAR2(400) ,
    ROLE_AUTHORIZATION    CLOB          ,
    REPLACE_ASGMT_NAME    VARCHAR2(2000),
    CREATION_DATE         TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_DATE      TIMESTAMP(6)      NOT NULL,
    CREATED_BY            VARCHAR2(256)     NOT NULL,
    LAST_UPDATED_BY       VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN     VARCHAR2(128) ,
    ID                    NUMBER(19, 0) ,
    JOB_ID                NUMBER(19, 0)     NOT NULL,
    OBJECT_NAME           VARCHAR2(2000),
    STATUS                VARCHAR2(80)  ,
    ERROR_MESSAGE         VARCHAR2(4000),
    ASSIGNMENT_NAME       VARCHAR2(2000),
    REPLACE_ASGMT_NAME    VARCHAR2(2000),
    CREATION_DATE         TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_DATE      TIMESTAMP(6)      NOT NULL,
    CREATED_BY            VARCHAR2(256)     NOT NULL,
    LAST_UPDATED_BY       VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN     VARCHAR2(128) ,
    AUTHORIZATION         VARCHAR2(400) ,
    ROLE_AUTHORIZATION    CLOB          ,
    OBJECT_ID             VARCHAR2(80)  ,
    CONSTRAINT pk_gtg_rpt_usr_asgmt_dtl PRIMARY KEY (ID, ID)
);
