Search Results psp_payroll_lines

Overview

The PSP_PAYROLL_LINES table is a core data repository within the Oracle E-Business Suite Labor Distribution (PSP) module. It serves as the central staging and storage point for individual payroll transactions imported into the system. Its primary role is to hold detailed payroll expenditure data sourced from both Oracle Payroll and external, non-Oracle payroll systems. This imported data is the fundamental input for the Labor Distribution process, which subsequently allocates payroll costs to the appropriate general ledger accounts and projects based on predefined distribution rules. The table's existence is critical for reconciling payroll expenses with financial accounts and ensuring accurate labor cost accounting.

Key Information Stored

The table stores a granular record for each payroll line item. Key columns, as indicated by its foreign key relationships, include PAYROLL_LINE_ID (the primary key), PAYROLL_CONTROL_ID (linking to the import batch in PSP_PAYROLL_CONTROLS), and SET_OF_BOOKS_ID (linking to the accounting context in GL_SETS_OF_BOOKS). Crucially, it holds references to cost accounting flexfields (COST_ALLOCATION_KEYFLEX_ID) and general ledger accounts (GL_CODE_COMBINATION_ID), which define the natural account and, often, the project-related charging details. The COST_ID column links to PAY_COSTS, connecting the line to the specific earning or deduction code from the payroll system. Each row effectively represents a single instance of a payroll cost assigned to a specific accounting combination.

Common Use Cases and Queries

The primary use case is the auditing and troubleshooting of payroll data imported for labor distribution. Analysts frequently query this table to verify the volume, value, and accounting attributes of payroll charges before running the distribution process. A common reporting pattern involves joining to related control and descriptive tables to generate a pre-distribution payroll register. For example:

• Identifying all payroll lines for a specific import batch to validate totals.
• Investigating lines distributed to an unexpected GL account by filtering on GL_CODE_COMBINATION_ID.
• Summarizing payroll costs by employee, department, or project segment stored within the cost allocation keyflex.

A typical diagnostic query might join PSP_PAYROLL_LINES with PSP_PAYROLL_CONTROLS (for batch info) and PAY_COSTS (for earning name).

Related Objects

PSP_PAYROLL_LINES sits at the center of a key data model. It is a parent table to PSP_PAYROLL_SUB_LINES, which holds further detailed breakdowns. Its integrity is governed by foreign key relationships to several controlling tables: PSP_PAYROLL_CONTROLS (import batches), GL_SETS_OF_BOOKS (ledger), PAY_COSTS (payroll earnings/deductions), PAY_COST_ALLOCATION_KEYFLEX (project accounting flexfield), and GL_CODE_COMBINATIONS (general ledger account). For transactional processing, it is primarily populated and managed by the payroll import process within the Labor Distribution module, rather than direct user DML. Reporting often leverages views that join this table to its related descriptive entities.