Results for “external_status”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PER_ASSIGNMENT_STATUS_TYPES_TL is the translation (TL) table for assignment status types within the Oracle E-Business Suite Human Resources (PER) module. It holds predefined and user-defined translated assignment status types, supplying the language-specific display text that accompanies the base definition stored in the corresponding non-translated table. In a multi-language EBS deployment, this object is what allows users to view assignment status names in their own language while the application continues to reference a single underlying status type identifier.

From a data modeling perspective, the heuristic Data Vault classification for this object is standalone. This reflects a table that primarily stores descriptive attribute text keyed by a parent identifier and language, rather than participating in a dense foreign-key web. The table is owned by the HR schema and, in ETRM 12.2.2, is documented with 11 columns. Its primary key, PER_ASG_STATUS_TYPES_TL_PK, is defined over ASSIGNMENT_STATUS_TYPE_ID and LANGUAGE.

Key Information Stored

The table's most important columns fall into three groups: identity, language/translation, and audit.

• ASSIGNMENT_STATUS_TYPE_ID — the surrogate identifier linking the translation row to its parent assignment status type definition. It is part of the primary key and the principal join key back to the base table.
• LANGUAGE — the language code for the translated row; combined with the identifier it forms the primary key.
• SOURCE_LANG — indicates the source language from which the translation derives, supporting the multilingual maintenance model.
• USER_STATUS and EXTERNAL_STATUS — the translated status text values presented to users and to external interfaces respectively.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard EBS audit columns recording who created and last modified each row, and when.
• ZD_EDITION_NAME — the editioning column introduced with the EBS online patching architecture in 12.2.

The documented unique index PER_ASG_STATUS_TYPES_TL_PK spans ASSIGNMENT_STATUS_TYPE_ID, LANGUAGE, and ZD_EDITION_NAME, making that combination the business-key candidate in the 12.2.2 schema. The surrogate identifier ASSIGNMENT_STATUS_TYPE_ID is thus distinct from the uniqueness enforced across the language and edition dimensions.

Common Use Cases and Queries

The most frequent requirement is retrieving the human-readable status name for a given assignment status type in a specific language. A typical query joins the translation table to a base or lookup table on the status type identifier:

• Reporting assignment statuses in a chosen language, filtering WHERE LANGUAGE = 'US' while selecting USER_STATUS.
• Auditing which status translations exist across installed languages, grouping counts by LANGUAGE.
• Comparing USER_STATUS and EXTERNAL_STATUS to confirm externally published status terminology aligns with user-facing labels.
• Detecting rows where SOURCE_LANG differs from LANGUAGE to review translation lineage.
• Filtering on ZD_EDITION_NAME in 12.2 environments to isolate the correct edition during patching windows.

A representative pattern selects the identifier, language, and translated text, joining to the parent table and constraining on the desired language and edition.

Related Objects

As a translation table, PER_ASSIGNMENT_STATUS_TYPES_TL depends on its base (non-TL) counterpart, joining on ASSIGNMENT_STATUS_TYPE_ID. The most significant related objects include:

• PER_ASSIGNMENT_STATUS_TYPES — the base table holding the language-independent status type definition; primary join column ASSIGNMENT_STATUS_TYPE_ID.
• PER_ASSIGNMENT_STATUSES — assignment statuses referencing the status type identifier.
• PER_ALL_ASSIGNMENTS_F — assignments whose status ultimately resolves through these status types.
• PER_ASSIGNMENT_STATUS_TYPES_TL linked via PER_ASG_STATUS_TYPES_TL_PK to enforce uniqueness across identifier, language, and edition.
• FND_LANGUAGES — supplies the valid LANGUAGE values used in this table.

Together these objects support the translation and presentation of assignment status information across the HR module.