Search Results ben_elig_comp_lvl_prte_f

Overview

The BEN_ELIG_COMP_LVL_PRTE_F table is a core data object within the Oracle E-Business Suite Advanced Benefits (BEN) module. It functions as a rule definition table, specifically designed to identify compensation levels for inclusion or exclusion within a compensation object. This table is integral to the configuration of eligibility and enrollment rules, enabling administrators to define precise criteria based on an employee's compensation level. Its role is to store the effective-dated rules that link eligibility profiles to specific compensation level factors, thereby controlling program participation. As a table with an effective-date structure (denoted by the '_F' suffix), it maintains a full history of rule changes over time, which is critical for accurate retroactive processing and auditing within the benefits system.

Key Information Stored

The table's structure centers on its primary and foreign keys, which define the rule's identity and its relationship to compensation factors. The primary key is a composite of ELIG_COMP_LVL_PRTE_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE, enforcing the temporal uniqueness of each rule entry. The ELIG_COMP_LVL_PRTE_ID is the unique identifier for the rule definition itself. The EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns define the period during which the rule is active. A critical foreign key column is COMP_LVL_FCTR_ID, which links the rule to a specific compensation level factor defined in the BEN_COMP_LVL_FCTR table. This link is the mechanism by which the system evaluates an employee's compensation against the defined rule. Additional columns, typical in BEN configuration tables, would include CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE for auditing, along with business columns to specify the rule's operator (e.g., equals, between) and potentially an exclusion flag.

Common Use Cases and Queries

A primary use case is the analysis or troubleshooting of benefits enrollment rules. For instance, a benefits administrator may need to verify all active rules that reference a particular compensation level factor. A common reporting requirement is to list the effective-dated history of a specific eligibility rule. Sample SQL to retrieve active rule definitions would leverage the effective date columns:

• SELECT prte.elig_comp_lvl_prte_id, prte.effective_start_date, prte.effective_end_date, fctr.name FROM ben_elig_comp_lvl_prte_f prte JOIN ben_comp_lvl_fctr fctr ON prte.comp_lvl_fctr_id = fctr.comp_lvl_fctr_id WHERE SYSDATE BETWEEN prte.effective_start_date AND prte.effective_end_date;

Another critical scenario involves data migration or integration, where external HR systems feed compensation data; understanding the mapping stored in this table is essential to ensure employees are correctly evaluated for benefits eligibility based on their compensation tier.

Related Objects

The table maintains defined foreign key relationships with other core Benefits tables, as documented in the ETRM. The primary relationship is with the compensation level factor definition table:

• BEN_COMP_LVL_FCTR: This table is referenced via the foreign key column BEN_ELIG_COMP_LVL_PRTE_F.COMP_LVL_FCTR_ID. This join (ON prte.comp_lvl_fctr_id = fctr.comp_lvl_fctr_id) is essential for retrieving the human-readable name or code of the compensation factor used in the rule.

While not listed in the provided excerpt, this table is typically a child of a higher-level eligibility profile object (such as BEN_ELIGY_PRFL) via the ELIG_COMP_LVL_PRTE_ID or a similar profile identifier. It would also be referenced by various Benefits engine APIs and seeded data upload programs during rule validation and processing.