Expand All Collapse All
Interaction Process Automation Data

Interaction Process Automation Data

New schema dbo have been created for Interaction Process Automation related tables, sprocs, views and triggers.


IPA_Flows Table

Launch source, dynamic details, initial action and initial state of IPA flow are stored in IPA_Flows table.

IPA_Flows 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
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

IPA_Flows Constraints

Primary Key Name Type Column Name (sort order)
PK_IPA_Flows Non-clustered 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

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)

IPA_Actions Table

IPA_Actions table is ued to store the IPA action id, action type, action output. Error description and error resolution argumnets are also stored in IPA_Actions table.

IPA_Actions 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
ActionExecID uniqueidentifier False Unknown

4.0.106.453 4.0 Release Action Execution ID Attribute Interaction Process Automation
ActionID uniqueidentifier False Unknown

4.0.106.453 4.0 Release Action ID Attribute Interaction Process Automation
ParentActionExecID uniqueidentifier True Unknown

4.0.106.453 4.0 Release Parent Action Execution ID Attribute Interaction Process Automation
PredecessorActionID uniqueidentifier True Unknown

4.0.106.453 4.0 Release Predecessor Action ID Attribute Interaction Process Automation
ActionType nvarchar (128) False Unknown

4.0.106.453 4.0 Release Action Type Attribute Interaction Process Automation
StartDateTime datetime 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 datetime 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
ExecutorStartDateTime datetime True Unknown

4.0.106.453 4.0 Release Executor Start Date Time Attribute Interaction Process Automation
ExecutorStartDTOffset int True Unknown

4.0.106.453 4.0 Release Executor Start DT Offset Fact Interaction Process Automation
ExecutorEndDateTime datetime True Unknown

4.0.106.453 4.0 Release Executor End Date Time Attribute Interaction Process Automation
ExecutorEndDTOffset int True Unknown

4.0.106.453 4.0 Release Executor End DT Offset Fact Interaction Process Automation
ActionOutput nvarchar (128) True Unknown

4.0.106.453 4.0 Release Action Output Attribute Interaction Process Automation
ErrorDescID int True Unknown

4.0.106.453 4.0 Release Error Description ID Attribute Interaction Process Automation
ErrorDescription nvarchar (1024) True Unknown

4.0.106.453 4.0 Release Error Description Attribute Interaction Process Automation
ErrorDescArgs nvarchar (1024) True Unknown

4.0.106.453 4.0 Release Error Description Args Attribute Interaction Process Automation
ErrorResolID int True Unknown

4.0.106.453 4.0 Release Error Resol ID Attribute Interaction Process Automation
ErrorResolDesc nvarchar (1024) True Unknown

4.0.106.453 4.0 Release Error Resol Description Attribute Interaction Process Automation
ErrorResolArgs nvarchar (1024) True Unknown

4.0.106.453 4.0 Release Error Resol Args Attribute Interaction Process Automation
XMLResultData xml True Unknown

4.0.106.453 4.0 Release XML Result Data Attribute Interaction Process Automation
Version int False Unknown

4.0.106.453 4.0 Release Version Fact Interaction Process Automation

IPA_Actions Constraints

Primary Key Name Type Column Name (sort order)
PK_IPA_Actions Clustered ActionExecID (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IPA_Actions_ParentExecID ParentActionExecID IPA_Actions ActionExecID Yes
FK_IPA_Actions_PredecExecID PredecessorActionID IPA_Actions ActionExecID Yes

IPA_FlowData_Audit Table

Data element id and data element value of IPA flow are stored in IPA_FlowData_Audit table.

IPA_FlowData_Audit 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

IPA_FlowData_Audit 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

IPA_States Table

IPA_States table is used to store the state id and parent state id of different IPA states like StatusKey, LoggedIn, AcdLoggedIn, StatusDND or StatusAcw.

IPA_States 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
StateExecID uniqueidentifier False Unknown

4.0.106.453 4.0 Release State Execution ID Attribute Interaction Process Automation
FlowExecID uniqueidentifier False Unknown

4.0.106.453 4.0 Release Flow Execution ID Attribute Interaction Process Automation
StateID uniqueidentifier False Unknown

4.0.106.453 4.0 Release State ID Attribute Interaction Process Automation
InitialActionExecID uniqueidentifier True Unknown

4.0.106.453 4.0 Release Initial Action Execution ID Attribute Interaction Process Automation
ParentActionExecID uniqueidentifier True Unknown

4.0.106.453 4.0 Release Parent Action Execution ID Attribute Interaction Process Automation
StartDateTime datetime 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 datetime 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

IPA_States Constraints

Primary Key Name Type Column Name (sort order)
PK_IPA_States Clustered StateExecID (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IPA_States_FlowExecID FlowExecID IPA_Flows FlowExecID Yes
FK_IPA_States_ParentActionExecID ParentActionExecID IPA_Actions ActionExecID Yes

IPA_Tasks Table

IPA_Tasks table is used to store th IPA tasks information like task id, task output and parent task execution id.

IPA_Tasks 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
TaskExecID uniqueidentifier False Unknown

4.0.106.453 4.0 Release Task Execution ID Attribute Interaction Process Automation
FlowExecID uniqueidentifier False Unknown

4.0.106.453 4.0 Release Flow Execution ID Attribute Interaction Process Automation
TaskID uniqueidentifier False Unknown

4.0.106.453 4.0 Release Task ID Attribute Interaction Process Automation
ParentActionExecID uniqueidentifier False Unknown

4.0.106.453 4.0 Release Parent Action Execution ID Attribute Interaction Process Automation
ParentStateExecID uniqueidentifier True Unknown

4.0.106.453 4.0 Release Parent State Execution ID Attribute Interaction Process Automation
ParentTaskExecID uniqueidentifier True Unknown

4.0.106.453 4.0 Release Parent Task 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
TaskTypeID int False Unknown

4.0.106.453 4.0 Release Task Type ID Attribute Interaction Process Automation
TaskOutput nvarchar (128) True Unknown

4.0.106.453 4.0 Release Task Output Attribute Interaction Process Automation
DueDateTime datetime True Unknown

4.0.106.453 4.0 Release Due Date Time Attribute Interaction Process Automation
DueDateTimeOffSet int True Unknown

4.0.106.453 4.0 Release Due Date Time Offset Fact Interaction Process Automation
StartDateTime datetime 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 datetime 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

IPA_Tasks Constraints

Primary Key Name Type Column Name (sort order)
PK_IPA_Tasks Clustered TaskExecID (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IPA_Tasks_FlowExecID FlowExecID IPA_Flows FlowExecID Yes
FK_IPA_Tasks_ParentStateExecID ParentStateExecID IPA_States StateExecID Yes
FK_IPA_Tasks_ParentTaskExecID ParentTaskExecID IPA_Tasks TaskExecID Yes

Index Name Type Column Name (sort order)
IX_IPA_Tasks_TaskID Non-clustered TaskID (Ascending)

IPA_Flow_Notes Table

IPA_Flow_Notes table is used to log the notes if any related to IPA flow.

IPA_Flow_Notes 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
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

IPA_Flow_Notes Constraints

Primary Key Name Type Column Name (sort order)
PK_IPA_Flow_Notes Clustered FlowExecID (Ascending)
LastModifiedDateTime (Ascending)

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

IPA_Flow_Attributes Table

IPA_Flow_Attributes table is used to store the IPA flow attribute name and values.

IPA_Flow_Attributes 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
AttrName nvarchar (128) False Unknown

4.0.106.453 4.0 Release Attribute Name Attribute Interaction Process Automation
AttrValue nvarchar (MAX) True Unknown

4.0.106.453 4.0 Release Attribute Value Attribute Interaction Process Automation
AttrType tinyint True Unknown

4.0.106.453 4.0 Release Attribute Type Attribute Interaction Process Automation
Version int False Unknown

4.0.106.453 4.0 Release Version Fact Interaction Process Automation

IPA_Flow_Attributes Constraints

Primary Key Name Type Column Name (sort order)
PK_IPA_Flow_Attributes Clustered FlowExecID (Ascending)
AttrName (Ascending)

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

IPA_Related_Interactions Table

User queue id information can be fetched from IPA_Related_Interactions table.

IPA_Related_Interactions 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

IPA_Related_Interactions 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)

IPA_Work_Items Table

A change sequence of the states like StatusKey, LoggedIn, AcdLoggedIn, StatusDND or StatusAcw is logged in IPA_Work_Items table. It is possible that more than one of these was changed, or that only one of these has changed.

IPA_Work_Items 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
WorkItemExecID uniqueidentifier False Unknown

4.0.106.453 4.0 Release Work Item Execution ID Attribute Interaction Process Automation
WorkItemID uniqueidentifier False Unknown

4.0.106.453 4.0 Release Work Item ID Attribute Interaction Process Automation
FlowExecID uniqueidentifier False Unknown

4.0.106.453 4.0 Release Flow Execution ID Attribute Interaction Process Automation
ParentActionExecID uniqueidentifier True Unknown

4.0.106.453 4.0 Release Parent Action 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
TaskExecID uniqueidentifier True Unknown

4.0.106.453 4.0 Release Task Execution ID Attribute Interaction Process Automation
StateExecID uniqueidentifier True Unknown

4.0.106.453 4.0 Release State Execution ID Attribute Interaction Process Automation
ActionID uniqueidentifier False Unknown

4.0.106.453 4.0 Release Action ID Attribute Interaction Process Automation
ActionType nvarchar (128) False Unknown

4.0.106.453 4.0 Release Action Type Attribute Interaction Process Automation
Category nvarchar (1024) False Unknown

4.0.106.453 4.0 Release Category Attribute Interaction Process Automation
Description nvarchar (1024) False Unknown

4.0.106.453 4.0 Release Description Attribute Interaction Process Automation
DueDateUTC datetime2 True Unknown

4.0.106.453 4.0 Release Due Date UTC 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
WorkItemOutputID uniqueidentifier True Unknown

4.0.106.453 4.0 Release Work Item Output ID Attribute Interaction Process Automation
Version int False Unknown

4.0.106.453 4.0 Release Version Fact Interaction Process Automation

IPA_Work_Items Constraints

Primary Key Name Type Column Name (sort order)
PK_IPA_Work_Items Clustered WorkItemExecID (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IPA_Work_Items_FlowExecID FlowExecID IPA_Flows FlowExecID Yes
FK_IPA_Work_Items_TaskExecID TaskExecID IPA_Tasks TaskExecID Yes

flowexec_Completion Table

Complete code information of IPA flow is stored in flowexec_Completion table.

flowexec_Completion 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
CompletionID uniqueidentifier False Unknown

15.3.0.384 Added for PASv2. Completion ID Attribute Interaction Process Automation
ParentExecID uniqueidentifier False Unknown

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

15.3.0.384 Added for PASv2. Child Execution ID Attribute Interaction Process Automation
CompleteTime bigint True Unknown

15.3.0.384 Added for PASv2. Complete Time Attribute Interaction Process Automation
CompleteVars nvarchar (MAX) True Unknown

15.3.0.384 Added for PASv2. Complete Vars Attribute Interaction Process Automation
CompleteCode int True Unknown

15.3.0.384 Added for PASv2. Complete Code Attribute Interaction Process Automation

flowexec_Completion Constraints

Primary Key Name Type Column Name (sort order)
PK_Flowexec_Completion Non-clustered CompletionID (Ascending)


flowexec_Flows Table

Flow config id and flow config revision is stored in flowexec_Flows table.

flowexec_Flows 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

flowexec_Flows 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)

flowexec_Storage Table

Create host, last host and storage id information of flow execution can be fetched from flowexec_Storage table.

flowexec_Storage 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
StorageID uniqueidentifier False Unknown

15.3.0.384 Added for PASv2. Storage ID Attribute Interaction Process Automation
CreateHost nvarchar (128) False Unknown

15.3.0.384 Added for PASv2. Create Host Attribute Interaction Process Automation
CreateTime datetime2 False Unknown

15.3.0.384 Added for PASv2. Create Time Attribute Interaction Process Automation
LastHost nvarchar (128) False Unknown

15.3.0.384 Added for PASv2. Last Host Attribute Interaction Process Automation
LastTime datetime2 False Unknown

15.3.0.384 Added for PASv2. Last Time Attribute Interaction Process Automation

flowexec_Storage Constraints

Primary Key Name Type Column Name (sort order)
PK_Flowexec_Storage Non-clustered StorageID (Ascending)


IPA_Entities Table

IPA_Entities table stores the object name which is used internally by Interaction Tracker.

IPA_Entities 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
ObjectID uniqueidentifier False Unknown

4.0.106.453 4.0 Release Object ID 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
SiteId smallint False Unknown

4.0.106.453 4.0 Release Site ID Attribute Interaction Process Automation
FlowID uniqueidentifier False Unknown

4.0.106.453 4.0 Release Flow ID Attribute Interaction Process Automation
ObjectName nvarchar (128) True Unknown

4.0.106.453 4.0 Release Object Name Attribute Interaction Process Automation
Version int False Unknown

4.0.106.453 4.0 Release Version Fact Interaction Process Automation

IPA_Entities Constraints

Primary Key Name Type Column Name (sort order)
PK_IPA_Entities Clustered ObjectID (Ascending)
MajorRevision (Ascending)
MinorRevision (Ascending)
SiteId (Ascending)


IPA_FlowSchema Table

IPA_FlowSchema table contains the XMLSchema of vcssSurveyScoringDetail table.

IPA_FlowSchema 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
FlowID uniqueidentifier False Unknown

4.0.106.453 4.0 Release Flow ID Attribute Interaction Process Automation
FLowMajorRevision int False Unknown

4.0.106.453 4.0 Release Flow Major Revision Fact Interaction Process Automation
FlowMinorRevision int False Unknown

4.0.106.453 4.0 Release Flow Minor Revision Fact Interaction Process Automation
SiteId smallint False Unknown

4.0.106.453 4.0 Release Site ID Attribute Interaction Process Automation
XMLSchema xml False Unknown

4.0.106.453 4.0 Release XML Schema Attribute Interaction Process Automation
Version int False Unknown

4.0.106.453 4.0 Release Version Fact Interaction Process Automation

IPA_FlowSchema Constraints

Primary Key Name Type Column Name (sort order)
PK_IPA_FlowSchema Clustered FlowID (Ascending)
FLowMajorRevision (Ascending)
FlowMinorRevision (Ascending)
SiteId (Ascending)


IPA_Jobs Table

IPA jobs table contains the site identifier of the source of IPA interaction. Which is used in multi-site rollup to distinguish the origin of data.

IPA_Jobs 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
JobExecID uniqueidentifier False Unknown

4.0.106.453 4.0 Release Job Execution ID 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
SiteID smallint False Unknown

4.0.106.453 4.0 Release Site ID Attribute Interaction Process Automation
Version int False Unknown

4.0.106.453 4.0 Release Version Fact Interaction Process Automation

IPA_Jobs Constraints

Primary Key Name Type Column Name (sort order)
PK_IPA_Jobs Clustered JobExecID (Ascending)


IPA_Work_Item_Interactions Table

The CallIDKeys in IPA_Work_Item_Interactions table are useful to correlate this table with other data tables.

IPA_Work_Item_Interactions 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
WorkItemExecID uniqueidentifier False Unknown

4.0.106.453 4.0 Release Work Item Execution 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
AppSegmentID smallint False Unknown

4.0.106.453 4.0 Release App Segment ID Attribute Interaction Process Automation
DestinationQueueType smallint False Unknown

4.0.106.453 4.0 Release Destination Queue Type Attribute Interaction Process Automation
DestinationQueueID nvarchar (1024) False Unknown

4.0.106.453 4.0 Release Destination Queue ID Attribute Interaction Process Automation
DestinationQueueHandling smallint False Unknown

4.0.106.453 4.0 Release Destination Queue Handling Attribute Interaction Process Automation
TransferUserID nvarchar (50) True Unknown

4.0.106.453 4.0 Release Transfer User ID Attribute Interaction Process Automation
SegmentStartDate datetime2 False Unknown

4.0.106.453 4.0 Release Segment Start Date Attribute Interaction Process Automation
SegmentStartDateOffset int False Unknown

4.0.106.453 4.0 Release Segment Start Date Offset Fact Interaction Process Automation
SegmentEndDate datetime2 True Unknown

4.0.106.453 4.0 Release Segment End Date Attribute Interaction Process Automation
SegmentEndDateOffset int True Unknown

4.0.106.453 4.0 Release Segment End Date Offset Fact Interaction Process Automation
PickupDate datetime2 True Unknown

4.0.106.453 4.0 Release Pickup Date Attribute Interaction Process Automation
PickupDateOffset int True Unknown

4.0.106.453 4.0 Release Pickup Date Offset Fact Interaction Process Automation
ConnectedDurationSeconds int True Unknown

4.0.106.453 4.0 Release Connected Duration Seconds Fact Interaction Process Automation
ConnectedUser nvarchar (50) True Unknown

4.0.106.453 4.0 Release Connected User Attribute Interaction Process Automation
HeldDurationSeconds int True Unknown

4.0.106.453 4.0 Release Held Duration Seconds Fact Interaction Process Automation
CompleteReason int False Unknown

4.0.106.453 4.0 Release Complete Reason Fact Interaction Process Automation
UsesSkills nvarchar (512) True Unknown

4.0.106.453 4.0 Release Uses Skills Attribute Interaction Process Automation
Priority smallint True Unknown

4.0.106.453 4.0 Release Priority Attribute Interaction Process Automation
Version int False Unknown

4.0.106.453 4.0 Release Version Fact Interaction Process Automation

IPA_Work_Item_Interactions Constraints

Primary Key Name Type Column Name (sort order)
PK_IPA_Work_Item_Interactions Clustered WorkItemExecID (Ascending)
CallIDKey (Ascending)
AppSegmentID (Ascending)