Search Results pay_balance_validation_pk

Overview

HR.PAY_BALANCE_VALIDATION is a transaction data table within the Oracle E-Business Suite HR schema, registered under FND Design Data as PAY.PAY_BALANCE_VALIDATION. It holds information regarding the validity of balances, specifically the status of the Run Balance population process and the date from which run balances were loaded for a given defined balance. The table is stored in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, which is consistent with its role as an operational, frequently updated transaction table rather than a reference or setup table.

Under the heuristic Data Vault classification mined from its foreign key structure, PAY_BALANCE_VALIDATION is modelled as a standalone object. This classification reflects the fact that the table carries its own surrogate primary key (BALANCE_VALIDATION_ID) and does not serve as a dependent child of an established hub or link in the documented dependency graph; the ETRM metadata records that the table does not reference any database object directly through enforced foreign keys, and is itself referenced only by the shadow package PAY_BALANCE_VALIDATION#. Practically, it functions as a validation-status satellite for balance definitions, tracking the lifecycle state of run-balance loading per balance and business group.

Key Information Stored

The table contains five documented columns. The most important are described below, distinguishing the generated surrogate key from the documented business-key candidates.

• BALANCE_VALIDATION_ID (NUMBER) — The system-generated primary key column, enforced by the unique index PAY_BALANCE_VALIDATION_PK. It uniquely identifies each validation record.
• DEFINED_BALANCE_ID (NUMBER) — Foreign key to PAY_DEFINED_BALANCES, identifying the balance whose validation status is being recorded. Combined with BUSINESS_GROUP_ID, it forms the unique business key.
• BUSINESS_GROUP_ID (NUMBER, length 15) — Foreign key to HR_ORGANIZATION_UNITS, scoping the validation record to a specific business group and enabling multi-org separation of balance data.
• RUN_BALANCE_STATUS (VARCHAR2) — The status of the Run Balance population, indicating whether run balances have been loaded, are pending, or have failed validation for the associated balance.
• BALANCE_LOAD_DATE (DATE) — The date from which run balances were loaded for this balance, providing the effective start point for the loaded run-balance data.

The unique index PAY_BALANCE_VALIDATION_UK1 (DEFINED_BALANCE_ID, BUSINESS_GROUP_ID) is the documented business-key candidate, guaranteeing at most one validation record per defined balance within a business group. This pairing is the natural identifier used by application logic to look up or upsert validation status.

Common Use Cases and Queries

Typical usage centres on verifying whether run balances have been populated for a defined balance and on determining the effective load date. A standard lookup retrieves the validation status and load date for a specific balance and business group:

• SELECT RUN_BALANCE_STATUS, BALANCE_LOAD_DATE FROM HR.PAY_BALANCE_VALIDATION WHERE DEFINED_BALANCE_ID = :defined_balance_id AND BUSINESS_GROUP_ID = :business_group_id;
• Joining to PAY_DEFINED_BALANCES on DEFINED_BALANCE_ID to list balances that have not yet been loaded, filtered on RUN_BALANCE_STATUS, supports payroll reconciliation and balance population monitoring.
• Reporting on BALANCE_LOAD_DATE ranges aids in tracking when run-balance data became effective across a business group.

Because the unique index on (DEFINED_BALANCE_ID, BUSINESS_GROUP_ID) supports efficient single-row access, application and concurrent-process logic can rely on it when validating or updating balance population status.

Related Objects

• PAY_DEFINED_BALANCES — Referenced through DEFINED_BALANCE_ID; defines the balances whose validation status is tracked.
• HR_ORGANIZATION_UNITS — Referenced through BUSINESS_GROUP_ID; provides the business group scoping of each validation record.
• PAY_BALANCE_VALIDATION# — The generated shadow package that references this table.
• PAY_BALANCE_VALIDATION_PK — Unique index on BALANCE_VALIDATION_ID.
• PAY_BALANCE_VALIDATION_UK1 — Unique index on (DEFINED_BALANCE_ID, BUSINESS_GROUP_ID), the documented business key.