CREATE TABLE gtg_ess_sub_job_results (
    ESS_REQ_ID            NUMBER(19, 0) ,
    ROOT_ESS_REQ_ID       NUMBER(19, 0) ,
    PARENT_ESS_REQ_ID     NUMBER(19, 0) ,
    STATE                 VARCHAR2(1020),
    STATUS                VARCHAR2(1020),
    CHILD_JOB_IDF         VARCHAR2(4000),
    TERMINATE_JOB_FLAG    NUMBER(1, 0)  ,
    RESULT                CLOB          ,
    JOB_DEPENDENCY        CLOB          ,
    DEPTH                 NUMBER(10, 0) ,
    IS_ESS_CLASS          NUMBER(1, 0)  ,
    CREATED_BY            VARCHAR2(256)     NOT NULL,
    CREATION_DATE         TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY       VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN     VARCHAR2(128) ,
    LAST_UPDATE_DATE      TIMESTAMP(6)      NOT NULL,
    ESS_REQ_ID            NUMBER(19, 0) ,
    ROOT_ESS_REQ_ID       NUMBER(19, 0) ,
    PARENT_ESS_REQ_ID     NUMBER(19, 0) ,
    STATE                 VARCHAR2(1020),
    STATUS                VARCHAR2(1020),
    CHILD_JOB_IDF         VARCHAR2(4000),
    TERMINATE_JOB_FLAG    NUMBER(1, 0)  ,
    RESULT                CLOB          ,
    JOB_DEPENDENCY        CLOB          ,
    DEPTH                 NUMBER(10, 0) ,
    CREATED_BY            VARCHAR2(256)     NOT NULL,
    CREATION_DATE         TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY       VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN     VARCHAR2(128) ,
    LAST_UPDATE_DATE      TIMESTAMP(6)      NOT NULL,
    IS_ESS_CLASS          NUMBER(1, 0)  ,
    CONSTRAINT pk_gtg_ess_sub_job_results PRIMARY KEY (ESS_REQ_ID, CHILD_JOB_IDF, ESS_REQ_ID, CHILD_JOB_IDF)
);
