Search Results ben_benefit_contributions_pk

Overview

The BEN_BENEFIT_CONTRIBUTIONS_F table is a core data structure within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically under the PER (Personnel) product family. This table stores the default contribution rules that define the financial obligations for a specific benefit coverage. It acts as a foundational table for managing employee benefits, enabling the system to calculate and process standard contribution amounts, such as those paid by the employer or employee, for a given benefit plan. Its role is critical for the accurate administration of benefits, payroll integration, and financial reporting related to employee compensation packages in both EBS releases 12.1.1 and 12.2.2.

Key Information Stored

The table is date-effective, utilizing EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns to maintain a history of contribution rule changes over time. The primary identifier is the BENEFIT_CONTRIBUTION_ID. According to the provided metadata, key columns defining a unique contribution rule include COVERAGE_TYPE and ELEMENT_TYPE_ID, which link the contribution to a specific type of benefit coverage and a corresponding payroll element. The table also contains a BUSINESS_GROUP_ID, which segregates data by the assigned business group, a standard security and multi-organization feature in Oracle HRMS. Other typical columns not listed in the excerpt but commonly present would detail contribution rates, calculation formulas, and the responsible party (e.g., employer vs. employee).

Common Use Cases and Queries

This table is primarily accessed for benefit setup, payroll processing, and auditing. Common scenarios include identifying the default contribution rules for a specific benefit during enrollment or generating reports on employer benefit costs. A typical query would join this table to benefit definition and payroll element tables to retrieve a current, effective set of rules.

• Sample Query to Find Active Contributions: SELECT * FROM ben_benefit_contributions_f WHERE sysdate BETWEEN effective_start_date AND effective_end_date AND business_group_id = :p_bg_id;
• Reporting Use Case: Generating a summary of all default employer contribution elements linked to medical benefit coverages for a given business group and effective date.

Related Objects

The table's integrity is maintained through defined primary and foreign key relationships. It has a primary key (BEN_BENEFIT_CONTRIBUTIONS_PK) on BENEFIT_CONTRIBUTION_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE, and a unique key on COVERAGE_TYPE, ELEMENT_TYPE_ID, and the date columns. As documented, a key foreign key relationship exists:

• Foreign Key to HR_ALL_ORGANIZATION_UNITS: The column BUSINESS_GROUP_ID in BEN_BENEFIT_CONTRIBUTIONS_F references HR_ALL_ORGANIZATION_UNITS. This enforces that every benefit contribution record is associated with a valid business group (organization unit) within the HRMS structure.

This table is also a likely parent to other benefits-related tables (not listed in the provided metadata) that store actual calculated contributions for enrolled participants, linking back via the BENEFIT_CONTRIBUTION_ID.