Search Results pay_balance_attributes_uk




Overview
Explore in AI Chat

Overview

The HR.PAY_BALANCE_ATTRIBUTES table is a core configuration table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 Payroll module. It serves as a mapping table that defines the relationship between balance attributes and defined balances. This mapping is fundamental to the payroll calculation engine, as it determines which specific attributes (such as a particular earnings type, deduction, or tax code) contribute to a specific balance (such as Gross Earnings or Tax Withheld). The table ensures that payroll calculations correctly accumulate and report values based on the legislative and business group-specific rules configured in the system.

Key Information Stored

The table's structure is designed to enforce unique mappings and maintain auditability. The key columns include the surrogate primary key, BALANCE_ATTRIBUTE_ID. The critical functional columns are ATTRIBUTE_ID, which references a specific attribute definition from PAY_BAL_ATTRIBUTE_DEFINITIONS, and DEFINED_BALANCE_ID, which references a specific balance from PAY_DEFINED_BALANCES. The BUSINESS_GROUP_ID and LEGISLATION_CODE columns provide the context for the mapping, allowing for country-specific and organization-specific configurations. The integrity of these mappings is enforced by the unique key constraint PAY_BALANCE_ATTRIBUTES_UK, which prevents duplicate attribute-to-balance assignments within the same business group and legislation context. Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track all changes.

Common Use Cases and Queries

This table is central to payroll setup, troubleshooting, and reporting. A common use case is verifying which attributes feed into a particular balance for audit or support purposes. For example, to list all attributes contributing to a specific defined balance, one would join PAY_BALANCE_ATTRIBUTES to PAY_DEFINED_BALANCES and PAY_BAL_ATTRIBUTE_DEFINITIONS. Another critical scenario involves diagnosing balance calculation issues by checking if the expected attribute mappings exist. Developers and functional consultants query this table when extending or customizing payroll calculations to ensure new attributes are correctly linked to the relevant balances. A foundational query pattern is:

  • SELECT pba.ATTRIBUTE_ID, pba.DEFINED_BALANCE_ID, pbd.BALANCE_NAME, pbad.ATTRIBUTE_NAME FROM HR.PAY_BALANCE_ATTRIBUTES pba JOIN PAY_DEFINED_BALANCES pbd ON pba.DEFINED_BALANCE_ID = pbd.DEFINED_BALANCE_ID JOIN PAY_BAL_ATTRIBUTE_DEFINITIONS pbad ON pba.ATTRIBUTE_ID = pbad.ATTRIBUTE_ID WHERE pba.BUSINESS_GROUP_ID = :p_bg_id;

Related Objects

The HR.PAY_BALANCE_ATTRIBUTES table has defined dependencies on two primary configuration tables, as documented by its foreign key constraints. It references the HR.PAY_BAL_ATTRIBUTE_DEFINITIONS table via the ATTRIBUTE_ID column to obtain the definition of the payroll attribute (e.g., Regular Earnings, Federal Income Tax). It also references the HR.PAY_DEFINED_BALANCES table via the DEFINED_BALANCE_ID column to identify the target balance for accumulation. These relationships are essential for maintaining referential integrity; a row in PAY_BALANCE_ATTRIBUTES cannot exist without a valid corresponding row in both of these parent tables. The table itself is referenced by the payroll calculation engine and various payroll reports and processes that need to understand how to classify input values for balance processing.