Search Results ben_startup_actn_typ_tl




Overview
Explore in AI Chat

Overview

BEN_STARTUP_ACTN_TYP_TL is a translation table (the "_TL" suffix denotes translatable columns) owned by the BEN schema within Oracle Advanced Benefits. It stores the multilingual, language-specific descriptive text for the seeded startup action types that drive the Benefits enrollment flow. While the base definition of each action type is held in the corresponding non-translated table (BEN_STARTUP_ACTN_TYP), this table supplies the NAME and DESCRIPTION values rendered to end users in their session language. It is a seeded reference table: its rows are delivered and maintained by Oracle rather than entered by customers, so its contents change primarily through patches, upgrades, and language installation.

From a Data Vault modeling perspective, the metadata's heuristic classification is standalone. That is, the table does not participate in a clear foreign-key parent/child chain within the mined schema and can reasonably be treated as an independent reference set. In practice it behaves like a translation satellite attached to the action-type business key, but the provided relationship data does not document an enforced parent link, so it should be modeled as a self-contained reference entity keyed by TYPE_CD and LANGUAGE.

Key Information Stored

The table comprises 11 documented columns. The most important are:

  • TYPE_CD — The code identifying the startup action type; the business key shared with the untranslated definition table.
  • LANGUAGE — The language code of the translated row (for example, US for English, FR for French). Together with TYPE_CD it forms the primary key.
  • NAME — The translated display name of the action type.
  • DESCRIPTION — The translated descriptive text explaining the action type.
  • SOURCE_LANG — The base language from which the translation was derived, used by the translation framework.
  • LAST_UPDATE_DATE / LAST_UPDATED_BY / LAST_UPDATE_LOGIN — Standard who-columns recording the last modification audit trail.
  • CREATED_BY / CREATION_DATE — Standard who-columns capturing row creation.
  • ZD_EDITION_NAME — The editioning column supporting Oracle EBS 12.2 online patching.

The documented primary key is BEN_STARTUP_ACTN_TYP_TL_PK, defined on (TYPE_CD, LANGUAGE). The unique index is documented as BEN_STARTUP_ACTN_TYP_TL_PK (TYPE_CD, LANGUAGE, ZD_EDITION_NAME), reflecting the 12.2 editioning addition. The business-key candidate is therefore TYPE_CD combined with LANGUAGE; no separate surrogate numeric key exists, as the documented schema exposes only TYPE_CD as the identifying code.

Common Use Cases and Queries

Reporting on enrollment action types and presenting them in the correct language is the primary use case. A typical bilingual lookup joins the translation to its base record:

SELECT t.TYPE_CD, t.NAME, t.DESCRIPTION
FROM BEN_STARTUP_ACTN_TYP_TL t
WHERE t.LANGUAGE = USERENV('LANG');

Because the table is multilingual, a common pattern is to retrieve a preferred language and fall back to the source language when a translation is missing. Analysts also use it to validate that all expected languages are present for the seeded action types, and to extract the canonical NAME values for reconciliation during upgrades. In a 12.2 environment, queries should be edition-aware, either by relying on the runtime edition or by explicitly constraining ZD_EDITION_NAME.

Related Objects

  • BEN_STARTUP_ACTN_TYP — The untranslated base definition table, joined on TYPE_CD.
  • BEN_STARTUP_ACTN_TYP_TL_PK — The primary-key index enforcing uniqueness of (TYPE_CD, LANGUAGE, ZD_EDITION_NAME).
  • BEN_STARTUP_ACTN — The transactional startup action instance table that references action types.
  • FND_LANGUAGES — The language reference used to validate LANGUAGE values.
  • BEN_STARTUP_ACTN_TYP_B, where present in related ETRM schemas, holding base (non-translated) columns.
  • FND_LOOKUPS / FND_LOOKUPS_TL — Reference pattern for translated seeded data consistent with this table's design.