| 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 Execution ID | Attribute | Interaction Process Automation | |
| ActionExecID | uniqueidentifier | False | Unknown | 4.0.106.453 | 4.0 Release | Action Execution ID | Attribute | Interaction Process Automation | |
| DataElementID | nvarchar (36) | False | Unknown | 4.0.106.453 | 4.0 Release | Data Element ID | Attribute | Interaction Process Automation | |
| DataElementValue | xml | True | Unknown | 4.0.106.453 | 4.0 Release | Data Element Value | Attribute | Interaction Process Automation | |
| LastModifiedDateTime | datetime | False | Unknown | 4.0.106.453 | 4.0 Release | Last Modified Date Time | 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 |
|---|---|---|---|---|---|---|---|---|---|
| FlowExecID | raw (16) | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| ActionExecID | raw (16) | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| DataElementID | nvarchar2 (36) | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| DataElementValue | xmltype | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| LastModifiedDateTime | timestamp | 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_FlowData_Audit | Clustered | FlowExecID (Ascending) ActionExecID (Ascending) DataElementID (Ascending) |
| Primary Key Name | Column Name (sort order) |
|---|---|
| PK_IPA_FlowData_Audit | FlowExecID (Ascending) ActionExecID (Ascending) DataElementID (Ascending) |
| Foreign Key Name | Column | Reference Table | Reference Column | Indexed |
|---|---|---|---|---|
| FK_IPA_FlowData_Audit_FlowExecID | FlowExecID | IPA_Flows | FlowExecID | Yes |
| FK_IPA_FlowData_Audit_ActionExecID | ActionExecID | IPA_Actions | ActionExecID | Yes |
| Foreign Key Name | Column | Reference Table | Reference Column | Indexed |
|---|---|---|---|---|
| FK_IPA_FLOWDATA_AUDIT_EXECID | FlowExecID | IPA_Flows | FlowExecID | Yes |
| FK_IPA_FLOWDATA_AUDIT_ACTIONID | ActionExecID | IPA_Actions | ActionExecID | Yes |