Search Results per_appraisal_templates




Overview
Explore in AI Chat

Overview

The PER_APPRAISAL_TEMPLATES table is a core data object within the Oracle E-Business Suite Human Resources (PER) module, specifically for the Performance Management functionality in releases 12.1.1 and 12.2.2. It serves as the master definition table for appraisal templates, which are structured frameworks used to conduct employee performance evaluations. As the metadata indicates, a template acts as "the heading or grouping of appraisal questions." Its primary role is to standardize the appraisal process by defining the assessment criteria, rating scales, and questionnaire structures that will be applied to individual employee appraisals. This ensures consistency and alignment with organizational performance management policies across different business groups.

Key Information Stored

The table stores the configuration metadata for an appraisal template. Its primary key is the system-generated APPRAISAL_TEMPLATE_ID. A unique key constraint on NAME and BUSINESS_GROUP_ID ensures template names are unique within a business group. Critical foreign key columns define the template's components: ASSESSMENT_TYPE_ID links to the type of assessment (PER_ASSESSMENT_TYPES), and RATING_SCALE_ID links to the applicable performance rating scale (PER_RATING_SCALES). The table also integrates with the flexible questionnaire engine via QUESTIONNAIRE_TEMPLATE_ID (HR_QUESTIONNAIRES) to define the specific questions for the appraisal. Additional columns, such as OBJECTIVE_ASMNT_TYPE_ID and MA_QUEST_TEMPLATE_ID, support related assessment types and managerial input questionnaires, respectively.

Common Use Cases and Queries

This table is central to administrative setup and reporting on the appraisal process. Common operational use cases include auditing available templates for a business group, validating template configurations before launching an appraisal cycle, and troubleshooting issues where appraisals cannot be initiated. A typical analytical query would join this table to PER_APPRAISALS to report on the distribution of appraisal types used across the organization. A fundamental setup validation query might be:

  • SELECT pat.name, pat.rating_scale_id, pat.questionnaire_template_id FROM per_appraisal_templates pat WHERE pat.business_group_id = :p_bg_id;

For reporting, a join to the child PER_APPRAISALS table is essential to link template definitions to actual appraisal instances, enabling analysis of template utilization and effectiveness.

Related Objects

PER_APPRAISAL_TEMPLATES has significant relationships with other HR objects, as detailed in its foreign key constraints. It is a parent table to PER_APPRAISALS, where each appraisal record references a specific template. It is a child table to several master definition tables: HR_ALL_ORGANIZATION_UNITS (for the BUSINESS_GROUP_ID), PER_ASSESSMENT_TYPES (twice, for primary and objective assessment types), PER_RATING_SCALES, and HR_QUESTIONNAIRES (twice, for main and managerial appraisal questionnaires). These relationships underscore its role as a central hub that binds together organizational structure, assessment methodology, rating criteria, and question content into a unified appraisal framework.