Search Results ben_vrbl_rt_prfl_f




Overview
Explore in AI Chat

Overview

The BEN_VRBL_RT_PRFL_F table is a core data object within the Oracle E-Business Suite Advanced Benefits (BEN) module. It functions as the master definition table for variable rate profiles. These profiles are critical for configuring complex, rule-based contribution or coverage calculations in benefit plans. A variable rate profile defines the logic for determining a rate—such as an employer contribution percentage or a premium cost—that can vary based on employee attributes like age, salary, length of service, or other customizable factors. The '_F' suffix indicates it is an effective-dated table, meaning it stores historical, current, and future-dated records to support changes in profile definitions over time without losing auditability.

Key Information Stored

The table's structure is designed to manage the lifecycle and logic of rate profiles. The primary key is a composite of VRBL_RT_PRFL_ID and EFFECTIVE_START_DATE, uniquely identifying each version of a profile. The EFFECTIVE_END_DATE defines the period for which that version is active. A critical foreign key column is COMP_LVL_FCTR_ID, which links to the BEN_COMP_LVL_FCTR table. This relationship associates the profile with a specific compensation level factor—the foundational element (e.g., salary grade, pay basis) upon which the variable calculation is built. Other columns, implied by its purpose, would typically store profile names, calculation rules, eligibility criteria references, and descriptive information.

Common Use Cases and Queries

This table is central to benefits administration processes. Common use cases include the setup and maintenance of benefit plans with tiered contribution structures, generating reports on active rate profiles, and troubleshooting calculation results during enrollment or payroll processing. A frequent query involves retrieving the currently effective profile definition for a specific plan or calculation.

Sample Query: Fetch Effective Variable Rate Profile
SELECT vrbl_rt_prfl_id,
effective_start_date,
effective_end_date,
comp_lvl_fctr_id
FROM ben.ben_vrbl_rt_prfl_f
WHERE vrbl_rt_prfl_id = :p_profile_id
AND SYSDATE BETWEEN effective_start_date AND effective_end_date;

Data from this table is typically accessed via the Benefits dedicated user interface or through custom integrations and reports that analyze benefit plan costing and contribution strategies.

Related Objects

  • BEN_COMP_LVL_FCTR (Table): Holds the definition of compensation level factors. The foreign key (COMP_LVL_FCTR_ID) in BEN_VRBL_RT_PRFL_F establishes a direct dependency, as a variable rate profile must be based on a valid factor.
  • BEN_VRBL_RT_RL (Table): Likely stores the individual rate rules or tiers that belong to a profile, defining specific rate values and the conditions (e.g., age ranges, service bands) that trigger them.
  • BEN_PGM_F / BEN_PL_F (Tables): Benefit programs and plans often reference a variable rate profile to determine contributions or premiums for enrolled participants.
  • Benefits APIs and PL/SQL Packages: Core benefits engine packages (e.g., BEN_EXTRA_ELEMENT, BEN_BNFT_CALC) will read from this table during enrollment, life event processing, and payroll calculation to apply the correct variable rates.