Search Results psp_default_labor_schedules




Overview
Explore in AI Chat

Overview

The table PSP_DEFAULT_LABOR_SCHEDULES is a core data structure within the Oracle E-Business Suite (EBS) Labor Distribution module (PSP). Its primary function is to serve as a repository for default labor costing schedules. These schedules are automatically applied during the labor distribution process when an employee does not have an explicitly defined, active labor schedule. This ensures that labor costs can be allocated to general ledger accounts and projects even in the absence of employee-specific assignment data, maintaining data integrity and process continuity in financial accounting and project costing.

Key Information Stored

The table stores the combination of attributes that define a default costing rule. Its structure is defined by a composite primary key (PSP_DEFAULT_LABOR_SCHEDULES_U1) and a unique identifier column (ORG_SCHEDULE_ID). Key columns include ORGANIZATION_ID and SCHEDULE_BEGIN_DATE, which define the organizational and temporal scope of the default rule. The financial and project accounting dimensions are captured through GL_CODE_COMBINATION_ID, PROJECT_ID, TASK_ID, AWARD_ID, EXPENDITURE_ORGANIZATION_ID, and EXPENDITURE_TYPE. Critical context is provided by SET_OF_BOOKS_ID and BUSINESS_GROUP_ID, linking the schedule to the correct financial and human resources information.

Common Use Cases and Queries

The primary use case is the automated selection of a default schedule during payroll distribution runs. The system queries this table when an employee's assignment lacks a valid schedule, typically matching on BUSINESS_GROUP_ID, ORGANIZATION_ID, and the effective date. Administrators may query the table to audit or maintain default rules. A common diagnostic query is to list all default schedules for a specific business group and organization:

  • SELECT org_schedule_id, schedule_begin_date, gl_code_combination_id, project_id, task_id FROM psp_default_labor_schedules WHERE business_group_id = &bg_id AND organization_id = &org_id ORDER BY schedule_begin_date DESC;

Another critical reporting use case involves joining with distribution lines to identify which cost postings utilized a default schedule versus an employee-specific one, which is vital for compliance and cost analysis.

Related Objects

PSP_DEFAULT_LABOR_SCHEDULES is centrally connected to several key EBS tables via foreign key relationships, primarily serving as a reference source for distribution lines. The documented relationships are:

These relationships enforce data integrity, ensuring that default schedules are built upon valid, existing setup data within General Ledger, Projects, and Human Resources.