Search Results balance_classification_id




Overview
Explore in AI Chat

Overview

The PAY_SHADOW_BALANCE_CLASSI table is a core technical object within the Oracle E-Business Suite Payroll (PAY) module, specifically for versions 12.1.1 and 12.2.2. It functions as a classification system for shadow balances associated with element templates. Shadow balances are specialized, temporary calculation contexts used during payroll processing to track intermediate values without affecting the primary, permanent balances. This table's primary role is to define and manage the classification rules that determine how these shadow balances are grouped and utilized within the complex payroll calculation engine, linking specific balance types to template exclusion logic.

Key Information Stored

The table's structure centers on creating associations between balance types and classification rules. The primary key, BALANCE_CLASSIFICATION_ID, uniquely identifies each classification rule. The critical foreign key columns define the relationships that give the table its purpose: BALANCE_TYPE_ID links to PAY_SHADOW_BALANCE_TYPES to specify which shadow balance is being classified, and EXCLUSION_RULE_ID links to PAY_TEMPLATE_EXCLUSION_RULES. This last relationship is pivotal, as it ties the shadow balance classification to the business logic that determines when an element template should be excluded from processing for a given balance context, ensuring calculations adhere to complex legislative and organizational policies.

Common Use Cases and Queries

This table is primarily accessed for technical configuration, troubleshooting, and audit purposes. Common scenarios include diagnosing payroll calculation results by tracing which shadow balance classifications and associated exclusion rules were applied. System administrators may query it to understand the setup. A typical analytical query would join the table to its related entities to review the full classification setup:

  • Identifying all classifications for a specific balance type: SELECT * FROM pay_shadow_balance_classi WHERE balance_type_id = <ID>;
  • Reviewing the full classification mapping: SELECT psbc.*, psbt.balance_name, pter.rule_name FROM pay_shadow_balance_classi psbc JOIN pay_shadow_balance_types psbt ON psbc.balance_type_id = psbt.balance_type_id JOIN pay_template_exclusion_rules pter ON psbc.exclusion_rule_id = pter.exclusion_rule_id;

Related Objects

PAY_SHADOW_BALANCE_CLASSI is a central link in a chain of payroll technical tables. Its two documented foreign keys define its primary relationships:

  • PAY_SHADOW_BALANCE_TYPES: This table stores the master definition of available shadow balances. PAY_SHADOW_BALANCE_CLASSI references it via BALANCE_TYPE_ID to specify which balance is being classified.
  • PAY_TEMPLATE_EXCLUSION_RULES: This table contains the business rules that govern when element templates are excluded from payroll calculations. The link via EXCLUSION_RULE_ID applies these rules to the context of a specific shadow balance classification.

As a configuration table, it is primarily referenced by the payroll calculation engine itself during runtime rather than by end-user reports or interfaces.