Search Results psp_enc_summary_lines_arch




Overview
Explore in AI Chat

Overview

PSP_ENC_SUMMARY_LINES_ARCH is a table in the PSP (Labor Distribution) product schema within Oracle E-Business Suite. It stores archived summary lines derived from summarized encumbrance lines, preserving the historical record of encumbrance activity after the operational data has been condensed or purged from the live transaction tables. The table carries 73 documented columns in the 12.2.2 schema, with a single primary key constraint, PSP_ENC_SUMMARY_LINES_ARCH_PK, defined on ENC_SUMMARY_LINE_ID.

In heuristic Data Vault terms, the table is classified as standalone, meaning it exhibits no incoming relationships that would make it a pure hub, link, or satellite under strict modeling rules. Practically, it functions as a satellite-style historical store: each row is keyed by a surrogate identifier and carries descriptive and foreign-key attributes describing one summarized encumbrance line at a point in time. The archiving role is significant because it enables retroactive encumbrance and labor distribution reconciliation without retaining the full volume of active summary data.

Key Information Stored

The primary key of the table is the surrogate key ENC_SUMMARY_LINE_ID, which is also exposed as the unique index PSP_ENC_SUMMARY_LINES_ARCH_U1 — this means the column acts simultaneously as the row identifier and the documented business-key candidate. Other important columns include:

Common Use Cases and Queries

Typical uses include reconciliation of encumbrance balances after period close, audit trails for sponsored award reporting, and trend analysis of summarized labor encumbrances. A common query pattern joins the archive to the expenditure tables to reconstruct the full life of an encumbrance line:

  • Retrieve all archived summary lines for a given award and period: SELECT * FROM psp_enc_summary_lines_arch WHERE award_id = :award AND time_period_id = :period;
  • Reconcile encumbrance control totals by joining on ENC_CONTROL_ID: SELECT a.enc_summary_line_id, a.summary_amount, c.enc_control_id FROM psp_enc_summary_lines_arch a, psp_enc_controls c WHERE a.enc_control_id = c.enc_control_id;
  • Identify lines rejected during posting using REJECT_REASON_CODE and STATUS_CODE filters.
  • Link archived lines to payroll actions for retroactive payroll encumbrance review via PAYROLL_ACTION_ID.
  • Report on debit/credit distribution using DR_CR_FLAG and GL_CODE_COMBINATION_ID for GL tie-out during period-end close.

Related Objects

The table’s relationships are defined primarily through its foreign keys:

  • PER_TIME_PERIODS — joined on TIME_PERIOD_ID to resolve accounting periods.
  • IGF_AW_AWARD_ALL — joined on AWARD_ID for award detail.
  • PSP_ENC_CONTROLS — joined on ENC_CONTROL_ID, the parent encumbrance control record.
  • PA_EXPENDITURES_ALL — joined on EXPENDITURE_ID for the related expenditure transaction.
  • PA_EXPENDITURE_ITEMS_ALL — joined on EXPENDITURE_ITEM_ID for expenditure line detail.
  • PAY_PAYROLL_ACTIONS — joined on PAYROLL_ACTION_ID for the originating payroll action.

Additional dependent objects include the live summary table PSP_ENC_SUMMARY_LINES, from which archived rows are derived, and PSP_ENC_SUMMARY_HEADERS, which provides header-level context for the summary lines. These relationships support consistent drill-down and reconciliation between active and archived encumbrance data.