Search Results pay_bal_attribute_definitions




Overview
Explore in AI Chat

Overview

The PAY_BAL_ATTRIBUTE_DEFINITIONS table is a core reference table within the Oracle E-Business Suite Payroll module (PAY). It serves as the master repository for defining balance attributes, which are critical metadata elements used to identify and categorize payroll balances. The primary role of this table is to establish the valid attributes that can be assigned to balance dimensions, thereby enabling the precise selection of specific balances for payroll calculations, reporting, and legislative compliance. It acts as a foundational control table, ensuring that balance-related logic is consistently applied across the payroll system in both releases 12.1.1 and 12.2.2.

Key Information Stored

The table stores the definitional metadata for each balance attribute. Key columns include the unique identifier ATTRIBUTE_ID (the primary key) and the ATTRIBUTE_NAME, which is a unique identifier for the attribute within a given business group or legislation. The BUSINESS_GROUP_ID and LEGISLATION_CODE columns provide the necessary context, determining whether the attribute definition is specific to a particular business group or is a global legislative rule. This structure allows for both localized and enterprise-wide attribute definitions, supporting complex multi-country payroll implementations.

Common Use Cases and Queries

This table is primarily referenced during the setup and maintenance of payroll balances and in the generation of balance-specific reports. A common use case is identifying all available balance attributes for a specific legislation to configure a new balance dimension. A typical query would retrieve the attribute definitions for a given context:

  • Sample Query: SELECT attribute_id, attribute_name FROM pay_bal_attribute_definitions WHERE legislation_code = 'US' ORDER BY attribute_name;

Another critical use case is troubleshooting or documenting the balance framework, where technical consultants join this table to PAY_BALANCE_ATTRIBUTES to understand which definitions are actively assigned to balance dimensions. Reports that filter balances based on specific characteristics, such as "Taxable" or "Non-Taxable," rely on the attribute mappings defined here.

Related Objects

The PAY_BAL_ATTRIBUTE_DEFINITIONS table has direct relationships with several other key payroll tables, as indicated by its foreign key constraints. The most significant relationship is with the PAY_BALANCE_ATTRIBUTES table, which links these definitions to specific balance dimensions. It is also referenced by PAY_BAL_ATTRIBUTE_DEFAULTS, which stores default values for attributes. Consequently, this table is central to the balance definition hierarchy, feeding into the PAY_BALANCE_DIMENSIONS and PAY_BALANCE_FEEDS_F tables through these relationships, forming the complete architecture for payroll balance management.