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.
- BALANCE_DIMENSION_ID — the surrogate primary key (PAY_BALANCE_DIMENSIONS_PK, which also includes ZD_EDITION_NAME). It uniquely identifies each dimension record and is the column referenced by nearly every dependent table.
- DIMENSION_NAME — the business name of the dimension. Together with BUSINESS_GROUP_ID, LEGISLATION_CODE, and ZD_EDITION_NAME it forms the unique business key PAY_BALANCE_DIMENSIONS_UK2.
- BUSINESS_GROUP_ID — the enterprise or business group that owns the dimension; a mandatory business-key component.
- LEGISLATION_CODE — the legislation under which the dimension applies, also part of the business key.
- DIMENSION_TYPE and DIMENSION_LEVEL — control how and at what level the balance is aggregated.
- ROUTE_ID — foreign key into FF_ROUTES, linking the dimension to its formula/route definition used during balance processing.
- PERIOD_TYPE — indicates whether the dimension aggregates over a period (for example, a payroll period) versus another scope.
- DATABASE_ITEM_SUFFIX and DATABASE_ITEM_FUNCTION — define the database item naming and function used to resolve the balance value.
- FEED_CHECKING_CODE, FEED_CHECKING_TYPE, EXPIRY_CHECKING_CODE, EXPIRY_CHECKING_LEVEL — govern validation behavior when balances feed other balances or expire.
- PAYMENTS_FLAG, SAVE_RUN_BALANCE_ENABLED, START_DATE_CODE — control payment association, run-balance persistence, and start-date handling.
- LEGISLATION_SUBGROUP, ASG_ACTION_BALANCE_DIM_ID, APPLICATION_ID, DESCRIPTION — provide finer legislative grouping, assignment-action linkage, owning application, and descriptive text.
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.
- FF_ROUTES — referenced by PAY_BALANCE_DIMENSIONS.ROUTE_ID.
- PAY_DEFINED_BALANCES — references BALANCE_DIMENSION_ID and is central to balance definitions.
- PAY_BAL_ATTRIBUTE_DEFAULTS — references BALANCE_DIMENSION_ID.
- PAY_DIMENSION_ROUTES — references BALANCE_DIMENSION_ID and RUN_DIMENSION_ID.
- PAY_BALANCE_BATCH_LINES — references BALANCE_DIMENSION_ID for batch processing.
- PAY_BALANCE_SET_MEMBERS — references BALANCE_DIMENSION_ID for balance set membership.
- PAY_TEMP_BALANCE_ADJUSTMENTS and PQP_EXCEPTION_REPORTS — reference BALANCE_DIMENSION_ID for adjustments and exception reporting.
- HR_S_* shadow views (HR_S_BALANCE_DIMENSIONS, HR_S_DEFINED_BALANCES, HR_S_DIMENSION_ROUTES) — reference the same key in the translated/secure layer.
-
Information allowing the summation of a balance.
-
Information allowing the summation of a balance.