| 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 |
|---|---|---|---|---|---|---|---|---|---|
| WorkItemExecID | uniqueidentifier | False | Unknown | 4.0.106.453 | 4.0 Release | Work Item Execution 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 | |
| AppSegmentID | smallint | False | Unknown | 4.0.106.453 | 4.0 Release | App Segment ID | Attribute | Interaction Process Automation | |
| DestinationQueueType | smallint | False | Unknown | 4.0.106.453 | 4.0 Release | Destination Queue Type | Attribute | Interaction Process Automation | |
| DestinationQueueID | nvarchar (1024) | False | Unknown | 4.0.106.453 | 4.0 Release | Destination Queue ID | Attribute | Interaction Process Automation | |
| DestinationQueueHandling | smallint | False | Unknown | 4.0.106.453 | 4.0 Release | Destination Queue Handling | Attribute | Interaction Process Automation | |
| TransferUserID | nvarchar (50) | True | Unknown | 4.0.106.453 | 4.0 Release | Transfer User ID | Attribute | Interaction Process Automation | |
| SegmentStartDate | datetime2 | False | Unknown | 4.0.106.453 | 4.0 Release | Segment Start Date | Attribute | Interaction Process Automation | |
| SegmentStartDateOffset | int | False | Unknown | 4.0.106.453 | 4.0 Release | Segment Start Date Offset | Fact | Interaction Process Automation | |
| SegmentEndDate | datetime2 | True | Unknown | 4.0.106.453 | 4.0 Release | Segment End Date | Attribute | Interaction Process Automation | |
| SegmentEndDateOffset | int | True | Unknown | 4.0.106.453 | 4.0 Release | Segment End Date Offset | Fact | Interaction Process Automation | |
| PickupDate | datetime2 | True | Unknown | 4.0.106.453 | 4.0 Release | Pickup Date | Attribute | Interaction Process Automation | |
| PickupDateOffset | int | True | Unknown | 4.0.106.453 | 4.0 Release | Pickup Date Offset | Fact | Interaction Process Automation | |
| ConnectedDurationSeconds | int | True | Unknown | 4.0.106.453 | 4.0 Release | Connected Duration Seconds | Fact | Interaction Process Automation | |
| ConnectedUser | nvarchar (50) | True | Unknown | 4.0.106.453 | 4.0 Release | Connected User | Attribute | Interaction Process Automation | |
| HeldDurationSeconds | int | True | Unknown | 4.0.106.453 | 4.0 Release | Held Duration Seconds | Fact | Interaction Process Automation | |
| CompleteReason | int | False | Unknown | 4.0.106.453 | 4.0 Release | Complete Reason | Fact | Interaction Process Automation | |
| UsesSkills | nvarchar (512) | True | Unknown | 4.0.106.453 | 4.0 Release | Uses Skills | Attribute | Interaction Process Automation | |
| Priority | smallint | True | Unknown | 4.0.106.453 | 4.0 Release | Priority | Attribute | 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 |
|---|---|---|---|---|---|---|---|---|---|
| WorkItemExecID | 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 | ||||
| AppSegmentID | number | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| DestinationQueueType | number | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| DestinationQueueID | nvarchar2 (1024) | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| DestinationQueueHandling | number | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| TransferUserID | nvarchar2 (50) | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| SegmentStartDate | timestamp | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| SegmentStartDateOffset | int | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| SegmentEndDate | timestamp | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| SegmentEndDateOffset | int | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| PickupDate | timestamp | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| PickupDateOffset | int | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| ConnectedDurationSeconds | int | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| ConnectedUser | nvarchar2 (50) | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| HeldDurationSeconds | int | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| CompleteReason | int | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| UsesSkills | nvarchar2 (512) | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| Priority | number | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| Version | int | False | Unknown | 4.0.106.453 | 4.0 Release |
| Primary Key Name | Type | Column Name (sort order) |
|---|---|---|
| PK_IPA_Work_Item_Interactions | Clustered | WorkItemExecID (Ascending) CallIDKey (Ascending) AppSegmentID (Ascending) |
| Primary Key Name | Column Name (sort order) |
|---|---|
| PK_IPA_Work_Item_Interactions | WorkItemExecID (Ascending) CallIDKey (Ascending) AppSegmentID (Ascending) |