Search Results ahl_visit_types_tl




Overview
Explore in AI Chat

Overview

AHL_VISIT_TYPES_TL is a translation (TL) table in the AHL schema, the module for Complex Maintenance, Repair and Overhaul (CMRO) in Oracle E-Business Suite. In the EBS multilanguage architecture, TL tables hold the language-dependent (translatable) attributes of a base entity, while the corresponding base (B) table stores language-independent attributes. For visit types, the base table is AHL_VISIT_TYPES_B, and this TL table stores the user-facing DESCRIPTION text for each visit type in each installed language. Visit types are the lookup-style classifications used to categorize a visitor or visit record — for example, inspection, repair, or overhaul visits — within the CMRO visit-tracking model.

The ETRM metadata classifies this table by a heuristic Data Vault rule as standalone. From a modeling perspective this reflects that the table, as mined from its foreign-key structure, has no dependent hub or link relationships within the AHL transactional model; its only documented foreign key points to an FND security lookup. A Data Vault practitioner would therefore treat AHL_VISIT_TYPES_TL as a descriptive satellite carrying the language-dependent description attributes keyed by the visit type identifier and language.

Key Information Stored

The table contains 10 documented columns at the 12.2.2 level. The most significant are:

  • VISIT_TYPE_ID — the surrogate primary key component that identifies the visit type; it joins to the base table AHL_VISIT_TYPES_B.
  • LANGUAGE — the language code identifying the translation row; together with VISIT_TYPE_ID it forms the unique business key.
  • SOURCE_LANG — indicates the source language of the row, supporting the translation framework used across EBS TL tables.
  • DESCRIPTION — the translated, user-visible description of the visit type, the principal translated attribute.
  • SECURITY_GROUP_ID — the security group reference; the documented foreign key to FND_SECURITY_GROUPS.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — the standard EBS "Who" audit columns recording creation and last modification details.

The unique index AHL_VISIT_TYPES_TL_U1 on (VISIT_TYPE_ID, LANGUAGE) confirms that combination as the business-key candidate, while VISIT_TYPE_ID alone serves as the surrogate key linking to the base entity.

Common Use Cases and Queries

Because the table is a translation satellite, its primary use is joining to the base table to retrieve descriptions in a selected language. A representative query retrieves the visit type description for a given language:

  • SELECT b.visit_type_id, t.description FROM ahl_visit_types_b b, ahl_visit_types_tl t WHERE b.visit_type_id = t.visit_type_id AND t.language = USERENV('LANG');
  • Reporting on all visit type definitions, restricted to a specific language for consistent labels.
  • Validation of translation completeness: identifying visit types missing a translation row for a target language.
  • Integration and interface loads that must resolve translated descriptions when populating downstream CMRO visit records.

Related Objects

  • AHL_VISIT_TYPES_B — the base table holding language-independent columns; joins on VISIT_TYPE_ID.
  • FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID; the only documented foreign key target.
  • AHL_VISITS — the transactional visit table that references visit types through the base entity.
  • FND_LANGUAGES — the language definitions underpinning the LANGUAGE and SOURCE_LANG columns.
  • EBS framework views such as FND_LOOKUPS-style translation access patterns, consistent with TL conventions.

Together these objects situate AHL_VISIT_TYPES_TL as the language-dependent descriptive layer of the CMRO visit-type model.