CREATE TABLE ben_batch_actions (
    BATCH_ACTION_ID      NUMBER       ,
    BATCH_ID             NUMBER           NOT NULL,
    BATCH_TYPE           VARCHAR2(120)    NOT NULL,
    ROLLUP_COUNT         NUMBER       ,
    ROLLUP_SUMOVN        NUMBER       ,
    BUSINESS_GROUP_ID    NUMBER(18, 0)    NOT NULL,
    CREATED_BY           VARCHAR2(256)    NOT NULL,
    CREATION_DATE        TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY      VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE     TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN    VARCHAR2(128),
    BATCH_ACTION_ID      NUMBER       ,
    BATCH_ID             NUMBER           NOT NULL,
    BATCH_TYPE           VARCHAR2(120)    NOT NULL,
    ROLLUP_COUNT         NUMBER       ,
    ROLLUP_SUMOVN        NUMBER       ,
    BUSINESS_GROUP_ID    NUMBER(18, 0)    NOT NULL,
    CREATED_BY           VARCHAR2(256)    NOT NULL,
    CREATION_DATE        TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY      VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE     TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN    VARCHAR2(128),
    CONSTRAINT pk_ben_batch_actions PRIMARY KEY (BATCH_ACTION_ID, BATCH_ACTION_ID)
);
