CREATE TABLE cmp_tcs_stmt_rating_b (
    STMT_RATING_ID            NUMBER(18, 0) ,
    STMT_ID                   NUMBER(18, 0)     NOT NULL,
    STMT_PERD_ID              NUMBER(18, 0)     NOT NULL,
    PERD_RUN_ID               NUMBER(18, 0)     NOT NULL,
    RATING_CODE               VARCHAR2(120) ,
    ORDER_NUM                 NUMBER(18, 0) ,
    REQUEST_ID                NUMBER(18, 0) ,
    JOB_DEFINITION_NAME       VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE    VARCHAR2(3600),
    CREATED_BY                VARCHAR2(256)     NOT NULL,
    CREATION_DATE             TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_DATE          TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY           VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(128) ,
    STMT_RATING_ID            NUMBER(18, 0) ,
    STMT_ID                   NUMBER(18, 0)     NOT NULL,
    STMT_PERD_ID              NUMBER(18, 0)     NOT NULL,
    PERD_RUN_ID               NUMBER(18, 0)     NOT NULL,
    RATING_CODE               VARCHAR2(120) ,
    ORDER_NUM                 NUMBER(18, 0) ,
    REQUEST_ID                NUMBER(18, 0) ,
    JOB_DEFINITION_NAME       VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE    VARCHAR2(3600),
    CREATED_BY                VARCHAR2(256)     NOT NULL,
    CREATION_DATE             TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_DATE          TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY           VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(128) ,
    CONSTRAINT pk_cmp_tcs_stmt_rating_b PRIMARY KEY (STMT_RATING_ID, STMT_RATING_ID)
);
