Search Results psp_payroll_controls




Overview
Explore in AI Chat

Overview

The PSP_PAYROLL_CONTROLS table is a core data repository within the Oracle E-Business Suite (EBS) Labor Distribution module (PSP). It serves as the master control table for all payroll cost data imported into the system for subsequent distribution to general ledger and project accounting. Its primary role is to track and manage the lifecycle of each batch of payroll transactions, from import through the distribution and posting processes. Each record represents a distinct payroll control, acting as a parent header for detailed payroll line items, thereby ensuring data integrity and auditability for payroll costing operations.

Key Information Stored

The table's structure centers on a system-generated primary key, PAYROLL_CONTROL_ID, which uniquely identifies each payroll batch. Critical foreign key columns establish essential relationships with other EBS entities. The PAYROLL_ACTION_ID links to the Payroll module (PAY_PAYROLL_ACTIONS), connecting the distributed costs to a specific payroll run. The TIME_PERIOD_ID references PER_TIME_PERIODS, anchoring the data to an accounting period. The SET_OF_BOOKS_ID ties the control to a specific ledger in General Ledger (GL_SETS_OF_BOOKS). Furthermore, the SOURCE_TYPE and PAYROLL_SOURCE_CODE columns reference PSP_PAYROLL_SOURCES, defining the origin system of the payroll data (e.g., Oracle Payroll, an external feeder). The BUSINESS_GROUP_ID links to HR_ALL_ORGANIZATION_UNITS, scoping the data within a specific HR organization.

Common Use Cases and Queries

A primary use case is auditing and troubleshooting the payroll import and distribution process. Analysts query this table to verify batch statuses, identify periods processed, and reconcile totals. Common SQL patterns include joining to related line tables to summarize imported amounts by period or source.

  • Identifying all payroll controls for a specific period: SELECT payroll_control_id, control_status FROM psp_payroll_controls WHERE time_period_id = (SELECT time_period_id FROM per_time_periods WHERE period_name = 'JAN-2024');
  • Summarizing imported payroll value by source: SELECT prc.payroll_source_code, SUM(pln.amount) FROM psp_payroll_controls prc JOIN psp_payroll_lines pln ON prc.payroll_control_id = pln.payroll_control_id GROUP BY prc.payroll_source_code;
  • Validating unprocessed batches: SELECT payroll_control_id, creation_date FROM psp_payroll_controls WHERE control_status = 'IMPORTED';

Related Objects

As indicated by its foreign key relationships, PSP_PAYROLL_CONTROLS is a central hub. It is referenced as a parent table by numerous detail and history tables within Labor Distribution, including PSP_PAYROLL_LINES (the detailed transaction lines), PSP_SUMMARY_LINES, PSP_ADJUSTMENT_LINES, and PSP_PRE_GEN_DIST_LINES, along with their corresponding history tables. These dependencies underscore its role as the controlling header. Its foreign keys to foundational EBS tables like PAY_PAYROLL_ACTIONS, PER_TIME_PERIODS, and GL_SETS_OF_BOOKS integrate payroll distribution deeply with the core HR, Payroll, and Financials modules, ensuring consistent period-end closing and financial reporting.