Search Results mtchg_rt_id




Overview
Explore in AI Chat

Overview

The BEN_MTCHG_RT_F table is a core data object within the Oracle E-Business Suite Advanced Benefits (BEN) module. It serves as a foundational table for configuring and storing matching rate definitions. In the context of benefits administration, a matching rate typically defines the employer's contribution formula for programs like 401(k) plans, where the employer matches a percentage of the employee's contribution, often up to a specified limit. This table's role is to hold the detailed rules and effective-dated history for these matching calculations, enabling the system to apply the correct rate based on the relevant effective date. As a table with an effective-date structure (denoted by the '_F' suffix and the EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns), it supports time-dependent changes to matching rate policies, ensuring historical accuracy for payroll and reporting.

Key Information Stored

The table's primary purpose is to define the parameters of a matching rate rule. Its structure, as indicated by the metadata, centers on a unique identifier and effective dating. The documented primary key consists of MTCHG_RT_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE, which guarantees uniqueness for each rate definition over time. A critical foreign key column is COMP_LVL_FCTR_ID, which links the matching rate to a specific compensation level factor defined in the BEN_COMP_LVL_FCTR table. This relationship is fundamental, as it ties the matching calculation to a specific element of an employee's compensation (e.g., base salary, total earnings). While the full column list is not detailed in the excerpt, typical data stored would include attributes such as the matching rate percentage or formula, applicable upper and lower limits for the match, and flags controlling the rule's activation and processing logic.

Common Use Cases and Queries

This table is primarily accessed during benefits enrollment processing, payroll calculation runs, and for generating compliance and plan valuation reports. A common operational query involves retrieving the active matching rate for a specific plan and compensation factor on a given date. For example, a payroll process might use a SQL pattern to join this table with plan assignment data to determine the correct employer match for an employee's contribution. Reporting use cases include auditing rate changes over time or analyzing matching costs by plan. Administrators may query the table to validate configuration or troubleshoot calculation discrepancies by examining the effective-dated history of a specific MTCHG_RT_ID.

Related Objects

The BEN_MTCHG_RT_F table exists within a tightly integrated schema. Its primary documented relationship, as per the provided foreign key metadata, is with the BEN_COMP_LVL_FCTR table. This relationship is established via the COMP_LVL_FCTR_ID column, meaning every matching rate rule must reference a valid compensation level factor. While not listed in the excerpt, it is architecturally certain that this table is referenced by other key benefits objects. These likely include plan design tables (e.g., BEN_PL_F) to associate rates with specific benefit programs, and potentially payroll interface tables that pass calculated match amounts to the payroll engine for processing. The primary key constraint, BEN_MTCHG_RT_F_PK, is also referenced by any foreign keys from child tables that store data derived from these rate rules.