Search Results psp_effort_reports




Overview
Explore in AI Chat

Overview

The PSP_EFFORT_REPORTS table is a core data object within the Oracle E-Business Suite (EBS) Labor Distribution module (PSP). It serves as the primary transactional repository for employee effort reports, which are formal documents used to record and certify the distribution of an employee's work effort across various funding sources, projects, or tasks over a specified accounting period. This table is fundamental to the effort reporting lifecycle, which includes report generation, certification, adjustment, and approval workflows. Its data is essential for ensuring labor costs are accurately allocated in compliance with organizational policies and external regulations, such as those governing sponsored research.

Key Information Stored

Each record in PSP_EFFORT_REPORTS represents a unique version of an effort report for a specific employee and time period. The table's structure is designed to support versioning and complex approval chains. The primary key is a composite of EFFORT_REPORT_ID and VERSION_NUM, allowing multiple iterations of a report to be maintained. Critical foreign key columns establish the table's central relationships: TEMPLATE_ID links to PSP_EFFORT_REPORT_TEMPLATES for formatting rules, SET_OF_BOOKS_ID links to GL_SETS_OF_BOOKS_11I for the financial context, and BUSINESS_GROUP_ID links to HR_ALL_ORGANIZATION_UNITS for the organizational context. Other significant columns typically include employee identifiers, report period start and end dates, current status (e.g., 'DRAFT', 'SUBMITTED', 'APPROVED'), and audit information such as creation and last update dates.

Common Use Cases and Queries

This table is central to operational and audit reporting within Labor Distribution. Common use cases include tracking the status of all effort reports within a business group for a given period, identifying reports pending certification or approval, and analyzing historical report data for compliance audits. A typical query might join PSP_EFFORT_REPORTS with HR_EMPLOYEES to list reports for a specific manager's team, filtered by status. For technical support, queries often trace transactional integrity by joining the table to its key child tables, such as PSP_DISTRIBUTION_LINES, to verify that all reported effort has corresponding distribution lines. Sample SQL often involves filtering on BUSINESS_GROUP_ID, SET_OF_BOOKS_ID, and REPORT_PERIOD_END_DATE.

Related Objects

As indicated by its extensive foreign key relationships, PSP_EFFORT_REPORTS is a central hub in the Labor Distribution schema. It is directly referenced by numerous transactional and historical tables. Key child tables include PSP_DISTRIBUTION_LINES and PSP_ADJUSTMENT_LINES, which store the detailed effort percentages and any manual corrections, respectively. Corresponding history tables (PSP_DISTRIBUTION_LINES_HISTORY, PSP_ADJUSTMENT_LINES_HISTORY) track changes to these details. PSP_EFFORT_REPORT_DETAILS holds additional report attributes, while PSP_ER_APPROVALS manages the approval workflow. PSP_PRE_GEN_DIST_LINES is used for staging distribution data before report finalization. The table's definition is governed by foreign keys to foundational EBS tables for templates (PSP_EFFORT_REPORT_TEMPLATES), general ledger sets (GL_SETS_OF_BOOKS_11I), and organizational structure (HR_ALL_ORGANIZATION_UNITS).