WorkFlowActions


Description

Automated workflow actions defining automated actions and business rules that can be triggered by system events or scheduled processes. This table enables process automation, notification systems, and automated business rule enforcement for operational efficiency and compliance management.

Columns

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

Primary key - Unique identifier for each workflow action
ActionType int 4 √ null

Action type - Type of automated action (Email, Update, Create, etc.)
Name nvarchar 510 √ null

Action name - Descriptive name of the workflow action
ActionValues nvarchar 1073741823 √ null

Action configuration - JSON or XML configuration defining the specific action parameters
Schedules nvarchar 1073741823 √ null

Schedule configuration - Configuration for when the action should be executed
AutomationRuleID int 4 √ null

Automation rule reference - Links to automation rule that triggers this action
DateCreated datetime 16,3 √ null

Creation date - Timestamp when the workflow action was created
CreatedBy int 4 √ null

Created by user - UserID of the person who created this workflow action
DateUpdated datetime 16,3 √ null

Update date - Timestamp of the most recent modification
UpdatedBy int 4 √ null

Updated by user - UserID of the person who last modified this workflow action
DeletedDate datetime 16,3 √ null

Deletion date - Soft delete timestamp for audit trail purposes

Indexes

Constraint Name Type Sort Column(s)
PK_WorkFlowActions Primary key Asc ID

Relationships

Close relationships within degrees of separation