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.
| 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 |
| 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 | number | False | No | Site ID of the interaction. |
4.0.106.453 | 4.0 Release | |||
| SeqNo | number | 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 | number | True | No | Custom number column. |
4.0.106.453 | 4.0 Release | |||
| CustomNum2 | number | True | No | Custom number column. |
4.0.106.453 | 4.0 Release | |||
| CustomNum3 | number | True | No | Custom number column. |
4.0.106.453 | 4.0 Release | |||
| CustomNum4 | number | True | No | Custom number column. |
4.0.106.453 | 4.0 Release | |||
| CustomNum5 | number | True | No | Custom number column. |
4.0.106.453 | 4.0 Release | |||
| CustomNum6 | number | True | No | Custom number column. |
4.0.106.453 | 4.0 Release | |||
| CustomNum7 | number | True | No | Custom number column. |
4.0.106.453 | 4.0 Release | |||
| CustomNum8 | number | True | No | Custom number column. |
4.0.106.453 | 4.0 Release | |||
| CustomNum9 | number | True | No | Custom number column. |
4.0.106.453 | 4.0 Release | |||
| CustomString1 | nvarchar2 (50) | True | Depends on customer usage | Custom number column. |
4.0.106.453 | 4.0 Release | |||
| CustomString2 | nvarchar2 (50) | True | Depends on customer usage | Custom number column. |
4.0.106.453 | 4.0 Release | |||
| CustomString3 | nvarchar2 (50) | True | Depends on customer usage | Custom number column. |
4.0.106.453 | 4.0 Release | |||
| CustomString4 | nvarchar2 (50) | True | Depends on customer usage | Custom number column. |
4.0.106.453 | 4.0 Release | |||
| CustomString5 | nvarchar2 (50) | True | Depends on customer usage | Custom number column. |
4.0.106.453 | 4.0 Release | |||
| CustomString6 | nvarchar2 (50) | True | Depends on customer usage | Custom number column. |
4.0.106.453 | 4.0 Release | |||
| CustomString7 | nvarchar2 (50) | True | Depends on customer usage | Custom number column. |
4.0.106.453 | 4.0 Release | |||
| CustomString8 | nvarchar2 (50) | True | Depends on customer usage | Custom number column. |
4.0.106.453 | 4.0 Release | |||
| CustomString9 | nvarchar2 (50) | True | Depends on customer usage | Custom number column. |
4.0.106.453 | 4.0 Release | |||
| CustomDateTime | timestamp | True | No | Custom DateTime column. |
4.0.106.453 | 4.0 Release | |||
| CustomDateTimeGMT | timestamp | True | No | Custom DateTime column, in GMT format. |
4.0.106.453 | 4.0 Release | |||
| I3TimeStampGMT | timestamp | False | No | Log timestamps. |
4.0.106.453 | 4.0 Release |
| Primary Key Name | Type | Column Name (sort order) |
|---|---|---|
| PK_InteractionCustomAttributes | Non-clustered | InteractionIDKey (Ascending) SiteID (Ascending) SeqNo (Ascending) |
| Primary Key Name | Column Name (sort order) |
|---|---|
| PK_InteractionCustomAttributes | 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) |
| Index Name | Column Name (sort order) |
|---|---|
| ix_interactioncas_i3ts_gmt | I3TimeStampGMT (Ascending) |
| IX_InteractCAS_INCL | SiteID (Ascending) InteractionIDKey () |