CREATE TABLE ben_pl_pcp (
    PL_PCP_ID                 NUMBER(18, 0),
    PL_ID                     NUMBER(18, 0)    NOT NULL,
    BUSINESS_GROUP_ID         NUMBER(18, 0)    NOT NULL,
    PCP_STRT_DT_CD            VARCHAR2(120),
    PCP_DSGN_CD               VARCHAR2(120),
    PCP_DPNT_DSGN_CD          VARCHAR2(120),
    PCP_RPSTRY_FLAG           VARCHAR2(120)    NOT NULL,
    PCP_CAN_KEEP_FLAG         VARCHAR2(120)    NOT NULL,
    PCP_RADIUS                NUMBER       ,
    PCP_RADIUS_UOM            VARCHAR2(120),
    PCP_RADIUS_WARN_FLAG      VARCHAR2(120)    NOT NULL,
    PCP_NUM_CHGS              NUMBER       ,
    PCP_NUM_CHGS_UOM          VARCHAR2(120),
    PCP_ATTRIBUTE_CATEGORY    VARCHAR2(120),
    PCP_ATTRIBUTE1            VARCHAR2(600),
    PCP_ATTRIBUTE2            VARCHAR2(600),
    PCP_ATTRIBUTE3            VARCHAR2(600),
    PCP_ATTRIBUTE4            VARCHAR2(600),
    PCP_ATTRIBUTE5            VARCHAR2(600),
    PCP_ATTRIBUTE6            VARCHAR2(600),
    PCP_ATTRIBUTE7            VARCHAR2(600),
    PCP_ATTRIBUTE8            VARCHAR2(600),
    PCP_ATTRIBUTE9            VARCHAR2(600),
    PCP_ATTRIBUTE10           VARCHAR2(600),
    PCP_ATTRIBUTE11           VARCHAR2(600),
    PCP_ATTRIBUTE12           VARCHAR2(600),
    PCP_ATTRIBUTE13           VARCHAR2(600),
    PCP_ATTRIBUTE14           VARCHAR2(600),
    PCP_ATTRIBUTE15           VARCHAR2(600),
    PCP_ATTRIBUTE16           VARCHAR2(600),
    PCP_ATTRIBUTE17           VARCHAR2(600),
    PCP_ATTRIBUTE18           VARCHAR2(600),
    PCP_ATTRIBUTE19           VARCHAR2(600),
    PCP_ATTRIBUTE20           VARCHAR2(600),
    PCP_ATTRIBUTE21           VARCHAR2(600),
    PCP_ATTRIBUTE22           VARCHAR2(600),
    PCP_ATTRIBUTE23           VARCHAR2(600),
    PCP_ATTRIBUTE24           VARCHAR2(600),
    PCP_ATTRIBUTE25           VARCHAR2(600),
    PCP_ATTRIBUTE26           VARCHAR2(600),
    PCP_ATTRIBUTE27           VARCHAR2(600),
    PCP_ATTRIBUTE28           VARCHAR2(600),
    PCP_ATTRIBUTE29           VARCHAR2(600),
    PCP_ATTRIBUTE30           VARCHAR2(600),
    PCP_ATTRIBUTE_NUMBER1     NUMBER       ,
    PCP_ATTRIBUTE_NUMBER2     NUMBER       ,
    PCP_ATTRIBUTE_NUMBER3     NUMBER       ,
    PCP_ATTRIBUTE_NUMBER4     NUMBER       ,
    PCP_ATTRIBUTE_NUMBER5     NUMBER       ,
    PCP_ATTRIBUTE_NUMBER6     NUMBER       ,
    PCP_ATTRIBUTE_NUMBER7     NUMBER       ,
    PCP_ATTRIBUTE_NUMBER8     NUMBER       ,
    PCP_ATTRIBUTE_NUMBER9     NUMBER       ,
    PCP_ATTRIBUTE_NUMBER10    NUMBER       ,
    PCP_ATTRIBUTE_NUMBER11    NUMBER       ,
    PCP_ATTRIBUTE_NUMBER12    NUMBER       ,
    PCP_ATTRIBUTE_NUMBER13    NUMBER       ,
    PCP_ATTRIBUTE_NUMBER14    NUMBER       ,
    PCP_ATTRIBUTE_NUMBER15    NUMBER       ,
    PCP_ATTRIBUTE_NUMBER16    NUMBER       ,
    PCP_ATTRIBUTE_NUMBER17    NUMBER       ,
    PCP_ATTRIBUTE_NUMBER18    NUMBER       ,
    PCP_ATTRIBUTE_NUMBER19    NUMBER       ,
    PCP_ATTRIBUTE_NUMBER20    NUMBER       ,
    PCP_ATTRIBUTE_DATE1       DATE         ,
    PCP_ATTRIBUTE_DATE2       DATE         ,
    PCP_ATTRIBUTE_DATE3       DATE         ,
    PCP_ATTRIBUTE_DATE4       DATE         ,
    PCP_ATTRIBUTE_DATE5       DATE         ,
    PCP_ATTRIBUTE_DATE6       DATE         ,
    PCP_ATTRIBUTE_DATE7       DATE         ,
    PCP_ATTRIBUTE_DATE8       DATE         ,
    PCP_ATTRIBUTE_DATE9       DATE         ,
    PCP_ATTRIBUTE_DATE10      DATE         ,
    PCP_ATTRIBUTE_DATE11      DATE         ,
    PCP_ATTRIBUTE_DATE12      DATE         ,
    PCP_ATTRIBUTE_DATE13      DATE         ,
    PCP_ATTRIBUTE_DATE14      DATE         ,
    PCP_ATTRIBUTE_DATE15      DATE         ,
    LAST_UPDATE_DATE          TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY           VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(128),
    CREATED_BY                VARCHAR2(256)    NOT NULL,
    CREATION_DATE             TIMESTAMP(6)     NOT NULL,
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)     NOT NULL,
    PL_PCP_ID                 NUMBER(18, 0),
    PL_ID                     NUMBER(18, 0)    NOT NULL,
    BUSINESS_GROUP_ID         NUMBER(18, 0)    NOT NULL,
    PCP_STRT_DT_CD            VARCHAR2(120),
    PCP_DSGN_CD               VARCHAR2(120),
    PCP_DPNT_DSGN_CD          VARCHAR2(120),
    PCP_RPSTRY_FLAG           VARCHAR2(120)    NOT NULL,
    PCP_CAN_KEEP_FLAG         VARCHAR2(120)    NOT NULL,
    PCP_RADIUS                NUMBER       ,
    PCP_RADIUS_UOM            VARCHAR2(120),
    PCP_RADIUS_WARN_FLAG      VARCHAR2(120)    NOT NULL,
    PCP_NUM_CHGS              NUMBER       ,
    PCP_NUM_CHGS_UOM          VARCHAR2(120),
    PCP_ATTRIBUTE_CATEGORY    VARCHAR2(120),
    PCP_ATTRIBUTE1            VARCHAR2(600),
    PCP_ATTRIBUTE2            VARCHAR2(600),
    PCP_ATTRIBUTE3            VARCHAR2(600),
    PCP_ATTRIBUTE4            VARCHAR2(600),
    PCP_ATTRIBUTE5            VARCHAR2(600),
    PCP_ATTRIBUTE6            VARCHAR2(600),
    PCP_ATTRIBUTE7            VARCHAR2(600),
    PCP_ATTRIBUTE8            VARCHAR2(600),
    PCP_ATTRIBUTE9            VARCHAR2(600),
    PCP_ATTRIBUTE10           VARCHAR2(600),
    PCP_ATTRIBUTE11           VARCHAR2(600),
    PCP_ATTRIBUTE12           VARCHAR2(600),
    PCP_ATTRIBUTE13           VARCHAR2(600),
    PCP_ATTRIBUTE14           VARCHAR2(600),
    PCP_ATTRIBUTE15           VARCHAR2(600),
    PCP_ATTRIBUTE16           VARCHAR2(600),
    PCP_ATTRIBUTE17           VARCHAR2(600),
    PCP_ATTRIBUTE18           VARCHAR2(600),
    PCP_ATTRIBUTE19           VARCHAR2(600),
    PCP_ATTRIBUTE20           VARCHAR2(600),
    PCP_ATTRIBUTE21           VARCHAR2(600),
    PCP_ATTRIBUTE22           VARCHAR2(600),
    PCP_ATTRIBUTE23           VARCHAR2(600),
    PCP_ATTRIBUTE24           VARCHAR2(600),
    PCP_ATTRIBUTE25           VARCHAR2(600),
    PCP_ATTRIBUTE26           VARCHAR2(600),
    PCP_ATTRIBUTE27           VARCHAR2(600),
    PCP_ATTRIBUTE28           VARCHAR2(600),
    PCP_ATTRIBUTE29           VARCHAR2(600),
    PCP_ATTRIBUTE30           VARCHAR2(600),
    PCP_ATTRIBUTE_NUMBER1     NUMBER       ,
    PCP_ATTRIBUTE_NUMBER2     NUMBER       ,
    PCP_ATTRIBUTE_NUMBER3     NUMBER       ,
    PCP_ATTRIBUTE_NUMBER4     NUMBER       ,
    PCP_ATTRIBUTE_NUMBER5     NUMBER       ,
    PCP_ATTRIBUTE_NUMBER6     NUMBER       ,
    PCP_ATTRIBUTE_NUMBER7     NUMBER       ,
    PCP_ATTRIBUTE_NUMBER8     NUMBER       ,
    PCP_ATTRIBUTE_NUMBER9     NUMBER       ,
    PCP_ATTRIBUTE_NUMBER10    NUMBER       ,
    PCP_ATTRIBUTE_NUMBER11    NUMBER       ,
    PCP_ATTRIBUTE_NUMBER12    NUMBER       ,
    PCP_ATTRIBUTE_NUMBER13    NUMBER       ,
    PCP_ATTRIBUTE_NUMBER14    NUMBER       ,
    PCP_ATTRIBUTE_NUMBER15    NUMBER       ,
    PCP_ATTRIBUTE_NUMBER16    NUMBER       ,
    PCP_ATTRIBUTE_NUMBER17    NUMBER       ,
    PCP_ATTRIBUTE_NUMBER18    NUMBER       ,
    PCP_ATTRIBUTE_NUMBER19    NUMBER       ,
    PCP_ATTRIBUTE_NUMBER20    NUMBER       ,
    PCP_ATTRIBUTE_DATE1       DATE         ,
    PCP_ATTRIBUTE_DATE2       DATE         ,
    PCP_ATTRIBUTE_DATE3       DATE         ,
    PCP_ATTRIBUTE_DATE4       DATE         ,
    PCP_ATTRIBUTE_DATE5       DATE         ,
    PCP_ATTRIBUTE_DATE6       DATE         ,
    PCP_ATTRIBUTE_DATE7       DATE         ,
    PCP_ATTRIBUTE_DATE8       DATE         ,
    PCP_ATTRIBUTE_DATE9       DATE         ,
    PCP_ATTRIBUTE_DATE10      DATE         ,
    PCP_ATTRIBUTE_DATE11      DATE         ,
    PCP_ATTRIBUTE_DATE12      DATE         ,
    PCP_ATTRIBUTE_DATE13      DATE         ,
    PCP_ATTRIBUTE_DATE14      DATE         ,
    PCP_ATTRIBUTE_DATE15      DATE         ,
    LAST_UPDATE_DATE          TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY           VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(128),
    CREATED_BY                VARCHAR2(256)    NOT NULL,
    CREATION_DATE             TIMESTAMP(6)     NOT NULL,
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)     NOT NULL,
    CONSTRAINT pk_ben_pl_pcp PRIMARY KEY (PL_PCP_ID, PL_PCP_ID)
);
