Search Results pay_balance_types

Overview

The PAY_BALANCE_TYPES table is a core master data table within the Oracle E-Business Suite Payroll (PAY) module. It serves as the central repository for defining the fundamental types of balances used in payroll calculations and reporting. A balance type represents a distinct, measurable payroll concept, such as gross earnings, tax withheld, or net pay, which accumulates values over a specified dimension of time (e.g., quarter-to-date, year-to-date). This table establishes the blueprint for balances; the actual balance instances for specific employees are stored in related tables. Its role is critical for configuring payroll processing, ensuring legislative compliance, and enabling comprehensive compensation reporting.

Key Information Stored

The table's primary identifier is the system-generated BALANCE_TYPE_ID. Each balance type is uniquely defined by a combination of its BALANCE_NAME, BUSINESS_GROUP_ID, and LEGISLATION_CODE, as enforced by the unique key PAY_BALANCE_TYPES_UK2. This structure allows for the creation of both global (legislation-specific) and local (business group-specific) balance definitions. While the provided metadata does not list all columns, typical columns in this table include REPORTING_NAME for display purposes, INPUT_VALUE_ID to link to the primary feed source, and attributes controlling the balance's behavior, such as whether it is an encumbrance balance or its classification (e.g., Gross Earnings, Voluntary Deductions).

Common Use Cases and Queries

This table is primarily referenced for setup, inquiry, and reporting. A common administrative task is to identify all balance types available for a specific legislation or business group to configure payroll elements or fast formulas. For reporting, developers often join this table to transaction tables to produce detailed balance summaries. A typical query pattern involves retrieving the definition of a balance by its common name:

• SELECT balance_type_id, balance_name, reporting_name FROM pay_balance_types WHERE business_group_id = :p_bg_id AND balance_name LIKE '%GROSS%';

Another critical use case is troubleshooting payroll results by tracing the source balance type for an unexpected value, which involves joining PAY_BALANCE_TYPES to PAY_BALANCE_FEEDS_F and PAY_INPUT_VALUES_F.

Related Objects

As indicated by the foreign key relationships, PAY_BALANCE_TYPES is a parent table to several key payroll objects. The PAY_DEFINED_BALANCES table creates specific instances of these balance types for particular dimensions (e.g., Assignment Year-to-Date). PAY_BALANCE_FEEDS_F defines how payroll run results (input values) feed into each balance type. PAY_BALANCE_CLASSIFICATIONS groups balance types into categories for processing and reporting logic. Finally, PAY_GROSSUP_BAL_EXCLUSIONS references this table to specify balances that should be omitted from gross-up calculations. Understanding these relationships is essential for any technical analysis of the payroll balance engine.