CREATE TABLE ben_elig_per_f (
    ELIG_PER_ID                     NUMBER(18, 0) ,
    BENEFIT_RELATION_ID             NUMBER(18, 0) ,
    EFFECTIVE_START_DATE            DATE          ,
    EFFECTIVE_END_DATE              DATE          ,
    DPNT_OTHR_PL_CVRD_RL_FLAG       VARCHAR2(120)     NOT NULL,
    PRTN_OVRIDN_THRU_DT             DATE          ,
    PL_KEY_EE_FLAG                  VARCHAR2(120)     NOT NULL,
    PL_HGHLY_COMPD_FLAG             VARCHAR2(120)     NOT NULL,
    ELIG_FLAG                       VARCHAR2(120)     NOT NULL,
    COMP_REF_AMT                    NUMBER        ,
    CMBN_AGE_N_LOS_VAL              NUMBER        ,
    COMP_REF_UOM                    VARCHAR2(120) ,
    AGE_VAL                         NUMBER        ,
    LOS_VAL                         NUMBER        ,
    PRTN_END_DT                     DATE          ,
    PRTN_STRT_DT                    DATE          ,
    WV_CTFN_TYP_CD                  VARCHAR2(120) ,
    HRS_WKD_VAL                     NUMBER        ,
    HRS_WKD_BNDRY_PERD_CD           VARCHAR2(120) ,
    PRTN_OVRIDN_FLAG                VARCHAR2(120)     NOT NULL,
    NO_MX_PRTN_OVRID_THRU_FLAG      VARCHAR2(120)     NOT NULL,
    PRTN_OVRIDN_RSN_CD              VARCHAR2(120) ,
    AGE_UOM                         VARCHAR2(120) ,
    LOS_UOM                         VARCHAR2(120) ,
    OVRID_SVC_DT                    DATE          ,
    FRZ_LOS_FLAG                    VARCHAR2(120)     NOT NULL,
    FRZ_AGE_FLAG                    VARCHAR2(120)     NOT NULL,
    FRZ_CMP_LVL_FLAG                VARCHAR2(120)     NOT NULL,
    FRZ_PCT_FL_TM_FLAG              VARCHAR2(120)     NOT NULL,
    FRZ_HRS_WKD_FLAG                VARCHAR2(120)     NOT NULL,
    FRZ_COMB_AGE_AND_LOS_FLAG       VARCHAR2(120)     NOT NULL,
    DSTR_RSTCN_FLAG                 VARCHAR2(120)     NOT NULL,
    PCT_FL_TM_VAL                   NUMBER        ,
    WV_PRTN_RSN_CD                  VARCHAR2(120) ,
    PL_WVD_FLAG                     VARCHAR2(120)     NOT NULL,
    PL_ID                           NUMBER(18, 0) ,
    PGM_ID                          NUMBER(18, 0) ,
    LER_ID                          NUMBER(18, 0) ,
    PERSON_ID                       NUMBER(18, 0)     NOT NULL,
    MUST_ENRL_ANTHR_PL_ID           NUMBER(18, 0) ,
    BUSINESS_GROUP_ID               NUMBER(18, 0)     NOT NULL,
    PEP_ATTRIBUTE_CATEGORY          VARCHAR2(120) ,
    PEP_ATTRIBUTE1                  VARCHAR2(600) ,
    PEP_ATTRIBUTE2                  VARCHAR2(600) ,
    PEP_ATTRIBUTE3                  VARCHAR2(600) ,
    PEP_ATTRIBUTE4                  VARCHAR2(600) ,
    PEP_ATTRIBUTE5                  VARCHAR2(600) ,
    PEP_ATTRIBUTE6                  VARCHAR2(600) ,
    PEP_ATTRIBUTE7                  VARCHAR2(600) ,
    PEP_ATTRIBUTE8                  VARCHAR2(600) ,
    PEP_ATTRIBUTE9                  VARCHAR2(600) ,
    PEP_ATTRIBUTE10                 VARCHAR2(600) ,
    PEP_ATTRIBUTE11                 VARCHAR2(600) ,
    PEP_ATTRIBUTE12                 VARCHAR2(600) ,
    PEP_ATTRIBUTE13                 VARCHAR2(600) ,
    PEP_ATTRIBUTE14                 VARCHAR2(600) ,
    PEP_ATTRIBUTE15                 VARCHAR2(600) ,
    PEP_ATTRIBUTE16                 VARCHAR2(600) ,
    PEP_ATTRIBUTE17                 VARCHAR2(600) ,
    PEP_ATTRIBUTE18                 VARCHAR2(600) ,
    PEP_ATTRIBUTE19                 VARCHAR2(600) ,
    PEP_ATTRIBUTE20                 VARCHAR2(600) ,
    PEP_ATTRIBUTE21                 VARCHAR2(600) ,
    PEP_ATTRIBUTE22                 VARCHAR2(600) ,
    PEP_ATTRIBUTE23                 VARCHAR2(600) ,
    PEP_ATTRIBUTE24                 VARCHAR2(600) ,
    PEP_ATTRIBUTE25                 VARCHAR2(600) ,
    PEP_ATTRIBUTE26                 VARCHAR2(600) ,
    PEP_ATTRIBUTE27                 VARCHAR2(600) ,
    PEP_ATTRIBUTE28                 VARCHAR2(600) ,
    PEP_ATTRIBUTE29                 VARCHAR2(600) ,
    PEP_ATTRIBUTE30                 VARCHAR2(600) ,
    PEP_ATTRIBUTE_NUMBER1           NUMBER        ,
    PEP_ATTRIBUTE_NUMBER2           NUMBER        ,
    PEP_ATTRIBUTE_NUMBER3           NUMBER        ,
    PEP_ATTRIBUTE_NUMBER4           NUMBER        ,
    PEP_ATTRIBUTE_NUMBER5           NUMBER        ,
    PEP_ATTRIBUTE_NUMBER6           NUMBER        ,
    PEP_ATTRIBUTE_NUMBER7           NUMBER        ,
    PEP_ATTRIBUTE_NUMBER8           NUMBER        ,
    PEP_ATTRIBUTE_NUMBER9           NUMBER        ,
    PEP_ATTRIBUTE_NUMBER10          NUMBER        ,
    PEP_ATTRIBUTE_NUMBER11          NUMBER        ,
    PEP_ATTRIBUTE_NUMBER12          NUMBER        ,
    PEP_ATTRIBUTE_NUMBER13          NUMBER        ,
    PEP_ATTRIBUTE_NUMBER14          NUMBER        ,
    PEP_ATTRIBUTE_NUMBER15          NUMBER        ,
    PEP_ATTRIBUTE_NUMBER16          NUMBER        ,
    PEP_ATTRIBUTE_NUMBER17          NUMBER        ,
    PEP_ATTRIBUTE_NUMBER18          NUMBER        ,
    PEP_ATTRIBUTE_NUMBER19          NUMBER        ,
    PEP_ATTRIBUTE_NUMBER20          NUMBER        ,
    PEP_ATTRIBUTE_DATE1             DATE          ,
    PEP_ATTRIBUTE_DATE2             DATE          ,
    PEP_ATTRIBUTE_DATE3             DATE          ,
    PEP_ATTRIBUTE_DATE4             DATE          ,
    PEP_ATTRIBUTE_DATE5             DATE          ,
    PEP_ATTRIBUTE_DATE6             DATE          ,
    PEP_ATTRIBUTE_DATE7             DATE          ,
    PEP_ATTRIBUTE_DATE8             DATE          ,
    PEP_ATTRIBUTE_DATE9             DATE          ,
    PEP_ATTRIBUTE_DATE10            DATE          ,
    PEP_ATTRIBUTE_DATE11            DATE          ,
    PEP_ATTRIBUTE_DATE12            DATE          ,
    PEP_ATTRIBUTE_DATE13            DATE          ,
    PEP_ATTRIBUTE_DATE14            DATE          ,
    PEP_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,
    REQUEST_ID                      NUMBER(18, 0) ,
    JOB_DEFINITION_NAME             VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE          VARCHAR2(3600),
    PROGRAM_APP_NAME                VARCHAR2(120) ,
    PROGRAM_NAME                    VARCHAR2(120) ,
    PROGRAM_UPDATE_DATE             DATE          ,
    OBJECT_VERSION_NUMBER           NUMBER(9, 0)      NOT NULL,
    RT_COMP_REF_AMT                 NUMBER        ,
    RT_CMBN_AGE_N_LOS_VAL           NUMBER        ,
    RT_COMP_REF_UOM                 VARCHAR2(120) ,
    RT_AGE_VAL                      NUMBER        ,
    RT_LOS_VAL                      NUMBER        ,
    RT_HRS_WKD_VAL                  NUMBER        ,
    RT_HRS_WKD_BNDRY_PERD_CD        VARCHAR2(120) ,
    RT_AGE_UOM                      VARCHAR2(120) ,
    RT_LOS_UOM                      VARCHAR2(120) ,
    RT_PCT_FL_TM_VAL                NUMBER        ,
    RT_FRZ_LOS_FLAG                 VARCHAR2(120)     NOT NULL,
    RT_FRZ_AGE_FLAG                 VARCHAR2(120)     NOT NULL,
    RT_FRZ_CMP_LVL_FLAG             VARCHAR2(120)     NOT NULL,
    RT_FRZ_PCT_FL_TM_FLAG           VARCHAR2(120)     NOT NULL,
    RT_FRZ_HRS_WKD_FLAG             VARCHAR2(120)     NOT NULL,
    RT_FRZ_COMB_AGE_AND_LOS_FLAG    VARCHAR2(120)     NOT NULL,
    INELG_RSN_CD                    VARCHAR2(120) ,
    ONCE_R_CNTUG_CD                 VARCHAR2(120) ,
    WAIT_PERD_CMPLTN_DT             DATE          ,
    PER_IN_LER_ID                   NUMBER(18, 0) ,
    PLIP_ID                         NUMBER(18, 0) ,
    PTIP_ID                         NUMBER(18, 0) ,
    PL_ORDR_NUM                     NUMBER(18, 0) ,
    PLIP_ORDR_NUM                   NUMBER(18, 0) ,
    PTIP_ORDR_NUM                   NUMBER(18, 0) ,
    WAIT_PERD_STRT_DT               DATE          ,
    ELIG_PER_ID                     NUMBER(18, 0) ,
    BENEFIT_RELATION_ID             NUMBER(18, 0) ,
    EFFECTIVE_START_DATE            DATE          ,
    EFFECTIVE_END_DATE              DATE          ,
    DPNT_OTHR_PL_CVRD_RL_FLAG       VARCHAR2(120)     NOT NULL,
    PRTN_OVRIDN_THRU_DT             DATE          ,
    PL_KEY_EE_FLAG                  VARCHAR2(120)     NOT NULL,
    PL_HGHLY_COMPD_FLAG             VARCHAR2(120)     NOT NULL,
    ELIG_FLAG                       VARCHAR2(120)     NOT NULL,
    COMP_REF_AMT                    NUMBER        ,
    CMBN_AGE_N_LOS_VAL              NUMBER        ,
    COMP_REF_UOM                    VARCHAR2(120) ,
    AGE_VAL                         NUMBER        ,
    LOS_VAL                         NUMBER        ,
    PRTN_END_DT                     DATE          ,
    PRTN_STRT_DT                    DATE          ,
    WV_CTFN_TYP_CD                  VARCHAR2(120) ,
    HRS_WKD_VAL                     NUMBER        ,
    HRS_WKD_BNDRY_PERD_CD           VARCHAR2(120) ,
    PRTN_OVRIDN_FLAG                VARCHAR2(120)     NOT NULL,
    NO_MX_PRTN_OVRID_THRU_FLAG      VARCHAR2(120)     NOT NULL,
    PRTN_OVRIDN_RSN_CD              VARCHAR2(120) ,
    AGE_UOM                         VARCHAR2(120) ,
    LOS_UOM                         VARCHAR2(120) ,
    OVRID_SVC_DT                    DATE          ,
    FRZ_LOS_FLAG                    VARCHAR2(120)     NOT NULL,
    FRZ_AGE_FLAG                    VARCHAR2(120)     NOT NULL,
    FRZ_CMP_LVL_FLAG                VARCHAR2(120)     NOT NULL,
    FRZ_PCT_FL_TM_FLAG              VARCHAR2(120)     NOT NULL,
    FRZ_HRS_WKD_FLAG                VARCHAR2(120)     NOT NULL,
    FRZ_COMB_AGE_AND_LOS_FLAG       VARCHAR2(120)     NOT NULL,
    DSTR_RSTCN_FLAG                 VARCHAR2(120)     NOT NULL,
    PCT_FL_TM_VAL                   NUMBER        ,
    WV_PRTN_RSN_CD                  VARCHAR2(120) ,
    PL_WVD_FLAG                     VARCHAR2(120)     NOT NULL,
    PL_ID                           NUMBER(18, 0) ,
    PGM_ID                          NUMBER(18, 0) ,
    LER_ID                          NUMBER(18, 0) ,
    PERSON_ID                       NUMBER(18, 0)     NOT NULL,
    MUST_ENRL_ANTHR_PL_ID           NUMBER(18, 0) ,
    BUSINESS_GROUP_ID               NUMBER(18, 0)     NOT NULL,
    PEP_ATTRIBUTE_CATEGORY          VARCHAR2(120) ,
    PEP_ATTRIBUTE1                  VARCHAR2(600) ,
    PEP_ATTRIBUTE2                  VARCHAR2(600) ,
    PEP_ATTRIBUTE3                  VARCHAR2(600) ,
    PEP_ATTRIBUTE4                  VARCHAR2(600) ,
    PEP_ATTRIBUTE5                  VARCHAR2(600) ,
    PEP_ATTRIBUTE6                  VARCHAR2(600) ,
    PEP_ATTRIBUTE7                  VARCHAR2(600) ,
    PEP_ATTRIBUTE8                  VARCHAR2(600) ,
    PEP_ATTRIBUTE9                  VARCHAR2(600) ,
    PEP_ATTRIBUTE10                 VARCHAR2(600) ,
    PEP_ATTRIBUTE11                 VARCHAR2(600) ,
    PEP_ATTRIBUTE12                 VARCHAR2(600) ,
    PEP_ATTRIBUTE13                 VARCHAR2(600) ,
    PEP_ATTRIBUTE14                 VARCHAR2(600) ,
    PEP_ATTRIBUTE15                 VARCHAR2(600) ,
    PEP_ATTRIBUTE16                 VARCHAR2(600) ,
    PEP_ATTRIBUTE17                 VARCHAR2(600) ,
    PEP_ATTRIBUTE18                 VARCHAR2(600) ,
    PEP_ATTRIBUTE19                 VARCHAR2(600) ,
    PEP_ATTRIBUTE20                 VARCHAR2(600) ,
    PEP_ATTRIBUTE21                 VARCHAR2(600) ,
    PEP_ATTRIBUTE22                 VARCHAR2(600) ,
    PEP_ATTRIBUTE23                 VARCHAR2(600) ,
    PEP_ATTRIBUTE24                 VARCHAR2(600) ,
    PEP_ATTRIBUTE25                 VARCHAR2(600) ,
    PEP_ATTRIBUTE26                 VARCHAR2(600) ,
    PEP_ATTRIBUTE27                 VARCHAR2(600) ,
    PEP_ATTRIBUTE28                 VARCHAR2(600) ,
    PEP_ATTRIBUTE29                 VARCHAR2(600) ,
    PEP_ATTRIBUTE30                 VARCHAR2(600) ,
    PEP_ATTRIBUTE_NUMBER1           NUMBER        ,
    PEP_ATTRIBUTE_NUMBER2           NUMBER        ,
    PEP_ATTRIBUTE_NUMBER3           NUMBER        ,
    PEP_ATTRIBUTE_NUMBER4           NUMBER        ,
    PEP_ATTRIBUTE_NUMBER5           NUMBER        ,
    PEP_ATTRIBUTE_NUMBER6           NUMBER        ,
    PEP_ATTRIBUTE_NUMBER7           NUMBER        ,
    PEP_ATTRIBUTE_NUMBER8           NUMBER        ,
    PEP_ATTRIBUTE_NUMBER9           NUMBER        ,
    PEP_ATTRIBUTE_NUMBER10          NUMBER        ,
    PEP_ATTRIBUTE_NUMBER11          NUMBER        ,
    PEP_ATTRIBUTE_NUMBER12          NUMBER        ,
    PEP_ATTRIBUTE_NUMBER13          NUMBER        ,
    PEP_ATTRIBUTE_NUMBER14          NUMBER        ,
    PEP_ATTRIBUTE_NUMBER15          NUMBER        ,
    PEP_ATTRIBUTE_NUMBER16          NUMBER        ,
    PEP_ATTRIBUTE_NUMBER17          NUMBER        ,
    PEP_ATTRIBUTE_NUMBER18          NUMBER        ,
    PEP_ATTRIBUTE_NUMBER19          NUMBER        ,
    PEP_ATTRIBUTE_NUMBER20          NUMBER        ,
    PEP_ATTRIBUTE_DATE1             DATE          ,
    PEP_ATTRIBUTE_DATE2             DATE          ,
    PEP_ATTRIBUTE_DATE3             DATE          ,
    PEP_ATTRIBUTE_DATE4             DATE          ,
    PEP_ATTRIBUTE_DATE5             DATE          ,
    PEP_ATTRIBUTE_DATE6             DATE          ,
    PEP_ATTRIBUTE_DATE7             DATE          ,
    PEP_ATTRIBUTE_DATE8             DATE          ,
    PEP_ATTRIBUTE_DATE9             DATE          ,
    PEP_ATTRIBUTE_DATE10            DATE          ,
    PEP_ATTRIBUTE_DATE11            DATE          ,
    PEP_ATTRIBUTE_DATE12            DATE          ,
    PEP_ATTRIBUTE_DATE13            DATE          ,
    PEP_ATTRIBUTE_DATE14            DATE          ,
    PEP_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,
    REQUEST_ID                      NUMBER(18, 0) ,
    JOB_DEFINITION_NAME             VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE          VARCHAR2(3600),
    PROGRAM_APP_NAME                VARCHAR2(120) ,
    PROGRAM_NAME                    VARCHAR2(120) ,
    PROGRAM_UPDATE_DATE             DATE          ,
    OBJECT_VERSION_NUMBER           NUMBER(9, 0)      NOT NULL,
    RT_COMP_REF_AMT                 NUMBER        ,
    RT_CMBN_AGE_N_LOS_VAL           NUMBER        ,
    RT_COMP_REF_UOM                 VARCHAR2(120) ,
    RT_AGE_VAL                      NUMBER        ,
    RT_LOS_VAL                      NUMBER        ,
    RT_HRS_WKD_VAL                  NUMBER        ,
    RT_HRS_WKD_BNDRY_PERD_CD        VARCHAR2(120) ,
    RT_AGE_UOM                      VARCHAR2(120) ,
    RT_LOS_UOM                      VARCHAR2(120) ,
    RT_PCT_FL_TM_VAL                NUMBER        ,
    RT_FRZ_LOS_FLAG                 VARCHAR2(120)     NOT NULL,
    RT_FRZ_AGE_FLAG                 VARCHAR2(120)     NOT NULL,
    RT_FRZ_CMP_LVL_FLAG             VARCHAR2(120)     NOT NULL,
    RT_FRZ_PCT_FL_TM_FLAG           VARCHAR2(120)     NOT NULL,
    RT_FRZ_HRS_WKD_FLAG             VARCHAR2(120)     NOT NULL,
    RT_FRZ_COMB_AGE_AND_LOS_FLAG    VARCHAR2(120)     NOT NULL,
    INELG_RSN_CD                    VARCHAR2(120) ,
    ONCE_R_CNTUG_CD                 VARCHAR2(120) ,
    WAIT_PERD_CMPLTN_DT             DATE          ,
    PER_IN_LER_ID                   NUMBER(18, 0) ,
    PLIP_ID                         NUMBER(18, 0) ,
    PTIP_ID                         NUMBER(18, 0) ,
    PL_ORDR_NUM                     NUMBER(18, 0) ,
    PLIP_ORDR_NUM                   NUMBER(18, 0) ,
    PTIP_ORDR_NUM                   NUMBER(18, 0) ,
    WAIT_PERD_STRT_DT               DATE          ,
    CONSTRAINT pk_ben_elig_per_f PRIMARY KEY (ELIG_PER_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, ELIG_PER_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE)
);
