Expand All Collapse All
Interaction Conversation Attribute

IntxAttributeCID Table

Interaction Conversation Attribute

This table stores the details of e-mail conversations (interactions) when the IC Server has Conversation IDs enabled.

  • 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
IntxID char (22) False No

This column stores GUID (Globally Unique Identifier) to uniquely identify an interaction segment. Refer to the IntxSegment table to find matching interaction segment identifiers and other interaction segment specific details.

 4.0.106.453 4.0 Release
Intx_Part_ID char (22) False No

This column stores GUID (Globally Unique Identifier) to uniquely identify an interaction segment participant. Refer to the Intx_Participant table to find matching participant identifiers and other participant specific details.

 4.0.106.453 4.0 Release
ConversationID char (39) False No

This column stores the conversation Identifier for email interactions when the IC Server has Conversation IDs enabled. Conversation identifiers are displayed in the subject line of emails. They are used to implement threaded email interactions. E-mail threads can be seen on the Conversation History tab of the Related Items view in Interaction Desktop.

 4.0.106.453 4.0 Release
ConversationAttribute nvarchar (4000) True No

This column stores an attribute on email interactions other than Conversation Identifier (CID).

 4.0.106.453 4.0 Release
EventDateTime datetime2 False No

This column stores the start date time-stamp of the segment that has the conversation identifier attribute set.

 4.0.106.453 4.0 Release
ExtID nvarchar (256) True Yes

This column stores the external identifier for an individual who is a participant in an email interaction.

 4.0.106.453 4.0 Release
Version int False No

Version for an IntxAttributeCID record. Reserved for future use.

 4.0.106.453 4.0 Release

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_IntxAttributeCID Non-clustered IntxID (Ascending)
Intx_Part_ID (Ascending)
ConversationID (Ascending)


Index Name Type Column Name (sort order)
IX_Intx_AttrCID_EventDT Clustered EventDateTime (Ascending)