Results for “pay_adjust_batch_groups_pk”

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

Overview

HR.PAY_ADJUST_BATCH_GROUPS is a transactional table in the Oracle E-Business Suite Human Resources (HR) schema that stores batch group information used during balance upload processing. Within the Oracle Payroll architecture, this table serves as the container-level record that organizes balance adjustments into logical groupings prior to consolidation, prepayment, and final balance transfer. Each row represents a discrete batch group, tied to a parent balance batch header and, through a foreign key, to the adjustment lines that belong to it. The table is registered under FND Design Data as PAY.PAY_ADJUST_BATCH_GROUPS and resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, indicating its role as an active transaction data store rather than a setup or reference table.

From a Data Vault modeling perspective, the heuristic classification of this object is satellite-leaning. This classification is derived from the foreign key structure: the table hangs off the parent PAY_BALANCE_BATCH_HEADERS hub via BATCH_ID and carries descriptive, status-oriented attributes such as BATCH_GROUP_STATUS, EFFECTIVE_DATE, and PREPAY_FLAG. This suggests the table functions primarily as a descriptive satellite attached to a central batch hub, though it also acts as the anchoring point for dependent line-level detail. It does not behave as an independent hub.

Key Information Stored

The table contains seven documented columns. The surrogate primary key is BATCH_GROUP_ID, a NUMBER column enforced by the unique index PAY_ADJUST_BATCH_GROUPS_PK, which is the object the searcher referenced. This is the sole unique index and therefore the only business-key candidate documented; no alternate unique index exists, so BATCH_GROUP_ID serves both as technical surrogate and as the effective business key.

• BATCH_GROUP_ID — Surrogate primary key; uniquely identifies each batch group and is the anchor referenced by dependent adjustment lines.
• BATCH_ID — Foreign key to PAY_BALANCE_BATCH_HEADERS; links the group to its parent balance batch.
• BATCH_GROUP_STATUS — VARCHAR2(30) status of the batch group, tracking its lifecycle state during balance upload.
• CONSOLIDATION_SET_ID — Foreign key to PAY_CONSOLIDATION_SETS; identifies the consolidation set applied to the group.
• PAYROLL_ID — Payroll identifier, scoping the group to a specific payroll.
• EFFECTIVE_DATE — Date on which the batch group becomes effective.
• PREPAY_FLAG — VARCHAR2(30) flag indicating where the prepayment process is run.

Together these attributes drive the balance upload and prepayment workflow, connecting payroll, consolidation, and batch header context.

Common Use Cases and Queries

Typical usage centers on monitoring balance upload batches, auditing group status, and joining group-level context to line-level detail. A common pattern retrieves all batch groups for a given payroll and consolidation set:

• Filtering groups by BATCH_GROUP_STATUS to find incomplete or failed uploads.
• Joining to PAY_BALANCE_BATCH_HEADERS on BATCH_ID to reconcile group counts against their parent batch.
• Joining to PAY_ADJUST_BATCH_LINES on BATCH_GROUP_ID to total adjustment amounts per group.
• Filtering by EFFECTIVE_DATE to segment processing by payroll period.
• Using PREPAY_FLAG to isolate groups where prepayment has been invoked.

Representative SQL: SELECT g.BATCH_GROUP_ID, g.BATCH_GROUP_STATUS, g.PAYROLL_ID, g.EFFECTIVE_DATE FROM HR.PAY_ADJUST_BATCH_GROUPS g WHERE g.BATCH_ID = :batch_id;

Related Objects

The most significant related objects, derived from documented referential relationships, include:

• PAY_BALANCE_BATCH_HEADERS — Parent batch header; joined via BATCH_ID.
• PAY_ADJUST_BATCH_LINES — Child lines; joined via BATCH_GROUP_ID (lines reference this table).
• PAY_CONSOLIDATION_SETS — Referenced via CONSOLIDATION_SET_ID.
• PAY_ADJUST_BATCH_GROUPS_PK — Unique index on BATCH_GROUP_ID in APPS_TS_TX_IDX.
• PAY_ADJUST_BATCH_GROUPS — Public synonym exposing the table.

This object is referenced by the APPS and PUBLIC synonyms, ensuring broad accessibility across payroll balance upload processing.