Search Results per_performance_ratings




Overview
Explore in AI Chat

Overview

The PER_PERFORMANCE_RATINGS table is a core data object within the Oracle E-Business Suite Human Resources (PER) module, specifically for versions 12.1.1 and 12.2.2. As defined in the ETRM, it stores a single evaluation of an objective. Its primary role is to record the outcome of an employee's performance appraisal process at the granular level of individual objectives. This table acts as the transactional repository linking an employee's specific objective, the overall appraisal event, and the assigned performance rating level, thereby enabling detailed performance tracking and analysis.

Key Information Stored

The table's structure is designed to capture the essential components of an objective evaluation. Its primary key is PERFORMANCE_RATING_ID, a unique system-generated identifier. The two most critical foreign key columns are OBJECTIVE_ID, which links to the specific performance objective being assessed, and APPRAISAL_ID, which links to the overarching appraisal event in the PER_APPRAISALS table. A third key column is PERFORMANCE_LEVEL_ID, which references the PER_RATING_LEVELS table to store the actual rating (e.g., 'Exceeds Expectations', 'Meets Expectations') assigned to the objective. The unique key constraint PER_PERFORMANCE_RATINGS_UK2 on OBJECTIVE_ID and APPRAISAL_ID enforces that an objective is only rated once within a given appraisal.

Common Use Cases and Queries

This table is central to performance management reporting and data extraction. Common use cases include generating detailed appraisal reports that list all objectives and their ratings for an employee, calculating aggregate performance scores, and auditing appraisal history. A typical query would join PER_PERFORMANCE_RATINGS with PER_OBJECTIVES, PER_APPRAISALS, and PER_RATING_LEVELS to produce a human-readable report. For example, to retrieve all ratings for a specific employee in a given appraisal period, one might use a SQL pattern such as:

  • SELECT pr.objective_id, o.name, rl.name AS rating
  • FROM per_performance_ratings pr,
  • per_objectives o,
  • per_rating_levels rl,
  • per_appraisals pa
  • WHERE pr.objective_id = o.objective_id
  • AND pr.performance_level_id = rl.rating_level_id
  • AND pr.appraisal_id = pa.appraisal_id
  • AND pa.person_id = <employee_id>
  • AND pa.date_to BETWEEN <start_date> AND <end_date>;

Related Objects

PER_PERFORMANCE_RATINGS has defined relationships with several key HR tables, as per the provided metadata. It is a child table to PER_APPRAISALS via the APPRAISAL_ID foreign key, anchoring the rating to the main appraisal event. It also references PER_RATING_LEVELS via PERFORMANCE_LEVEL_ID to standardize the rating value. While not explicitly listed in the excerpt, it logically relates to PER_OBJECTIVES via the OBJECTIVE_ID column. This table is likely referenced by performance-related views and is integral to the underlying data model for the Performance Management and Appraisals functionalities. Data is typically created and maintained through the Oracle HRMS application's appraisal forms and workflows, not via direct SQL manipulation.