Search Results psp_distribution_lines_history




Overview
Explore in AI Chat

Overview

The PSP_DISTRIBUTION_LINES_HISTORY table is a core data repository within the Oracle E-Business Suite (EBS) Labor Distribution module (PSP). Its primary role is to serve as a staging and historical record for payroll cost distribution details. Specifically, it stores distributed payroll sublines—originating from both Oracle Payroll and non-Oracle payroll systems—that have been processed by the Labor Distribution engine but have not yet been posted to the General Ledger (GL) or Grants Accounting modules. This table acts as a critical intermediary, holding the detailed accounting breakdown of labor costs by project, task, award, and other segments until the final accounting transfer is completed, ensuring a clear audit trail of distributed amounts prior to their financial system integration.

Key Information Stored

The table's structure is defined by its primary and foreign keys, which link it to major entities across HR, Payroll, and Projects. The primary key is DISTRIBUTION_LINE_ID, which uniquely identifies each historical distribution record. Key foreign key columns and the data they hold include: PAYROLL_SUB_LINE_ID, linking to the source payroll detail in PSP_PAYROLL_SUB_LINES; SUMMARY_LINE_ID and SCHEDULE_LINE_ID, connecting to aggregated and scheduled distribution data in PSP_SUMMARY_LINES and PSP_SCHEDULE_LINES; ELEMENT_ACCOUNT_ID, referencing the earning type and account mapping in PSP_ELEMENT_TYPE_ACCOUNTS; and EFFORT_REPORT_ID, linking to certified effort data in PSP_EFFORT_REPORTS. Other significant columns likely include BUSINESS_GROUP_ID for organizational context, SET_OF_BOOKS_ID for the target ledger, and VERSION_NUM for tracking changes to distribution records over time.

Common Use Cases and Queries

A primary use case is auditing and reconciling labor costs before they are transferred to the General Ledger. Analysts query this table to verify that payroll amounts have been correctly distributed according to established schedules and effort reports. Common reporting needs include identifying all undistributed payroll sublines for a specific period or project, and tracing the distribution history of a particular payroll run. Sample query patterns often involve joins to related payroll and project tables:

  • Identifying distributed lines pending GL transfer: SELECT * FROM psp_distribution_lines_history dlh WHERE NOT EXISTS (SELECT 1 FROM gl_interface gi WHERE gi.reference_id = dlh.distribution_line_id);
  • Summarizing distributed amounts by project and task: SELECT project_id, task_id, SUM(amount) FROM psp_distribution_lines_history dlh JOIN psp_schedule_lines sl ON dlh.schedule_line_id = sl.schedule_line_id GROUP BY project_id, task_id;

Related Objects

PSP_DISTRIBUTION_LINES_HISTORY is centrally connected to numerous key tables in the Labor Distribution and HRMS schemas. As per the provided metadata, its main foreign key relationships are with: PSP_PAYROLL_SUB_LINES (the source payroll data), PSP_SUMMARY_LINES and PSP_SCHEDULE_LINES (for distribution rules and schedules), PSP_ELEMENT_TYPE_ACCOUNTS (for account derivation), and PSP_EFFORT_REPORTS (for effort certification linkage). It also references foundational setup tables like HR_ALL_ORGANIZATION_UNITS (BUSINESS_GROUP_ID) and GL_SETS_OF_BOOKS (SET_OF_BOOKS_ID). This web of relationships underscores its role as the nexus point where payroll details, distribution rules, and project accounting data converge before final posting.