Search Results psp_enc_lines_arch




Overview
Explore in AI Chat

Overview

PSP_ENC_LINES_ARCH is an archived detail table owned by the PSP schema within the Oracle EBS Labor Distribution (PSP) product family. It stores historical Encumbrance Lines that have been moved out of the active ETRM encumbrance processing tables as part of the labor encumbrance archiving and purge cycle. In Oracle EBS 12.1.1 and 12.2.2, Labor Distribution generates encumbrances against labor schedules and payroll actions to reserve funds for anticipated labor costs. As these encumbrance records age and are no longer required for active balance maintenance, they are relocated into PSP_ENC_LINES_ARCH, preserving the audit trail without burdening the primary transaction tables.

The table is registered in ETRM as VALID with a documented physical schema of 58 columns. The heuristic Data Vault classification mined from the foreign key structure is standalone, meaning no single parent dominates its relationships; from a modeling perspective the structure behaves as a multi-parent link with satellite-like descriptive attributes. The surrogate primary key is enforced through PSP_ENC_LINES_ARCH_PK on ENC_LINE_ID.

Key Information Stored

The table captures the full encumbrance line context. The most significant columns include:

Original dimension columns such as ORIG_PROJECT_ID, ORIG_TASK_ID, ORIG_AWARD_ID, ORIG_EXPENDITURE_ORG_ID, and ORIG_EXPENDITURE_TYPE allow reconstruction of the pre-adjustment state, supporting reconciliation across archive boundaries.

Common Use Cases and Queries

Typical usage centers on historical and audit reporting of labor encumbrances. A common query reconstructs encumbrance history for a person or award by joining archived lines to active controls:

  • Audit reconciliation — compare archived lines against the active encumbrance control to confirm complete transfer: SELECT a.enc_line_id, a.encumbrance_amount, a.status_code FROM psp_enc_lines_arch a WHERE a.enc_control_id = :control_id;
  • Award funding history — aggregate archived encumbrances by award and period: SELECT award_id, SUM(encumbrance_amount) FROM psp_enc_lines_arch GROUP BY award_id;
  • Payroll impact analysis — trace encumbrances back to payroll actions using PAYROLL_ACTION_ID and PAYROLL_ID.
  • Period-based reporting — filter on ENCUMBRANCE_DATE or TIME_PERIOD_ID to report encumbrances for a closed accounting period.
  • Change tracking — identify reclassified lines where ORIG_GL_CODE_COMBINATION_ID differs from GL_CODE_COMBINATION_ID.

Because the table can grow large, queries should always be filtered by ENC_CONTROL_ID, AWARD_ID, or a date range rather than scanned in full.

Related Objects

The documented foreign keys connect PSP_ENC_LINES_ARCH to the following significant objects, with join columns indicated:

These relationships support the reconstruction of a complete labor encumbrance trail from payroll through award and general ledger impact, which is essential for grant compliance and period-close reconciliation in EBS Financials and Projects.