Results for “per_cagr_entitlement_items_tl”

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

Overview

PER_CAGR_ENTITLEMENT_ITEMS_TL is the translation table for entitlement items defined within Oracle EBS Human Resources (PER) and used by the Compensation and Benefits Administration / Total Compensation (CAGR) functionality. In Oracle EBS 12.1.1 and 12.2.2, the "_TL" suffix denotes a translated (language-dependent) table: it stores the user-facing, multilingual description of each entitlement item, while the underlying business record and its non-translated attributes reside in the corresponding base table, PER_CAGR_ENTITLEMENT_ITEMS_B. The object resides in the HR schema and holds a 10-column physical structure.

Entitlement items represent the individual benefit or compensation components to which an employee or assignment is entitled, and are referenced during eligibility processing and enrollment. This table therefore provides the language-specific item names displayed to end users in the correct session language. Based on the heuristic Data Vault classification mined from its foreign key structure, the object is best modeled as a standalone entity — it does not participate in the descriptive hub/link/satellite dependencies that characterize more heavily integrated transactional tables. This suggests it functions as an independent reference/translation store rather than a junction or event table.

Key Information Stored

The table's primary key, defined by the index PER_CAGR_ENT_ITEMS_TL_PK, is the composite of CAGR_ENTITLEMENT_ITEM_ID and LANGUAGE. The documented unique index also includes ZD_EDITION_NAME, which is the editioning column used by EBS 12.2.x Online Patching; the business-key candidate for a single language row is therefore CAGR_ENTITLEMENT_ITEM_ID + LANGUAGE + ZD_EDITION_NAME.

• CAGR_ENTITLEMENT_ITEM_ID — Surrogate identifier inherited from the base business entity; the foreign-key-style link back to the parent entitlement item record.
• LANGUAGE — The language code of the translated row; part of the composite primary key.
• ITEM_NAME — The translated, user-facing name of the entitlement item displayed in forms and reports.
• SOURCE_LANG — The language in which the item name was originally entered, used by the translation framework to flag untranslated values.
• ZD_EDITION_NAME — Editioning column supporting Online Patching in 12.2.x; included in the unique index.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns recording when, by whom, and in which login session the row was last changed.
• CREATED_BY, CREATION_DATE — Standard WHO columns capturing row creation metadata.

Common Use Cases and Queries

Typical usage centers on resolving the correct-language display name for an entitlement item. Joining the translation table to the base table returns one row per configured language, and filtering on LANGUAGE yields the localized label for reporting or interfaces.

• Listing all translations of an item: SELECT cagr_entitlement_item_id, language, item_name FROM per_cagr_entitlement_items_tl WHERE cagr_entitlement_item_id = :id;
• Detecting untranslated items by comparing LANGUAGE against SOURCE_LANG.
• Reporting on coverage of translations across languages, grouped by LANGUAGE with COUNT of item names.
• Joining to PER_CAGR_ENTITLEMENT_ITEMS_B or eligibility/enrollment queries to present user-friendly item names in extracts and XML publisher reports.

Because the object is editioned in 12.2.x, queries should generally rely on the runtime edition view rather than referencing the edition column directly.

Related Objects

The following objects are most significant when working with this table, joined primarily on CAGR_ENTITLEMENT_ITEM_ID:

• PER_CAGR_ENTITLEMENT_ITEMS_B — Base (non-translated) parent table holding entitlement item business attributes; join on CAGR_ENTITLEMENT_ITEM_ID.
• PER_CAGR_ENTITLEMENT_ITEMS_VL — The translated view combining base and _TL columns, commonly queried instead of the tables directly.
• PER_CAGR_ENTITLEMENTS — Entitlement definitions that reference entitlement items.
• PER_CAGR_ELIG_PERIODS / PER_CAGR_ENRL_ACTIONS — Eligibility and enrollment entities that consume entitlement items.
• FND_LANGUAGES — Reference table providing valid LANGUAGE and SOURCE_LANG values.
• FND_LOOKUPS — Often supplies any coded lookups associated with item configuration.