CREATE TABLE cn_srp_pay_groups_all (
    ORG_ID                   NUMBER(18, 0),
    SRP_PAY_GROUP_ID         NUMBER(18, 0),
    SALESREP_ID              NUMBER(18, 0)    NOT NULL,
    PAY_GROUP_ID             NUMBER(18, 0)    NOT NULL,
    START_DATE               DATE             NOT NULL,
    END_DATE                 DATE         ,
    ATTRIBUTE_CATEGORY       VARCHAR2(120),
    ATTRIBUTE1               VARCHAR2(600),
    ATTRIBUTE2               VARCHAR2(600),
    ATTRIBUTE3               VARCHAR2(600),
    ATTRIBUTE4               VARCHAR2(600),
    ATTRIBUTE5               VARCHAR2(600),
    ATTRIBUTE6               VARCHAR2(600),
    ATTRIBUTE7               VARCHAR2(600),
    ATTRIBUTE8               VARCHAR2(600),
    ATTRIBUTE9               VARCHAR2(600),
    ATTRIBUTE10              VARCHAR2(600),
    ATTRIBUTE11              VARCHAR2(600),
    ATTRIBUTE12              VARCHAR2(600),
    ATTRIBUTE13              VARCHAR2(600),
    ATTRIBUTE14              VARCHAR2(600),
    ATTRIBUTE15              VARCHAR2(600),
    CREATED_BY               VARCHAR2(256)    NOT NULL,
    CREATION_DATE            TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN        VARCHAR2(128),
    LAST_UPDATE_DATE         TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY          VARCHAR2(256)    NOT NULL,
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)     NOT NULL,
    LOCK_FLAG                VARCHAR2(4)      NOT NULL,
    ROLE_PAY_GROUP_ID        NUMBER(18, 0),
    SRP_ROLE_ID              NUMBER(18, 0),
    ORG_ID                   NUMBER(18, 0),
    SRP_PAY_GROUP_ID         NUMBER(18, 0),
    SALESREP_ID              NUMBER(18, 0)    NOT NULL,
    PAY_GROUP_ID             NUMBER(18, 0)    NOT NULL,
    START_DATE               DATE             NOT NULL,
    END_DATE                 DATE         ,
    ATTRIBUTE_CATEGORY       VARCHAR2(120),
    ATTRIBUTE1               VARCHAR2(600),
    ATTRIBUTE2               VARCHAR2(600),
    ATTRIBUTE3               VARCHAR2(600),
    ATTRIBUTE4               VARCHAR2(600),
    ATTRIBUTE5               VARCHAR2(600),
    ATTRIBUTE6               VARCHAR2(600),
    ATTRIBUTE7               VARCHAR2(600),
    ATTRIBUTE8               VARCHAR2(600),
    ATTRIBUTE9               VARCHAR2(600),
    ATTRIBUTE10              VARCHAR2(600),
    ATTRIBUTE11              VARCHAR2(600),
    ATTRIBUTE12              VARCHAR2(600),
    ATTRIBUTE13              VARCHAR2(600),
    ATTRIBUTE14              VARCHAR2(600),
    ATTRIBUTE15              VARCHAR2(600),
    CREATED_BY               VARCHAR2(256)    NOT NULL,
    CREATION_DATE            TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN        VARCHAR2(128),
    LAST_UPDATE_DATE         TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY          VARCHAR2(256)    NOT NULL,
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)     NOT NULL,
    LOCK_FLAG                VARCHAR2(4)      NOT NULL,
    ROLE_PAY_GROUP_ID        NUMBER(18, 0),
    SRP_ROLE_ID              NUMBER(18, 0),
    CONSTRAINT pk_cn_srp_pay_groups_all PRIMARY KEY (ORG_ID, SRP_PAY_GROUP_ID, ORG_ID, SRP_PAY_GROUP_ID)
);
