Search Results psp_payroll_sources




Overview
Explore in AI Chat

Overview

The PSP_PAYROLL_SOURCES table is a core reference table within the Oracle E-Business Suite Labor Distribution module (PSP). It functions as a master repository for defining and storing valid payroll source codes, which are categorized by source type. This table is essential for maintaining data integrity across the payroll distribution process, ensuring that all payroll transactions and adjustments reference a predefined and authorized source. Its role is to provide a controlled list of valid combinations that other transactional tables can reference via foreign key constraints, thereby enforcing business rules and supporting accurate labor costing and allocation.

Key Information Stored

The table's structure is defined by a composite primary key consisting of two critical columns. The SOURCE_TYPE column categorizes the broad classification of the payroll source, such as regular earnings, bonuses, or other adjustment types. The SOURCE_CODE column holds the specific, unique identifier within that type, representing the actual payroll element or earning code imported from the payroll system. While the provided metadata does not list additional descriptive columns, such a reference table typically includes fields for an enabled flag, a description, and possibly a user-defined name to enhance usability within the application's forms and reports.

Common Use Cases and Queries

A primary use case is the validation of payroll data during the import and adjustment processes. Before creating adjustment lines or processing payroll batches, the system validates that the source type and code combinations exist in this table. Common queries involve listing all valid sources for a given type or checking for the existence of a specific code. For instance, to retrieve all source codes for a specific type, one might use: SELECT source_code FROM psp_payroll_sources WHERE source_type = '<TYPE>';. Reporting use cases often involve joining this table to transactional data to translate coded values into meaningful descriptions for labor distribution reports and audit trails.

Related Objects

The PSP_PAYROLL_SOURCES table is centrally referenced by several key transactional and control tables in the Labor Distribution module, as documented by its foreign key relationships. The primary key (SOURCE_TYPE, SOURCE_CODE) is referenced by the following objects:

  • PSP_ADJUSTMENT_LINES: The SOURCE_TYPE column in this table references PSP_PAYROLL_SOURCES, linking each adjustment to a valid source type.
  • PSP_ADJUSTMENT_LINES_HISTORY: Both the SOURCE_TYPE and SOURCE_CODE columns reference the primary key, maintaining historical integrity of the source data.
  • PSP_PAYROLL_CONTROLS: The SOURCE_TYPE and PAYROLL_SOURCE_CODE columns reference the primary key, defining the valid sources for a given payroll control setup.
These relationships ensure consistent and valid payroll source data is used throughout the labor distribution lifecycle.