Results for “psp_enc_payroll_assignments”

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

Overview

PSP_ENC_PAYROLL_ASSIGNMENTS is a table in the PSP (Labor Distribution) product of Oracle E-Business Suite, owned by the PSP schema. As documented in ETRM for releases 12.1.1 and 12.2.2, it stores all assignments related to an encumbrance payroll. Within the Oracle EBS Labor Distribution architecture, the table acts as the association layer that links individual assignment records to a parent encumbrance payroll, allowing encumbered labor costs to be tracked and reconciled at the assignment level before they are distributed to the appropriate general ledger accounts.

The heuristic Data Vault classification derived from the foreign-key structure is satellite-leaning. In Data Vault modeling terms, this suggests that PSP_ENC_PAYROLL_ASSIGNMENTS behaves as a descriptive satellite that carries contextual attributes around a parent business entity (the encumbrance payroll recorded in PSP_ENC_PAYROLLS), rather than acting as an independent hub of business keys or a pure many-to-many link. This classification is a modeling suggestion only; the implemented structure remains a conventional relational table with a surrogate primary key and a single documented foreign key.

Key Information Stored

The documented physical schema for release 12.2.2 lists ten columns. The most significant are described below.

• ENC_PAYROLL_ASSIGNMENT_ID — Surrogate primary key, enforced by the index PSP_ENC_PAYROLL_ASSIGNMENTS_PK. This column also participates in the unique index PSP_ENC_PAYROLL_ASSIGNMENTS_U1, making it the documented business-key candidate for the row.
• ENC_PAYROLL_ID — Foreign key to PSP_ENC_PAYROLLS, identifying the parent encumbrance payroll to which the assignment belongs.
• ASSIGNMENT_ID — Reference to the assignment (person/assignment combination) associated with the encumbrance payroll.
• BUSINESS_GROUP_ID — Identifies the business group (HR security organization) under which the record is defined.
• SET_OF_BOOKS_ID — Identifies the ledger (set of books) in which the encumbrance accounting entries are held.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — Standard Oracle EBS audit columns capturing who created and last modified each row, and when.

The separation between the surrogate key and the business-key candidate is important: ENC_PAYROLL_ASSIGNMENT_ID uniquely identifies each row mechanically, while the association between ENC_PAYROLL_ID and ASSIGNMENT_ID carries the meaningful business relationship.

Common Use Cases and Queries

Typical use cases include identifying which assignments are included in a given encumbrance payroll, auditing encumbrance payroll content for a specific business group or ledger, and joining assignment detail to HR data for cost analysis. A representative query joining to the parent payroll is shown below.

• Assignments for a payroll: SELECT a.enc_payroll_assignment_id, a.assignment_id FROM psp_enc_payroll_assignments a WHERE a.enc_payroll_id = :enc_payroll_id;
• Payroll context for each assignment: SELECT a.assignment_id, p.enc_payroll_id FROM psp_enc_payroll_assignments a JOIN psp_enc_payrolls p ON p.enc_payroll_id = a.enc_payroll_id;
• Audit reporting: Query by CREATION_DATE or LAST_UPDATE_DATE to trace recently created or modified encumbrance assignment rows, filtered by BUSINESS_GROUP_ID and SET_OF_BOOKS_ID.

These patterns are commonly embedded in custom Labor Distribution reports, reconciliation extracts, and interfaces that feed downstream costing or general ledger processes.

Related Objects

The most significant related object is the parent table referenced by the documented foreign key.

• PSP_ENC_PAYROLLS — Parent table joined via PSP_ENC_PAYROLL_ASSIGNMENTS.ENC_PAYROLL_ID = PSP_ENC_PAYROLLS.ENC_PAYROLL_ID. This is the primary relationship and defines the satellite-style dependency.
• PSP_ENCUMBRANCES / PSP labor cost tables — Downstream Labor Distribution tables that consume encumbrance payroll data and depend on payroll-assignment associations.
• HR assignment entities (PER_ASSIGNMENTS) — Related through ASSIGNMENT_ID, providing assignment-level detail for reporting.
• PSP_ENC_PAYROLL_ACTIONS and related PSP encumbrance objects — Companion tables in the same module that may reference payroll and assignment context.

Because the documented metadata exposes only one foreign key, integration and reporting logic should be anchored on the PSP_ENC_PAYROLLS relationship and on the ASSIGNMENT_ID, BUSINESS_GROUP_ID, and SET_OF_BOOKS_ID columns.