Search Results per_qualification_ty041427_who

Overview

The HR.PER_QUALIFICATION_TYPES_TL table is a translation table within the Oracle E-Business Suite Human Resources (HRMS) module, specifically for versions 12.1.1 and 12.2.2. It is a core component of the multi-language architecture, designed to store translated textual descriptions for qualification types. Its primary role is to support the localization of the qualification framework, enabling the system to display qualification type names in a user's session language. The table holds the translated attributes sourced from its base table, HR.PER_QUALIFICATION_TYPES, which stores the non-translatable, language-independent data.

Key Information Stored

The table's structure is characteristic of Oracle EBS translation tables. The key columns include the entity identifier and language code, which together form the primary key. The NAME column is the primary translatable attribute, holding the translated name of the qualification type (e.g., "Bachelor's Degree," "Professional Certification"). The SOURCE_LANG column records the original language in which the data was entered, which is critical for synchronization during translation processes. The table is secured by a unique primary key constraint, PER_QUALIFICATION_TYPES_TL_PK, on the combination of QUALIFICATION_TYPE_ID and LANGUAGE. A non-unique index, PER_QUALIFICATION_TYPES_TL_N1, on LANGUAGE and NAME facilitates efficient language-specific searches.

• QUALIFICATION_TYPE_ID: Foreign key to PER_QUALIFICATION_TYPES. Identifies the qualification entity.
• LANGUAGE: The ISO language code (e.g., 'US', 'FR') for the translation.
• SOURCE_LANG: The language code of the original source record.
• NAME: The translated name of the qualification type (max 150 characters).
• Standard WHO Columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN for auditing.

Common Use Cases and Queries

This table is primarily queried in conjunction with its base table to present localized qualification data in forms, reports, and self-service pages. A standard pattern is to join PER_QUALIFICATION_TYPES_TL to PER_QUALIFICATION_TYPES using QUALIFICATION_TYPE_ID, filtered by the user's session language (via the USERENV('LANG') function or a session variable). For reporting, it enables the creation of multi-lingual qualification catalogs. A common administrative use case is verifying translation coverage for a specific qualification type across installed languages.

Sample Query to Retrieve Translated Qualification Types:
SELECT b.QUALIFICATION_TYPE_ID,
t.LANGUAGE,
t.NAME
FROM HR.PER_QUALIFICATION_TYPES b,
HR.PER_QUALIFICATION_TYPES_TL t
WHERE b.QUALIFICATION_TYPE_ID = t.QUALIFICATION_TYPE_ID
AND t.LANGUAGE = USERENV('LANG');

Related Objects

The table has a direct foreign key relationship with its base table, HR.PER_QUALIFICATION_TYPES, via the QUALIFICATION_TYPE_ID column. This is a master-detail relationship where PER_QUALIFICATION_TYPES is the master. The table is also referenced by the APPS synonym PER_QUALIFICATION_TYPES_TL and a PUBLIC synonym of the same name, which are standard access mechanisms within the Oracle EBS architecture. The dependency information indicates it is referenced by a database trigger (PER_QUALIFICATION_TY041427_WHO), which is a standard WHO column population trigger generated by the application.

• Base Table: HR.PER_QUALIFICATION_TYPES (Joined on QUALIFICATION_TYPE_ID)
• Synonyms: APPS.PER_QUALIFICATION_TYPES_TL, PUBLIC.PER_QUALIFICATION_TYPES_TL
• Trigger: PER_QUALIFICATION_TY041427_WHO (for maintaining WHO column data)