Expand All Collapse All

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

SQL 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