Search Results edw_bim_srclsts_m




Overview
Explore in AI Chat

Overview

The EDW_BIM_SRCLSTS_M table is a core dimension table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Marketing Intelligence (BIM) module. As a dimension table in a data warehouse schema, its primary role is to provide a centralized, descriptive reference for source list codes used across the enterprise's marketing data. It acts as a master lookup, enabling consistent categorization, filtering, and reporting of marketing activities—such as campaigns, events, leads, and opportunities—by their originating source list. This structure is fundamental to the EBS Business Intelligence schema, ensuring data integrity and enabling dimensional analysis by providing context to the numeric measures stored in related fact tables.

Key Information Stored

While the provided ETRM metadata does not list specific column names, the structure and naming conventions indicate the table's key components. As a dimension table with a primary key named `L1_SRCLST_PK_KEY`, it contains a unique surrogate key for each source list record. This key is designed for efficient joins to multiple fact tables. The table almost certainly includes descriptive attributes for each source, such as a source list code, name, description, type classification, and effective date ranges. Additional columns likely manage data warehouse processes, including creation dates, last update dates, and ETL (Extract, Transform, Load) batch identifiers to track the dimension's history and lineage.

Common Use Cases and Queries

This table is essential for generating marketing performance reports segmented by lead or interaction source. Analysts use it to answer questions about which source lists generate the highest quality leads or the most revenue. A typical reporting query would join this dimension to one or more fact tables to aggregate metrics. For example, to analyze lead volume by source, a query would join `EDW_BIM_SRCLSTS_M` to `BIM_EDW_LEADS_F` on the `SRCLST_FK_KEY`. The primary use case is to provide the descriptive "by" clause in Business Intelligence queries, enabling drill-downs and pivots on the source dimension in tools like Oracle BI Publisher or Discoverer. It also serves as a critical validation point for ensuring all source list codes referenced in transactional fact data have a corresponding descriptive entry in the master dimension.

Related Objects

The EDW_BIM_SRCLSTS_M table is a central hub referenced by numerous fact tables within the BIM data warehouse, as documented by its foreign key relationships. Key dependent objects include:

Each of these fact tables contains a foreign key column (`SRCLST_FK_KEY`) that links back to the primary key of the EDW_BIM_SRCLSTS_M table, establishing the source list for each recorded fact.