Search Results pay_balance_dimensions




Overview
Explore in AI Chat

Overview

The PAY_BALANCE_DIMENSIONS table is a core configuration table within the Oracle E-Business Suite Payroll module (PAY). It serves as the master repository for defining the different contexts or "dimensions" in which payroll balances can be calculated and stored. A balance dimension defines the scope of summation for a balance, such as a calendar year-to-date, a payroll period-to-date, or an assignment-level lifetime total. This table is critical for the payroll engine's ability to accurately accumulate and report on earnings, deductions, and other payroll results across various timeframes and organizational contexts, forming the structural basis for all defined balances in the system.

Key Information Stored

The table stores the metadata that defines each unique summation context. Key columns include BALANCE_DIMENSION_ID (the primary key surrogate identifier), DIMENSION_NAME (the unique name of the dimension, often descriptive like "Assignment Lifetime to Date" or "Calendar Year to Date"), and LEGISLATION_CODE (which ties the dimension to a specific country's legislative requirements). The BUSINESS_GROUP_ID column allows for dimension definitions at the business group level. The table also maintains a foreign key, ROUTE_ID, which links to the FF_ROUTES table, indicating the FastFormula used by the payroll engine to determine the database period (e.g., specific payroll period or date range) for balance calculations when processing a run.

Common Use Cases and Queries

This table is primarily referenced during payroll configuration, balance definition, and complex reporting. A common use case is identifying all system-defined dimensions for a specific legislation to understand available balance contexts. For troubleshooting or auditing, one might query which dimensions are used by specific defined balances. A typical reporting query joins PAY_BALANCE_DIMENSIONS to PAY_DEFINED_BALANCES to list all balances and their calculation dimensions.

  • Listing dimensions for a legislation: SELECT dimension_name, balance_dimension_id FROM pay_balance_dimensions WHERE legislation_code = 'US';
  • Finding dimensions used by a specific balance feed: SELECT pbd.dimension_name FROM pay_balance_dimensions pbd, pay_defined_balances pdb WHERE pdb.balance_dimension_id = pbd.balance_dimension_id AND pdb.defined_balance_id = &balance_id;

Related Objects

The PAY_BALANCE_DIMENSIONS table has integral relationships with several other payroll tables, as documented by its foreign key constraints.

  • PAY_DEFINED_BALANCES: A defined balance must be associated with a single dimension. Joined via PAY_DEFINED_BALANCES.BALANCE_DIMENSION_ID.
  • PAY_DIMENSION_ROUTES: This table uses PAY_BALANCE_DIMENSIONS twice. It links a balance dimension (BALANCE_DIMENSION_ID) to the specific run dimension (RUN_DIMENSION_ID) that controls the period for payroll runs.
  • PAY_BAL_ATTRIBUTE_DEFAULTS: Stores default values for balance attributes specific to a dimension. Joined via PAY_BAL_ATTRIBUTE_DEFAULTS.BALANCE_DIMENSION_ID.
  • FF_ROUTES: Contains the FastFormula used to determine the database period for the dimension. Joined via PAY_BALANCE_DIMENSIONS.ROUTE_ID.