Expand All Collapse All

IPA_Related_Interactions 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 Exceution ID Attribute Interaction Process Automation
CallId char (10) False Unknown

4.0.106.453 4.0 Release Call ID Attribute Interaction Process Automation
CallIdKey char (18) False Unknown

4.0.106.453 4.0 Release Call Id Key Attribute Interaction Process Automation
UserQueueID nvarchar (50) False Unknown

4.0.106.453 4.0 Release User Queue ID Attribute Interaction Process Automation
DateRelated datetime2 False Unknown

4.0.106.453 4.0 Release Date Related Attribute Interaction Process Automation
DateRelatedOffset int False Unknown

4.0.106.453 4.0 Release Date Related Offset Fact 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_Related_Interactions Clustered FlowExecID (Ascending)
CallIdKey (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IPA_Related_Interactions FlowExecID IPA_Flows FlowExecID Yes

Index Name Type Column Name (sort order)
IX_IPA_Related_Interactions_CallIdKey Non-clustered CallIdKey (Ascending)