Results for “per_rating_scales_tl”

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

Overview

PER_RATING_SCALES_TL is the translation table for rating scales within the Oracle EBS Human Resources (PER) product family. A rating scale defines the ordered set of values used to evaluate competencies, performance, and other HR appraisal constructs. The _TL suffix denotes a translated ("language") table: it stores the language-dependent text attributes of a rating scale, specifically its name and description, in each installed language. The corresponding base table, PER_RATING_SCALES_B, holds language-independent attributes and the business identity of the scale.

The object resides in the HR schema and is documented as VALID in ETRM for release 12.2.2, with equivalent presence in 12.1.1. It is a dependent table: a row in PER_RATING_SCALES_TL has no independent meaning without its parent row in PER_RATING_SCALES_B, which is keyed by RATING_SCALE_ID. In Data Vault terms, the ETRM metadata classifies this object as standalone, based on a heuristic mining of its foreign-key structure. A practical modeling suggestion is therefore to treat it as a satellite attached to the rating-scale hub, rather than as a hub or link in its own right; the multi-language key (RATING_SCALE_ID, LANGUAGE) behaves as a satellite grain over the parent business key, and no independent relationships to other entities are implied.

Key Information Stored

The table is documented with ten columns. The most significant are:

• RATING_SCALE_ID — the surrogate identifier inherited from the base table; together with LANGUAGE it forms the primary key.
• LANGUAGE — the NLS language code for the translated row, such as US or DE. Every translatable entity carries one row per installed language.
• SOURCE_LANG — the language in which the source text was originally authored; used by the translation framework to determine whether a translation is current.
• NAME — the displayed, language-specific name of the rating scale, for example "Performance Rating" or its localized equivalent.
• DESCRIPTION — the language-specific explanatory text for the scale.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS audit columns maintained by the WHO columns framework.

The surrogate primary key is defined by constraint PER_RATING_SCALES_TL_PK over (LANGUAGE, RATING_SCALE_ID). A unique index named PER_RATING_SCALES_TL_PK is documented over (RATING_SCALE_ID, LANGUAGE), which is the business-key candidate: at most one row per scale per language. Unlike the base table, this table introduces no additional uniqueness beyond the composite language key; NAME is not constrained unique.

Common Use Cases and Queries

The dominant access pattern is a join from the base table to the translation table filtered by the session language, which is how the rating scale LOV and the competency/performance setup forms resolve a display name.

SELECT b.rating_scale_id
     , t.name
     , t.description
  FROM per_rating_scales_b  b
     , per_rating_scales_tl t
 WHERE b.rating_scale_id = t.rating_scale_id
   AND t.language = USERENV('LANG');

To retrieve a single scale by name in a specific language, query the translation table directly and join back for base attributes:

SELECT t.rating_scale_id
     , t.name
  FROM per_rating_scales_tl t
 WHERE t.language = 'US'
   AND t.name = 'Performance Rating';

A third pattern is translation-completeness auditing, which is common during multi-country rollouts. Rows whose SOURCE_LANG differs from LANGUAGE, or whose LAST_UPDATE_DATE equals CREATION_DATE, indicate text that has never been localized.

SELECT t.rating_scale_id
     , t.language
     , t.source_lang
  FROM per_rating_scales_tl t
 WHERE t.source_lang <> t.language
   AND t.last_update_date = t.creation_date;

Reporting use cases include HR setup extracts that list all rating scales with their localized names, data-migration validation between legacy and target instances, and reconciliation of translated versus untranslated scales prior to go-live.

Related Objects

• PER_RATING_SCALES_B — the base table; join on RATING_SCALE_ID. This is the primary dependency and the parent of the translation row.
• PER_RATING_SCALE_LEVELS — defines the ordered levels belonging to a rating scale, referenced via RATING_SCALE_ID.
• PER_RATING_LEVELS_TL — the translated names of those levels; the same language pattern applies.
• PER_COMPETENCES_B / PER_COMPETENCES_TL — competencies that may be rated using a rating scale, linked through the scale identifier.
• HR_RATING_SCALES_VL — the translated view over the base and _TL tables, commonly used by forms and reports in place of direct joins.
• FND_LANGUAGES — the language reference table validating the LANGUAGE column.
• FND_TERRITORIES / NLS session settings — supply the value for USERENV('LANG') used in translation-aware queries.