Search Results per_qualification_types_tl_pk

Overview

HR.PER_QUALIFICATION_TYPES_TL is the translation (language) table for the Qualification Types entity in Oracle E-Business Suite Release 12.1.1 and 12.2.2. Qualification types form the reference data used by Oracle Human Resources and Oracle Learning Management to categorize the qualifications, degrees, certifications, and academic credentials that can be recorded against a person, an applicant, or a resource. Because qualification type names must be presented in the user's own language, the descriptive attributes are stored in this translation table while the language-independent attributes reside in the base table HR.PER_QUALIFICATION_TYPES. The row count in this table therefore approximates the number of qualification types multiplied by the number of installed and active languages.

No foreign key constraints are documented for this object, and the mined relationship data classifies it as a standalone object. Under a Data Vault modeling heuristic this would be treated as a satellite, since it carries the descriptive, language-dependent NAME attribute that changes independently of the base entity key. The object is valid in the ETRM data dictionary and is owned by the HR schema, with FND design data registered as PER.PER_QUALIFICATION_TYPES_TL.

Key Information Stored

The table stores ten documented columns. The primary key is defined by the unique index PER_QUALIFICATION_TYPES_TL_PK, whose documented column list is QUALIFICATION_TYPE_ID, LANGUAGE, and ZD_EDITION_NAME; the table-level primary key is the narrower QUALIFICATION_TYPE_ID plus LANGUAGE pair, which constitutes the business-key candidate for the translated description. Note that QUALIFICATION_TYPE_ID is a surrogate identifier — it is the primary key of the base entity and holds no business meaning on its own; the meaningful combination is that surrogate key plus the language.

• QUALIFICATION_TYPE_ID — Numeric surrogate key inherited from the base table; identifies the qualification type being translated.
• LANGUAGE — The installed language of the translation row; part of both the primary key and the N1 index.
• SOURCE_LANG — The language in which the source record was originally entered, used for the "translated from" indication in the UI.
• NAME — The translated display name of the qualification type, up to 150 characters; this is the principal payload of the table and the second column of the N1 index.
• ZD_EDITION_NAME — The editioning column used by the EBS online patching (Edition-Based Redefinition) architecture to isolate application code changes; it participates in the primary key index.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — The standard "Who" audit columns maintained automatically by Oracle Forms and the database triggers.

Common Use Cases and Queries

The most frequent requirement is to present qualification type names in the session language while retaining access to the base row. A typical join is:

• SELECT b.qualification_type_id, b.qualification_type_code, t.name FROM per_qualification_types b, per_qualification_types_tl t WHERE b.qualification_type_id = t.qualification_type_id AND t.language = USERENV('LANG');
• Where the N1 index (LANGUAGE, NAME) is exploited: filtering by LANGUAGE = USERENV('LANG') and ordering by NAME for LOVs and value-set validation. This index exists specifically to satisfy language-scoped lookups and sorted list-of-values queries without a full scan of the translation table.
• Translation completeness reporting: comparing PER_QUALIFICATION_TYPES_TL rows per LANGUAGE against the base table row count to detect qualification types that have not been translated into a required language.
• Data migration and interface validation: confirming that SOURCE_LANG and NAME are populated for every active combination before loading qualification data through the HR/open interfaces.

Related Objects

The documented dependencies are minimal; the following objects are the most significant in practice.

• HR.PER_QUALIFICATION_TYPES — The base table holding the language-independent definition; joined on QUALIFICATION_TYPE_ID. This is the parent of the translated attributes described here.
• PER_QUALIFICATION_TYPES_TL# — The editioned variant referenced by this table under the EBS online patching model.
• HR.PER_QUALIFICATIONS — The transactional table recording the qualifications actually held by a person; it references the qualification type and is the principal consumer of the translated names.
• HR.PER_QUALIFICATION_TYPE_USAGES — Links qualification types to the modules or areas of use in which they are valid.
• FND_LANGUAGES / FND_LANGUAGE_TL — The language registry that governs which LANGUAGE values are available and installed.
• HR_QUALIFICATION_TYPES_API / HR_QUALIFICATION_TYPE_API — The PL/SQL APIs that insert, update, and translate qualification types, and which maintain this table when a new type or a new translation is created.