Search Results subjects_taken_id




Overview
Explore in AI Chat

Overview

The PER_SUBJECTS_TAKEN_TL table is a translation table within the Oracle E-Business Suite Human Resources (PER) module. Its primary function is to store translated versions of the grade attained for academic or professional subjects taken by a person, as recorded in the system. This table enables the support of multiple languages within a single EBS instance, allowing for the localization of grade descriptions. It operates as a child table to its corresponding base table, PER_SUBJECTS_TAKEN, and is a standard component of Oracle's Multi-Language Support (MLS) architecture in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by its composite primary key, which consists of two columns. The SUBJECTS_TAKEN_ID column is a foreign key that uniquely links each row to a specific record in the base PER_SUBJECTS_TAKEN table. The LANGUAGE column stores the language code (e.g., 'US' for American English, 'ES' for Spanish) for the translated text. The core data element stored in this table is the translated text for the grade attained. While the specific column name for this translation is not explicitly listed in the provided metadata, based on standard Oracle EBS translation table design patterns, it is typically a column named GRADE_ATTAINED or a similarly named translatable attribute from the base table.

Common Use Cases and Queries

The primary use case is to retrieve subject and grade information in a user's session language for forms, reports, and self-service pages. A common reporting query involves joining this table to its base table and the FND_LANGUAGES table to present localized data. For example, to list subjects taken with translations for a specific person and language, one might use the following pattern:

  • SELECT pst.SUBJECTS_TAKEN_ID, psttl.GRADE_ATTAINED
  • FROM PER_SUBJECTS_TAKEN pst,
  • PER_SUBJECTS_TAKEN_TL psttl
  • WHERE pst.SUBJECTS_TAKEN_ID = psttl.SUBJECTS_TAKEN_ID
  • AND psttl.LANGUAGE = USERENV('LANG')
  • AND pst.PERSON_ID = :person_id;

Data is typically maintained via the standard HR APIs or through the EBS user interface, which automatically manages the insertion and update of records in this translation table based on the user's session language.

Related Objects

The table has a direct and critical relationship with its base data table. The primary documented relationship is as follows:

  • Base Table (PER_SUBJECTS_TAKEN): The PER_SUBJECTS_TAKEN_TL table is a child of PER_SUBJECTS_TAKEN. The SUBJECTS_TAKEN_ID column in the TL table is a foreign key referencing the SUBJECTS_TAKEN_ID primary key in the base table. This relationship ensures every translation is associated with a valid master record.
  • Primary Key Constraint: PER_SUBJECTS_TAKEN_TL_PK on columns (SUBJECTS_TAKEN_ID, LANGUAGE).
  • Foreign Key Constraint: While not named in the metadata, a foreign key constraint from SUBJECTS_TAKEN_ID to PER_SUBJECTS_TAKEN.SUBJECTS_TAKEN_ID is implicit in the design.

This table may also be referenced by various HRMS views that present subject information, and its data is accessed through standard Oracle HRMS APIs for person qualifications and education.