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 | |
Notes | nvarchar (1024) | False | Unknown | 4.0.106.453 | 4.0 Release | Notes | Attribute | Interaction Process Automation | |
ICUserID | nvarchar (50) | False | Unknown | 4.0.106.453 | 4.0 Release | IC User ID | Attribute | Interaction Process Automation | |
LastModifiedDateTime | datetime2 | False | Unknown | 4.0.106.453 | 4.0 Release | Last Modified Date Time | Attribute | Interaction Process Automation | |
LastModifiedDTOffset | int | False | Unknown | 4.0.106.453 | 4.0 Release | Last Modified 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 |
---|---|---|---|---|---|---|---|---|---|
FlowExecID | raw (16) | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
Notes | nvarchar2 (1024) | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
ICUserID | nvarchar2 (50) | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
LastModifiedDateTime | timestamp | False | Unknown | 4.0.106.453 | 4.0 Release | ||||
LastModifiedDTOffset | integer | 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_Flow_Notes | Clustered | FlowExecID (Ascending) LastModifiedDateTime (Ascending) |
Primary Key Name | Column Name (sort order) |
---|---|
PK_IPA_Flow_Notes | FlowExecID (Ascending) LastModifiedDateTime (Ascending) |
Foreign Key Name | Column | Reference Table | Reference Column | Indexed |
---|---|---|---|---|
FK_IPA_Flow_Notes_FlowExecID | FlowExecID | IPA_Flows | FlowExecID | Yes |
Foreign Key Name | Column | Reference Table | Reference Column | Indexed |
---|---|---|---|---|
FK_IPA_Flow_Notes_FlowExecID | FlowExecID | IPA_Flows | FlowExecID | Yes |