Jump to: navigation, search

GIM-SubjArea-Facts.png

Facts Subject Area

In addition to referring to dimension tables, some fact tables refer to other fact tables. This subject area diagram depicts the interrelationships between subject area fact tables.

Facts Subject Area View Large

Subject Area Dimensional Model Tables

Table/View Description
CALLBACK_FACT Represents a callback-related event.
CALLING_LIST_METRIC_FACT Represents a snapshot of outbound campaign calling list metrics.
CAMPAIGN_GROUP_SESSION_FACT Represents the loading and unloading of an outbound campaign group session.
CAMPAIGN_GROUP_STATE_FACT Represents the states of a campaign group session.
CONTACT_ATTEMPT_FACT Represents a processing attempt for an outbound campaign contact.
INTERACTION_FACT Represents interactions from the perspective of a customer experience.
INTERACTION_RESOURCE_FACT Represents a summary of each attempt to handle an interaction. It encompasses the mediation process that is required to offer the interaction to a target handling resource, as well as the activities of that target handling resource.
IXN_RESOURCE_STATE_FACT Provides detailed interaction-handling state information in the context of an interaction resource fact. It facilitates interval-based reporting for interaction-related resource states.
MEDIATION_SEGMENT_FACT Describes interaction activity with respect to ACD queues, virtual queues, interaction queues, and interaction workbins.
SM_MEDIA_NEUTRAL_STATE_FACT Represents agent resource states, summarized across all media.
SM_RES_SESSION_FACT Represents agent resource media sessions from login to logout, summarized to the media type.
SM_RES_STATE_FACT Represents agent resource states, summarized to the media type.
SM_RES_STATE_REASON_FACT Represents agent resource state reasons, summarized to the media type.
CALLING_LIST_TO_CAMP_FACT view Each row describes the association of a calling list to an outbound campaign. The grain of the fact is an accumulating snapshot that represents the duration of the association between a calling list and a campaign.
GROUP_TO_CAMPAIGN_FACT view Each row describes the association of an agent or place group to an outbound campaign. The grain of the fact is an accumulating snapshot that represents the duration of the association between an agent or place group and a campaign.
PLACE_GROUP_FACT view Each row describes the membership of one place in one place group. The grain of the fact is an accumulating snapshot that represents the duration of the configured membership, which is identified by its ID in the Configuration Database.
RESOURCE_GROUP_FACT view Each row describes the membership of one resource (routing point, queue, or agent) in one resource group. The grain of the fact is an accumulating snapshot that represents the duration of the configured membership, which is identified by its ID in the configuration database.
RESOURCE_SKILL_FACT view Each row describes one skill at a particular proficiency level that one agent possesses. The grain of the fact is an accumulating snapshot that represents the duration of the configured skill and proficiency, which are identified by a unique ID in the configuration database.

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 10 August 2017, at 06:40.