Search Results bsc_db_measure_cols_tl




Overview
Explore in AI Chat

Overview

The table BSC_DB_MEASURE_COLS_TL is owned by the BSC schema and belongs to the Oracle EBS Balanced Scorecard product family. Its documented purpose is "Measure columns information," meaning it stores the descriptive and translation-related attributes that define the individual columns belonging to a scorecard measure group. In Oracle EBS 12.1.1 and 12.2.2 this object appears with a status of VALID and is registered as a base table within the BSC application dictionary.

The structure of the table, with its translation-language column and its foreign-key linkage to a group definition, indicates that it holds attribute-style descriptive detail rather than core business entities. Based on the heuristic Data Vault classification mined from the foreign-key structure, this object can be modeled as satellite-leaning: it functions primarily as a dependent descriptive store attached to a parent measure-group definition, rather than as a standalone hub or a connecting link. This classification is offered as a modeling suggestion only and does not alter the physical design delivered by Oracle.

Key Information Stored

The documented physical schema for 12.1.1 exposes seven columns. The most significant of these are described below.

  • MEASURE_COL — the sole column forming the primary key constraint BSC_DB_MEASURE_COLS_TL_PK. This is the surrogate identifier for a measure column record.
  • LANGUAGE — the translation language of the row. Together with MEASURE_COL it forms the unique index BSC_DB_MEASURE_COLS_TL_U1, the documented business-key candidate for this table.
  • SOURCE_LANG — the source language from which the translated content originates, used by the standard EBS multilingual (MLS) mechanism.
  • HELP — the descriptive or help text associated with the measure column, subject to translation.
  • MEASURE_GROUP_ID — the foreign key that anchors this column to its parent measure group; it references BSC_DB_MEASURE_GROUPS_TL.
  • PROJECTION_ID — an additional foreign key referencing IGI_IAC_PROJECTIONS, linking the column to a projection definition.
  • MEASURE_TYPE — the classification of the measure column, distinguishing how the measure is interpreted within the scorecard.

The distinction between the surrogate key (MEASURE_COL) and the business-key candidate (MEASURE_COL plus LANGUAGE) is central to querying this table correctly, since the same measure column appears once per installed language.

Common Use Cases and Queries

Typical usage involves resolving the descriptive text for measure columns in a specific language while joining back to the parent group. A representative pattern is:

  • Retrieving translated column help for a scorecard group: SELECT c.MEASURE_COL, c.HELP FROM BSC_DB_MEASURE_COLS_TL c WHERE c.MEASURE_GROUP_ID = :group_id AND c.LANGUAGE = USERENV('LANG');
  • Reporting measure columns alongside their projection context by joining on PROJECTION_ID to IGI_IAC_PROJECTIONS.
  • Auditing multilingual completeness by comparing SOURCE_LANG against LANGUAGE values to identify untranslated rows.
  • Enumerating measure types across groups to document the composition of a scorecard definition.

Related Objects

The following objects are the most significant in relation to this table, based on the documented primary-key and foreign-key relationships.

  • BSC_DB_MEASURE_GROUPS_TL — parent translation table; joined via BSC_DB_MEASURE_COLS_TL.MEASURE_GROUP_ID = BSC_DB_MEASURE_GROUPS_TL.MEASURE_GROUP_ID.
  • IGI_IAC_PROJECTIONS — projection definition table referenced through PROJECTION_ID.
  • BSC_DB_MEASURE_COLS_TL_PK — the primary-key constraint on MEASURE_COL.
  • BSC_DB_MEASURE_COLS_TL_U1 — the unique index on (MEASURE_COL, LANGUAGE), confirming the multilingual business key.
  • Associated BSC measure and scorecard definition tables that consume MEASURE_GROUP_ID for hierarchy resolution and reporting.