BEN_ELIG_PER_F

BEN_ELIG_PER_F captures information about persons found eligible, and in some cases ineligible, for a program or plan. Typically, being eligible to participate means that the person can make an election or be enrolled, however, there are some circumstances where enrollment is not appropriate for a plan and being eligible does not mean that the participant can enroll at the same time as when they are eligible. The broadest definition of participation eligibility is that the person satisfies the plan defined criteria for receiving benefits from the plan at some time.

Details

  • Schema: FUSION

  • Object owner: BEN

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

BEN_ELIG_PER_F_PK

ELIG_PER_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping
ELIG_PER_ID NUMBER 18 Yes System generated primary key column.
BENEFIT_RELATION_ID NUMBER 18 Foreign Key to BEN_BENEFIT_RELATIONS_F
EFFECTIVE_START_DATE DATE Yes Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATE DATE Yes Date Effective Entity: indicates the date at the end of the date range within which the row is effective.
DPNT_OTHR_PL_CVRD_RL_FLAG VARCHAR2 30 Yes Dependent covered in other plan rule Y or N.
PRTN_OVRIDN_THRU_DT DATE Participation overriden through date.
PL_KEY_EE_FLAG VARCHAR2 30 Yes This column holds Plan Key Employee Y or N.
PL_HGHLY_COMPD_FLAG VARCHAR2 30 Yes This column holds Plan Highly Compensated Y or N.
ELIG_FLAG VARCHAR2 30 Yes This column holds Eligible Y or N.
COMP_REF_AMT NUMBER Eligible compensation reference amount.
CMBN_AGE_N_LOS_VAL NUMBER Eligible combined age and length of service value.
COMP_REF_UOM VARCHAR2 30 Eligible compensation reference unit of measure.
AGE_VAL NUMBER This column holds Eligible age value.
LOS_VAL NUMBER This column holds Eligible length of service value.
PRTN_END_DT DATE This column holds Participation end date.
PRTN_STRT_DT DATE This column holds Participation start date.
WV_CTFN_TYP_CD VARCHAR2 30 This column holds Waive certification type.
HRS_WKD_VAL NUMBER This column holds Eligible hours worked.
HRS_WKD_BNDRY_PERD_CD VARCHAR2 30 This column holds Eligible hours worked boundary period.
PRTN_OVRIDN_FLAG VARCHAR2 30 Yes This column holds Participation Overriden Y or N.
NO_MX_PRTN_OVRID_THRU_FLAG VARCHAR2 30 Yes No Maximum Participation Override Through Y or N.
PRTN_OVRIDN_RSN_CD VARCHAR2 30 This column holds Participation override reason.
AGE_UOM VARCHAR2 30 This column holds Eligible age unit of measure.
LOS_UOM VARCHAR2 30 Eligible length of service unit of measure.
OVRID_SVC_DT DATE This column holds Override service date.
FRZ_LOS_FLAG VARCHAR2 30 Yes This column holds Freeze Length of Service Y or N.
FRZ_AGE_FLAG VARCHAR2 30 Yes This column holds Freeze Age Y or N.
FRZ_CMP_LVL_FLAG VARCHAR2 30 Yes This column holds Freeze Compensation Level Y or N.
FRZ_PCT_FL_TM_FLAG VARCHAR2 30 Yes This column holds Freeze Percent Full Time Y or N.
FRZ_HRS_WKD_FLAG VARCHAR2 30 Yes This column holds Freeze Hours Worked Y or N.
FRZ_COMB_AGE_AND_LOS_FLAG VARCHAR2 30 Yes Freeze Combination Age And Length of Service Y or N.
DSTR_RSTCN_FLAG VARCHAR2 30 Yes This column holds Distribution restriction Y or N.
PCT_FL_TM_VAL NUMBER This column holds Eligible percent full time value.
WV_PRTN_RSN_CD VARCHAR2 30 This column holds Waive participation reason.
PL_WVD_FLAG VARCHAR2 30 Yes This column holds Plan Waived Y or N.
PL_ID NUMBER 18 This column holds Foreign Key to BEN_PL_F.
PGM_ID NUMBER 18 This column holds Foreign key to BEN_PGM_F.
LER_ID NUMBER 18 This column holds Foreign Key to BEN_LER_F.
PERSON_ID NUMBER 18 Yes This column holds Foreign Key to PER_PEOPLE_F.
MUST_ENRL_ANTHR_PL_ID NUMBER 18 This column holds Foreign key to BEN_PL_F.
BUSINESS_GROUP_ID NUMBER 18 Yes Foreign Key to HR_ORGANIZATION_UNITS
PEP_ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield structure defining column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE21 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE22 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE23 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE24 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE25 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE26 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE27 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE28 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE29 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE30 VARCHAR2 150 Descriptive Flexfield segment column. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_NUMBER11 NUMBER Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_NUMBER12 NUMBER Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_NUMBER13 NUMBER Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_NUMBER14 NUMBER Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_NUMBER15 NUMBER Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_NUMBER16 NUMBER Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_NUMBER17 NUMBER Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_NUMBER18 NUMBER Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_NUMBER19 NUMBER Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_NUMBER20 NUMBER Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_DATE6 DATE Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_DATE7 DATE Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_DATE8 DATE Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_DATE9 DATE Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_DATE10 DATE Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_DATE11 DATE Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_DATE12 DATE Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_DATE13 DATE Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_DATE14 DATE Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
PEP_ATTRIBUTE_DATE15 DATE Descriptive Flexfield: segment of the descriptive flexfield. Eligible Plan Attributes (BEN_ELIG_PER_DFF)
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
PROGRAM_APP_NAME VARCHAR2 30 This column holds Populated with FND_GLOBAL_PROG.APP_NAME
PROGRAM_NAME VARCHAR2 30 Concurrent Program Name -- Name of the concurrent program that last updated this row ( Populated with FND_GLOBAL_CONC.PROGRAM_NAME).
PROGRAM_UPDATE_DATE DATE Concurrent Program who column - date when a program last updated this row).
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
RT_COMP_REF_AMT NUMBER This column holds Rate compensation reference amount.
RT_CMBN_AGE_N_LOS_VAL NUMBER Rate combination age and length of service value.
RT_COMP_REF_UOM VARCHAR2 30 Rate compensation reference unit of measure.
RT_AGE_VAL NUMBER This column holds Rate age value.
RT_LOS_VAL NUMBER This column holds Rate length of service value.
RT_HRS_WKD_VAL NUMBER This column holds Rate hours worked value.
RT_HRS_WKD_BNDRY_PERD_CD VARCHAR2 30 This column holds Rate hours worked boundary period.
RT_AGE_UOM VARCHAR2 30 This column holds Rate age unit of measure.
RT_LOS_UOM VARCHAR2 30 This column holds Rate length of service unit of measure.
RT_PCT_FL_TM_VAL NUMBER This column holds Rate percent full time value.
RT_FRZ_LOS_FLAG VARCHAR2 30 Yes This column holds Rate Freeze Length of Service Y or N.
RT_FRZ_AGE_FLAG VARCHAR2 30 Yes This column holds Rate Freeze Age Y or N.
RT_FRZ_CMP_LVL_FLAG VARCHAR2 30 Yes This column holds Rate Freeze Compensation Level Y or N.
RT_FRZ_PCT_FL_TM_FLAG VARCHAR2 30 Yes This column holds Rate Freeze Percent Full Time Y or N.
RT_FRZ_HRS_WKD_FLAG VARCHAR2 30 Yes This column holds Rate Freeze Hours Worked Y or N.
RT_FRZ_COMB_AGE_AND_LOS_FLAG VARCHAR2 30 Yes Rate Freeze Combination Age And Length of Service Y or N.
INELG_RSN_CD VARCHAR2 30 This column holds Ineligible reason.
ONCE_R_CNTUG_CD VARCHAR2 30 This column holds Once or continuing.
WAIT_PERD_CMPLTN_DT DATE This column holds Waiting period completion date.
PER_IN_LER_ID NUMBER 18 This column holds Foreign Key to BEN_PER_IN_LER.
PLIP_ID NUMBER 18 This column holds Foreign key to BEN_PLIP_F.
PTIP_ID NUMBER 18 This column holds Foreign Key to BEN_PTIP_F.
PL_ORDR_NUM NUMBER 18 This column holds Plan order number.
PLIP_ORDR_NUM NUMBER 18 This column holds Plan in program order number.
PTIP_ORDR_NUM NUMBER 18 This column holds Plan type in program order number.
WAIT_PERD_STRT_DT DATE This column holds Waiting Period Start Date

Indexes

Index Uniqueness Tablespace Columns Status
BEN_ELIG_PER_F_FK1 Non Unique Default BUSINESS_GROUP_ID
BEN_ELIG_PER_F_FK2 Non Unique Default BENEFIT_RELATION_ID
BEN_ELIG_PER_F_FK6 Non Unique Default PER_IN_LER_ID
BEN_ELIG_PER_F_N1 Non Unique Default PL_ID
BEN_ELIG_PER_F_N2 Non Unique Default PLIP_ID
BEN_ELIG_PER_F_N3 Non Unique Default PERSON_ID Obsolete
BEN_ELIG_PER_F_N4 Non Unique Default PGM_ID
BEN_ELIG_PER_F_N5 Non Unique Default PTIP_ID
BEN_ELIG_PER_F_N6 Non Unique Default LER_ID
BEN_ELIG_PER_F_N7 Non Unique Default MUST_ENRL_ANTHR_PL_ID
BEN_ELIG_PER_F_N8 Non Unique Default PERSON_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, PL_ID
BEN_ELIG_PER_F_PK Unique Default ELIG_PER_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE