Search Results psp_pre_gen_dist_lines_history




Overview
Explore in AI Chat

Overview

The PSP_PRE_GEN_DIST_LINES_HISTORY table is a core data object within the Oracle E-Business Suite (EBS) Labor Distribution module (PSP). It functions as a historical archive for pre-generated labor distribution lines. Its primary role is to store a permanent record of distribution lines that have been successfully processed and transferred from the Labor Distribution module to the downstream financial systems, specifically General Ledger (GL) and Grants Accounting (PA). This table is critical for maintaining a complete audit trail of processed labor costs, ensuring data integrity, and supporting reconciliation processes between the originating payroll data and the final accounting entries.

Key Information Stored

The table's structure is designed to capture the complete accounting and project attributes of a finalized distribution line. The primary key is the PRE_GEN_DIST_LINE_ID, which uniquely identifies each historical record. As indicated by its extensive foreign key relationships, the table stores a comprehensive set of reference identifiers. Key stored data points include the link to the original source record in PSP_DISTRIBUTION_INTERFACE (DISTRIBUTION_INTERFACE_ID), the payroll control (PAYROLL_CONTROL_ID), and the accounting period (TIME_PERIOD_ID). It holds the critical accounting flexfield combination (GL_CODE_COMBINATION_ID) and the Set of Books (SET_OF_BOOKS_ID) for the entry. For project-related distributions, it stores PROJECT_ID, TASK_ID, EXPENDITURE_TYPE, and EXPENDITURE_ORGANIZATION_ID. The table also references the associated summary line (SUMMARY_LINE_ID) and any suspense account (SUSPENSE_ORG_ACCOUNT_ID) used during the distribution process.

Common Use Cases and Queries

This table is central to audit, reconciliation, and reporting activities. A common use case is tracing the history of labor charges posted to a specific project or general ledger account. Analysts query this table to verify that payroll batches were fully transferred to the GL and to investigate discrepancies. For example, to retrieve all historical distribution lines for a specific project within a date range, a query would join to PER_TIME_PERIODS. Another critical pattern is reconciling the total labor cost transferred to GL for a payroll run by summarizing amounts grouped by PAYROLL_CONTROL_ID. Since this table stores successfully transferred data, it is often used as the source for certified historical labor reports required for grant billing and compliance.

Related Objects

PSP_PRE_GEN_DIST_LINES_HISTORY has defined foreign key relationships with numerous fundamental EBS tables, as documented in the ETRM metadata. These relationships are essential for joining to master and transactional data in queries: