Search Results per_qualification_types_tl




Overview
Explore in AI Chat

Overview

PER_QUALIFICATION_TYPES_TL is a translation (TL) table in the HR schema of Oracle E-Business Suite, classified under the PER (Human Resources) product family. It maintains the language-specific, translatable attributes of qualification types, which are used throughout Oracle HRMS to describe the educational credentials, degrees, certifications, and professional designations that employees, applicants, and resources may hold. In a multilingual EBS implementation, the base transactional row for a qualification type is stored in PER_QUALIFICATION_TYPES_B, while the human-readable name displayed to users is resolved from this table according to the session's language setting.

The object is classified heuristically as standalone within a Data Vault modeling convention. This suggests that, in a dimensional or vault-style model, the table is best treated as an independent reference or lookup structure rather than as a hub, link, or satellite that participates in a defined FK relationship to another core entity. Its primary key, PER_QUALIFICATION_TYPES_TL_PK, is defined on QUALIFICATION_TYPE_ID and LANGUAGE, with the documented physical schema additionally listing ZD_EDITION_NAME in the unique index.

Key Information Stored

The table contains approximately ten documented columns, of which the most significant are the following:

  • QUALIFICATION_TYPE_ID — Surrogate identifier that joins back to the base qualification type definition. It forms the leading component of the PER_QUALIFICATION_TYPES_TL_PK primary key.
  • LANGUAGE — The language code for the translated row; the second component of PER_QUALIFICATION_TYPES_TL_PK.
  • NAME — The translated display name of the qualification type, and a business-key candidate through the unique index PER_QUALIFICATION_TYPES_TL_UK2 (QUALIFICATION_TYPE_ID, NAME) and UK1 (LANGUAGE, NAME).
  • SOURCE_LANG — Indicates the source language from which the translation was derived.
  • ZD_EDITION_NAME — Editioning column included in the documented physical unique index.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN capture row-level audit information.

The surrogate key (QUALIFICATION_TYPE_ID, LANGUAGE) uniquely identifies each row, while the business-key candidates enforce uniqueness on the translated name per language.

Common Use Cases and Queries

Typical usage centers on displaying qualification data in the user's preferred language and on maintaining translations. A frequent pattern joins the base table to the translation table filtered by language:

  • Retrieve translated names: SELECT b.qualification_type_id, t.name FROM per_qualification_types_b b, per_qualification_types_tl t WHERE b.qualification_type_id = t.qualification_type_id AND t.language = USERENV('LANG');
  • Find missing translations: compare the set of qualification_type_id values in the base table against those present for a given language to identify untranslated entries.
  • Reporting: join this table to person qualification and qualification type usage tables to produce localized qualification catalogs and compliance reports.
  • Data migration: load or update translated names during multi-language rollout or regionalization projects.

Related Objects

The most significant related objects are:

  • PER_QUALIFICATION_TYPES_B — base table joined on QUALIFICATION_TYPE_ID.
  • PER_QUALIFICATION_TYPES_VL — the translated view that typically joins the base and TL tables by QUALIFICATION_TYPE_ID and LANGUAGE.
  • PER_PERSON_QUALIFICATIONS — holds qualification instances referencing qualification types.
  • PER_QUALIFICATIONS — master qualification records linked to qualification types.
  • HR_QUALIFICATION_TYPES_API — the public API used to create and maintain qualification type definitions and their translations.
  • FND_LANGUAGES — provides the language codes referenced by the LANGUAGE column.