Search Results per_rating_levels

Overview

The PER_RATING_LEVELS 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. It represents a single step or point on a defined rating scale, which is used to assess and quantify competencies, proficiencies, and performance levels. This table is fundamental to the talent management framework, enabling structured evaluations in processes such as performance appraisals, competence assessments, and resource skill management. Its role is to store the discrete, valid rating options that can be assigned to an employee or entity for a given competence and rating scale combination.

Key Information Stored

The table's structure is designed to enforce data integrity and business rules through its primary and unique keys. The primary identifier is the system-generated RATING_LEVEL_ID. Crucially, the table maintains relationships to other master data through foreign keys, including RATING_SCALE_ID (linking to PER_RATING_SCALES), COMPETENCE_ID (linking to PER_COMPETENCES), and BUSINESS_GROUP_ID (linking to HR_ALL_ORGANIZATION_UNITS for security). Key descriptive columns include NAME, which holds the textual description of the rating level (e.g., "Expert", "Proficient"), and STEP_VALUE, a numeric representation of the level's position or weight within its scale. The unique constraints (PER_RATING_LEVELS_UK2 and UK3) ensure that within a specific rating scale and competence, each step value and each name is unique.

Common Use Cases and Queries

A primary use case is retrieving all valid rating options for a specific competence to populate a list of values in an appraisal or skills interface. For example, to find all rating levels for a specific competence within a business group, a query would join PER_RATING_LEVELS to PER_RATING_SCALES and PER_COMPETENCES. Another critical scenario is reporting on performance evaluation results, which involves joining PER_RATING_LEVELS to tables like PER_APPRAISALS (via OVERALL_PERFORMANCE_LEVEL_ID) or PER_PERFORMANCE_RATINGS to translate stored level IDs into meaningful names and step values for analysis. A common SQL pattern is to select rating level details for a given scale:

• SELECT prl.name, prl.step_value FROM per_rating_levels prl WHERE prl.rating_scale_id = :p_scale_id AND prl.competence_id = :p_competence_id ORDER BY prl.step_value;

Related Objects

PER_RATING_LEVELS is central to the HR assessment ecosystem, with numerous objects referencing it. It is a child table of PER_RATING_SCALES, PER_COMPETENCES, and HR_ALL_ORGANIZATION_UNITS. Its data is heavily referenced by transactional and assessment tables, including PER_APPRAISALS (for overall performance rating), PER_COMPETENCE_ELEMENTS (for rating, weighting, and proficiency levels), and PER_PERFORMANCE_RATINGS. It is also referenced by the AHL_RESOURCE_SKILLS table in the Service suite, demonstrating cross-modular integration for skills management. These relationships highlight its role as a key lookup table for standardized rating data across the application.