Search Results ben_comp_lvl_rt_f




Overview
Explore in AI Chat

Overview

The BEN_COMP_LVL_RT_F table is a core data structure within the Oracle E-Business Suite (EBS) Advanced Benefits (BEN) module, specifically versions 12.1.1 and 12.2.2. It serves as a rate table that stores compensation-level-based factors used in benefit calculations. This table is fundamental for configuring and executing complex benefit plans where eligibility, coverage amounts, or premium contributions are determined by an employee's compensation level. As a date-effective table (indicated by the "_F" suffix and the EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns), it maintains a historical record of rate changes, allowing the system to apply the correct rate based on the effective date of a given transaction or enrollment event.

Key Information Stored

The table's primary purpose is to link a specific compensation level factor to a corresponding numerical rate value. Its structure is defined by a primary key composed of COMP_LVL_RT_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE, ensuring unique, time-aware records. The most critical columns include COMP_LVL_RT_ID, which uniquely identifies each rate entry; COMP_LVL_FCTR_ID, a foreign key linking to the BEN_COMP_LVL_FCTR table that defines the specific compensation level factor (e.g., salary band or grade rate); and the EFFECTIVE_START_DATE and EFFECTIVE_END_DATE, which define the period during which the rate is valid. Additional columns typically store the actual RATE_VALUE, creation/modification metadata (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE), and other attributes for business rule context.

Common Use Cases and Queries

This table is primarily accessed during benefit plan processing to determine correct contribution percentages or coverage multiples. A common operational query retrieves the active rate for a specific compensation level factor as of a given date, such as an employee's enrollment date. For example:

  • SELECT rate_value FROM ben_comp_lvl_rt_f WHERE comp_lvl_fctr_id = :p_factor_id AND :p_effective_date BETWEEN effective_start_date AND effective_end_date;

Reporting use cases include auditing rate history for a factor or validating that all required compensation levels have defined rates for a future plan year. Data fixes often involve inserting new dated rows to correct or update rates, ensuring historical data integrity is maintained.

Related Objects

The BEN_COMP_LVL_RT_F table has a direct and documented foreign key relationship with the BEN_COMP_LVL_FCTR table. The join is performed on the column BEN_COMP_LVL_RT_F.COMP_LVL_FCTR_ID, which references the corresponding key in BEN_COMP_LVL_FCTR. This relationship is critical: BEN_COMP_LVL_FCTR defines the compensation level factors (the "what"), while BEN_COMP_LVL_RT_F stores the applicable rates (the "value") for those factors over time. Consequently, any process or report querying rates will typically join these two tables. The table is also referenced by various Benefits APIs and is integral to the calculation engine within the Advanced Benefits module.