CREATE TABLE cn_srp_plan_components_all (
    SRP_PLAN_COMPONENT_ID      NUMBER(18, 0),
    SRP_COMP_PLAN_ID           NUMBER(18, 0)    NOT NULL,
    COMP_PLAN_COMPONENT_ID     NUMBER(18, 0),
    PARTICIPANT_ID             NUMBER(18, 0),
    COMP_PLAN_ID               NUMBER(18, 0),
    PLAN_COMPONENT_ID          NUMBER(18, 0)    NOT NULL,
    CUSTOMIZED_FLAG            VARCHAR2(4)      NOT NULL,
    CUSTOMIZED_OPTION          VARCHAR2(120),
    TARGET_INCENTIVE_WEIGHT    NUMBER           NOT NULL,
    ATTRIBUTE_CATEGORY         VARCHAR2(120),
    ATTRIBUTE1                 VARCHAR2(960),
    ATTRIBUTE2                 VARCHAR2(960),
    ATTRIBUTE3                 VARCHAR2(960),
    ATTRIBUTE4                 VARCHAR2(960),
    ATTRIBUTE5                 VARCHAR2(960),
    ATTRIBUTE6                 VARCHAR2(960),
    ATTRIBUTE7                 VARCHAR2(960),
    ATTRIBUTE8                 VARCHAR2(960),
    ATTRIBUTE9                 VARCHAR2(960),
    ATTRIBUTE10                VARCHAR2(960),
    ATTRIBUTE11                VARCHAR2(960),
    ATTRIBUTE12                VARCHAR2(960),
    ATTRIBUTE13                VARCHAR2(960),
    ATTRIBUTE14                VARCHAR2(960),
    ATTRIBUTE15                VARCHAR2(960),
    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),
    ORG_ID                     NUMBER(18, 0)    NOT NULL,
    OBJECT_VERSION_NUMBER      NUMBER(9, 0)     NOT NULL,
    ATTRIBUTE_DATE1            DATE         ,
    ATTRIBUTE_DATE2            DATE         ,
    ATTRIBUTE_DATE3            DATE         ,
    ATTRIBUTE_DATE4            DATE         ,
    ATTRIBUTE_DATE5            DATE         ,
    ATTRIBUTE_DATE6            DATE         ,
    ATTRIBUTE_DATE7            DATE         ,
    ATTRIBUTE_DATE8            DATE         ,
    ATTRIBUTE_DATE9            DATE         ,
    ATTRIBUTE_DATE10           DATE         ,
    ATTRIBUTE_DATE11           DATE         ,
    ATTRIBUTE_DATE12           DATE         ,
    ATTRIBUTE_DATE13           DATE         ,
    ATTRIBUTE_DATE14           DATE         ,
    ATTRIBUTE_DATE15           DATE         ,
    ATTRIBUTE_NUMBER1          NUMBER       ,
    ATTRIBUTE_NUMBER2          NUMBER       ,
    ATTRIBUTE_NUMBER3          NUMBER       ,
    ATTRIBUTE_NUMBER4          NUMBER       ,
    ATTRIBUTE_NUMBER5          NUMBER       ,
    ATTRIBUTE_NUMBER6          NUMBER       ,
    ATTRIBUTE_NUMBER7          NUMBER       ,
    ATTRIBUTE_NUMBER8          NUMBER       ,
    ATTRIBUTE_NUMBER9          NUMBER       ,
    ATTRIBUTE_NUMBER10         NUMBER       ,
    ATTRIBUTE_NUMBER11         NUMBER       ,
    ATTRIBUTE_NUMBER12         NUMBER       ,
    ATTRIBUTE_NUMBER13         NUMBER       ,
    ATTRIBUTE_NUMBER14         NUMBER       ,
    ATTRIBUTE_NUMBER15         NUMBER       ,
    SRP_PLAN_COMPONENT_ID      NUMBER(18, 0),
    SRP_COMP_PLAN_ID           NUMBER(18, 0)    NOT NULL,
    COMP_PLAN_COMPONENT_ID     NUMBER(18, 0),
    PLAN_COMPONENT_ID          NUMBER(18, 0)    NOT NULL,
    CUSTOMIZED_FLAG            VARCHAR2(4)      NOT NULL,
    TARGET_INCENTIVE_WEIGHT    NUMBER           NOT NULL,
    ATTRIBUTE_CATEGORY         VARCHAR2(120),
    ATTRIBUTE1                 VARCHAR2(960),
    ATTRIBUTE2                 VARCHAR2(960),
    ATTRIBUTE3                 VARCHAR2(960),
    ATTRIBUTE4                 VARCHAR2(960),
    ATTRIBUTE5                 VARCHAR2(960),
    ATTRIBUTE6                 VARCHAR2(960),
    ATTRIBUTE7                 VARCHAR2(960),
    ATTRIBUTE8                 VARCHAR2(960),
    ATTRIBUTE9                 VARCHAR2(960),
    ATTRIBUTE10                VARCHAR2(960),
    ATTRIBUTE11                VARCHAR2(960),
    ATTRIBUTE12                VARCHAR2(960),
    ATTRIBUTE13                VARCHAR2(960),
    ATTRIBUTE14                VARCHAR2(960),
    ATTRIBUTE15                VARCHAR2(960),
    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),
    ORG_ID                     NUMBER(18, 0)    NOT NULL,
    OBJECT_VERSION_NUMBER      NUMBER(9, 0)     NOT NULL,
    PARTICIPANT_ID             NUMBER(18, 0),
    COMP_PLAN_ID               NUMBER(18, 0),
    ATTRIBUTE_DATE1            DATE         ,
    ATTRIBUTE_DATE2            DATE         ,
    ATTRIBUTE_DATE3            DATE         ,
    ATTRIBUTE_DATE4            DATE         ,
    ATTRIBUTE_DATE5            DATE         ,
    ATTRIBUTE_DATE6            DATE         ,
    ATTRIBUTE_DATE7            DATE         ,
    ATTRIBUTE_DATE8            DATE         ,
    ATTRIBUTE_DATE9            DATE         ,
    ATTRIBUTE_DATE10           DATE         ,
    ATTRIBUTE_DATE11           DATE         ,
    ATTRIBUTE_DATE12           DATE         ,
    ATTRIBUTE_DATE13           DATE         ,
    ATTRIBUTE_DATE14           DATE         ,
    ATTRIBUTE_DATE15           DATE         ,
    ATTRIBUTE_NUMBER1          NUMBER       ,
    ATTRIBUTE_NUMBER2          NUMBER       ,
    ATTRIBUTE_NUMBER3          NUMBER       ,
    ATTRIBUTE_NUMBER4          NUMBER       ,
    ATTRIBUTE_NUMBER5          NUMBER       ,
    ATTRIBUTE_NUMBER6          NUMBER       ,
    ATTRIBUTE_NUMBER7          NUMBER       ,
    ATTRIBUTE_NUMBER8          NUMBER       ,
    ATTRIBUTE_NUMBER9          NUMBER       ,
    ATTRIBUTE_NUMBER10         NUMBER       ,
    ATTRIBUTE_NUMBER11         NUMBER       ,
    ATTRIBUTE_NUMBER12         NUMBER       ,
    ATTRIBUTE_NUMBER13         NUMBER       ,
    ATTRIBUTE_NUMBER14         NUMBER       ,
    ATTRIBUTE_NUMBER15         NUMBER       ,
    CUSTOMIZED_OPTION          VARCHAR2(120),
    CONSTRAINT pk_cn_srp_plan_components_all PRIMARY KEY (SRP_PLAN_COMPONENT_ID, SRP_PLAN_COMPONENT_ID)
);
