Expand All Collapse All
Interaction Custom Attributes

InteractionCustomAttributes Table

Interaction Custom Attributes

This is a table that contains custom attributes that need to be captured for an interaction. Prior to 4.0, we used to have custom attributes as part of the Calldetail table. Now those attributes are moved to a stand alone table. The advantage is now we have 12 custom columns instead of 6. The IC Administrator can configure to log up to 12 custom attributes for any interaction.

  • 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
CustomNum1 int True No

Custom number column.

 4.0.106.453 4.0 Release
CustomNum2 int True No

Custom number column.

 4.0.106.453 4.0 Release
CustomNum3 int True No

Custom number column.

 4.0.106.453 4.0 Release
CustomNum4 int True No

Custom number column.

 4.0.106.453 4.0 Release
CustomNum5 int True No

Custom number column.

 4.0.106.453 4.0 Release
CustomNum6 int True No

Custom number column.

 4.0.106.453 4.0 Release
CustomNum7 int True No

Custom number column.

 4.0.106.453 4.0 Release
CustomNum8 int True No

Custom number column.

 4.0.106.453 4.0 Release
CustomNum9 int True No

Custom number column.

 4.0.106.453 4.0 Release
CustomString1 nvarchar (50) True Depends on customer usage

Custom number column.

 4.0.106.453 4.0 Release
CustomString2 nvarchar (50) True Depends on customer usage

Custom number column.

 4.0.106.453 4.0 Release
CustomString3 nvarchar (50) True Depends on customer usage

Custom number column.

 4.0.106.453 4.0 Release
CustomString4 nvarchar (50) True Depends on customer usage

Custom number column.

 4.0.106.453 4.0 Release
CustomString5 nvarchar (50) True Depends on customer usage

Custom number column.

 4.0.106.453 4.0 Release
CustomString6 nvarchar (50) True Depends on customer usage

Custom number column.

 4.0.106.453 4.0 Release
CustomString7 nvarchar (50) True Depends on customer usage

Custom number column.

 4.0.106.453 4.0 Release
CustomString8 nvarchar (50) True Depends on customer usage

Custom number column.

 4.0.106.453 4.0 Release
CustomString9 nvarchar (50) True Depends on customer usage

Custom number column.

 4.0.106.453 4.0 Release
CustomDateTime datetime2 True No

Custom DateTime column.

 4.0.106.453 4.0 Release
CustomDateTimeGMT datetime2 True No

Custom DateTime column, in GMT format.

 4.0.106.453 4.0 Release
I3TimeStampGMT datetime2 False No

Log timestamps.

 4.0.106.453 4.0 Release

SQL Constraints

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


Index Name Type Column Name (sort order)
I3TimeStampGMT Clustered I3TimeStampGMT (Ascending)
IX_IntxCustomAttr_SiteID_IntxIDKey Non-clustered SiteID (Ascending)