Results for “pre_payment_id”

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

Overview

PAY_CONTRIBUTING_PAYMENTS is a payroll module table owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It acts as a cross-reference or association table that links contributing prepayment records to the payroll action and assignment action context in which they were created. In payroll processing, contributing prepayments represent subordinate payment components that aggregate into a consolidated prepayment handled by the PrePayments process. This table captures that parent-child relationship between a target prepayment and the contributing prepayments that roll into it, allowing the payroll engine to reconcile, audit, and reverse these amounts correctly.

The ETRM metadata classifies this object heuristically as a standalone structure from a Data Vault perspective. Because it holds only linking identifiers without descriptive attributes, the same data could reasonably be modeled as a link table connecting payroll actions, assignment actions, and prepayments. This classification is offered as a modeling suggestion rather than a documented constraint.

Key Information Stored

The documented physical schema for 12.2.2 contains four columns, all of which are identifiers rather than descriptive attributes:

• PAYROLL_ACTION_ID — Foreign key to PAY_PAYROLL_ACTIONS, identifying the payroll action under which the contributing payment was generated.
• ASSIGNMENT_ACTION_ID — Foreign key to PAY_ASSIGNMENT_ACTIONS, identifying the assignment-level action that produced the contribution.
• PRE_PAYMENT_ID — Foreign key to PAY_PRE_PAYMENTS, pointing to the parent (target) prepayment that receives the contribution.
• CONTRIBUTING_PRE_PAYMENT_ID — The business-key candidate, uniquely indexed by PAY_CONTRIBUTING_PAYMENTS_N3, identifying the prepayment that contributes into the parent prepayment.

No dedicated surrogate primary key column is documented in the ETRM metadata; the unique index on CONTRIBUTING_PRE_PAYMENT_ID serves as the primary business-key candidate. The table functions purely as a junction between the three referenced entities.

Common Use Cases and Queries

The primary use case is reconciliation of prepayment aggregation during payroll runs. Analysts and payroll administrators query this table to determine which contributing prepayments were folded into a given parent prepayment, and to trace the associated payroll and assignment actions for audit or reversal purposes. A typical join pattern follows the documented foreign keys:

• Join PAY_CONTRIBUTING_PAYMENTS.PRE_PAYMENT_ID to PAY_PRE_PAYMENTS.PRE_PAYMENT_ID to retrieve parent prepayment details.
• Join CONTRIBUTING_PRE_PAYMENT_ID back to PAY_PRE_PAYMENTS to resolve the contributing prepayment’s own attributes and amounts.
• Join PAYROLL_ACTION_ID to PAY_PAYROLL_ACTIONS and ASSIGNMENT_ACTION_ID to PAY_ASSIGNMENT_ACTIONS to reconstruct the processing context.

Representative reporting scenarios include identifying all contributors for a specific prepayment, auditing which assignment actions generated contributions within a payroll period, and tracing prepayment lineage when investigating overpayments or reversals. Because the table is narrow and key-based, queries are typically driven by PRE_PAYMENT_ID or CONTRIBUTING_PRE_PAYMENT_ID as high-selectivity predicates.

Related Objects

The following objects are directly related through the documented foreign key and unique index relationships:

• PAY_PAYROLL_ACTIONS — referenced via PAYROLL_ACTION_ID; provides the payroll action context.
• PAY_ASSIGNMENT_ACTIONS — referenced via ASSIGNMENT_ACTION_ID; provides the assignment action detail.
• PAY_PRE_PAYMENTS — referenced via PRE_PAYMENT_ID (parent) and CONTRIBUTING_PRE_PAYMENT_ID (contributor); the central entity this table serves.
• PAY_ASSIGNMENT_ACTION_CONTEXTS and PAY_RUN_RESULTS — commonly joined through the assignment action to obtain processed amounts and balances.
• PAY_PAYROLL_RUNS — joined via PAY_PAYROLL_ACTIONS to group contributions by payroll run.

These relationships make PAY_CONTRIBUTING_PAYMENTS an effective audit trail for prepayment aggregation and reversal analysis within the Oracle Payroll module.