Results for “pay_balance_dimensions”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PAY_BALANCE_DIMENSIONS is a core configuration table in the Oracle E-Business Suite Payroll (PAY) module, owned by the HR schema. Its documented purpose is to store "information allowing the summation of a balance." In practical terms, each row defines a dimension or grouping level at which payroll balances can be aggregated, filtered, and reported. Balances in Oracle Payroll are not simple scalars; they are collected across multiple contextual axes — assignment, element, run, period, and others. The rows in PAY_BALANCE_DIMENSIONS describe those axes so the payroll engine and balance reporting tools can determine how a given balance is summed.

From a Data Vault modeling perspective, the documented foreign-key structure classifies this table as hub-leaning. Its surrogate primary key, BALANCE_DIMENSION_ID, is referenced by numerous dependent tables, which is characteristic of a hub entity that anchors relationships to other descriptive and transactional structures. This classification should be treated as a heuristic modeling suggestion rather than a formal Oracle designation.

Key Information Stored

The table is documented with twenty-two columns in ETRM 12.2.2. The most significant are summarized below.

Common Use Cases and Queries

Typical uses include identifying which dimensions a defined balance aggregates by, tracing the route and database item behind a dimension, and reporting on dimension configuration by legislation or business group. Because the business key is name-based, day-to-day lookups tend to resolve by name rather than by surrogate ID.

Sample query returning defined balances and their dimensions:

  • SELECT db.BALANCE_NAME, bd.DIMENSION_NAME, bd.DIMENSION_TYPE FROM PAY_DEFINED_BALANCES db JOIN PAY_BALANCE_DIMENSIONS bd ON db.BALANCE_DIMENSION_ID = bd.BALANCE_DIMENSION_ID WHERE bd.LEGISLATION_CODE = :legislation;
  • SELECT BALANCE_DIMENSION_ID, DIMENSION_NAME, ROUTE_ID, DIMENSION_LEVEL FROM PAY_BALANCE_DIMENSIONS WHERE BUSINESS_GROUP_ID = :bg AND DIMENSION_NAME = :name;

Related Objects

The following tables are the most significant dependents or references based on the documented foreign-key relationships.