Search Results lvl_col_long_name

Overview

APPS.EDW_LEVEL_ATTS_MD_V is a reporting view in the Oracle E-Business Suite (EBS) Enterprise Data Warehouse (EDW) and ETRM (Enterprise Transaction Reporting Model) layer. It exposes level attribute metadata used to describe the dimensional hierarchy within the EDW star schema — specifically, the columns that characterize levels inside a dimension. The view is a thin projection over a single underlying metadata table and does not join, filter, or transform the data; it simply selects a defined set of columns from EDW_LEVEL_ATTS_MD and exposes them under the APPS schema so that reporting tools, BI publishers, and integration routines can access level attribute metadata through a stable, published interface.

In the context of EBS 12.1.1 and 12.2.2, this object is part of the database-tier metadata catalog that ships with ETRM/EDW. It is most relevant to developers and analysts building or maintaining the EDW dimensional model, generating reports driven by metadata rather than by hard-coded column names, and documenting the physical mapping between business-level attribute names and the underlying warehouse columns. Because the view is a simple projection, its behavior mirrors the underlying table exactly, including any row-level filtering (none documented) and ordering (none defined).

Underlying Base Objects

The documented base object is EDW_LEVEL_ATTS_MD. The view definition is:

• SELECT "DIM_ID", "DIM_NAME", "LVL_ID", "LVL_NAME", "LVL_COL_ID", "LVL_COL_NAME", "LVL_COL_LONG_NAME", "UK_ID", "UK_NAME" FROM EDW_LEVEL_ATTS_MD

All nine columns are selected verbatim from the base table; there are no expressions, aggregations, or joins. This confirms the view is a pure metadata access layer intended to present a controlled, read-friendly column list. Because the view does not contain its own WHERE clause, any filtering, sorting, or aggregation is the responsibility of the calling query.

Key Columns

• DIM_ID — Identifier of the dimension to which the level attribute belongs.
• DIM_NAME — Descriptive name of that dimension.
• LVL_ID — Identifier of the level within the dimension hierarchy.
• LVL_NAME — Short name of the level.
• LVL_COL_ID — Identifier of the column associated with the level.
• LVL_COL_NAME — Physical/short column name for the level attribute.
• LVL_COL_LONG_NAME — The long, business-friendly column name. This is the column that answers the user's search term lvl_col_long_name, and it is the most commonly referenced field when mapping report labels or metadata-driven prompts to physical warehouse columns.
• UK_ID — Identifier of the unique key associated with the level attribute.
• UK_NAME — Name of that unique key.

Common Use Cases and Queries

Typical scenarios include locating the long name of a level attribute column, generating metadata-driven reports, and validating the dimensional model. A representative query to locate a specific long name follows:

• SELECT dim_name, lvl_name, lvl_col_name, lvl_col_long_name FROM apps.edw_level_atts_md_v WHERE lvl_col_long_name = 'lvl_col_long_name';
• SELECT dim_name, lvl_name, lvl_col_long_name FROM apps.edw_level_atts_md_v WHERE dim_id = :dim_id ORDER BY lvl_id;
• SELECT COUNT(*) FROM apps.edw_level_atts_md_v;

Because no indexes or filters are documented on the view itself, performance depends on the indexing and statistics of EDW_LEVEL_ATTS_MD. Queries should constrain on DIM_ID, LVL_ID, or LVL_COL_LONG_NAME where possible. Users should treat this view as read-only metadata and expect it to remain consistent with the base table across EBS 12.1.1 and 12.2.2.