Results for “media_item_type”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

BIX_SERVER_IB is a table in the BIX schema, belonging to the BIX – Interaction Center Intelligence product module within Oracle E-Business Suite. It is derived from the "Interaction Blending CCI Data" subject area and functions as a pre-aggregated analytical repository that captures the workload, staffing, and service-level behaviour of interaction blending environments across sites and media types. The table is documented as VALID in both ETRM 12.1.1 and 12.2.2, and holds 15 columns in the documented 12.1.1 physical schema.

The table is keyed by BIX_SERVER_IB_PK on the SERVER_IB_ID column. Applying the heuristic Data Vault classification mined from the foreign key structure, BIX_SERVER_IB is best modelled as a satellite. It records descriptive, time-stamped measurements (minute-level workload and staffing metrics) attached to a business context defined by site, media type, and loss-of-service category. Its only outbound foreign key, BIX_SERVER_IB.SECURITY_GROUP_ID, references FND_SECURITY_GROUPS, meaning the table is otherwise standalone within the BIX star schema and does not act as a hub or link.

Key Information Stored

The surrogate primary key is SERVER_IB_ID, populated via BIX_SERVER_IB_PK. No separate unique business-key index is documented in the ETRM metadata, so the natural grain must be derived from the combination of the granularity columns below.

• SERVER_IB_ID – Surrogate primary key for each row.
• MINUTE – The minute-level time bucket at which the snapshot was captured, establishing the temporal grain of the data.
• SITE_ID – Identifies the interaction centre or site to which the metrics apply.
• MEDIA_ITEM_TYPE – The interaction channel or media classification (for example, voice, chat, or e-mail) being blended.
• LOS_CATEGORY_ID – The loss-of-service (LOS) category against which service performance is measured.
• LOS_CATEGORY_DIRECTION – Indicates the direction or threshold interpretation of the LOS category.
• NUMBER_OF_ITEMS_QUEUED – Volume of interactions placed into the queue during the interval.
• NUMBER_OF_ITEMS_SERVICED – Volume of interactions handled by agents.
• ITEMS_SERVICED_WITHIN_LOS – Interactions completed inside the target service level.
• ITEMS_NOT_SERVICED_WITHIN_LOS – Interactions that breached the target service level.
• ITEMS_LEFT_TO_BE_SERVICED – Backlog remaining at the close of the interval.
• ITEMS_SERVICED_TODAY – Cumulative count of interactions serviced in the current day.
• NUMBER_AGENTS_WORKING – Actual agent headcount engaged during the minute.
• MINIMUM_NUMBER_OF_AGENTS_REQ – Modelled minimum staffing required to meet the service objective.
• SECURITY_GROUP_ID – Foreign key to FND_SECURITY_GROUPS enforcing row-level access control.

Common Use Cases and Queries

BIX_SERVER_IB supports intraday interaction-blending analytics: service-level attainment, agent-staffing adequacy, queue backlog trends, and channel-mix comparisons. Because the table is minute-grained, typical reporting aggregates to the site, media type, and hour or day.

• Service-level attainment by site and media type: compare ITEMS_SERVICED_WITHIN_LOS against NUMBER_OF_ITEMS_SERVICED grouped by SITE_ID and MEDIA_ITEM_TYPE.
• Staffing gap analysis: contrast NUMBER_AGENTS_WORKING with MINIMUM_NUMBER_OF_AGENTS_REQ to identify under-staffed intervals.
• Backlog monitoring: trend ITEMS_LEFT_TO_BE_SERVICED and NUMBER_OF_ITEMS_QUEUED over MINUTE to detect peak-period build-up.
• Channel performance: rank MEDIA_ITEM_TYPE by LOS breach rate using ITEMS_NOT_SERVICED_WITHIN_LOS.

A representative query joining the fact table to its only documented foreign key target applies the security predicate as follows:

SELECT h.SITE_ID, h.MEDIA_ITEM_TYPE, SUM(h.ITEMS_SERVICED_WITHIN_LOS) / SUM(h.NUMBER_OF_ITEMS_SERVICED) AS svc_level
FROM BIX.BIX_SERVER_IB h, FND_SECURITY_GROUPS g
WHERE h.SECURITY_GROUP_ID = g.SECURITY_GROUP_ID
GROUP BY h.SITE_ID, h.MEDIA_ITEM_TYPE;

Related Objects

The documented relationship data identifies a single outbound foreign key; adjacent BIX objects are inferred from the "Interaction Blending CCI Data" subject area and the shared grain columns.

• FND_SECURITY_GROUPS – Referenced by BIX_SERVER_IB.SECURITY_GROUP_ID; drives row-level security and must be joined for secured reporting.
• BIX_SERVER_IB_PK – The primary-key constraint/index on SERVER_IB_ID.
• BIX site/centre dimension table keyed by SITE_ID, providing site descriptions for the SITE_ID value.
• BIX media/channel dimension keyed by MEDIA_ITEM_TYPE, supplying channel labels.
• BIX LOS category dimension keyed by LOS_CATEGORY_ID and LOS_CATEGORY_DIRECTION.
• Sibling BIX interaction-blending fact tables that share the MINUTE, SITE_ID, and MEDIA_ITEM_TYPE grain.
• BIX ETL or concurrent-program objects that populate and maintain this table from the source Interaction Center data.