Search Results per_rating_scales_uk1

Overview

The PER_RATING_SCALES table is a core data object within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically under the PER product family. It serves as the master repository for defining rating scales, which are standardized measurement tools used to evaluate competencies, performance, and other qualitative factors within the organization. These scales provide a consistent framework for assessments, ensuring that ratings applied to employees, competencies, or appraisal templates are uniform and comparable across the business group. The table's integrity is enforced by primary and unique key constraints, and it acts as a central reference point for numerous other entities in the performance management and competency architecture.

Key Information Stored

The table's primary purpose is to store the definition of each unique rating scale. The most critical columns include RATING_SCALE_ID, which is the primary key and unique numeric identifier for each scale. The NAME column, in conjunction with BUSINESS_GROUP_ID, forms a unique key (PER_RATING_SCALES_UK1), ensuring scale names are not duplicated within a single business group. The BUSINESS_GROUP_ID itself is a foreign key to HR_ALL_ORGANIZATION_UNITS, enforcing data security at the business group level as per Oracle HRMS's multi-org principles. While the provided metadata does not list all columns, typical supplementary columns would include descriptive fields, effective dating columns (e.g., DATE_FROM, DATE_TO), and creation/modification audit columns.

Common Use Cases and Queries

This table is central to configuring and reporting on performance management. Administrators use it to define scales such as "1-5 Numeric" or "Exceeds/Meets/Needs Improvement." Common operational and reporting queries involve joining to child tables. For instance, to list all defined rating scales within a business group, a query would filter on BUSINESS_GROUP_ID. A more complex report might link a scale to its associated rating levels and competencies. A typical SQL pattern for retrieving active scales and their related levels would be:

• SELECT prs.name, prl.name, prl.rating_level_code, prl.step_value FROM per_rating_scales prs, per_rating_levels prl WHERE prs.rating_scale_id = prl.rating_scale_id AND SYSDATE BETWEEN prs.date_from AND NVL(prs.date_to, SYSDATE) AND prs.business_group_id = :p_bg_id ORDER BY prs.name, prl.step_value;

This data is also critical for backend support when troubleshooting why specific rating options appear in appraisal forms or competency assessments.

Related Objects

As indicated by the foreign key relationships, PER_RATING_SCALES is a heavily referenced parent table. Its primary key, RATING_SCALE_ID, is referenced by several key performance management tables. The PER_RATING_LEVELS table stores the individual steps (e.g., "Poor," "Good," "Excellent") that belong to each scale. Furthermore, rating scales are linked to PER_COMPETENCES to define how a specific competency is measured, and to PER_APPRAISAL_TEMPLATES and PER_ASSESSMENT_TYPES to define the overall rating methodology for appraisals and assessments. Notably, PER_ASSESSMENT_TYPES references the table twice: once for a primary rating scale and once for a separate weighting scale. The table's relationship with HR_ALL_ORGANIZATION_UNITS via BUSINESS_GROUP_ID anchors it to the enterprise's organizational model.