Expand All Collapse All

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

SQL 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