Search Results per_rating_levels_tl




Overview
Explore in AI Chat

Overview

PER_RATING_LEVELS_TL is a translation (TL) table within the Oracle E-Business Suite Human Resources (PER) module. It stores the language-dependent, translatable attributes of rating scale steps. In Oracle HRMS competence management, a rating scale (for example, a five-point proficiency scale) consists of multiple rating levels, where each level represents a single point on that scale and is used to rate competences. The "_TL" suffix indicates that this table holds the user-facing descriptive text — most notably the level name and behavioural indicator — for each rating level in one or more installed languages, while the base table PER_RATING_LEVELS_B retains the language-independent columns.

From a Data Vault modeling perspective, the metadata classifies this object heuristically as a standalone table. In practice, PER_RATING_LEVELS_TL behaves as a satellite attached to the rating level hub represented by PER_RATING_LEVELS_B (keyed by RATING_LEVEL_ID). The standalone classification reflects that no foreign-key relationships were mined from the catalogued structure, so dependent objects should be confirmed through the application's own metadata rather than assumed.

Key Information Stored

The table contains ten documented columns. The following are the most significant:

  • RATING_LEVEL_ID — Surrogate identifier for the rating level. Together with LANGUAGE it forms the composite primary key PER_RATING_LEVELS_TL_PK and links each translated row back to its base record in PER_RATING_LEVELS_B.
  • LANGUAGE — The language code of the translated content, forming the second component of the primary key.
  • SOURCE_LANG — The language from which the row was originally created, used by the Multi-Language Support (MLS) infrastructure to track the source of a translation.
  • NAME — The translated display name of the rating level, such as "Expert" or "Novice". This is the principal business-facing value.
  • BEHAVIOURAL_INDICATOR — The translated descriptive text explaining the behaviour or proficiency that characterizes this rating level; it provides the guidance raters use when assigning a score.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and last modified the row and when.

The composite primary key (RATING_LEVEL_ID, LANGUAGE) is also the only unique index documented, making it the business-key candidate: no rating level may have more than one translation row per language. RATING_LEVEL_ID alone is the surrogate key inherited from the base table.

Common Use Cases and Queries

The table is queried whenever rating level names or behavioural indicators must be displayed in a specific language, for example in competence assessment pages, rating scale setup forms, and talent management reports. A typical query joins the base and translation tables, restricting to the session language:

  • Retrieve level names for a scale: SELECT t.rating_level_id, t.name, t.behavioural_indicator FROM per_rating_levels_tl t WHERE t.language = USERENV('LANG') ORDER BY t.rating_level_id;
  • Compare translations across languages: select all rows for a given RATING_LEVEL_ID and inspect NAME per LANGUAGE to audit translation coverage.
  • Detect untranslated levels: outer-join PER_RATING_LEVELS_B to PER_RATING_LEVELS_TL and filter where the translation row is null for a target language.
  • Reporting extracts for competence frameworks frequently denormalize NAME and BEHAVIOURAL_INDICATOR to provide readable labels in BI Publisher or OTBI-style outputs.

Related Objects

The most significant related objects are the base and reference tables that supply the untranslated attributes and the scales to which levels belong:

  • PER_RATING_LEVELS_B — base table holding language-independent rating level columns; join on RATING_LEVEL_ID.
  • PER_RATING_SCALES_B and PER_RATING_SCALES_TL — the rating scales to which levels belong.
  • PER_RATING_LEVELS_TL itself is referenced wherever competence ratings are rendered in the user's language.
  • PER_COMPETENCES_B / _TL — competences rated against these levels.
  • HR API / forms such as the Rating Scales setup form populate and maintain these MLS rows.