Search Results bix_sum_grp_cls_inq_pk

Overview

The BIX_SUM_GRP_CLS_INQ table is a core data warehouse table within the Oracle E-Business Suite (EBS) Interaction Center Intelligence (BIX) module. Its primary function is to serve as a performance summary table, aggregating detailed interaction data from the BIX_INTERACTIONS table to a daily grain. This summarization is performed across key business dimensions including time, agent groups, call centers, campaigns, and interaction classifications. The table's role is to enable efficient historical reporting and analysis of contact center performance by providing pre-aggregated metrics, thereby reducing the need for complex, resource-intensive queries against the granular transaction table.

Key Information Stored

The table stores aggregated metrics for each unique combination of its dimensional attributes. While the full column list is not provided in the metadata, the structure is defined by its primary and unique keys. The unique key (BIX_SUM_GRP_CLS_INQ_UK) explicitly names the critical dimensional columns: HOUR (providing time granularity within a day), RESOURCE_GROUP_ID (identifying the agent group), INTERACTION_CENTER_ID (identifying the call center), CAMPAIGN_ID, and INTERACTION_CLASSIFICATION. The primary key column, SUM_GRP_CLS_INQ_ID, serves as a surrogate key for the row. Each row will contain summarized quantitative data, such as count of interactions, total handle time, or other key performance indicators relevant to the specified dimension combination.

Common Use Cases and Queries

This table is primarily used for generating historical operational reports for contact center management. Common analytical queries include trend analysis of interaction volumes by classification over time, performance comparison across different agent groups or call centers, and campaign effectiveness reporting. A typical reporting query would select aggregated metrics filtered and grouped by the dimensional columns. For example, to analyze daily interaction volumes by classification for a specific campaign, a query would filter on CAMPAIGN_ID, group by HOUR (truncated to day) and INTERACTION_CLASSIFICATION, and sum the relevant metric column. The existence of the unique key ensures data integrity for these dimensional combinations and can be used in joins to descriptive dimension tables for more readable reports.

Related Objects

The table has documented relationships through its defined keys. Its primary relationship is with the source transaction table, BIX_INTERACTIONS, from which its summarized data is populated via ETL processes. The table's structure is enforced by two key constraints:

• Primary Key: BIX_SUM_GRP_CLS_INQ_PK on column SUM_GRP_CLS_INQ_ID. This unique identifier is likely referenced by other summary or staging tables within the BIX schema.
• Unique Key: BIX_SUM_GRP_CLS_INQ_UK on columns (HOUR, RESOURCE_GROUP_ID, INTERACTION_CENTER_ID, CAMPAIGN_ID, INTERACTION_CLASSIFICATION). This key defines the business grain of the table and would be used to join to descriptive dimension tables (e.g., HR_ORGANIZATION_UNITS for RESOURCE_GROUP_ID, IMC_CAMPAIGNS_ALL for CAMPAIGN_ID) in analytical queries.