Search Results psp_enc_payrolls




Overview
Explore in AI Chat

Overview

PSP_ENC_PAYROLLS is a table in the PSP (Labor Distribution) product schema of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. Per the ETRM metadata, its documented purpose is to store encumbrance-related payrolls. In the labor distribution flow, payroll costing results must be reflected against encumbrances held on awards, grants, and projects so that committed and actual balances remain consistent. PSP_ENC_PAYROLLS acts as the payroll-level anchor for that process, holding one row per encumbrance payroll and providing the parent key consumed by encumbrance line and assignment-level detail tables.

From a dimensional modeling perspective, the relationship structure suggests this object behaves as a hub-leaning entity. Its defining identifier (ENC_PAYROLL_ID) is referenced as a foreign key by two downstream tables, while it carries reference columns such as PAYROLL_ID, BUSINESS_GROUP_ID, and SET_OF_BOOKS_ID. This pattern is consistent with a hub that links an encumbrance payroll to its associated payroll, business group, and ledger context.

Key Information Stored

The table is documented with 26 columns. The most significant are:

  • ENC_PAYROLL_ID — the primary key and the surrogate identifier. It is enforced by the unique index PSP_ENC_PAYROLLS_U1 and is the column referenced by PSP_ENC_PAYROLL_ASSIGNMENTS.
  • PAYROLL_ID — the business-key candidate declared as the primary key constraint PEL_UK, linking the encumbrance payroll back to the source payroll. It is the column referenced by PSP_ENC_LINES.
  • BUSINESS_GROUP_ID — the HR business group owning the payroll, governing security and operating-unit context.
  • SET_OF_BOOKS_ID — the ledger in which the encumbrance payroll is accounted, essential for GL reconciliation.
  • INC_EXC_FLAG — indicates whether the payroll is included in or excluded from encumbrance processing.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard Oracle EBS descriptive flexfield (DFF) columns, enabling client-specific extensions.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — the WHO audit columns present on nearly all Oracle EBS transactional tables.

The distinction between the surrogate key (ENC_PAYROLL_ID) and the business-key candidate (PAYROLL_ID, via PEL_UK) is important for join design: assignment-level detail resolves through ENC_PAYROLL_ID, while line-level detail resolves through PAYROLL_ID.

Common Use Cases and Queries

Typical scenarios include reconciling encumbrance payrolls to ledger balances, auditing which payrolls were included or excluded from encumbrance processing, and reporting encumbrance detail by business group or set of books.

A representative query joining header to line detail:

  • SELECT p.enc_payroll_id, p.payroll_id, l.line_number, l.amount FROM psp.psp_enc_payrolls p, psp.psp_enc_lines l WHERE p.payroll_id = l.payroll_id AND p.set_of_books_id = :ledger_id;

A second pattern joins header to assignment-level detail through the surrogate key:

  • SELECT p.enc_payroll_id, a.assignment_id FROM psp.psp_enc_payrolls p, psp.psp_enc_payroll_assignments a WHERE p.enc_payroll_id = a.enc_payroll_id;

Filtering on INC_EXC_FLAG supports inclusion/exclusion reporting, and the ATTRIBUTE columns support client-specific DFF-based reporting.

Related Objects

The FK and PK metadata identifies the principal related objects:

  • PSP_ENC_LINES — child table joined via PSP_ENC_LINES.PAYROLL_ID = PSP_ENC_PAYROLLS.PAYROLL_ID, holding line-level encumbrance detail.
  • PSP_ENC_PAYROLL_ASSIGNMENTS — child table joined via PSP_ENC_PAYROLL_ASSIGNMENTS.ENC_PAYROLL_ID = PSP_ENC_PAYROLLS.ENC_PAYROLL_ID, holding assignment-level encumbrance payroll detail.

Beyond these documented relationships, related labor distribution and payroll objects include the source payroll definitions, the GL encumbrance balance tables reconciled through SET_OF_BOOKS_ID, and the standard Oracle EBS descriptive flexfield views that expose the ATTRIBUTE columns. Together these objects form the encumbrance payroll chain within PSP.