Results for “pay_bal_attribute_defaults”

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

Overview

PAY_BAL_ATTRIBUTE_DEFAULTS is a Payroll (PAY) module table owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to store balance attribution values that are defaulted automatically, based on the configuration rows held in this table. In practical terms, the table acts as a configuration and rules repository that determines which attribute value is applied to a balance dimension for a given balance category, business group, and legislation. This enables payroll administrators to standardize how balance attributions are derived without requiring manual entry on every balance or dimension combination.

Because the table is purely a configuration/definition repository that stores relationships between balance categories, balance dimensions, and balance attributes, its heuristic Data Vault classification is link. This classification is offered as a modeling suggestion: the table resolves many-to-many-style associations between balance dimensions and attribute definitions rather than representing a standalone business entity.

Key Information Stored

The documented physical schema contains twelve columns in the HR schema. The most significant columns are:

• BAL_ATTRIBUTE_DEFAULT_ID — the surrogate primary key, enforced by the PAY_BAL_ATTRIBUTE_DEFAULTS_PK unique index (which also includes ZD_EDITION_NAME).
• BALANCE_CATEGORY_ID — identifies the balance category to which the default attribution applies.
• BALANCE_DIMENSION_ID — foreign key to PAY_BALANCE_DIMENSIONS; identifies the balance dimension being defaulted.
• ATTRIBUTE_ID — foreign key to PAY_BAL_ATTRIBUTE_DEFINITIONS; identifies the attribute definition used as the default value.
• BUSINESS_GROUP_ID — scopes the default to a specific business group (partitioning by enterprise).
• LEGISLATION_CODE — scopes the default to a specific legislation/country.
• ZD_EDITION_NAME — the editioning column introduced in the 12.2 online patching (edition-based redefinition) architecture.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard EBS WHO audit columns tracking creation and modification.

The business-key candidate for this table is the PAY_BAL_ATTRIBUTE_DEFAULTS_UK unique index, comprising BALANCE_CATEGORY_ID, BALANCE_DIMENSION_ID, ATTRIBUTE_ID, BUSINESS_GROUP_ID, LEGISLATION_CODE, and ZD_EDITION_NAME. This means a given balance category, dimension, and attribute combination can occur only once per business group and legislation. The surrogate key BAL_ATTRIBUTE_DEFAULT_ID should not be confused with this natural/business key.

Common Use Cases and Queries

Typical use cases include auditing which default attribute applies to a dimension, validating configuration before payroll runs, and reporting on attribution setup across legal entities. A representative query resolves the defaulted attribute definition for a dimension:

• SELECT d.balance_dimension_id, d.attribute_id, d.business_group_id, d.legislation_code FROM pay_bal_attribute_defaults d WHERE d.balance_dimension_id = :p_dimension_id;
• Joining to PAY_BALANCE_DIMENSIONS to obtain dimension names, and to PAY_BAL_ATTRIBUTE_DEFINITIONS to obtain attribute names, supports configuration reports.
• Filtering by LEGISLATION_CODE and BUSINESS_GROUP_ID isolates defaults relevant to a specific payroll statutory environment.

Because the table is configuration data, queries are most often read-only. Reporting should always filter on BUSINESS_GROUP_ID and LEGISLATION_CODE to avoid cross-enterprise contamination, and on ZD_EDITION_NAME = 'ORA$BASE' in 12.2 environments where editioning applies.

Related Objects

The following objects are most significant in relation to this table, based on documented foreign-key and business-key relationships:

• PAY_BAL_ATTRIBUTE_DEFINITIONS — referenced via PAY_BAL_ATTRIBUTE_DEFAULTS.ATTRIBUTE_ID; supplies the attribute definition being defaulted.
• PAY_BALANCE_DIMENSIONS — referenced via PAY_BAL_ATTRIBUTE_DEFAULTS.BALANCE_DIMENSION_ID; supplies the dimension to which the default applies.
• PAY_BALANCE_CATEGORIES — associated through BALANCE_CATEGORY_ID, identifying the balance category context.
• PAY_BAL_ATTRIBUTE_DEFAULTS_PK / PAY_BAL_ATTRIBUTE_DEFAULTS_UK — the primary and business-key unique indexes.
• HR business group and legislation reference objects — scoping entities for BUSINESS_GROUP_ID and LEGISLATION_CODE.

Together these objects form the configuration layer that governs automatic balance attribution within Oracle Payroll.