Expand All Collapse All
Abandon Exception Events

EE_AbandonEvents Table

Abandon Exception Events

Stores information about all the interactions that were abandoned in queue.

  • Table Type - Historical
  • Last Changed Version - 17.1.0.324
  • Last Changed Reason - Added for abandon exception events.

SQL Column Definitions

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason CX Insights Name CX Insights Type CX Insights Folder Name
SerialKey uniqueidentifier False No

Unique Event ID - GUID

 17.1.0.324 Added for abandon exception events.
InteractionIDKey char (18) False No

Interaction ID key.

 17.1.0.324 Added for abandon exception events.
SiteID smallint False No

Site ID of the Interaction where the exception is captured

 17.1.0.324 Added for abandon exception events.
EventDateTimeUTC datetime2 False No

Event date/time (UTC) when the exception was captured.

 17.1.0.324 Added for abandon exception events.
EventDTOffset int False No

Offset to Server local time, in milliseconds, for the UTC event date/time

 17.1.0.324 Added for abandon exception events.
SourceQueueType smallint False No

Enum of Source Queue Type :

(i.e. System = 11, User = 9, Station = 3, Workgroup =10, Orbit = 184)

 17.1.0.324 Added for abandon exception events.
SourceQueueId bigint False No

Queue Name ID for captured exception.

 17.1.0.324 Added for abandon exception events.
TimeInQueue bigint False No

Duration from queue entry until remote disconnect without being connected in milliseconds.

 17.1.0.324 Added for abandon exception events.

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_AbandonEvents Non-clustered SerialKey (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_EE_AbandonEvents_SrcQID SourceQueueId QueueNameLookup QueueId Yes

Index Name Type Column Name (sort order)
IX_AbandonEventsInc Non-clustered InteractionIDKey (Ascending)
EventDateTimeUTC (Ascending)
SourceQueueId (Ascending)