Search Results pay_bal_attribute_defaults




Overview
Explore in AI Chat

Overview

The PAY_BAL_ATTRIBUTE_DEFAULTS table is a core configuration table within the Oracle E-Business Suite Payroll module (PAY). It serves as a master repository for defining default balance attributes, which are fundamental to the calculation and tracking of payroll balances. Balances represent cumulative totals for various payroll elements, such as gross earnings or tax withholdings, over specific time dimensions. This table establishes the standard, system-defined attribution rules that determine which balance categories, dimensions, and attributes are linked by default. Its configuration underpins the accurate generation of payroll results and is critical for legislative compliance across different business groups and geographies.

Key Information Stored

The table stores the relationships that define default balance behavior. Its structure, anchored by a primary key on BAL_ATTRIBUTE_DEFAULT_ID and a unique key for business rule integrity, includes several critical columns. The BALANCE_CATEGORY_ID and BALANCE_DIMENSION_ID specify the type and time period of the balance (e.g., a "Run" dimension for a "Gross Earnings" category). The ATTRIBUTE_ID links to a specific balance attribute definition. Crucially, the BUSINESS_GROUP_ID and LEGISLATION_CODE columns scope these defaults to a specific organizational unit or legislative territory, allowing for localized payroll setups. This combination ensures that for any given balance context within a defined legal and organizational framework, the correct default attributes are applied automatically.

Common Use Cases and Queries

This table is primarily referenced during payroll process design, balance initialization, and troubleshooting. A common use case is verifying the default attributes assigned to a specific balance category and dimension for a business group to ensure correct payroll calculations. For example, an implementation consultant might run a query to review all default attributes for a particular legislation. Sample SQL to retrieve this information often involves joining to related definition tables:

  • SELECT pbcd.name balance_category, pbd.dimension_name, pbad.attribute_name, pbadf.business_group_id, pbadf.legislation_code FROM pay_bal_attribute_defaults pbadf, pay_balance_categories_b pbcd, pay_balance_dimensions pbd, pay_bal_attribute_definitions pbad WHERE pbadf.balance_category_id = pbcd.balance_category_id AND pbadf.balance_dimension_id = pbd.balance_dimension_id AND pbadf.attribute_id = pbad.attribute_id AND pbadf.legislation_code = 'US';

Direct data manipulation in this table is rare; configurations are typically managed via dedicated administrative forms or APIs.

Related Objects

PAY_BAL_ATTRIBUTE_DEFAULTS is centrally linked to other key payroll balance definition tables through foreign key constraints. It directly references PAY_BAL_ATTRIBUTE_DEFINITIONS via the ATTRIBUTE_ID column to obtain the technical name and details of the attribute. It also references PAY_BALANCE_DIMENSIONS via the BALANCE_DIMENSION_ID. While not listed in the provided metadata, it logically relates to PAY_BALANCE_CATEGORIES_B for balance category information. This table is a foundational component for the balance engine, and its rules are utilized by various payroll calculation and balance adjustment processes within the system.