Search Results psp_schedules




Overview
Explore in AI Chat

Overview

The PSP_SCHEDULES table is a core data repository within the Oracle E-Business Suite (EBS) Labor Distribution module (PSP). Its primary function is to store schedule information linked to employee assignments defined in Oracle Human Resources (HRMS). This table acts as the foundational data source for labor distribution schedules, which are critical for allocating employee costs and effort across multiple projects, tasks, or general ledger accounts. By associating schedules with specific HR assignments, it enables the systematic and rule-based distribution of payroll and labor expenses, a fundamental process for project accounting, grants management, and financial reporting in EBS.

Key Information Stored

The table's structure centers on a composite primary key that uniquely identifies a schedule within the context of an HR assignment and its organizational and financial boundaries. The key columns are ASSIGNMENT_ID, BUSINESS_GROUP_ID, and SET_OF_BOOKS_ID. The ASSIGNMENT_ID directly links to the HR assignment (PER_ALL_ASSIGNMENTS_F). The BUSINESS_GROUP_ID associates the schedule with a specific business group (HR operating unit), and SET_OF_BOOKS_ID ties it to the applicable ledger or accounting setup. While the provided metadata does not list all columns, typical data stored would include schedule effective dates, distribution percentages, and status flags. The table's design ensures that labor distribution rules are scoped correctly to the employee's assignment and the relevant financial and organizational structures.

Common Use Cases and Queries

The primary use case is the creation, maintenance, and reporting of employee labor distribution schedules. Administrators use this data to define how an individual's salary or hours are split across funding sources. Common queries involve retrieving schedules for a specific employee, validating schedule coverage sums to 100%, or identifying schedules active within a given date range for payroll processing or audit purposes. A typical reporting SQL pattern would join PSP_SCHEDULES to HR assignment and person tables.

  • Sample Query: To find active schedules for an employee: SELECT * FROM psp_schedules ps, per_all_assignments_f paf WHERE ps.assignment_id = paf.assignment_id AND paf.person_id = :p_person_id AND SYSDATE BETWEEN paf.effective_start_date AND paf.effective_end_date;
  • Integration: Data from this table is used by the Labor Distribution engine to generate distribution lines during payroll transfer and costing processes.

Related Objects

PSP_SCHEDULES has defined relationships with several other objects within the PSP module. As per the metadata, it is referenced by a foreign key in the PSP_SCHEDULE_HIERARCHY table, which likely stores hierarchical or multi-level schedule breakdowns. Its most critical relationship is with the Oracle HRMS foundation, specifically the PER_ALL_ASSIGNMENTS_F table, via the ASSIGNMENT_ID column. It is also intrinsically linked to the financials setup through SET_OF_BOOKS_ID (GL_SETS_OF_BOOKS). For reporting and application logic, it is commonly accessed through standard Labor Distribution APIs and forms, which ensure data integrity and business rule enforcement when creating or modifying schedule records.