Search Results cug_sr_type_attr_maps_tl




Overview
Explore in AI Chat

Overview

The CUG_SR_TYPE_ATTR_MAPS_TL table is a core data object within the Oracle E-Business Suite Citizen Interaction Center (CUG) module. It functions as a translation table, storing multilingual versions of the descriptive data held in its base table, CUG_SR_TYPE_ATTR_MAPS_B. This design is a standard Oracle Applications pattern, enabling the support of multiple languages in a global deployment. The table's primary role is to allow user-facing labels and descriptions for service request type attribute mappings to be displayed in a user's preferred language, which is critical for citizen-facing and internal service desk applications.

Key Information Stored

The table stores translated text for corresponding records in the base table. Its structure is defined by a composite primary key and language-specific columns. The key columns are SR_TYPE_ATTR_MAP_ID, which is the foreign key linking to the base table's unique identifier, and LANGUAGE, which holds the language code (e.g., 'US' for American English). The primary translated column is typically a DESCRIPTION or similar attribute name column, though the specific column name is implied by the TL (Translation) table convention. Additional standard columns include SOURCE_LANG to denote the original language of the record and CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE for auditing.

Common Use Cases and Queries

This table is primarily accessed indirectly through the application's standard multilingual views or APIs, which automatically filter data based on the current session's language setting. Common use cases include generating service request entry forms or administrative setup screens in a localized language. For direct reporting or data extraction, a typical query joins this table to its base table while filtering for a specific language. A sample SQL pattern is:

  • SELECT b.attr_map_code, tl.description FROM cug_sr_type_attr_maps_b b, cug_sr_type_attr_maps_tl tl WHERE b.sr_type_attr_map_id = tl.sr_type_attr_map_id AND tl.language = USERENV('LANG');

Data maintenance for this table is typically performed via the Oracle Applications translation utilities or the relevant setup forms in the CUG module, not via direct DML.

Related Objects

The table has a direct and essential relationship with its base table, as documented in the provided metadata. The primary foreign key relationship is:

  • Foreign Key to CUG_SR_TYPE_ATTR_MAPS_B: The SR_TYPE_ATTR_MAP_ID column in CUG_SR_TYPE_ATTR_MAPS_TL references the primary key of the same name in the CUG_SR_TYPE_ATTR_MAPS_B table. This relationship ensures every translation record is linked to a valid base configuration record.

In practice, this table will also be referenced by higher-level views (often suffixed with '_VL' for View Localized) that present a combined, language-sensitive perspective of the data for reporting and application logic.