Search Results per_assignment_status_types_tl

Overview

The table PER_ASSIGNMENT_STATUS_TYPES_TL is a core translation table within the Oracle E-Business Suite Human Resources (PER) module. It stores the translated, user-facing names and descriptions for assignment status types, which are critical for defining the employment status of a person's assignment within the organization. This table supports the application's multi-language capabilities, allowing a single assignment status type, such as 'ACTIVE_ASSIGN' or 'SUSPENDED', to be presented in the user's preferred language (e.g., English, French, German). Its role is to provide the localized textual content that appears in forms, reports, and self-service pages, ensuring compliance and usability in global deployments.

Key Information Stored

The table's structure is designed to hold language-specific translations linked to a base status identifier. The primary key, as documented, is a composite of ASSIGNMENT_STATUS_TYPE_ID and LANGUAGE, ensuring a unique translation per language for each status type. While the full column list is not detailed in the provided metadata, standard translation table patterns in Oracle EBS dictate that key columns typically include ASSIGNMENT_STATUS_TYPE_ID (foreign key to the base table), LANGUAGE (the language code, e.g., 'US'), SOURCE_LANG (the original language of the data), USER_STATUS_TYPE (the translated name for the status), and DESCRIPTION (the translated descriptive text). The table contains both seeded data for predefined statuses and records for any user-defined assignment status types.

Common Use Cases and Queries

This table is primarily queried to present localized assignment status information in user interfaces and reports. A common use case is generating a localized list of active assignment statuses for an HR report or a value set in a form. A typical SQL pattern involves joining this translation table with its base table, PER_ASSIGNMENT_STATUS_TYPES, and filtering by the desired language. For example, to retrieve all status names in American English for reporting:

• SELECT t.user_status_type, t.description FROM per_assignment_status_types_tl t, per_assignment_status_types b WHERE b.assignment_status_type_id = t.assignment_status_type_id AND t.language = 'US' AND b.active_flag = 'Y';

Another critical use case is during data migration or setup, where verifying the existence of translations for all required languages is essential for global rollouts.

Related Objects

PER_ASSIGNMENT_STATUS_TYPES_TL has a direct foreign key relationship with its base table, PER_ASSIGNMENT_STATUS_TYPES. The join is made on the ASSIGNMENT_STATUS_TYPE_ID column. The assignment status type itself is a key reference data element used extensively in the PER_ALL_ASSIGNMENTS_F table, which stores the main assignment records for employees. Consequently, this translation table is indirectly critical for any process or report that needs to display a person's assignment status in a localized manner. It is also referenced by various HRMS APIs and views that surface assignment data for forms and self-service pages.