Search Results attribute_longname




Overview
Explore in AI Chat

Overview

The view APPS.EDW_DIM_ATTRIBUTES_MD_V is an Oracle E-Business Suite (EBS) data dictionary object belonging to the Enterprise Data Warehouse (EDW) metadata layer supplied with the E-Business Tax (ETRM) product family. It exposes the dimensional attribute definitions that describe how individual attributes are organized within each EDW dimension, together with the natural-key identifiers used to link those attributes back to their originating source structures. In Oracle EBS 12.1.1 and 12.2.2 it is used primarily by reporting, extract, and integration processes that need to enumerate the attributes available on every EDW dimension without querying the underlying metadata table directly.

The view is a thin, column-projected wrapper: it selects a fixed list of nine columns from a single base table. It performs no joins, aggregation, filtering, or transformation, so its behavior is entirely determined by the rows present in that base table.

Underlying Base Objects

Per the ETRM documentation, EDW_DIM_ATTRIBUTES_MD_V is defined over the base table EDW_DIM_ATTRIBUTES_MD. The documented view text is:

The metadata registry lists no other referenced base objects and does not document any join conditions, synonyms, or remote dependencies. Consequently, each row in the view corresponds one-to-one with a row in EDW_DIM_ATTRIBUTES_MD; the view adds no derived or computed columns and imposes no predicates. Because the object is a view rather than a table, it carries no independent storage and inherits all access privileges and DML restrictions of its base table.

Key Columns

The view exposes the following attributes, each mirroring the identically named column in the base table:

  • DIM_ID — Identifier of the EDW dimension to which the attribute belongs.
  • DIM_NAME — Name of that dimension, useful for display and filtering.
  • ATTRIBUTE_ID — Unique identifier for the attribute within the dimension.
  • ATTRIBUTE_NAME — Short (physical) name of the attribute.
  • ATTRIBUTE_LONGNAME — Descriptive, human-readable name used in reports and user interfaces.
  • ATTRIBUTE_SOURCE_LEVEL — The source level from which the attribute is derived, indicating its position in the dimensional hierarchy.
  • ATTRIBUTE_SOURCE_LEVEL_PREFIX — Prefix applied to the source level, typically used to disambiguate columns generated from like-named levels.
  • UK_ID — Identifier of the unique key associated with the attribute, matching the user's search term.
  • UK_NAME — Name of that unique key.

The pairing of UK_ID and UK_NAME identifies the unique key context under which an attribute participates, allowing consumers to distinguish attributes that share the same short name across different key definitions.

Common Use Cases and Queries

The view is typically consumed by metadata-driven extract routines that build dimension loaders or that document the EDW schema. A representative query filters attributes for a specific dimension:

  • SELECT DIM_NAME, ATTRIBUTE_NAME, ATTRIBUTE_LONGNAME, UK_ID, UK_NAME FROM APPS.EDW_DIM_ATTRIBUTES_MD_V WHERE DIM_NAME = :dim;

The user's search term uk_id is directly supported by the view; to locate every attribute tied to a given unique key:

  • SELECT DIM_NAME, ATTRIBUTE_NAME, ATTRIBUTE_SOURCE_LEVEL FROM APPS.EDW_DIM_ATTRIBUTES_MD_V WHERE UK_ID = :uk_id;

To resolve a unique key by name and inspect its attribute set:

  • SELECT ATTRIBUTE_NAME, ATTRIBUTE_LONGNAME, ATTRIBUTE_SOURCE_LEVEL_PREFIX FROM APPS.EDW_DIM_ATTRIBUTES_MD_V WHERE UK_NAME = :uk_name ORDER BY ATTRIBUTE_ID;

Because the view is unfiltered, callers should always constrain results by DIM_ID, DIM_NAME, UK_ID, or UK_NAME to avoid returning the full attribute catalogue. As with all ETRM EDW metadata objects, queries are conventionally qualified with the APPS schema.