Search Results grossup_balances_id




Overview
Explore in AI Chat

Overview

The PAY_SHADOW_GU_BAL_EXCLUSIONS table is a core data object within the Oracle E-Business Suite (EBS) Payroll module, specifically for releases 12.1.1 and 12.2.2. It functions as a configuration table that defines exclusion rules for gross-up calculations. In payroll processing, a gross-up is a calculation to determine the pre-tax amount needed to cover a specified after-tax liability. This table stores mappings that identify specific balance types which should be excluded from these gross-up calculations when they are processed through an element template. Its role is critical for ensuring accurate and compliant payroll results by allowing precise control over which earnings or deductions are factored into gross-up computations.

Key Information Stored

The table's structure centers on linking a source element template, a balance type, and an exclusion rule. While the full column list is not detailed in the provided metadata, the foreign key relationships explicitly identify the key columns and their purpose. The SOURCE_ID column links to PAY_SHADOW_ELEMENT_TYPES, identifying the specific element template governing the gross-up. The BALANCE_TYPE_ID column links to PAY_SHADOW_BALANCE_TYPES, specifying the exact balance (e.g., a particular type of tax or deduction) to be excluded. The EXCLUSION_RULE_ID column links to PAY_TEMPLATE_EXCLUSION_RULES, which defines the logic or condition for the exclusion. The primary key, GROSSUP_BALANCES_ID, uniquely identifies each exclusion record.

Common Use Cases and Queries

The primary use case is troubleshooting and validating the setup of gross-up calculations. A payroll administrator or implementer would query this table to audit which balances are excluded for a given element template, ensuring the gross-up logic aligns with business or legal requirements. A common query would join to related shadow tables to get descriptive names. For example:

  • Identifying all exclusions for a specific element template: SELECT pet.element_name, pbt.balance_name, pter.rule_name FROM pay_shadow_gu_bal_exclusions psgbe, pay_shadow_element_types pet, pay_shadow_balance_types pbt, pay_template_exclusion_rules pter WHERE psgbe.source_id = pet.shadow_element_type_id AND psgbe.balance_type_id = pbt.shadow_balance_type_id AND psgbe.exclusion_rule_id = pter.exclusion_rule_id AND pet.element_name = 'X_GROSSUP_ELEMENT';
  • Reporting on all configured gross-up balance exclusions within the system for documentation purposes.

Related Objects

This table is integral to the shadow payroll architecture used for fast formula and template processing. Its key relationships, as defined by its foreign keys, are:

  • PAY_SHADOW_ELEMENT_TYPES: The source element template that contains the gross-up rule.
  • PAY_SHADOW_BALANCE_TYPES: The specific balance type being excluded from the calculation.
  • PAY_TEMPLATE_EXCLUSION_RULES: The rule defining the condition of the exclusion.
  • The table is also centrally referenced by its primary key constraint, PAY_SHADOW_GU_BAL_EXCLUSION_PK.