Search Results per_assignment_info_types_tl




Overview
Explore in AI Chat

Overview

PER_ASSIGNMENT_INFO_TYPES_TL is a translation (TL) table in the HR schema of Oracle E-Business Suite, belonging to the PER (Human Resources) product family. It stores the language-specific, translated descriptions of the types of extra information that may be held against an assignment. In Oracle EBS, flexfield-style "extra information" is attached to assignment records through information types, and this table provides the multilingual text used to present those types to users in their selected session language.

This object is a pure translation table. Its non-translated counterpart, PER_ASSIGNMENT_INFO_TYPES_B (or an equivalent base table), holds the language-independent definition of each information type, while PER_ASSIGNMENT_INFO_TYPES_TL supplies the DESCRIPTION and other display attributes per installed language. The row identity is controlled by the composite key formed from the information type and the language code.

From a Data Vault modeling perspective, the mined relationship data classifies this object as standalone. Heuristically, this suggests it is best modeled as a satellite — reference/descriptive data hanging off the information type business key rather than participating as a hub or link in its own right. The absence of documented foreign keys reinforces that the table is a dependent, descriptive store keyed by a natural business key.

Key Information Stored

The table contains 10 documented columns. The most significant are:

  • INFORMATION_TYPE — Identifies the specific assignment information type. This is part of the primary key and the primary business-key candidate; it links back to the base definition of the information type.
  • LANGUAGE — The language code for the translated row. This is the second component of the primary key, ensuring one row per information type per language.
  • SOURCE_LANG — Indicates the source language of the translated text, used to track translation provenance.
  • DESCRIPTION — The translated, user-facing description of the information type, displayed in forms and reports in the session language.
  • ZD_EDITION_NAME — The edition name used by the Online Patching / Edition-Based Redefinition (EBR) infrastructure in EBS 12.2.x, enabling non-disruptive upgrades.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns capturing who last changed the row and when.
  • CREATED_BY, CREATION_DATE — Standard WHO creation audit columns.

The documented primary key is PER_ASG_INFO_TYPES_TL_PK (INFORMATION_TYPE, LANGUAGE). The documented unique index is PER_ASG_INFO_TYPES_TL_PK (INFORMATION_TYPE, LANGUAGE, ZD_EDITION_NAME), which extends the business key with the edition column to remain unique across EBR editions. The surrogate identity is therefore effectively the (INFORMATION_TYPE, LANGUAGE) pair, not a single sequence column.

Common Use Cases and Queries

Typical usage centers on displaying information types in the user's session language and joining translated rows to their base definitions. A standard join pattern retrieves the description for a given language:

  • SELECT t.information_type, t.description FROM per_assignment_info_types_tl t WHERE t.language = USERENV('LANG');
  • Joining to the base table to obtain language-independent attributes: SELECT b.information_type, t.description FROM per_assignment_info_types_b b, per_assignment_info_types_tl t WHERE b.information_type = t.information_type AND t.language = :p_lang;
  • Reporting on translation completeness by comparing available languages: SELECT information_type, COUNT(*) FROM per_assignment_info_types_tl GROUP BY information_type;
  • Filtering out stale editions in 12.2.x: WHERE zd_edition_name = 'SET1' or using the EBR-aware views.

These queries are useful for HR setup validation, localization audits, and any custom form or concurrent program that must render assignment extra-information types in the correct language.

Related Objects

The following objects are most relevant when working with this translation table:

  • PER_ASSIGNMENT_INFO_TYPES_B — The base (language-independent) table keyed by INFORMATION_TYPE; the natural join parent for translations.
  • PER_ASSIGNMENT_INFO_TYPES_VL — The translated view that typically union-joins the B and TL tables to present fully translated information type data.
  • PER_ASSIGNMENTS_F / PER_ALL_ASSIGNMENTS_F — Assignment entities for which extra information types are held and displayed.
  • PER_ASSIGNMENT_EXTRA_INFO — Stores the actual extra-information values attached to assignments, referencing the information type.
  • FND_LANGUAGES — Provides the valid LANGUAGE codes and translation language context.
  • FND_TERRITORIES / FND_LOOKUPS — Supporting reference data used when rendering translated information type labels in localization scenarios.

Because the table is classified as standalone with no documented foreign keys, joins are performed on the INFORMATION_TYPE business key rather than enforced referential constraints.