Results for “per_bf_balance_amounts”

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

Overview

PER_BF_BALANCE_AMOUNTS is a Human Resources (PER) module table in the HR schema of Oracle E-Business Suite 12.1.1 and 12.2.2. It holds assignment-level run amount and summary values for backfeed balances, organized by payroll processing period. Backfeed processing captures balance adjustments originating from external payroll systems or legacy sources and reconciles them against Oracle Payroll assignments, and this table persists the resulting monetary figures at the individual assignment and balance type level.

The table stores period-to-date, month-to-date, quarter-to-date, fiscal year-to-date, and year-to-date accumulations alongside the current run amount, enabling downstream payroll calculations, retroactive processing, and reporting to reflect balances that were supplied through backfeed rather than calculated natively. It forms part of the backfeed processing infrastructure, which also encompasses processed assignment headers and backfeed balance type definitions.

From a heuristic Data Vault modeling perspective, the mined foreign key structure suggests classification as a link table. The presence of multiple foreign keys referencing independent parent entities — business group, balance type, and processed assignment — indicates that the table's primary function is to record relationships and associated measures between those dimensions rather than to serve as a standalone descriptive hub or satellite.

Key Information Stored

The table contains 47 documented columns, of which the most functionally significant are:

• BALANCE_AMOUNT_ID — the surrogate primary key defined by the PER_BF_BALANCE_AMOUNTS_PK unique index. This identifier uniquely distinguishes each row.
• PROCESSED_ASSIGNMENT_ID and BALANCE_TYPE_ID — together forming the business-key candidate PER_BF_BALANCE_AMOUNTS_UK1. The combination guarantees one amount row per assignment and balance type, which is the natural business grain of the table.
• BUSINESS_GROUP_ID — the operating business group (organization) that owns the record, establishing multi-tenant partitioning across HR data.
• RUN_AMOUNT — the amount attributed to the current payroll run for the referenced assignment and balance type.
• PTD_AMOUNT, MTD_AMOUNT, QTD_AMOUNT — period-to-date, month-to-date, and quarter-to-date accumulations.
• FYTD_AMOUNT and YTD_AMOUNT — fiscal year-to-date and year-to-date totals.
• OBJECT_VERSION_NUMBER — an optimistic locking token used by the Oracle Applications Framework to detect concurrent updates.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — the standard WHO audit columns recording who created and last modified each row.
• BBA_ATTRIBUTE_CATEGORY and BBA_ATTRIBUTE1 through BBA_ATTRIBUTE30 — thirty flexible descriptive columns plus a category descriptor, provided for customer-specific extensions and localization requirements.

Common Use Cases and Queries

Typical usage centers on reconciliation, payroll verification, and period-based balance reporting. A common pattern retrieves all backfeed balances for a specific assignment together with their descriptive balance type names:

SELECT b.balance_amount_id, t.balance_name, b.run_amount, b.ytd_amount, b.ptd_amount
FROM per_bf_balance_amounts b, per_bf_balance_types t
WHERE b.balance_type_id = t.balance_type_id
AND b.processed_assignment_id = :assignment_id;

Period reconciliation queries aggregate run amounts by business group and balance type to compare backfeed totals against expected payroll results:

SELECT balance_type_id, SUM(run_amount), SUM(ytd_amount)
FROM per_bf_balance_amounts
WHERE business_group_id = :bg_id
GROUP BY balance_type_id;

Concurrency investigation relies on OBJECT_VERSION_NUMBER, while audit enquiries filter by CREATION_DATE or LAST_UPDATE_DATE to trace adjustments within a processing window. Because flexible attributes exist, extract scripts often select the BBA_ATTRIBUTE columns where localizations or third-party integrations populate additional context.

Related Objects

The following tables participate in documented foreign key relationships with PER_BF_BALANCE_AMOUNTS:

• PER_BF_PROCESSED_ASSIGNMENTS — joined via PROCESSED_ASSIGNMENT_ID; supplies the processed assignment header that groups backfeed amounts by assignment and processing period.
• PER_BF_BALANCE_TYPES — joined via BALANCE_TYPE_ID; provides the definition and naming of each backfeed balance.
• HR_ALL_ORGANIZATION_UNITS — joined via BUSINESS_GROUP_ID; identifies the business group owning the balance amount record.

In practice, these parent tables are joined to produce meaningful reports, since the amount table itself stores only identifiers and numeric measures. The two unique indexes — PER_BF_BALANCE_AMOUNTS_PK and PER_BF_BALANCE_AMOUNTS_UK1 — enforce integrity and support efficient lookups by surrogate key or by the assignment-and-balance-type combination.