Search Results ben_elig_comp_lvl_prte_d




Overview
Explore in AI Chat

Overview

The view APPS.BEN_ELIG_COMP_LVL_PRTE_D is a denormalized reporting object within the Oracle Advanced Benefits (BEN) module. Its name follows the standard BEN naming convention: BEN_ELIG denotes an eligibility rule entity, COMP_LVL identifies a compensation-level determinant, and the _PRTE_D suffix indicates that this is a descriptive ("_D") view over the underlying eligibility participation record (_PRTE_F). The view was retrofitted into the EBS data model, meaning it was created after the initial release of the base eligibility tables to expose a flattened, human-readable projection of compensation-level eligibility rules without altering the underlying normalized schema.

Its role is purely read-oriented. Oracle EBS concurrent programs, BI Publisher reports, and third-party integration extracts reference this view when they need to display eligibility rule definitions in a form that is directly understandable to a benefits administrator—resolved factor names, plan/profile names, and lookup meanings—rather than the numeric surrogate keys stored on the base table. Because it is defined in the APPS schema, it inherits the standard EBS security model and can be queried by any responsibility with appropriate grants on the BEN schema objects.

Underlying Base Objects

The view text joins five objects. The driving table is BEN_ELIG_COMP_LVL_PRTE_F, the "F" (fact/foundation) table that physically stores one row per compensation-level eligibility participation rule. All joins are outer joins (indicated by the (+) operator), which ensures that a participation rule is still returned even when its referenced lookups or descriptive attributes are absent or inactive.

The documented ETRM metadata also records HR_API (package) as a referenced object, reflecting the dependency chain used by the BEN/HR eligibility APIs that populate and validate the underlying tables.

Key Columns

  • ROW_ID — the physical row identifier (ECL.ROWID), useful for uniquely addressing a rule row.
  • ELIG_COMP_LVL_PRTE_ID — the surrogate primary key of the compensation-level participation rule.
  • EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the date-effective range governing when the rule is valid, central to any date-tracked query.
  • COMP_LVL_FCTR_NAME — the resolved compensation-level factor associated with the rule.
  • ELIGY_PRFL_NAME — the eligibility profile to which this compensation-level criterion belongs.
  • EXCLD_MEANING — the Yes/No translation of EXCLD_FLAG, indicating whether the rule includes or excludes participants.
  • ORDR_NUM — the evaluation sequence of the rule within its profile.
  • LAST_UPDATE_DATE / LAST_UPDATED_BY — audit columns, with the user ID resolved against FND_USER.

Common Use Cases and Queries

The view is typically used to audit eligibility configuration, troubleshoot unexpected enrollment outcomes, and feed reporting extracts. A representative query to list active compensation-level rules for a given profile follows:

  • SELECT eligy_prfl_name, comp_lvl_fctr_name, excld_meaning, ordr_num
  • FROM apps.ben_elig_comp_lvl_prte_d
  • WHERE TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date
  • AND eligy_prfl_name = :p_profile
  • ORDER BY ordr_num;

Analysts also use the view to reconcile configuration changes by filtering on last_updated_by and last_update_date, and integration developers join it to BEN_ELIGY_PRFL_F on eligy_prfl_name to flatten complete eligibility definitions for downstream systems.