Results for “ben_elig_per_f_rbv”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

BEN_ELIG_PER_F_RBV is a denormalized, date-tracked table in the Oracle Advanced Benefits (BEN) module of Oracle E-Business Suite, holding eligibility rule configuration for benefit plans and plan types. The suffix convention indicates a "rule/relationship base" structure that carries effective-dated, versioned eligibility criteria evaluated at person and plan level during the benefits enrollment lifecycle. In ETRM 12.1.1 and 12.2.2 the object resides in the BEN schema, is flagged VALID, and exposes a documented physical schema of 109 columns.

Functionally, the table encodes the conditions under which a person qualifies for a given plan (PL_ID), plan-in-plan program (PLIP_ID), plan type in program (PTIP_ID), or program (PGM_ID). Rather than storing a single static eligibility flag, it stores the parameters of the underlying life-event, age, length-of-service, compensation, hours-worked, and participation-based rules. This makes it the primary configuration repository consumed by the benefits eligibility evaluation engine.

The ETRM heuristic Data Vault classification for this object is standalone, with no single parent hub. Two of its foreign keys nevertheless point to transactional context tables — BEN_BENEFIT_ACTIONS and BEN_PERSON_ACTIONS — which suggests the table is best modeled as a link-and-satellite hybrid: the qualifying rule definition is the satellite payload, while BENEFIT_ACTION_ID and PERSON_ACTION_ID form the linkage to the action context in which the rule was evaluated or generated.

Key Information Stored

The surrogate primary key is ELIG_PER_ID, a system-generated identifier for each eligibility rule row. The documented unique index BEN_ELIG_PER_F_RBV_PK is composed of BENEFIT_ACTION_ID, ELIG_PER_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE, confirming that this is a date-effectivity table: multiple historical versions of the same ELIG_PER_ID coexist, and the PK enforces one row per action per validity window.

The most business-significant columns include:

• BENEFIT_ACTION_ID — the benefits action instance this eligibility evaluation belongs to; part of the business key.
• ELIG_PER_ID — the eligibility period/rule surrogate identifier.
• PERSON_ID and PERSON_ACTION_ID — the person context and the person-level action that triggered evaluation.
• PL_ID, PLIP_ID, PTIP_ID, PGM_ID — the specific plan, plan-in-program, plan type in program, and program to which the rule applies.
• ELIG_FLAG and INELG_RSN_CD — the resulting eligibility determination and the reason for ineligibility.
• AGE_VAL, LOS_VAL, HRS_WKD_VAL, PCT_FL_TM_VAL, COMP_REF_AMT — the rule threshold values for age, length of service, hours worked, percentage full-time, and compensation reference amount.
• WAIT_PERD_STRT_DT, WAIT_PERD_CMPLTN_DT, ONCE_R_CNTUG_CD — waiting-period start/completion dates and the once-per-contiguous-period indicator.
• FRZ_* and RT_FRZ_* flag columns — the freeze and re-freeze indicators for LOS, age, compensation level, percentage full-time, hours worked, and the combined age-and-LOS condition.
• DSTR_RSTCN_FLAG, PL_HGHLY_COMPD_FLAG, PL_KEY_EE_FLAG, PL_WVD_FLAG — plan-level characteristic flags.
• Standard EBS audit columns: LAST_UPDATE_DATE, CREATED_BY, REQUEST_ID, PROGRAM_ID, OBJECT_VERSION_NUMBER.

Common Use Cases and Queries

Eligibility engineers and benefits administrators query this table to audit why a person was determined eligible or ineligible, to replicate rule configuration for new plans, and to reconcile waiting-period outcomes. A typical audit query retrieves the current rule set for a person and plan:

• SELECT e.elig_per_id, e.elig_flag, e.inelg_rsn_cd, e.age_val, e.los_val, e.hrs_wkd_val, e.wait_perd_cmpltn_dt FROM ben.ben_elig_per_f_rbv e WHERE e.person_id = :p_person_id AND e.pl_id = :p_plan_id AND e.benefit_action_id = :p_action_id AND SYSDATE BETWEEN e.effective_start_date AND e.effective_end_date;
• Ineligibility root-cause reporting — aggregate by INELG_RSN_CD grouped by plan and action to identify systemic disqualifiers.
• Rule migration and comparison — join PL_ID to BEN_PL_F and BEN_PLIP_F to compare age/LOS thresholds across programs.
• Reconciliation against BEN_BENEFIT_ACTIONS to verify each action has a complete set of effective eligibility rows, and against BEN_PER_IN_LER for the learner/eligibility relationship context.

Because the row count is per-action and effective-dated, extraction for data-warehouse benefit-eligibility marts should always filter on the effective window and the action instance to avoid duplicates.

Related Objects

The documented foreign keys anchor this object to three parents, with the most consequential join relationships listed below:

• BEN_PER_IN_LER — joined via BEN_ELIG_PER_F_RBV.PER_IN_LER_ID = BEN_PER_IN_LER.PER_IN_LER_ID; supplies the person-in-learner-line relationship that defines the eligibility target.
• BEN_BENEFIT_ACTIONS — joined via BENEFIT_ACTION_ID; provides the processing action context and is part of the unique business key.
• BEN_PERSON_ACTIONS — joined via PERSON_ACTION_ID; links evaluation to the individual's action record.
• BEN_PL_F / BEN_PLIP_F / BEN_PGM_F — the plan, plan-in-program, and program definition tables referenced by PL_ID, PLIP_ID, and PGM_ID.
• BEN_ELIG_PER_F — the underlying eligibility rule table for which this object acts as the read-only base view/denormalized companion.
• BEN_ELIG_PER_OPT_F — optional eligibility criteria linked by ELIG_PER_ID.
• BEN_PTIP_F — plan type in program definition referenced by PTIP_ID.

Together these relationships establish BEN_ELIG_PER_F_RBV as the effective-dated, action-scoped eligibility rule base that supports the entire BEN enrollment decision path in both 12.1.1 and 12.2.2.