Results for “per_person_types_tl_pk”

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

Overview

HR.PER_PERSON_TYPES_TL is the translation (TL) table for Oracle Human Resources person types in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the language-specific, translated value of the USER_PERSON_TYPE attribute for each person type record defined in the base table HR.PER_PERSON_TYPES. Person types classify the relationship an individual has with the enterprise — for example Employee, Applicant, Contingent Worker, or Party — and the user-facing name of these classifications must be presented in the session language of each user. The _TL suffix identifies this as a multi-language lookup table following the standard Oracle EBS MLS (Multi-Language Support) pattern, where one row exists per person type per installed or defined language.

The object resides in the HR schema, is registered in FND Design Data as PER.PER_PERSON_TYPES_TL, and is stored in the APPS_TS_TX_DATA tablespace with a PCT Free of 10. Its status is VALID. From a heuristic Data Vault modeling perspective, this object is classified as a standalone satellite-like structure: it carries descriptive, language-dependent attributes keyed to the PERSON_TYPE_ID business entity, with no outbound foreign-key dependency to another documented table. The metadata indicates it does not reference any database object directly, though PERSON_TYPE_ID is functionally a foreign key to PER_PERSON_TYPES.

Key Information Stored

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

• PERSON_TYPE_ID (NUMBER(15)) — The identifier of the parent person type; functionally the foreign key to PER_PERSON_TYPES.
• LANGUAGE (VARCHAR2) — The language in which the translated name is expressed.
• SOURCE_LANG (VARCHAR2) — The language in which the record was originally authored, used by the MLS translation mechanism.
• USER_PERSON_TYPE (VARCHAR2(80)) — The translated, user-facing name of the person type. This is the core payload of the table.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — Standard WHO audit columns tracking creation and modification.
• ZD_EDITION_NAME — Part of the editioning/unique-index structure in the 12.2.2 documented schema.

The primary key is PER_PERSON_TYPES_TL_PK on (PERSON_TYPE_ID, LANGUAGE). In the 12.2.2 physical schema the unique index additionally includes ZD_EDITION_NAME, yielding a business-key candidate of (PERSON_TYPE_ID, LANGUAGE, ZD_EDITION_NAME). The surrogate identifier is therefore the PERSON_TYPE_ID-plus-LANGUAGE combination, while the translated USER_PERSON_TYPE value is purely descriptive.

Common Use Cases and Queries

The primary use case is retrieving the localized display name of a person type for a given user session. Reporting and integration layers join this table to the base table to resolve a translated label. A typical query pattern is:

• Join PER_PERSON_TYPES_TL to PER_PERSON_TYPES on PERSON_TYPE_ID to obtain SYSTEM_PERSON_TYPE alongside the translated USER_PERSON_TYPE.
• Filter by LANGUAGE = USERENV('LANG') to return the label in the current session language.
• Use SOURCE_LANG to identify untranslated rows where the stored value falls back to the source language.

Sample SQL:

SELECT pt.SYSTEM_PERSON_TYPE, tl.USER_PERSON_TYPE
FROM HR.PER_PERSON_TYPES pt, HR.PER_PERSON_TYPES_TL tl
WHERE pt.PERSON_TYPE_ID = tl.PERSON_TYPE_ID
AND tl.LANGUAGE = USERENV('LANG');

Reporting scenarios include headcount and assignment reports grouped by translated person type, and HR setup validation to confirm every active person type has a translation row for each installed language.

Related Objects

• HR.PER_PERSON_TYPES — Base table holding the untranslated person type definition; joined on PERSON_TYPE_ID.
• HR.PER_ALL_PEOPLE_F — Assignment and person records referencing person types.
• HR.PER_ASSIGNMENTS_F — Assignment facts whose person type resolution depends on this table.
• APPS.PER_PERSON_TYPES_TL — Application synonym exposing the table to the APPS schema.
• PER_PERSON_TYPES_TL041313_WHO — Documented WHO-column related object referenced by this table.

These dependencies reflect the role of the table as a subordinate lookup feeding translated person type labels across HR reporting and self-service functionality.