Results for “grade_attained”

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

Overview

PER_SUBJECTS_TAKEN_TL is the translation (TL) table for the PER_SUBJECTS_TAKEN entity within the Oracle EBS Human Resources (PER) product family. It stores language-specific text for attributes defined in the base PER_SUBJECTS_TAKEN table, most notably the translated value of GRADE_ATTAINED. In Oracle EBS 12.1.1 and 12.2.2 the object resides in the HR schema and is documented as VALID in the ETRM repository.

The table’s role is to satisfy multi-language (MLS) requirements for the competency and qualifications module, where recorded subjects, education and qualification records may be displayed to users operating in different session languages. Each row represents the translated text of one base entity record for one installed language.

The ETRM metadata provides a heuristic Data Vault classification of standalone, meaning no foreign-key relationships were mined from the physical model. Modelled in Data Vault terms this classification suggests treating the object as a satellite-like construct keyed to the base entity, rather than as an independent hub or link. Practically, it is a dependent child of PER_SUBJECTS_TAKEN, partitioned by LANGUAGE.

Key Information Stored

The 9 documented columns carry the translation payload plus standard EBS audit columns:

• SUBJECTS_TAKEN_ID — Surrogate identifier of the parent subject-taken record. This is the column users typically search for (subjects_taken_id) and forms the first component of the primary key.
• LANGUAGE — The language code of the translated row. Together with SUBJECTS_TAKEN_ID it forms the composite primary key PER_SUBJECTS_TAKEN_TL_PK, making it a business-key candidate.
• SOURCE_LANG — Indicates the source language from which the translated text was derived; distinguishes original entries from translations.
• GRADE_ATTAINED — The translated text of the grade attained, the primary descriptive attribute carried by this TL table.
• CREATED_BY, CREATION_DATE — Standard audit columns recording the creating user and timestamp.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns recording the most recent modification user, timestamp and login.

The surrogate primary key is therefore composite: SUBJECTS_TAKEN_ID plus LANGUAGE, not the ID alone. Any query that omits LANGUAGE risks returning one row per installed language and duplicating results.

Common Use Cases and Queries

Typical scenarios include translating qualification records for display, auditing translations, and reporting on attained grades in the user’s session language. The most common access pattern joins the TL table to its base table or filters by the searched identifier.

• Retrieve the translated grade for a known subject-taken record:
  SELECT grade_attained FROM per_subjects_taken_tl WHERE subjects_taken_id = :id AND language = USERENV('LANG');
• Find all languages available for a record:
  SELECT language, grade_attained FROM per_subjects_taken_tl WHERE subjects_taken_id = :id ORDER BY language;
• Detect missing translations by comparing base rows to TL rows.
• Identify rows whose SOURCE_LANG differs from LANGUAGE for translation-quality reporting.
• Extract audit history using LAST_UPDATE_DATE for data-governance review.

Because the object is classified as standalone with no mined foreign keys, reports often join on SUBJECTS_TAKEN_ID explicitly to PER_SUBJECTS_TAKEN.SUBJECTS_TAKEN_ID rather than relying on enforced constraints.

Related Objects

• PER_SUBJECTS_TAKEN — Base (non-translated) table; joined on SUBJECTS_TAKEN_ID.
• PER_SUBJECTS_TAKEN_TL_PK — Primary key index on (SUBJECTS_TAKEN_ID, LANGUAGE).
• PER_PERSON_QUALIFICATIONS / qualification entities — Consume subject-taken records for employee qualification reporting.
• HR_LOOKUPS / FND_LANGUAGES — Source of LANGUAGE and SOURCE_LANG code meanings.
• PER_SUBJECTS — Catalogue of subjects referenced by the parent record.
• FND_AUDIT / WHO columns convention — Governs the standard audit column behaviour.