ActionRule


Description

Action workflow rules defining business rules and status transitions for workflow automation. This table manages the conditional logic that determines how actions progress through different states based on error conditions, status changes, and business rule validation for automated workflow processing.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
RuleID int identity 4 √ null

Primary key - Unique identifier for each action rule
ActionID int 4 √ null

Action reference - Links to the workflow action this rule applies to
Statusid int 4 √ null

Source status - The current status that triggers this rule evaluation
ErrorID varchar 10 √ null

Error condition - Specific error code or condition that triggers this rule
ToStatusID int 4 √ null

Target status - The status to transition to when this rule is triggered

Indexes

Constraint Name Type Sort Column(s)
IX_ActionID Performance Asc ActionID
IX_ActionStatus Performance Asc Statusid
IX_ErrorID Performance Asc ErrorID

Relationships

Close relationships within degrees of separation