Results for “per_appraisals”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PER_APPRAISALS is the core transactional table within the Oracle E-Business Suite Human Resources (PER) module that stores appraisal records — evaluations of a person by others. Each row represents a single appraisal event, capturing the appraisee, the appraiser, the appraisal template applied, associated performance ratings, objectives, and assessment data. In Oracle EBS 12.1.1 and 12.2.2, this table sits at the heart of the Performance Management and Talent Management workflows, providing the persistence layer for both the self-service appraisal pages and the administrative appraisal functions.

From a dimensional modeling perspective, the ETRM metadata classifies PER_APPRAISALS heuristically as satellite-leaning. This suggests it is best modeled as a satellite attached to a business key that represents the appraisal or the appraisee/appraiser relationship, rather than as a standalone hub. The presence of descriptive attributes such as status, dates, comments, and rating references — combined with foreign keys to reference tables — supports this satellite classification, though the surrogate primary key APPRAISAL_ID also gives it a hub-like quality in a raw Data Vault build.

Key Information Stored

The table contains 75 documented columns. The most significant include:

• APPRAISAL_ID — Surrogate primary key (PER_APPRAISALS_PK); uniquely identifies each appraisal record.
• BUSINESS_GROUP_ID — Foreign key to HR_ALL_ORGANIZATION_UNITS; scopes the appraisal to a legislative business group.
• APPRAISAL_TEMPLATE_ID — Foreign key to PER_APPRAISAL_TEMPLATES; defines the structure and scoring model used.
• APPRAISEE_PERSON_ID / APPRAISER_PERSON_ID — Identify the evaluated person and the evaluator.
• MAIN_APPRAISER_ID — Designates the primary appraiser when multiple participants exist.
• APPRAISAL_DATE, APPRAISAL_PERIOD_START_DATE, APPRAISAL_PERIOD_END_DATE — Define the review cycle and evaluation window.
• STATUS / APPRAISAL_SYSTEM_STATUS — Track workflow state (e.g., planned, in progress, completed).
• OVERALL_PERFORMANCE_LEVEL_ID — Foreign key to PER_RATING_LEVELS; the overall performance rating.
• TYPE — Classifies the appraisal (e.g., annual, probationary).
• ASSIGNMENT_ID and related ASSIGNMENT_* columns — Denormalized assignment context at appraisal time.
• COMMENTS / APPRAISEE_COMMENTS — Textual feedback captured during the appraisal.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the OAF framework.
• LAST_UPDATE_DATE, CREATED_BY, CREATION_DATE — Standard audit columns.
• PLAN_ID — Links the appraisal to an appraisal plan where applicable.

Common Use Cases and Queries

Typical reporting scenarios include tracking appraisal completion rates, average performance ratings by organization, and identifying overdue appraisals. A common SQL pattern joins PER_APPRAISALS to PER_RATING_LEVELS and HR_ALL_ORGANIZATION_UNITS to report ratings by business group:

• Listing all appraisals for a person within a period: SELECT appraisal_id, appraisal_date, status FROM per_appraisals WHERE appraisee_person_id = :person_id AND appraisal_date BETWEEN :start AND :end.
• Calculating average overall ratings by template: aggregate OVERALL_PERFORMANCE_LEVEL_ID joined to PER_RATING_LEVELS.
• Workflow monitoring: filter on STATUS and APPRAISAL_SYSTEM_STATUS to find appraisals pending completion.
• Downstream detail retrieval: join to PER_ASSESSMENTS, PER_OBJECTIVES, and PER_PERFORMANCE_RATINGS via APPRAISAL_ID.

These queries are frequently used in OBIEE/OTBI extracts, custom concurrent programs, and HR analytics dashboards.

Related Objects

• PER_ASSESSMENTS — References PER_APPRAISALS.APPRAISAL_ID; stores individual competency assessments.
• PER_OBJECTIVES — References PER_APPRAISALS.APPRAISAL_ID; stores appraisal objectives.
• PER_PERFORMANCE_RATINGS — References PER_APPRAISALS.APPRAISAL_ID; stores line-level ratings.
• PER_APPRAISAL_TEMPLATES — Referenced by APPRAISAL_TEMPLATE_ID; defines template structure.
• PER_RATING_LEVELS — Referenced by OVERALL_PERFORMANCE_LEVEL_ID; defines rating values.
• HR_ALL_ORGANIZATION_UNITS — Referenced by BUSINESS_GROUP_ID; provides the business group context.