Search Results psp_payroll_sub_lines




Overview
Explore in AI Chat

Overview

The PSP_PAYROLL_SUB_LINES table is a core data object within the Oracle E-Business Suite (EBS) Labor Distribution module (PSP). Its primary function is to store the detailed breakdown of a single payroll line when the associated earnings or cost must be allocated across multiple accounting dimensions. This occurs when a payroll transaction, such as an employee's salary payment, is distributed to more than one cost center, project, task, or other funding source. The table acts as a child entity to PSP_PAYROLL_LINES, enabling a one-to-many relationship where a single payroll line can spawn multiple sub-lines, each representing a distinct segment of the total amount for specific accounting and reporting purposes.

Key Information Stored

Each record in PSP_PAYROLL_SUB_LINES represents one segment of a split payroll amount. The table's structure is designed to capture both the financial allocation and its organizational context. The primary key is PAYROLL_SUB_LINE_ID, a unique system-generated identifier. A critical foreign key column is PAYROLL_LINE_ID, which links the sub-line back to its parent record in PSP_PAYROLL_LINES. Key descriptive columns include ORGANIZATION_ID and JOB_ID, which tie the cost allocation to a specific business unit and job role, respectively. Other essential columns typically include the allocated AMOUNT or QUANTITY, and accounting flexfield segment values (such as CODE_COMBINATION_ID) that define the exact general ledger account for the distribution.

Common Use Cases and Queries

The primary use case is tracing and reporting on how payroll costs are distributed. This is vital for project accounting, grant management, and internal chargebacks. Common queries involve joining to parent and related tables to produce detailed labor distribution reports. For instance, to analyze all sub-line distributions for a specific payroll run, one might use a query pattern such as:

  • SELECT prl.payroll_run_id, psl.* FROM psp_payroll_sub_lines psl JOIN psp_payroll_lines prl ON psl.payroll_line_id = prl.payroll_line_id WHERE prl.payroll_run_id = &RUN_ID;

Another frequent scenario is reconciling the sum of sub-line amounts back to the original payroll line total to ensure data integrity. Auditors and functional consultants often query this table to validate that labor costs have been correctly assigned according to established distribution schedules.

Related Objects

PSP_PAYROLL_SUB_LINES sits at the center of several key relationships within the Labor Distribution schema, as documented by its foreign key constraints:

These relationships illustrate that the sub-line record is the definitive source for creating and tracking subsequent distribution lines and associated adjustment reasons.