Results for “per_bf_balance_types”

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

Overview

PER_BF_BALANCE_TYPES is a Human Resources (PER) table that stores the definitions of balance types that can be held within Oracle E-Business Suite. It resides in the HR schema and is a foundational reference object for the PER balance framework, which supports accrual plans, absence tracking, and other HR-related balance computations. Each row defines a distinct type of balance — for example, a vacation accrual, a sick leave balance, or a compensatory time balance — and establishes the naming, unit of measure, and currency context under which that balance is recorded.

From a Data Vault modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification. The table is anchored by a surrogate primary key and carries descriptive attributes (names, units, categories) that describe a balance concept rather than representing a standalone hub of a business entity. This is offered as a heuristic modeling suggestion; in a dimensional or Data Vault implementation, PER_BF_BALANCE_TYPES would most naturally serve as a reference or lookup dimension supplying descriptive context to balance transaction facts.

Key Information Stored

The table contains 16 documented columns. The most significant are:

• BALANCE_TYPE_ID — The surrogate primary key (PER_BF_BALANCE_TYPES_PK) that uniquely identifies each balance type and is the join key to dependent tables.
• BUSINESS_GROUP_ID — The business group (organization) that owns the balance type; a foreign key to HR_ALL_ORGANIZATION_UNITS, enabling multi-tenant separation of balance definitions.
• DISPLAYED_NAME — The user-facing label for the balance type, forming one of two business-key candidates (PER_BF_BALANCE_TYPES_UK1, combined with BUSINESS_GROUP_ID).
• INTERNAL_NAME — The internal system name, forming the second business-key candidate (PER_BF_BALANCE_TYPES_UK2, combined with BUSINESS_GROUP_ID).
• UOM — The unit of measure (for example, hours or days) applied to the balance.
• CURRENCY — The currency context where the balance is monetary in nature.
• CATEGORY — A classification grouping for the balance type.
• INPUT_VALUE_ID — A reference linking the balance type to its associated input value definition.
• DATE_FROM / DATE_TO — Effective-dating bounds that determine the validity window of the balance type definition.

Standard audit and concurrency columns are also present: OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE. The distinction between the surrogate key (BALANCE_TYPE_ID) and the two composite business-key candidates is important: integrations should resolve balance types by the business keys (INTERNAL_NAME or DISPLAYED_NAME scoped to BUSINESS_GROUP_ID) rather than relying on the generated numeric identifier, which may differ across environments.

Common Use Cases and Queries

Typical uses include resolving balance amounts for reporting, validating inputs during absence or accrual processing, and building reference data extracts for downstream analytics. A common query joins balance types to their amounts to report balances per employee:

• List active balance types for a business group filtered by the effective dates: SELECT balance_type_id, displayed_name, uom, currency FROM per_bf_balance_types WHERE business_group_id = :p_bg AND TRUNC(SYSDATE) BETWEEN date_from AND NVL(date_to, TRUNC(SYSDATE));
• Join amounts to their type to produce readable output: SELECT bt.internal_name, ba.balance_amount FROM per_bf_balance_amounts ba JOIN per_bf_balance_types bt ON ba.balance_type_id = bt.balance_type_id;
• Reference-data extract for validation across environments using business keys: SELECT internal_name, displayed_name FROM per_bf_balance_types WHERE business_group_id = :p_bg ORDER BY internal_name;

Related Objects

The most significant related objects, based on the documented foreign-key relationships, are:

• PER_BF_BALANCE_AMOUNTS — References PER_BF_BALANCE_TYPES via BALANCE_TYPE_ID. This is the primary child table holding the actual balance values; it is the dominant dependent object.
• HR_ALL_ORGANIZATION_UNITS — Parent of PER_BF_BALANCE_TYPES via BUSINESS_GROUP_ID; supplies the business group definition that scopes each balance type.

Balance-type definitions are also consumed indirectly by PER absence and accrual processes and by any HR reporting layer that renders balance figures, all of which resolve the descriptive context from this table through BALANCE_TYPE_ID.