Jump to: navigation, search


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 Describes the association of a calling list to an outbound campaign.
GROUP_TO_CAMPAIGN_FACT view Describes the association of an agent or place group to an outbound campaign.
PLACE_GROUP_FACT view Describes the membership of places in place groups.
RESOURCE_GROUP_FACT view Describes the membership of resources in resource groups.
RESOURCE_SKILL_FACT view Describes an agent's skills and proficiency levels.

Comment on this article:

blog comments powered by Disqus
This page was last modified on 29 August 2016, at 15:02.