Search Results edw_bim_ih_outcm_m_pk

Overview

The table EDW_BIM_IH_OUTCM_M is an interaction outcome dimension table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments. It belongs to the BIM (Marketing Intelligence) product module, which is documented as obsolete. This table functions as a master reference or lookup table, providing a standardized set of descriptive attributes for classifying the results or conclusions of customer interactions. Its primary role is to support data warehousing and analytical reporting within the EBS framework by enabling the consistent categorization and analysis of interaction outcomes across transactional data.

Key Information Stored

As a dimension table, EDW_BIM_IH_OUTCM_M is structured to hold a unique list of valid interaction outcomes. While the specific column list is not detailed in the provided metadata, the structure of such tables typically includes a surrogate primary key and descriptive attributes. The documented primary key column is OTCM_INTRCTN_OUTCOME_PK_KEY. This surrogate key is a system-generated identifier used for efficient joins to fact tables. Other columns would logically store business-friendly outcome codes and descriptions (e.g., 'SALE', 'INQUIRY', 'COMPLAINT_RESOLVED'), along with control columns for ETL processes such as effective start and end dates for tracking historical changes.

Common Use Cases and Queries

The primary use case for this table is to enrich transactional interaction data with meaningful outcome descriptions for reporting and dashboards. Analysts would join this dimension to fact tables to segment and measure interaction performance. A typical analytical query would aggregate interactions by their outcome type.

• Sample Query Pattern: SELECT o.OUTCOME_DESCRIPTION, COUNT(f.INTRCTN_ID) FROM BIM_EDW_INTRCTNS_F f JOIN EDW_BIM_IH_OUTCM_M o ON f.INTRCTN_OUTCOME_FK_KEY = o.OTCM_INTRCTN_OUTCOME_PK_KEY GROUP BY o.OUTCOME_DESCRIPTION;
• Reporting Use Cases: Generating reports on campaign effectiveness by outcome, analyzing customer service resolution rates, or tracking sales lead progression through different interaction stages.

Related Objects

The metadata explicitly defines a critical relationship with the interaction fact table. The primary key of EDW_BIM_IH_OUTCM_M is referenced by a foreign key in the BIM_EDW_INTRCTNS_F table via the column BIM_EDW_INTRCTNS_F.INTRCTN_OUTCOME_FK_KEY. This establishes a direct dimensional link from transactional interaction records to their defined outcomes. The table's primary key constraint is named EDW_BIM_IH_OUTCM_M_PK. Given its role in the obsolete BIM module, it is part of a broader, legacy data mart schema likely comprising other dimension tables (e.g., for time, customer, channel) and the central interaction fact table.