Results for “min_scale_step”

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

Overview

PER_RATING_SCALES 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 definition of rating scales used to rate and evaluate competencies, appraisals, and assessments. Each row represents one rating scale, identified by a surrogate primary key RATING_SCALE_ID, and scoped to a specific business group through BUSINESS_GROUP_ID. Because a scale is a reusable, shared reference object rather than a transactional record, the table functions as a central definition hub from which many appraisal, assessment, and competency records draw their validation values.

The heuristic Data Vault classification, mined from the foreign key structure, is hub-leaning. In practice this means PER_RATING_SCALES behaves as a hub: it holds a stable, business-independent set of unique scale definitions keyed by a surrogate identifier, while surrounding tables act as links or satellites attaching scales to templates, competencies, and assessment types. Modeling it as a hub with RATING_SCALE_ID as the business key is a reasonable design suggestion.

Key Information Stored

The table contains 35 documented columns. The most significant are listed below.

• RATING_SCALE_ID — surrogate primary key (PER_RATING_SCALES_PK) uniquely identifying each rating scale.
• BUSINESS_GROUP_ID — foreign key to HR_ALL_ORGANIZATION_UNITS; the business group that owns the scale, providing multi-tenancy within a single HR schema.
• NAME — the user-visible name of the scale; part of the unique business key PER_RATING_SCALES_UK1 (NAME plus BUSINESS_GROUP_ID).
• TYPE — classifies the scale, for example numeric or descriptive, determining how levels are interpreted.
• DESCRIPTION — free-text explanation of the scale's purpose.
• DEFAULT_FLAG — indicates whether the scale is the default for its business group.
• MAX_SCALE_STEP and MIN_SCALE_STEP — define the upper and lower bounds of the rating range.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the OAF/BC4J framework to detect concurrent updates.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE20 — the standard EBS descriptive flexfield columns for customer-defined extensions.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — the standard audit trail columns recording who created and last modified the row.

The documented unique indexes are PER_RATING_SCALES_PK on RATING_SCALE_ID and PER_RATING_SCALES_UK1 on NAME and BUSINESS_GROUP_ID, meaning a scale name must be unique within a business group.

Common Use Cases and Queries

Typical scenarios include locating the default scale for a business group, retrieving all steps for a scale, and joining scales to competencies or appraisal templates for reporting.

• Finding the default scale: SELECT rating_scale_id, name, type FROM per_rating_scales WHERE business_group_id = :bg_id AND default_flag = 'Y';
• Listing levels for a scale: join PER_RATING_LEVELS on RATING_SCALE_ID to enumerate the scoring steps.
• Identifying scales used by competence assessments: join PER_ASSESSMENT_TYPES on RATING_SCALE_ID or WEIGHTING_SCALE_ID.
• Auditing definitions: select NAME, MIN_SCALE_STEP, MAX_SCALE_STEP, LAST_UPDATE_DATE ordered by business group.

Reporting queries should always filter on BUSINESS_GROUP_ID to respect multi-tenancy, and use the PK index when resolving a known scale identifier.

Related Objects

The following tables depend on or reference PER_RATING_SCALES through documented foreign keys.

• HR_ALL_ORGANIZATION_UNITS — referenced via BUSINESS_GROUP_ID, providing the owning business group.
• PER_RATING_LEVELS — references RATING_SCALE_ID, holding the individual rating steps that belong to a scale.
• PER_APPRAISAL_TEMPLATES — references RATING_SCALE_ID, linking appraisal templates to a rating scale.
• PER_ASSESSMENT_TYPES — references RATING_SCALE_ID and WEIGHTING_SCALE_ID, associating assessment types with rating and weighting scales.
• PER_COMPETENCES — references RATING_SCALE_ID, tying competencies to the scale used to evaluate them.

These relationships establish PER_RATING_SCALES as a foundational reference table for the competency and appraisal configuration model, ensuring rating behavior is consistently defined across the enterprise.