Search Results per_appraisals

Overview

The PER_APPRAISALS 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 serves as the primary repository for records of performance evaluations conducted on individuals within an organization. This table is fundamental to the performance management lifecycle, storing the master header information for each formal appraisal event. Its role is to centrally track the appraisal process, linking key elements such as the appraised person, the appraisal template used, the overall outcome, and the organizational context.

Key Information Stored

The table stores metadata and results for each appraisal instance. Critical columns, as indicated by its primary and foreign key relationships, include the unique APPRAISAL_ID (primary key), the BUSINESS_GROUP_ID linking to HR_ALL_ORGANIZATION_UNITS for organizational security, and the APPRAISAL_TEMPLATE_ID referencing PER_APPRAISAL_TEMPLATES to define the structure and content of the evaluation. A significant data point is the OVERALL_PERFORMANCE_LEVEL_ID, which stores the final summarized rating by referencing the PER_RATING_LEVELS table. Other typical columns would include identifiers for the appraisee (PERSON_ID), appraisal status, period dates, and details of the appraiser(s).

Common Use Cases and Queries

This table is central to performance reporting and process tracking. Common use cases include generating lists of completed appraisals for a manager, analyzing performance rating distributions across business groups, and auditing appraisal cycles. A typical reporting query might join PER_APPRAISALS with person and assignment tables to list appraisals with their overall ratings:

• SELECT pa.appraisal_id, pp.full_name, pa.appraisal_date, rtl.name overall_rating FROM per_appraisals pa, per_all_people_f pp, per_rating_levels_tl rtl WHERE pa.person_id = pp.person_id AND pa.overall_performance_level_id = rtl.rating_level_id AND sysdate BETWEEN pp.effective_start_date AND pp.effective_end_date AND rtl.language = USERENV('LANG');

Data fixes often target this table to correct erroneous links to templates or business groups, or to update statuses for stalled appraisals, always respecting its foreign key constraints.

Related Objects

As per the provided metadata, PER_APPRAISALS has a central relationship with several key performance management tables. It is the parent table for detailed appraisal components: PER_ASSESSMENTS (stores individual competency assessments), PER_OBJECTIVES (holds goals and objectives reviewed in the appraisal), and PER_PERFORMANCE_RATINGS (may store additional rating details). Its definition is governed by foreign keys to PER_APPRAISAL_TEMPLATES and PER_RATING_LEVELS. For custom reporting or integrations, one would also typically join to PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F to retrieve employee and job context, though these specific joins are not listed as formal foreign keys in the provided excerpt.