Search Results per_subjects_taken_tl_pk




Overview
Explore in AI Chat

Overview

The HR.PER_SUBJECTS_TAKEN_TL table is a core translation table within the Oracle E-Business Suite Human Resources (HRMS) module, specifically for versions 12.1.1 and 12.2.2. Its primary role is to store translated values for the 'grade_attained' field associated with an employee's or applicant's educational history. It operates as a supporting object to the base table, HR.PER_SUBJECTS_TAKEN, enabling the application to present grade information in multiple languages based on the user's session language. This design is a standard Oracle EBS pattern for supporting multilingual installations, ensuring that descriptive text is accessible globally.

Key Information Stored

The table's structure is defined to manage translations efficiently. The key columns are the composite primary key, consisting of SUBJECTS_TAKEN_ID (a foreign key to PER_SUBJECTS_TAKEN) and LANGUAGE (the code for the translation language, such as 'US' or 'DE'). The GRADE_ATTAINED column (VARCHAR2(100)) holds the actual translated text. Critical for translation integrity is the SOURCE_LANG column, which records the language code of the original record from which the translation was created. The table also includes standard "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing. All rows are stored in the APPS_TS_TX_DATA tablespace.

Common Use Cases and Queries

The primary use case is the dynamic retrieval of a subject's grade in a user's preferred language during application runtime. This is typically handled by the Oracle Applications framework, which automatically joins to this table based on the session's LANGUAGE setting. For reporting and data extraction, a common pattern is to join this table with its base table to get a complete, language-specific view of educational subjects. A typical query to retrieve translated grades for a specific employee or language would be:

  • SELECT pst.person_id, pst.subject, pstl.grade_attained, pstl.language
  • FROM hr.per_subjects_taken pst,
  • hr.per_subjects_taken_tl pstl
  • WHERE pst.subject_taken_id = pstl.subject_taken_id
  • AND pstl.language = USERENV('LANG');

Data maintenance for this table is generally performed through the Oracle EBS application forms for maintaining education records, which handle the creation and update of translation rows transparently.

Related Objects

The table has a direct and singular relationship with its base table, as documented in the metadata. The SUBJECTS_TAKEN_ID column is a foreign key to the HR.PER_SUBJECTS_TAKEN table. This relationship is enforced by the primary key constraint PER_SUBJECTS_TAKEN_TL_PK on the combination of SUBJECTS_TAKEN_ID and LANGUAGE. The table is also referenced by synonym structures (APPS.PER_SUBJECTS_TAKEN_TL and PUBLIC.PER_SUBJECTS_TAKEN_TL) for simplified access within the application schema. Furthermore, a database trigger named PER_SUBJECTS_TAKEN_T041336_WHO is documented as referencing this table, which is likely responsible for populating the standard "Who" auditing columns.