Search Results pay_shadow_bal_attributes




Overview
Explore in AI Chat

Overview

The PAY_SHADOW_BAL_ATTRIBUTES table is a core technical repository within the Oracle E-Business Suite Payroll (PAY) module, specifically for versions 12.1.1 and 12.2.2. It functions as a metadata table that defines the specific balance attributes associated with shadow defined balances. These shadow balances are temporary, in-memory constructs generated during payroll processing based on element templates. The table's primary role is to store the configuration that dictates which balance dimensions (e.g., Assignment, Tax Unit, Jurisdiction) and exclusion rules apply to a shadow balance, thereby controlling how payroll results are accumulated for elements processed via templates.

Key Information Stored

The table's structure is designed to link shadow balances with their processing attributes. The primary and foreign key relationships are central to its function. The key columns include:

  • BALANCE_ATTRIBUTE_ID: The primary key (PK) column, uniquely identifying each attribute record for a shadow balance.
  • DEFINED_BALANCE_ID: A foreign key (FK) column linking to the PAY_SHADOW_DEFINED_BALANCES table. This associates the attribute with a specific shadow balance definition.
  • EXCLUSION_RULE_ID: A foreign key column linking to the PAY_TEMPLATE_EXCLUSION_RULES table. This defines any exclusion rule that must be evaluated when accumulating the balance for the element template, allowing for complex conditional logic in payroll calculations.

While the explicit column list is not detailed in the provided metadata, based on its purpose and related objects, it would also typically store identifiers for balance dimensions (e.g., TAX_UNIT_ID, JURISDICTION_CODE) to define the accumulation context.

Common Use Cases and Queries

This table is primarily accessed by the payroll engine during runtime and is less frequently queried directly for operational reporting. Direct queries are most common in diagnostic and support scenarios to understand or verify the configuration of element template balances. A typical analytical query would join to related definition tables to list all attributes for shadow balances associated with a specific element template or balance name.

Sample Diagnostic Query:
SELECT psdb.balance_name, psba.*
FROM pay_shadow_bal_attributes psba,
pay_shadow_defined_balances psdb
WHERE psba.defined_balance_id = psdb.defined_balance_id
AND psdb.template_id = :p_template_id
ORDER BY psdb.balance_name;

This query helps payroll functional and technical consultants trace how a template's calculated values are being accumulated into specific balance contexts, which is crucial for debugging incorrect payroll results.

Related Objects

As indicated by the foreign keys, PAY_SHADOW_BAL_ATTRIBUTES has integral relationships with two other key payroll tables:

  • PAY_SHADOW_DEFINED_BALANCES: This is the parent table. Each record in PAY_SHADOW_BAL_ATTRIBUTES must belong to a single shadow balance definition stored here.
  • PAY_TEMPLATE_EXCLUSION_RULES: This table stores the rule definitions referenced by the EXCLUSION_RULE_ID. The relationship allows a shadow balance attribute to conditionally exclude certain input values from accumulation based on defined criteria.

Furthermore, this table is intrinsically linked to the element template functionality within the Payroll module. It is populated and managed by the underlying template definition and balance initialization APIs during payroll process execution.