Search Results cug_incidnt_attr_vals_tl




Overview
Explore in AI Chat

Overview

The CUG_INCIDNT_ATTR_VALS_TL table is a core translation table within the Oracle E-Business Suite (EBS) Citizen Interaction Center (CUG) module. It is designed to support the multilingual capabilities of the application by storing translated descriptions for user-defined incident attribute values. This table operates in a parent-child relationship with the base table CUG_INCIDNT_ATTR_VALS_B, which holds the language-independent, transactional data. The TL (Translation) table enables the Citizen Interaction Center to present attribute values, such as statuses or categories, in the language of the user's session, a critical feature for public-facing and multi-national government or service organizations.

Key Information Stored

The table's structure is typical of EBS translation tables, using a composite primary key that combines a foreign key to the base record and a language code. The most critical columns are:

  • INCIDNT_ATTR_VAL_ID: The foreign key linking to the primary key of the CUG_INCIDNT_ATTR_VALS_B table. This identifies the specific attribute value being translated.
  • LANGUAGE: The language code (e.g., 'US' for American English, 'FR' for French) for the translated text. Together with INCIDNT_ATTR_VAL_ID, this forms the table's primary key.
  • DESCRIPTION: The translated text for the incident attribute value. This is the column that is displayed to the end-user in their selected language.
  • Standard EBS columns like CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY are also present for auditing.

Common Use Cases and Queries

This table is primarily accessed by the application's runtime engine to fetch locale-specific labels. For reporting and data extraction, queries must join to this table to retrieve descriptions in the desired language. A common pattern is to use the NVL function with the session language or a base language to ensure a description is always returned.

Sample Query:
SELECT b.incidnt_attr_val_id,
NVL(tl.description, b.description) AS translated_description
FROM cug_incidnt_attr_vals_b b,
cug_incidnt_attr_vals_tl tl
WHERE b.incidnt_attr_val_id = tl.incidnt_attr_val_id(+)
AND tl.language(+) = USERENV('LANG')
AND b.incident_id = :p_incident_id;

This table is also central during implementation for loading seed data translations and for any localization efforts to add support for a new language.

Related Objects

The CUG_INCIDNT_ATTR_VALS_TL table has a direct, dependent relationship with its base table. The documented foreign key relationship is:

  • CUG_INCIDNT_ATTR_VALS_B: This is the primary related object. The TL table references it via the foreign key column CUG_INCIDNT_ATTR_VALS_TL.INCIDNT_ATTR_VAL_ID. All records in the TL table must correspond to a valid record in this base table. The base table (CUG_INCIDNT_ATTR_VALS_B) itself is likely related to the core incident entity (CUG_INCIDENTS) and attribute definitions (CUG_INCIDENT_ATTRIBUTES), forming the complete data model for extensible incident attributes within the CUG module.