Results for “pay_balance_types”

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

Overview

PAY_BALANCE_TYPES is the defining table for balance types within the Oracle E-Business Suite Payroll (PAY) module. Stored in the HR schema, it holds the metadata that describes each balance an Oracle Payroll installation can accumulate, feed, or report against — for example gross earnings, taxable wages, deductions, or employer contributions. Every balance that is calculated during a payroll run, that is fed into another balance, or that appears in a statutory report must first exist as a row in this table, making it a foundational reference object rather than a transactional one.

From a Data Vault modeling perspective, the FK topology suggests a hub-leaning classification: PAY_BALANCE_TYPES is referenced by several dependent tables via BALANCE_TYPE_ID but does not itself reference a parent entity through a foreign key in the documented relationship set. This positions BALANCE_TYPE_ID as the natural business key candidate for a hub, with descriptive attributes such as reporting name, unit of measure, and comments lending themselves to a satellite. Dimensional modelers should treat it as a slowly changing dimension of type 1 or 2 depending on legislative maintenance requirements.

Key Information Stored

The table contains forty-four columns. The most significant are:

• BALANCE_TYPE_ID — the surrogate primary key (PAY_BALANCE_TYPES_PK), a system-generated identifier that all dependent tables reference.
• BALANCE_NAME — the internal name of the balance; combined with BUSINESS_GROUP_ID and LEGISLATION_CODE, and ZD_EDITION_NAME, it forms the unique business key PAY_BALANCE_TYPES_UK2.
• BUSINESS_GROUP_ID — the enterprise group that owns the balance definition, enabling multi-tenant separation of payroll data.
• LEGISLATION_CODE — the country or legislative context for which the balance is valid, critical for statutory compliance.
• LEGISLATION_SUBGROUP — a finer legislative partition used by some localizations.
• CURRENCY_CODE — the currency in which the balance is denominated.
• BALANCE_UOM — the unit of measure for the balance value (for example hours, currency, or number).
• REPORTING_NAME — the user-facing label displayed on reports and online inquiry.
• BALANCE_CATEGORY_ID — groups the balance into a reporting or behavioural category.
• BASE_BALANCE_TYPE_ID — self-referencing pointer to a parent balance for derived or rolled-up balances.
• ASSIGNMENT_REMUNERATION_FLAG — indicates whether the balance participates in remuneration calculations.
• TAX_TYPE and JURISDICTION_LEVEL — tax treatment and jurisdictional granularity.
• COMMENTS, APPLICATION_ID, and the twenty ATTRIBUTE columns — descriptive free text, owning application, and extensibility placeholders.
• ZD_EDITION_NAME — editioning column supporting online patching in Release 12.2.

Common Use Cases and Queries

Typical uses include auditing balance definitions after a patch or localization install, reconciling balances across business groups, and driving custom reporting. A common pattern joins the table to its classifications and defined balances:

• Retrieve a balance by name and legislation: SELECT balance_type_id, reporting_name, balance_uom FROM pay_balance_types WHERE balance_name = :name AND legislation_code = :leg AND business_group_id = :bg;
• List all balances feeding a target balance through PAY_BALANCE_FEEDS_F.
• Report balances classified under a given PAY_BALANCE_CLASSIFICATIONS row.
• Identify derived balances by inspecting BASE_BALANCE_TYPE_ID.

Because ZD_EDITION_NAME participates in the unique indexes, queries should constrain or exclude the obsolete edition during patching windows.

Related Objects

The documented foreign keys identify the principal dependent objects:

• PAY_BALANCE_CLASSIFICATIONS.BALANCE_TYPE_ID — assigns each balance to classification groupings.
• PAY_BALANCE_FEEDS_F.BALANCE_TYPE_ID — defines the feed hierarchy between balances.
• PAY_DEFINED_BALANCES.BALANCE_TYPE_ID — holds defined balance records referencing the type.
• PAY_GROSSUP_BAL_EXCLUSIONS.BALANCE_TYPE_ID — lists balances excluded from gross-up processing.

Together these form the balance definition and calculation framework used throughout Oracle Payroll.