Interaction Aggregations

The interaction aggregation view object summarizes interaction metrics, such as number of interactions for this week, month, agent, channel and number of interactions not associated to a service request.

Data Store Key : CrmAnalyticsAM.ServiceExtractAM.SvcMgmtBiccExtractAM.InteractionAggExtractPVO

Primary Keys : InteractionsAggId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
AgentId	The agent engaged in the interaction. This is a foreign key to the Party view object.
CalMonth	The unique identifier of the month.
CalWeek	The unique identifier of the week.
ChannelId	The unique identifier of the channel used as a foreign Key to the Channels object.
CreatedBy	The user who created the row.
CreationDate	The date and time when the row was created.
Interactions	The number of interactions aggregated by week, month, agent and channel.
InteractionsAggId	The unique identifier of the record. This is the primary key for the view object.
InteractionsNoSr	The number of interactions not associated to a service request, aggregated by week, month, agent, and channel.
LastUpdateDate	The date and time when the row was last updated.
LastUpdateLogin	The session login of the user who last updated the row.
LastUpdatedBy	The user who last updated the row.
ObjectVersionNumber	The number of times the row has been updated.
StripeCd	The lookup code that indicates the stripe code, such as CRM or HCM.