Results for “per_qualifications_tl”

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

Overview

PER_QUALIFICATIONS_TL is the translation table for qualification definitions in Oracle E-Business Suite Human Resources (PER module). It stores language-specific, translated text for qualification records originally defined in PER_QUALIFICATIONS (or its base equivalent), enabling multilingual display of qualification attributes across the enterprise. The "_TL" suffix follows the standard Oracle EBS translation-table naming convention, where a corresponding base table holds the primary business record and the _TL table holds one row per installed language. In EBS 12.1.1 and 12.2.2 the object resides in the HR schema and is documented as VALID, with a physical schema of 16 columns in ETRM 12.2.2.

The heuristic Data Vault classification mined from the foreign-key structure is standalone. From a modeling perspective, this suggests the object can be treated as a self-contained satellite-style entity attached to the qualification business key, rather than participating in a hub or link relationship. Because its primary key combines LANGUAGE with QUALIFICATION_ID, each qualification can carry multiple translated rows—one per language—making it a descriptive, language-scoped companion to the base qualification record.

Key Information Stored

The table's surrogate primary key is PER_QUALIFICATIONS_TL_PK, defined on the composite of LANGUAGE and QUALIFICATION_ID. The documented unique index (business-key candidate) is also PER_QUALIFICATIONS_TL_PK over QUALIFICATION_ID and LANGUAGE, confirming that the qualification identifier plus language code uniquely identify each translated row.

• QUALIFICATION_ID — Surrogate/foreign key linking each translated row to its base qualification record; the principal join column.
• LANGUAGE — Language code of the translation; combined with QUALIFICATION_ID forms the unique key.
• SOURCE_LANG — The source language from which the translation was derived, used by the translation framework.
• TITLE — The translated name or title of the qualification, the primary user-facing descriptive attribute.
• GROUP_RANKING — Translated grouping/ranking descriptor for the qualification.
• LICENSE_RESTRICTIONS — Translated text describing licensing restrictions associated with the qualification.
• AWARDING_BODY — Translated name of the organization that awards the qualification.
• GRADE_ATTAINED — Translated grade or level attained for the qualification.
• REIMBURSEMENT_ARRANGEMENTS — Translated description of reimbursement terms.
• TRAINING_COMPLETED_UNITS — Translated units of completed training required or recorded.
• MEMBERSHIP_CATEGORY — Translated membership category associated with the qualification.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN track row creation and modification.

Common Use Cases and Queries

The most frequent use of PER_QUALIFICATIONS_TL is joining translated qualification text to the base qualification record for multilingual reporting, competency catalogues, and qualification lookup pages in HR self-service. A typical query pattern filters by the user's session language:

• Join base qualification and its translation: SELECT q.qualification_id, t.title FROM per_qualifications q, per_qualifications_tl t WHERE q.qualification_id = t.qualification_id AND t.language = :p_language.
• Retrieve all translations for audit or comparison: SELECT language, title FROM per_qualifications_tl WHERE qualification_id = :id ORDER BY language.
• Detect missing translations by comparing base records against available LANGUAGE rows.
• Feed translated TITLE and AWARDING_BODY values into qualification catalogue reports and competency gap analyses.

Related Objects

• PER_QUALIFICATIONS — Base qualification table; joined on QUALIFICATION_ID.
• PER_QUALIFICATIONS_TL_PK — Unique index enforcing the LANGUAGE/QUALIFICATION_ID key.
• PER_QUALIFICATION_MEMBERSHIPS — Qualification-membership association referencing the qualification.
• PER_PERSON_TYPE_QUALIFICATIONS — Links persons to qualifications, resolved via QUALIFICATION_ID.
• HR_QUALIFICATION_API — PL/SQL API for creating and maintaining qualification and translation records.
• FND_LANGUAGES — Provides valid LANGUAGE values installed in the instance.