Results for “hr_s_balance_dimensions”

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

Overview

HR_S_BALANCE_DIMENSIONS is a table owned by the HR schema within the PER (Human Resources) product module of Oracle E-Business Suite, documented as VALID in releases 12.1.1 and 12.2.2. The ETRM record carries the description annotation "Retrofitted," indicating that the object was introduced or modified to support the current technical baseline rather than forming part of the original functional design. The table stores the balance dimension definitions that drive how absence, accrual, and leave balances are categorized, validated, and exposed to payroll and compensation processing within Oracle HRMS.

From a data modeling perspective, the mined heuristic classification for this object is standalone, meaning the ETRM Data Vault analysis did not detect inbound foreign key dependencies from other tables. In warehouse-style modeling terms, the table functions as a standalone reference or descriptor object rather than as a hub or link. It nevertheless participates in an outbound relationship to the payroll dimension repository, which supplies the canonical dimension identity it extends.

Key Information Stored

The physical schema documents twenty columns. The most significant include:

• BALANCE_DIMENSION_ID — the surrogate identifier and the only documented foreign key target, referencing PAY_BALANCE_DIMENSIONS. This column is the primary join anchor to the payroll dimension master.
• BUSINESS_GROUP_ID — the multi-tenancy discriminator that scopes each dimension definition to a specific business group (enterprise/legislative unit).
• LEGISLATION_CODE and LEGISLATION_SUBGROUP — the statutory jurisdiction and its subordinate grouping, determining which legislative rules apply to the dimension.
• DIMENSION_NAME, DIMENSION_TYPE, and DESCRIPTION — the descriptive business-key candidates used to identify the dimension in user-facing configuration and reports.
• DIMENSION_LEVEL — the hierarchical plane at which the balance is measured (for example, assignment versus period level).
• PERIOD_TYPE — the accumulation cycle applied to the balance, such as monthly, quarterly, or annual.
• ROUTE_ID — an internal routing reference used by the processing engine.
• FEED_CHECKING_CODE and FEED_CHECKING_TYPE — the validation rules applied when balances are fed into downstream calculations.
• EXPIRY_CHECKING_CODE and EXPIRY_CHECKING_LEVEL — the rules governing when accumulated balances expire.
• PAYMENTS_FLAG — indicates whether the dimension participates in payment processing.
• DATABASE_ITEM_SUFFIX and DATABASE_ITEM_FUNCTION — the physical database item mapping used by the balance calculation engine.
• ASG_ACTION_BALANCE_DIM_ID and SAVE_RUN_BALANCE_ENABLED — the assignment-action linkage and the switch controlling whether balances are persisted during a payroll run.
• START_DATE_CODE — the effective-dating rule for the dimension.

No unique index is separately documented in the ETRM excerpt, so BALANCE_DIMENSION_ID serves as the surrogate primary key, while DIMENSION_NAME combined with BUSINESS_GROUP_ID and LEGISLATION_CODE form the plausible natural business key.

Common Use Cases and Queries

Typical usage centers on configuration auditing, balance reconciliation, and legislative validation reporting. Analysts frequently need to confirm that every payroll balance dimension is backed by an HR dimension definition, or to enumerate the dimensions active for a given legislation.

SELECT d.balance_dimension_id,
       d.dimension_name,
       d.dimension_type,
       d.period_type,
       d.payments_flag
  FROM hr.hr_s_balance_dimensions d
 WHERE d.business_group_id = :p_business_group_id
   AND d.legislation_code = :p_legislation_code;

A reconciliation query against the payroll master identifies orphaned or mismatched definitions:

SELECT p.balance_dimension_id,
       p.dimension_name   payroll_name,
       h.dimension_name   hr_name
  FROM pay.pay_balance_dimensions p
  LEFT OUTER JOIN hr.hr_s_balance_dimensions h
    ON h.balance_dimension_id = p.balance_dimension_id
 WHERE h.balance_dimension_id IS NULL;

Because the table is classified as standalone, extraction for warehouse loading is straightforward and requires no fan-out handling.

Related Objects

• PAY_BALANCE_DIMENSIONS — the referenced dimension master; joined on BALANCE_DIMENSION_ID.
• PAY_BALANCE_TYPES and PAY_BALANCES — consume the dimension identifier to classify accumulated balances.
• PER_BUSINESS_GROUPS — supplies the organizational scope keyed by BUSINESS_GROUP_ID.
• FND_ID_FLEX_STRUCTURES — underpins the key flexfield structures that dimension definitions often map to.
• HR_S_BALANCE_DIMENSIONS_TL (where available) — the translated description table for multilingual installations.