Results for “csc_prof_table_columns_tl”

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

Overview

The CSC_PROF_TABLE_COLUMNS_TL table is a translation-enabled child table within the CSC (Customer Care) schema of Oracle E-Business Suite. It stores drilldown metadata associated with profile variables defined in the Customer Care module. Specifically, it records the source table and column names used to construct the drilldown form, along with an OBJECT_CODE that resolves to the form function invoked when a user drills into a profile value. Because the table carries the _TL suffix, it is a multilingual (translated) companion to the base CSC_PROF_TABLE_COLUMNS_B table, holding the language-specific label text required for display in different locales.

From a heuristic Data Vault modeling perspective, the metadata classifies this object as standalone. In Data Vault terms it behaves closest to a satellite that hangs off a parent profile-variable hub, carrying descriptive, language-dependent attributes. It should not be treated as a link, since its documented foreign key relationship points to a reference/lookup table (FND_SECURITY_GROUPS) rather than to another business entity.

Key Information Stored

The table is documented with 11 physical columns. The most significant are described below.

• TABLE_COLUMN_ID — Surrogate identifier for the drilldown column record. Together with LANGUAGE it forms the primary key CSC_PROF_TABLE_COLUMNS_TL_PK.
• LANGUAGE — The language code identifying the translation row. Combined with TABLE_COLUMN_ID, it distinguishes one localized row from another.
• SOURCE_LANG — The language of the source (base) record from which the translation was derived; used by the EBS Translation (TL) model to track origin.
• LABEL — The translated display text presented to the user for the drilldown column.
• ZD_EDITION_NAME — Editioning column, part of the unique index CSC_PROF_TABLE_COLUMNS_TL_U1 (TABLE_COLUMN_ID, LANGUAGE, ZD_EDITION_NAME). It supports the online patching (edition-based redefinition) architecture introduced in EBS 12.2 and is a business-key candidate alongside the first two.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing multi-org / security-group based data isolation.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit (WHO) columns capturing insert and update provenance.

Practically, the business-key candidate is the composite (TABLE_COLUMN_ID, LANGUAGE, ZD_EDITION_NAME); the surrogate primary key remains (TABLE_COLUMN_ID, LANGUAGE).

Common Use Cases and Queries

This table is primarily consumed by the Customer Care drilldown framework, which resolves a profile variable into a navigable form. Typical usages include:

• Extracting drilldown labels for a given language to audit or localize the Customer Care UI.
• Validating that every base drilldown column has a corresponding translated row before a release.
• Joining to CSC_PROF_TABLE_COLUMNS_B to reconcile the base table/column definitions with their translations.

A representative query returning drilldown labels for a specific language:

SELECT b.table_column_id,
       t.label,
       t.source_lang
FROM   csc_prof_table_columns_b b,
       csc_prof_table_columns_tl t
WHERE  b.table_column_id = t.table_column_id
AND    t.language = USERENV('LANG');

A reporting query listing all translated labels with audit information:

SELECT table_column_id, language, label,
       last_updated_by, last_update_date
FROM   csc_prof_table_columns_tl
ORDER  BY table_column_id, language;

Related Objects

The following objects are most relevant when joining or referencing this table:

• CSC_PROF_TABLE_COLUMNS_B — The base (untranslated) table; joined on TABLE_COLUMN_ID. Supplies the source table/column names and OBJECT_CODE.
• FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID; governs security-group filtering.
• CSC_PROF_TABLE_COLUMNS_TL_PK — Primary key constraint enforcing uniqueness on (TABLE_COLUMN_ID, LANGUAGE).
• CSC_PROF_TABLE_COLUMNS_TL_U1 — Unique index on (TABLE_COLUMN_ID, LANGUAGE, ZD_EDITION_NAME).
• CSC_PROF_VARIABLES — Parent profile-variable definitions that the drilldown columns ultimately serve.
• FND_FORM_FUNCTIONS — Resolves the OBJECT_CODE into the form function invoked on drilldown.

Because the object is documented as standalone with only a single FK to a reference table, direct relational dependencies are limited; most value is obtained by pairing it with its base table and the profile-variable metadata.