| 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 |
|---|---|---|---|---|---|---|---|---|---|
| TaskExecID | uniqueidentifier | False | Unknown | 4.0.106.453 | 4.0 Release | Task Execution ID | Attribute | Interaction Process Automation | |
| FlowExecID | uniqueidentifier | False | Unknown | 4.0.106.453 | 4.0 Release | Flow Execution ID | Attribute | Interaction Process Automation | |
| TaskID | uniqueidentifier | False | Unknown | 4.0.106.453 | 4.0 Release | Task ID | Attribute | Interaction Process Automation | |
| ParentActionExecID | uniqueidentifier | False | Unknown | 4.0.106.453 | 4.0 Release | Parent Action Execution ID | Attribute | Interaction Process Automation | |
| ParentStateExecID | uniqueidentifier | True | Unknown | 4.0.106.453 | 4.0 Release | Parent State Execution ID | Attribute | Interaction Process Automation | |
| ParentTaskExecID | uniqueidentifier | True | Unknown | 4.0.106.453 | 4.0 Release | Parent Task Execution ID | Attribute | Interaction Process Automation | |
| InitialActionExecID | uniqueidentifier | True | Unknown | 4.0.106.453 | 4.0 Release | Initial Action Execution ID | Attribute | Interaction Process Automation | |
| TaskTypeID | int | False | Unknown | 4.0.106.453 | 4.0 Release | Task Type ID | Attribute | Interaction Process Automation | |
| TaskOutput | nvarchar (128) | True | Unknown | 4.0.106.453 | 4.0 Release | Task Output | Attribute | Interaction Process Automation | |
| DueDateTime | datetime | True | Unknown | 4.0.106.453 | 4.0 Release | Due Date Time | Attribute | Interaction Process Automation | |
| DueDateTimeOffSet | int | True | Unknown | 4.0.106.453 | 4.0 Release | Due Date Time Offset | Fact | Interaction Process Automation | |
| StartDateTime | datetime | False | Unknown | 4.0.106.453 | 4.0 Release | Start Date Time | Attribute | Interaction Process Automation | |
| StartDateTimeOffset | int | False | Unknown | 4.0.106.453 | 4.0 Release | Start Date Time Offset | Fact | Interaction Process Automation | |
| EndDateTime | datetime | True | Unknown | 4.0.106.453 | 4.0 Release | End Date Time | Attribute | Interaction Process Automation | |
| EndDateTimeOffset | int | True | Unknown | 4.0.106.453 | 4.0 Release | End Date Time 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 |
|---|---|---|---|---|---|---|---|---|---|
| TaskExecID | raw (16) | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| FlowExecID | raw (16) | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| TaskID | raw (16) | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| ParentActionExecID | raw (16) | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| ParentStateExecID | raw (16) | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| ParentTaskExecID | raw (16) | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| InitialActionExecID | raw (16) | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| TaskTypeID | integer | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| TaskOutput | nvarchar2 (128) | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| DueDateTime | timestamp | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| DueDateTimeOffSet | integer | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| StartDateTime | timestamp | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| StartDateTimeOffset | integer | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| EndDateTime | timestamp | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| EndDateTimeOffset | integer | True | 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_Tasks | Clustered | TaskExecID (Ascending) |
| Primary Key Name | Column Name (sort order) |
|---|---|
| PK_IPA_Tasks | TaskExecID (Ascending) |
| Foreign Key Name | Column | Reference Table | Reference Column | Indexed |
|---|---|---|---|---|
| FK_IPA_Tasks_FlowExecID | FlowExecID | IPA_Flows | FlowExecID | Yes |
| FK_IPA_Tasks_ParentStateExecID | ParentStateExecID | IPA_States | StateExecID | Yes |
| FK_IPA_Tasks_ParentTaskExecID | ParentTaskExecID | IPA_Tasks | TaskExecID | Yes |
| Foreign Key Name | Column | Reference Table | Reference Column | Indexed |
|---|---|---|---|---|
| FK_IPA_Tasks_FlowExecID | FlowExecID | IPA_Flows | FlowExecID | Yes |
| fk_ipa_tasks_parstateexecid | ParentStateExecID | IPA_States | StateExecID | Yes |
| fk_ipa_tasks_partaskexecid | ParentTaskExecID | IPA_Tasks | TaskExecID | Yes |
| Index Name | Type | Column Name (sort order) |
|---|---|---|
| IX_IPA_Tasks_TaskID | Non-clustered | TaskID (Ascending) |
| Index Name | Column Name (sort order) |
|---|---|
| IX_IPA_Tasks_TaskID | TaskID (Ascending) |