CREATE TABLE grc_job_item_current (
    JOB_ID               NUMBER(19, 0) ,
    JOB_RUN_ID           NUMBER(19, 0)     NOT NULL,
    PARENT_JOB_ID        NUMBER(19, 0) ,
    STATUS               VARCHAR2(80)  ,
    HAS_STARTED          VARCHAR2(4)   ,
    SCHEDULER_ID         VARCHAR2(1020),
    JOB                  CLOB          ,
    CREATION_DATE        TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_DATE     TIMESTAMP(6)      NOT NULL,
    CREATED_BY           VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN    VARCHAR2(128) ,
    LAST_UPDATED_BY      VARCHAR2(256)     NOT NULL,
    JOB_ID               NUMBER(19, 0) ,
    JOB_RUN_ID           NUMBER(19, 0)     NOT NULL,
    PARENT_JOB_ID        NUMBER(19, 0) ,
    STATUS               VARCHAR2(80)  ,
    HAS_STARTED          VARCHAR2(4)   ,
    SCHEDULER_ID         VARCHAR2(1020),
    JOB                  CLOB          ,
    CREATION_DATE        TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_DATE     TIMESTAMP(6)      NOT NULL,
    CREATED_BY           VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN    VARCHAR2(128) ,
    LAST_UPDATED_BY      VARCHAR2(256)     NOT NULL,
    CONSTRAINT pk_grc_job_item_current PRIMARY KEY (JOB_ID, JOB_ID)
);
