CREATE TABLE cso_pipeline_item_status (
    RECORD_ID            VARCHAR2(128),
    PIPELINE_ITEM_ID     VARCHAR2(128)    NOT NULL,
    PROCESSED_COUNT      NUMBER(8, 0)     NOT NULL,
    FAILED_COUNT         NUMBER(8, 0)     NOT NULL,
    TOTAL_COUNT          NUMBER(8, 0)     NOT NULL,
    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),
    RECORD_ID            VARCHAR2(128),
    PIPELINE_ITEM_ID     VARCHAR2(128)    NOT NULL,
    PROCESSED_COUNT      NUMBER(8, 0)     NOT NULL,
    FAILED_COUNT         NUMBER(8, 0)     NOT NULL,
    TOTAL_COUNT          NUMBER(8, 0)     NOT NULL,
    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),
    CONSTRAINT pk_cso_pipeline_item_status PRIMARY KEY (RECORD_ID, RECORD_ID)
);
