Search Results psp_pre_gen_dist_lines_arch_pk

Overview

The PSP_PRE_GEN_DIST_LINES_ARCH table is a core data object within the Oracle E-Business Suite (EBS) Labor Distribution module (PSP). It functions as a historical archive, specifically storing pre-generated labor distribution lines that have been moved from the active processing tables into the system's history. This archival mechanism is critical for maintaining the performance and manageability of the active labor distribution engine by segregating historical transaction data, while preserving a complete audit trail for compliance, reporting, and reconciliation purposes. Its role is integral to the lifecycle management of distribution lines within the PSP module.

Key Information Stored

As an archive table, its structure mirrors that of its corresponding active table, capturing the full state of a distribution line at the point of archival. The primary identifier and sole documented key column is PRE_GEN_DIST_LINE_ID, which uniquely identifies each archived line record. While the provided ETRM excerpt does not list additional columns, typical data stored in such an archive includes the original distribution line details such as project and task assignments, expenditure types, percentages or amounts, employee information, source batch identifiers, and the effective dates for the distribution. Crucially, it also captures system-generated metadata like the original creation date and the archival date, providing temporal context for the historical record.

Common Use Cases and Queries

The primary use case for this table is historical reporting and auditing. Financial controllers and project accountants query this archive to analyze labor cost distributions over past periods, investigate historical adjustments, or support internal and external audits. A common query pattern involves filtering by date ranges or source batch identifiers to reconstruct the distribution landscape for a specific payroll period. For example, a query to find all archived lines for a specific employee or project would join on the PRE_GEN_DIST_LINE_ID or other relevant business key columns to related history tables. Another critical use case is data reconciliation, where totals from active and archived tables are summed to verify completeness against source payroll systems.

Related Objects

The table's relationships are defined by its primary key. The documented primary key constraint, PSP_PRE_GEN_DIST_LINES_ARCH_PK, is built solely on the PRE_GEN_DIST_LINE_ID column. This indicates that this identifier is the fundamental link to other history or transaction tables within the Labor Distribution schema. While specific foreign key relationships are not detailed in the provided metadata, this table is inherently related to the active pre-generation tables (such as PSP_PRE_GEN_DIST_LINES) from which records are sourced. It will also have logical relationships with other PSP history tables (e.g., for earnings, disbursements) that share the same PRE_GEN_DIST_LINE_ID to form a complete historical record set. Queries joining on PRE_GEN_DIST_LINE_ID are essential for comprehensive historical reporting.