Search Results ben_benfts_grp_rt_f




Overview
Explore in AI Chat

Overview

The BEN_BENFTS_GRP_RT_F table is a core data object within the Oracle E-Business Suite (EBS) Advanced Benefits (BEN) module, specifically for releases 12.1.1 and 12.2.2. It functions as the primary repository for storing rate information associated with a benefits group. A benefits group is a logical collection of employees defined for eligibility and enrollment purposes. This table is date-effective, meaning it maintains a historical record of rate changes over time, which is critical for accurate benefits costing, payroll deductions, and retroactive calculations. Its role is central to the financial and administrative aspects of benefits management, enabling the system to apply the correct contribution or premium rates for employees based on their assigned benefits group membership.

Key Information Stored

The table's structure is designed to manage time-sensitive rate data. The primary key, BEN_BENFTS_GRP_RT_F_PK, is a composite of BENFTS_GRP_RT_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE, enforcing uniqueness for each rate record's valid date range. Key columns include:

  • BENFTS_GRP_RT_ID: The unique identifier for a specific rate record.
  • EFFECTIVE_START_DATE and EFFECTIVE_END_DATE: Define the period during which the associated rate is valid.
  • BENFTS_GRP_ID: A foreign key column linking the rate to its parent benefits group defined in the BEN_BENFTS_GRP table.

While the provided metadata does not list all columns, this table typically stores the actual rate values (which may be monetary amounts or percentages), the rate type (e.g., employee contribution, employer contribution, premium), and associated currency or unit information.

Common Use Cases and Queries

This table is primarily accessed for benefits costing, payroll interface feeds, and auditing rate history. A common reporting requirement is to determine the effective rate for a benefits group as of a specific date for payroll processing. A typical query pattern would join to the benefits group table to filter by group name or identifier and select the valid rate record.

SELECT rt.*
FROM ben_benfts_grp_rt_f rt
WHERE rt.benfts_grp_id = :p_group_id
  AND :p_effective_date BETWEEN rt.effective_start_date AND rt.effective_end_date;

Another critical use case involves auditing rate changes over time for a given group, which leverages the date-effective nature of the table to track modifications for compliance or reconciliation purposes.

Related Objects

The table maintains a direct and documented foreign key relationship, establishing its dependency within the data model. The primary related object is:

  • BEN_BENFTS_GRP: This is the parent table for the benefits group definition. The BEN_BENFTS_GRP_RT_F table references it via the foreign key constraint on the column BEN_BENFTS_GRP_RT_F.BENFTS_GRP_ID. Any rate record must be associated with a valid, existing benefits group in this parent table. This relationship ensures data integrity and is fundamental for joining group details (like name or description) to its associated financial rates.