Search Results pay_balance_feeds_f




Overview
Explore in AI Chat

Overview

The PAY_BALANCE_FEEDS_F table is a core configuration table within the Oracle E-Business Suite Payroll module (PAY). It serves as the master control mechanism defining the permissible sources of data for payroll balance calculations. Specifically, it governs which input values—the fundamental units of pay, deductions, and other earnings—are authorized to feed into a given balance type. This relationship is fundamental to ensuring that balances, which track running totals for payments and deductions over defined periods, are calculated correctly and consistently according to legislative and business rules. The table is date-effective, indicated by the '_F' suffix, meaning it maintains a historical record of how these feeding rules change over time, which is critical for accurate retroactive payroll processing.

Key Information Stored

The table's structure centers on establishing and maintaining the link between a balance type and its source input values. The primary identifier is the system-generated BALANCE_FEED_ID. The core relational columns are BALANCE_TYPE_ID, which references a specific balance (e.g., "Regular Earnings Paid"), and INPUT_VALUE_ID, which references the specific source element entry value (e.g., an hourly rate or a flat deduction amount). The table enforces data integrity through a unique constraint (PAY_BALANCE_FEEDS_F_UK2) that prevents duplicate feed definitions for the same balance, input value, business group (BUSINESS_GROUP_ID), legislation code (LEGISLATION_CODE), and effective date range. The EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns define the period during which the feeding rule is active, enabling historical tracking and future-dated changes.

Common Use Cases and Queries

This table is primarily referenced for configuration analysis, troubleshooting balance calculations, and developing custom payroll reports. A common diagnostic query involves identifying all input values feeding a particular balance to verify setup or investigate discrepancies. For example, to audit the feeds for a specific balance type within a business group, one might use a query joining PAY_BALANCE_FEEDS_F to PAY_BALANCE_TYPES_B and PAY_INPUT_VALUES_F. Another critical use case is during the design and testing of new elements or balances, where consultants must insert or validate records in this table to establish the correct feeding relationships. Reporting on the evolution of these rules over time for compliance purposes also relies on querying the effective date columns.

Related Objects

PAY_BALANCE_FEEDS_F has direct dependencies on several other key payroll tables. Its primary foreign key relationship is with PAY_BALANCE_TYPES (via BALANCE_TYPE_ID), which defines the balances themselves. The INPUT_VALUE_ID column typically relates to PAY_INPUT_VALUES_F. The table is also intrinsically linked to PAY_ELEMENT_ENTRIES_F and PAY_ELEMENT_TYPES_F, as input values belong to elements. For comprehensive reporting or data extraction, views such as PAY_BALANCE_FEEDS (a synonym or simplified view) may be utilized. The table is central to the balance calculation engine and is referenced by core payroll processes and APIs that compute and maintain balance figures.