Search Results edw_bim_ih_reasn_m




Overview
Explore in AI Chat

Overview

The EDW_BIM_IH_REASN_M table is a dimension table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, owned by the BIM (Marketing Intelligence) product family. Its primary role is to serve as the master reference for interaction reasons within the enterprise data warehouse (EDW) layer. As a dimension table, it provides the descriptive context and categorization for transactional facts, specifically for marketing and customer interaction data. This table is a core component of the data model supporting analytical reporting and business intelligence activities in the Marketing Intelligence module, enabling users to segment and analyze customer interactions based on standardized reason codes.

Key Information Stored

While the provided metadata does not list specific column names beyond the primary key, the structure of a typical dimension table like EDW_BIM_IH_REASN_M can be inferred. Its central column is the primary key, RESN_INTRCTN_REASON_PK_KEY, which uniquely identifies each valid interaction reason. The table would typically contain descriptive attributes for each reason, such as a reason code, a descriptive name, and potentially hierarchical classifications (e.g., major/minor reason categories). It may also include standard data warehouse columns for tracking data validity, such as effective start date (EFF_FROM_DT), effective end date (EFF_TO_DT), and current record indicator (CURRENT_FLG). The table's design ensures referential integrity and provides a single source of truth for interaction reason metadata.

Common Use Cases and Queries

The primary use case for this table is to enable dimensional analysis of customer interaction data. It is essential for reports that break down interaction volumes, campaign effectiveness, or service inquiries by the reason for the interaction. A common SQL pattern involves joining this dimension table to the related interaction fact table to enrich transactional records with descriptive reason text.

  • Sample Query for Interaction Analysis:
    SELECT i.INTRCTN_ID, r.REASON_NAME, i.INTRCTN_DATE
    FROM BIM_EDW_INTRCTNS_F i
    JOIN EDW_BIM_IH_REASN_M r ON i.INTRCTN_REASON_FK_KEY = r.RESN_INTRCTN_REASON_PK_KEY
    WHERE r.CURRENT_FLG = 'Y';
  • Reporting Use Case: Generating a summary report showing the count of all customer interactions grouped by interaction reason for a given period, which is fundamental for understanding contact drivers and allocating resources.

Related Objects

The EDW_BIM_IH_REASN_M table has a documented foreign key relationship where it is referenced as a parent table. This relationship is critical for maintaining data integrity within the warehouse schema.

  • Referencing Table (Child): BIM_EDW_INTRCTNS_F
    Foreign Key Column: BIM_EDW_INTRCTNS_F.INTRCTN_REASON_FK_KEY
    Joins To: EDW_BIM_IH_REASN_M.RESN_INTRCTN_REASON_PK_KEY
    This relationship indicates that the interaction fact table (BIM_EDW_INTRCTNS_F) stores a foreign key that must correspond to a valid primary key in the EDW_BIM_IH_REASN_M dimension table, linking each interaction record to its defined reason.