Search Results per_performance_reviews_pk

Overview

The PER_PERFORMANCE_REVIEWS table is a core data object within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically under the PER product family. It serves as the primary repository for storing performance review information for employees. This table is integral to the performance management lifecycle, enabling organizations to formally record, track, and analyze employee evaluations. Its data is critical for downstream processes such as compensation planning, career development, and talent management initiatives within the integrated EBS environment.

Key Information Stored

The table's structure is centered on the performance review entity. Its primary key is the PERFORMANCE_REVIEW_ID, a unique system-generated identifier for each review record. A critical foreign key relationship is established via the EVENT_ID column, which links the performance review to a specific entry in the PER_EVENTS table. This linkage formally associates the review with a scheduled HR event. While the provided metadata does not list all columns, typical data stored includes review dates (period start and end), overall performance ratings, reviewer and employee identifiers, review status (e.g., 'Draft', 'Completed'), and narrative comments or summary text. The table acts as the anchor for detailed scoring, which may be stored in related child tables.

Common Use Cases and Queries

This table is central to performance reporting and process automation. Common use cases include generating review completion reports for managers, analyzing performance rating distributions, and feeding data into compensation workflows. A typical query might join PER_PERFORMANCE_REVIEWS with PER_ALL_PEOPLE_F to retrieve employee names and details for completed reviews within a specific period. Another common pattern is to link the table to PER_PAY_PROPOSALS to identify employees whose compensation proposals are based on a specific performance review. Sample SQL for finding completed reviews would filter on a STATUS column and join with the events table to get the review period.

Related Objects

• PER_EVENTS: A foundational HR table. PER_PERFORMANCE_REVIEWS references it via the EVENT_ID foreign key, tying the review to a calendar event.
• PER_PAY_PROPOSALS: This table holds a foreign key (PERFORMANCE_REVIEW_ID) referencing PER_PERFORMANCE_REVIEWS, demonstrating a direct dependency where a pay proposal can be initiated based on a performance review.
• PER_PERFORMANCE_REVIEWS_PK: The primary key constraint on the PERFORMANCE_REVIEW_ID column, ensuring data integrity.
• Performance Management APIs and Views: Standard Oracle HR APIs (likely in the HRPS* or PER* packages) and seeded views (e.g., PER_PERFORMANCE_REVIEWS_V) would typically provide programmatic and read-only access to this table's data, respectively.