| 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 | |
| JobExecID | uniqueidentifier | False | Unknown | 4.0.106.453 | 4.0 Release | Job Execution ID | Attribute | Interaction Process Automation | |
| FlowID | uniqueidentifier | False | Unknown | 4.0.106.453 | 4.0 Release | Flow ID | Attribute | Interaction Process Automation | |
| FlowType | int | False | Unknown | 4.0.106.453 | 4.0 Release | Flow Type | Attribute | Interaction Process Automation | |
| MajorRevision | int | False | Unknown | 4.0.106.453 | 4.0 Release | Major Revision | Fact | Interaction Process Automation | |
| MinorRevision | int | False | Unknown | 4.0.106.453 | 4.0 Release | Minor Revision | Fact | Interaction Process Automation | |
| LaunchType | smallint | False | Unknown | 4.0.106.453 | 4.0 Release | Launch Type | Attribute | Interaction Process Automation | |
| LaunchSource | nvarchar (256) | False | Unknown | 4.0.106.453 | 4.0 Release | Launch Source | Attribute | Interaction Process Automation | |
| LaunchSourceIndivID | char (22) | True | Unknown | 4.0.106.453 | 4.0 Release | Launch Source Individual ID | Attribute | Interaction Process Automation | |
| CurrentStateExecID | uniqueidentifier | True | Unknown | 4.0.106.453 | 4.0 Release | Current State Execution ID | Attribute | Interaction Process Automation | |
| InitialStateExecID | uniqueidentifier | True | Unknown | 4.0.106.453 | 4.0 Release | Initial State 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 | |
| StatusID | smallint | False | Unknown | 4.0.106.453 | 4.0 Release | Status ID | Attribute | Interaction Process Automation | |
| StatusModifiedDT | datetime2 | True | Unknown | 4.0.106.453 | 4.0 Release | Status Modified DT | Attribute | Interaction Process Automation | |
| StatusModifiedDTOffset | int | True | Unknown | 4.0.106.453 | 4.0 Release | Status Modified DT Offset | Fact | Interaction Process Automation | |
| DynamicDetails | nvarchar (MAX) | True | Unknown | 4.0.106.453 | 4.0 Release | Dynamic Details | Attribute | Interaction Process Automation | |
| NumericID | int | True | Unknown | 4.0.106.453 | 4.0 Release | Numeric ID | Attribute | Interaction Process Automation | |
| XMLResultdata | xml | True | Unknown | 4.0.106.453 | 4.0 Release | XML Result Data | Attribute | Interaction Process Automation | |
| CompleteReason | nvarchar (256) | True | Unknown | 4.0.106.453 | 4.0 Release | Complete Reason | Attribute | Interaction Process Automation | |
| StartDateTime | datetime2 | 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 | datetime2 | 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 |
|---|---|---|---|---|---|---|---|---|---|
| StartDateTime | timestamp | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| FlowExecID | raw (16) | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| FlowID | raw (16) | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| NumericID | integer | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| LaunchType | number | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| LaunchSource | nvarchar2 (256) | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| LaunchSourceIndivID | char (22) | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| StatusID | number | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| MajorRevision | integer | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| JobExecID | raw (16) | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| FlowType | integer | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| MinorRevision | integer | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
| CurrentStateExecID | raw (16) | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| InitialStateExecID | raw (16) | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| InitialActionExecID | raw (16) | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| StatusModifiedDT | timestamp | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| StatusModifiedDTOffset | integer | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| DynamicDetails | nclob | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| XMLResultdata | xmltype | True | Unknown | 4.0.106.453 | 4.0 Release | ||||
| CompleteReason | nvarchar2 (256) | True | 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_Flows | Non-clustered | FlowExecID (Ascending) |
| Primary Key Name | Column Name (sort order) |
|---|---|
| PK_IPA_Flows | startdatetime (Ascending) FlowExecID (Ascending) |
| Foreign Key Name | Column | Reference Table | Reference Column | Indexed |
|---|---|---|---|---|
| FK_IPA_Flows_JobExecID | JobExecID | IPA_Jobs | JobExecID | Yes |
| FK_IPA_Flows_LaunchSourceIndivID | LaunchSourceIndivID | Individual | IndivID | Yes |
| FK_IPA_Flows_InitActionExecID | InitialActionExecID | IPA_Actions | ActionExecID | Yes |
| Foreign Key Name | Column | Reference Table | Reference Column | Indexed |
|---|---|---|---|---|
| FK_IPA_FLOWS_LNCHSRCINDIVID | LaunchSourceIndivID | Individual | IndivID | Yes |
| FK_IPA_Flows_JobExecID | JobExecID | IPA_Jobs | JobExecID | Yes |
| FK_IPA_Flows_InitActionExecID | InitialActionExecID | IPA_Actions | ActionExecID | Yes |
| Index Name | Type | Column Name (sort order) |
|---|---|---|
| IX_IPA_Flows_FlowID | Non-clustered | FlowID (Ascending) |
| IX_IPA_Flows_LaunchSource | Non-clustered | LaunchSource (Ascending) |
| IX_IPA_Flows_LaunchSourceIndivID | Non-clustered | LaunchSourceIndivID (Ascending) |
| IX_IPA_Flows_StartDateTime | Clustered | StartDateTime (Ascending) |
| Index Name | Column Name (sort order) |
|---|---|
| IX_IPA_Flows_FlowID | FlowID (Ascending) |
| IX_IPA_Flows_LaunchSource | NLS_LOWER(LAUNCHSOURCE) (Ascending) |
| ix_ipa_flows_lnchsrcindivid | LaunchSourceIndivID (Ascending) |
| IX_IPA_Flows_StartDateTime | StartDateTime (Ascending) |