| 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 |
|---|---|---|---|---|---|---|---|---|---|
| StateExecID | uniqueidentifier | False | Unknown | 4.0.106.453 | 4.0 Release | State Execution ID | Attribute | Interaction Process Automation | |
| FlowExecID | uniqueidentifier | False | Unknown | 4.0.106.453 | 4.0 Release | Flow Execution ID | Attribute | Interaction Process Automation | |
| StateID | uniqueidentifier | False | Unknown | 4.0.106.453 | 4.0 Release | State ID | Attribute | Interaction Process Automation | |
| InitialActionExecID | uniqueidentifier | True | Unknown | 4.0.106.453 | 4.0 Release | Initial Action Execution ID | Attribute | Interaction Process Automation | |
| ParentActionExecID | uniqueidentifier | True | Unknown | 4.0.106.453 | 4.0 Release | Parent Action Execution ID | Attribute | 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 |
|---|---|---|---|---|---|---|---|---|---|
| StateExecID | raw (16) | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| FlowExecID | raw (16) | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| StateID | raw (16) | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| InitialActionExecID | raw (16) | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| ParentActionExecID | raw (16) | 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_States | Clustered | StateExecID (Ascending) |
| Primary Key Name | Column Name (sort order) |
|---|---|
| PK_IPA_States | StateExecID (Ascending) |
| Foreign Key Name | Column | Reference Table | Reference Column | Indexed |
|---|---|---|---|---|
| FK_IPA_States_FlowExecID | FlowExecID | IPA_Flows | FlowExecID | Yes |
| FK_IPA_States_ParentActionExecID | ParentActionExecID | IPA_Actions | ActionExecID | Yes |
| Foreign Key Name | Column | Reference Table | Reference Column | Indexed |
|---|---|---|---|---|
| FK_IPA_States_FlowExecID | FlowExecID | IPA_Flows | FlowExecID | Yes |
| FK_IPA_STATES_PARACTEXECID | ParentActionExecID | IPA_Actions | ActionExecID | Yes |