Expand All Collapse All

flowexec_Flows Table

  • Table Type - Historical
  • Last Changed Version - 17.4.0.0
  • Last Changed Reason - Added clustered index, CX_Fe_Flows, for IC-143292.

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
ExecID uniqueidentifier False Unknown

15.3.0.384 Added for PASv2. Execution ID Attribute Interaction Process Automation
FlowExecID uniqueidentifier False Unknown

15.3.0.384 Added for PASv2. Flow Execution ID Attribute Interaction Process Automation
StorageOwnerID uniqueidentifier False Unknown

15.3.0.384 Added for PASv2. Storage Owner ID Attribute Interaction Process Automation
Type smallint False Unknown

15.3.0.384 Added for PASv2. Type Attribute Interaction Process Automation
Attributes nvarchar (MAX) True Unknown

15.3.0.384 Added for PASv2. Attributes Attribute Interaction Process Automation
FlowConfigID uniqueidentifier False Unknown

15.3.0.384 Added for PASv2. Flow Config ID Attribute Interaction Process Automation
FlowConfigRev nvarchar (30) False Unknown

15.3.0.384 Added for PASv2. Flow Config Revision Attribute Interaction Process Automation
LaunchMode smallint False Unknown

15.3.0.384 Added for PASv2. Launch Mode Attribute Interaction Process Automation

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_flowexec_Flows Non-clustered ExecID (Ascending)


Index Name Type Column Name (sort order)
CX_Fe_Flows Clustered StorageOwnerID (Ascending)
FlowExecID (Ascending)
UX_fe_Flows_FlowExecId Non-clustered FlowExecID (Ascending)