Expand All Collapse All

IPA_FlowData_Audit Table

  • Table Type - Historical
  • Last Changed Version - 4.0.106.453
  • Last Changed Reason - 4.0 Release

SQL Column Definitions

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

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_IPA_FlowData_Audit Clustered 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