Expand All Collapse All
This is a table summarizing extended attributes of the interaction.

InteractionSummaryEx Table

This is a table summarizing extended attributes of the interaction.

This is a table summarizing extended attributes of the interaction. In general, only one row for an interaction will be logged here if necessary. If the interaction is persisted and recreated with the same InteractionIDKey, we will see two rows with sequence numbers incremented.

  • Table Type - Historical
  • Last Changed Version - 20.1.0.0
  • Last Changed Reason - IC-155825

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
InteractionIDKey char (18) False No

Interaction Key

 20.1.0.0 IC-155825
SiteID smallint False No

SiteID of the Interaction where it disconnected.

 20.1.0.0 IC-155825
SeqNo tinyint False No

SeqNo will only be used when the interaction is persisted and recreated with the same InteractionIDKey.

 20.1.0.0 IC-155825
StartDateTimeUTC datetime2 False No

StartDateTime (UTC) for the Interaction ID.

 20.1.0.0 IC-155825
StartDTOffset int False No

Offset to Server local time, in milliseconds, for the UTC StartDateTime.

 20.1.0.0 IC-155825
CallEventLog nvarchar (MAX) False No

Call Event log

 20.1.0.0 IC-155825

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_InteractionSummaryEx Non-clustered InteractionIDKey (Ascending)
SiteID (Ascending)
SeqNo (Ascending)