Results for “ben_benefit_contributions_f”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

BEN_BENEFIT_CONTRIBUTIONS_F is a Human Resources (PER) module table in the Oracle E-Business Suite schema HR. It stores the default contributions payable for cover by a specific benefit, acting as the rules repository that defines how employee and employer contributions are calculated, bounded, and applied to a given coverage type. The table is a date-tracked ("_F") entity, meaning every logical record is maintained across one or more effective-dated rows, allowing historical contribution definitions to coexist without overwriting prior values. This design supports audit requirements and point-in-time benefits reporting.

From a Data Vault modeling perspective, the heuristic classification is satellite-leaning. The table's structure — a surrogate keyed identifier (BENEFIT_CONTRIBUTION_ID) combined with effective dating, plus descriptive and numeric attributes — is characteristic of a satellite attached to a benefits/coverage hub entity. This is a modeling suggestion rather than a functional statement about the EBS schema itself.

Key Information Stored

The surrogate primary key BEN_BENEFIT_CONTRIBUTIONS_PK is composed of BENEFIT_CONTRIBUTION_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE. The date columns are not merely audit fields: because they participate in the primary key, the table forces a distinct row whenever contribution rules change over time.

A second documented unique index, BEN_BENEFIT_CONTRIBUTIONS_UK2, functions as a business-key candidate. It spans COVERAGE_TYPE, ELEMENT_TYPE_ID, and the same effective date pair, establishing that a given coverage type and payroll element configuration must be unique within an effective range.

• BENEFIT_CONTRIBUTION_ID — surrogate identifier for a contribution definition.
• BUSINESS_GROUP_ID — organizational scope; foreign key to HR_ALL_ORGANIZATION_UNITS, partitioning data across enterprise business groups.
• COVERAGE_TYPE — the coverage level (for example employee, employee plus dependents) the contribution applies to.
• ELEMENT_TYPE_ID — links the contribution to the payroll element used to deduct or accrue it.
• FORMULA_ID — the formula that computes non-flat contributions.
• EMPLOYEE_CONTRIBUTION and EMPLOYER_CONTRIBUTION — default contribution amounts.
• MAXIMUM_EMPLOYEE_CONTRIBUTION, MINIMUM_EMPLOYEE_CONTRIBUTION, MAXIMUM_EMPLOYER_CONTRIBUTION, MINIMUM_EMPLOYER_CONTRIBUTION — caps and floors applied during calculation.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-track validity window.
• LAST_UPDATE_DATE, CREATED_BY, CREATION_DATE — standard EBS audit columns.

Common Use Cases and Queries

Typical scenarios include retrieving the active contribution rule for a coverage type as of a payroll period, and reconciling configured contribution amounts against payroll run results.

SELECT coverage_type, element_type_id,
       employee_contribution, employer_contribution,
       maximum_employee_contribution
  FROM hr.ben_benefit_contributions_f
 WHERE business_group_id = :p_bg_id
   AND TRUNC(:p_effective_date) BETWEEN effective_start_date
                                   AND effective_end_date;

For point-in-time history, querying all rows for a BENEFIT_CONTRIBUTION_ID ordered by EFFECTIVE_START_DATE produces a complete change log of contribution terms — useful in audit and benefits eligibility reviews. Joining on ELEMENT_TYPE_ID supports reports correlating contributions to payroll deduction element classifications.

Related Objects

• HR_ALL_ORGANIZATION_UNITS — joined via BUSINESS_GROUP_ID to resolve business group context.
• Payroll element definition tables — joined via ELEMENT_TYPE_ID to identify the paying or deducting element.
• Benefit formula definitions — joined via FORMULA_ID to trace contribution calculation logic.
• Coverage and plan tables in the BEN schema — related through COVERAGE_TYPE and plan enrollment structures.
• Concurrent program definitions — the seeded processes that create and maintain contribution rows in the HR schema.