Search Results psp_sub_line_reasons




Overview
Explore in AI Chat

Overview

The PSP_SUB_LINE_REASONS table is a core data structure within the Oracle E-Business Suite (EBS) Labor Distribution module (PSP). Its primary function is to provide an audit trail and business logic context for the process of creating detailed payroll sublines from summarized payroll lines. This process is central to labor costing and distribution, where a single payroll line representing an employee's gross pay must be allocated across multiple projects, tasks, or accounts. The table stores the specific reason codes that justify each allocation, linking a business rationale to the financial distribution. This ensures compliance, supports managerial reporting, and enables detailed analysis of labor costs against funded projects or internal activities.

Key Information Stored

The table is designed as a child entity to the PSP_PAYROLL_SUB_LINES table, with its structure focused on the reason for a subline's creation. Based on the provided metadata, the two critical columns are part of a composite primary key. The PAYROLL_SUB_LINE_ID column is a foreign key that uniquely links each reason record to its parent payroll subline in the PSP_PAYROLL_SUB_LINES table. The REASON_CODE column stores the alphanumeric code that categorizes the business justification for the subline allocation. Typical reason codes might indicate allocations based on timesheet hours, predefined labor schedules, manual adjustments, or cost transfer corrections. The composite primary key (PSP_SUB_LINE_REASONS_PK) ensures that a single payroll subline can have multiple, distinct reason codes associated with it if necessary.

Common Use Cases and Queries

The primary use case is auditing and reporting on the rationale behind labor cost distributions. For instance, an auditor may need to verify all sublines created for a specific project that used a "Manual Adjustment" reason code. A common reporting query would join this table to the subline and payroll line tables to produce a detailed cost report with justification.

  • Sample Query: To list all sublines with their associated reasons for a given payroll run:
    SELECT psl.payroll_sub_line_id, psl.amount, pslr.reason_code
    FROM psp_payroll_sub_lines psl, psp_sub_line_reasons pslr
    WHERE psl.payroll_sub_line_id = pslr.payroll_sub_line_id
    AND psl.payroll_line_id IN (SELECT payroll_line_id FROM psp_payroll_lines WHERE payroll_run_id = 12345);
  • Business Scenario: A project manager investigates a variance in labor charges. By querying this table, they can filter sublines for their project by REASON_CODE to identify if the variance stems from late timesheet entries (code 'LATE_TS') or manual reallocations (code 'MANUAL_XFER').

Related Objects

PSP_SUB_LINE_REASONS has a direct and essential relationship with the PSP_PAYROLL_SUB_LINES table, as defined by its foreign key constraint. This establishes a one-to-many relationship where one payroll subline can have multiple reason records. The table is part of the larger Labor Distribution data model, which is fed by the Payroll interface. Key related objects include PSP_PAYROLL_LINES (the source lines from payroll) and PSP_LABOR_DISTRIBUTIONS, which may be created or adjusted based on the sublines. While not explicitly listed in the metadata, the REASON_CODE values likely correspond to a lookup type (e.g., PSP_REASON_CODE) defined within the application's Flexfield or Lookup tables to ensure data integrity and provide meaningful descriptions.