Results for “per_rating_levels”

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

Overview

PER_RATING_LEVELS is a Human Resources (PER) module table in Oracle E-Business Suite 12.1.1 and 12.2.2, owned by the HR schema. It stores the individual steps, or rating levels, that make up a rating scale used to assess competencies and performance. Each row represents a single point on a rating scale — for example a step such as "Exceeds Expectations" or "Meets Expectations" — and it is against these steps that competences, appraisals, and performance ratings are evaluated throughout the HCM and related enterprise modules.

Because the table holds the distinct business entities (rating levels) that are referenced across a wide set of dependent tables, the mined Data Vault classification is a hub. As a modeling suggestion, PER_RATING_LEVELS functions as a central reference point for rating level identities, with satellites capturing descriptive attributes such as name and behavioural indicator, and links connecting it to scales, competences, and consuming transactional records.

Key Information Stored

The table contains 34 documented columns. The most significant are:

• RATING_LEVEL_ID — the surrogate primary key (PER_RATING_LEVELS_PK) uniquely identifying each rating level.
• RATING_SCALE_ID — foreign key to PER_RATING_SCALES, identifying the scale to which this step belongs. It participates in the business-key unique index PER_RATING_LEVELS_UK2.
• COMPETENCE_ID — foreign key to PER_COMPETENCES, linking the level to a specific competence where applicable; also part of PER_RATING_LEVELS_UK2.
• STEP_VALUE — the numeric or ordinal value assigned to the step within the scale; completes the PER_RATING_LEVELS_UK2 business-key candidate.
• NAME — the descriptive label of the rating level.
• BUSINESS_GROUP_ID — foreign key to HR_ALL_ORGANIZATION_UNITS, scoping the level to an organization/business group.
• BEHAVIOURAL_INDICATOR — a flag or indicator describing behavioural expectations at this level.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the OAF/ADF framework.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE20 — the standard Oracle descriptive flexfield (DFF) columns for customer-extensible attributes.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — who/when audit columns maintained across the EBS data model.

Business-key candidates are the unique indexes PER_RATING_LEVELS_PK (RATING_LEVEL_ID) and PER_RATING_LEVELS_UK2 (RATING_SCALE_ID, COMPETENCE_ID, STEP_VALUE); a third unique index PER_RATING_LEVELS_UK3 (RATING_SCALE_ID, COMPETENCE_ID, NAME) is also documented.

Common Use Cases and Queries

Typical scenarios include listing the steps of a rating scale, resolving the label shown on an appraisal, and reporting competence proficiency distributions. A representative query joins the level to its scale:

• Enumerate steps: SELECT RATING_LEVEL_ID, NAME, STEP_VALUE FROM HR.PER_RATING_LEVELS WHERE RATING_SCALE_ID = :scale_id ORDER BY STEP_VALUE;
• Resolve an appraisal's overall rating: join PER_APPRAISALS.OVERALL_PERFORMANCE_LEVEL_ID to PER_RATING_LEVELS.RATING_LEVEL_ID.
• Competence profiling: join to PER_COMPETENCE_ELEMENTS on RATING_LEVEL_ID, PROFICIENCY_LEVEL_ID, or HIGH_PROFICIENCY_LEVEL_ID.
• Skills and resources: join BOM_RESOURCES, BOM_OPERATION_SKILLS, or AHL_RESOURCE_SKILLS on RATING_LEVEL_ID for manufacturing and scheduling skill matching.

Related Objects

The following are the most significant objects referencing or referenced by PER_RATING_LEVELS:

• PER_RATING_SCALES — parent scale; joined via RATING_SCALE_ID.
• PER_COMPETENCES — joined via COMPETENCE_ID.
• HR_ALL_ORGANIZATION_UNITS — joined via BUSINESS_GROUP_ID.
• PER_APPRAISALS — references OVERALL_PERFORMANCE_LEVEL_ID.
• PER_COMPETENCE_ELEMENTS — multiple FKs: RATING_LEVEL_ID, WEIGHTING_LEVEL_ID, PROFICIENCY_LEVEL_ID, HIGH_PROFICIENCY_LEVEL_ID.
• PER_PERFORMANCE_RATINGS — references PERFORMANCE_LEVEL_ID.
• AHL_RESOURCE_SKILLS — references RATING_LEVEL_ID.
• BOM_RESOURCES and BOM_OPERATION_SKILLS — manufacturing skill references.
• PA_COMPETENCE_PROFILES, BEN_COMPTNCY_RT_F, and BEN_ELIG_COMPTNCY_PRTE_F — competitive profiling and benefits competence rate/eligibility references.

These relationships confirm PER_RATING_LEVELS as a foundational reference hub spanning HCM, Manufacturing, Projects, and Benefits modules.