| 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 |
|---|---|---|---|---|---|---|---|---|---|
| FlowExecID | uniqueidentifier | False | Unknown | 4.0.106.453 | 4.0 Release | Flow Exceution ID | Attribute | Interaction Process Automation | |
| CallId | char (10) | False | Unknown | 4.0.106.453 | 4.0 Release | Call ID | Attribute | Interaction Process Automation | |
| CallIdKey | char (18) | False | Unknown | 4.0.106.453 | 4.0 Release | Call Id Key | Attribute | Interaction Process Automation | |
| UserQueueID | nvarchar (50) | False | Unknown | 4.0.106.453 | 4.0 Release | User Queue ID | Attribute | Interaction Process Automation | |
| DateRelated | datetime2 | False | Unknown | 4.0.106.453 | 4.0 Release | Date Related | Attribute | Interaction Process Automation | |
| DateRelatedOffset | int | False | Unknown | 4.0.106.453 | 4.0 Release | Date Related Offset | Fact | Interaction Process Automation | |
| Version | int | False | Unknown | 4.0.106.453 | 4.0 Release | Version | Fact | Interaction Process Automation |
| 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 |
|---|---|---|---|---|---|---|---|---|---|
| FlowExecID | raw (16) | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| CallId | char (10) | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| CallIdKey | char (18) | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| UserQueueID | nvarchar2 (50) | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| DateRelated | timestamp | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| DateRelatedOffset | number | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| Version | integer | False | Unknown | 4.0.106.453 | 4.0 Release |
| Primary Key Name | Type | Column Name (sort order) |
|---|---|---|
| PK_IPA_Related_Interactions | Clustered | FlowExecID (Ascending) CallIdKey (Ascending) |
| Primary Key Name | Column Name (sort order) |
|---|---|
| PK_IPA_Related_Interactions | FlowExecID (Ascending) CallIdKey (Ascending) |
| Foreign Key Name | Column | Reference Table | Reference Column | Indexed |
|---|---|---|---|---|
| FK_IPA_Related_Interactions | FlowExecID | IPA_Flows | FlowExecID | Yes |
| Foreign Key Name | Column | Reference Table | Reference Column | Indexed |
|---|---|---|---|---|
| FK_IPA_Related_Interactions | FlowExecID | IPA_Flows | FlowExecID | Yes |
| Index Name | Type | Column Name (sort order) |
|---|---|---|
| IX_IPA_Related_Interactions_CallIdKey | Non-clustered | CallIdKey (Ascending) |
| Index Name | Column Name (sort order) |
|---|---|
| ix_ipa_rel_int_callidkey | CallIdKey (Ascending) |