Expand All Collapse All
This table contains a different segment of the interaction captured.

InteractionSegmentDetail Table

This table contains a different segment of the interaction captured.

This table contains a different segment of the interaction captured. This is primarily used by the Interaction Detail view in Interaction Center Business Manager Application (ICBM). In general, there will be only one row for an interaction that will be logged here. If the interaction is persisted and recreated with the same InteractionIDKey, we will see two rows with the sequence numbers incremented.

  • Table Type - Historical
  • Last Changed Version - 4.0.106.453
  • Last Changed Reason - 4.0 Release

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.

 4.0.106.453 4.0 Release
SiteID smallint False No

Site ID of the interaction.

 4.0.106.453 4.0 Release
SeqNo tinyint False No

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

 4.0.106.453 4.0 Release
StartDateTimeUTC datetime2 False No

Start date time(UTC) of the interaction segments.

 4.0.106.453 4.0 Release
StartDTOffset int False No

Offset for the StartDateTime.

 4.0.106.453 4.0 Release
ConversationID varchar (24) True No

Conversation ID associated with Email interaction.

 4.0.106.453 4.0 Release
SegmentLog nvarchar (MAX) False No

Multi value URI representation of the interaction history which may be extracted with ICE Lib APIs. Refer to the ICE Lib documentation for more detail about the URI string.

 4.0.106.453 4.0 Release

SQL Constraints

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


Index Name Type Column Name (sort order)
IX_IntxSegDetail_StartDT_UTC Clustered StartDateTimeUTC (Ascending)