Omnichannel Events

This view object provides details about omnichannel events. Events are generated from work objects, which are channel requests that need to be routed to an Agent for assignment.

Data Store Key : CrmAnalyticsAM.ServiceExtractAM.SvcMgmtBiccExtractAM.OmniEventExtractPVO

Primary Keys : EventId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
BUOrgId	The unique identifier of the business unit organization.
ChannelId	The unique identifier of the channel. This is a foreign Key to the Channels object.
ChannelTypeCd	The lookup code that indicates the channel type, such as EMAIL, PHONE, FACEBOOK, and TWITTER.
ContactPartyId	The unique identifier of the customer contact. This is foreign key to the Party view object.
CreatedBy	The user who created the row.
CreationDate	The date and time when the row was created.
DurationMs	The difference between end time and start time in milliseconds.
EndDate	The end date of this event.
EndTime	The end date and time of this event.
EndTimeHh24Mi	A numeric value representing the end time in hours and minutes.
EventId	The unique identifier of the record. This is the primary key for the view object.
EventNameCd	Identifies the lookup code indicating the name of the event.
InteractionId	The unique identifier of the interaction. This is a foreign key to the Interaction view object.
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.
ObjectId	The unique identifier of the business object. This is a foreign key to the view object identified by the object type code.
ObjectTypeCd	The business object this record is associated with. The type determines the table that the identifier refers to.
ObjectVersionNumber	The number of times the row has been updated.
Priority	The priority of the work object associated with this event.
QueueId	The unique identifier of the assigned queue. This is foreign key to the Queue view object.
ResourcePartyId	The unique identifier of the agent. This is a foreign key to the Party view object.
StartDate	The start date of this event.
StartTime	The start date and time of this event.
StartTimeHh24Mi	A numeric value representing the start time in hours and minutes.
StripeCd	The lookup code that indicates the stripe code, such as CRM or HCM.
SubmitDate	The date of submitting the underlying work object.
SubmitTime	The date and time of submitting the underlying work object.
Value	The value associated with the event. The meaning of the value is event specific.
WorkObjectId	The unique identifier of the work object associated with this event.