Workflow Module

Module purpose

The Workflow module manages the business process engine, task assignment and rule execution. It orchestrates the processing of applications through defined workflows, assigns tasks to users and tracks the status of each process step.

Key tables

Core workflow tables

Table Description Rows
TWOR_WORKFLOW Workflow instances 3,310,389
TWOR_WORKFLOW_STORY Workflow history 1,621,040
TWOR_ATTIVITA Workflow activities 6,303,178
TWOR_ATTIVITA_STORY Activity history 5,376,682
TWOR_WF Workflow records (alternate) 1,614,310
TWOR_STEP Workflow steps 5,234,988
TWOR_STEP_STORY Step history 5,148,009

Rule engine

Table Description Rows
TRUE_REGOLA Rules 7,478
TRUE_REGOLA_STORIA Rule history 7,116
TRUE_INVOCAZIONE Rule invocations 5,008
TRUE_INVOCAZIONE_STORAGE Invocation storage 4,648,115
TRUE_ESECUZIONE Rule executions 1,523,115
TRUE_ESECUZIONE_STORAGE Execution storage 24,135
TRUE_ESPRESSIONE Rule expressions 15,085
TRUE_AZIONE Rule actions 7,633
TRUE_EVENTO Rule events 5,227

Task management

Table Description Rows
TWOR_TASK Task records 1,893,076
TWOR_TASK_STORY Task history 1,836,740
TWOR_ASSEGNAZIONE Task assignments 1,821,423
TWOR_ESITO Task outcomes 6,238,574

Definition tables

Table Description Rows
TWOR_DEF_WORKFLOW Workflow definitions 1,171
TWOR_DEF_STEP Step definitions 7,167
TWOR_DEF_ATTIVITA Activity definitions 5,893
TWOR_DEF_FLUSSO Flow definitions 7,399
TWOR_DEF_ASSEGNAZIONE Assignment definitions 2,001
TWOR_DEF_ESITO Outcome definitions 1,619
TWOR_DEF_TRANSIZIONE Transition definitions 8,176
TRUE_DEF_REGOLA Rule definitions 1,118
TRUE_DEF_EVENTO Event definitions 139
TRUE_DEF_AZIONE Action definitions 216

User/role tables

Table Description Rows
TOPE_OPERATORE Operators/users 1,179
TOPE_RUOLO Roles 4,424
TOPE_UTENTE User accounts 1,136
TOPE_PROFILO User profiles 0
TOPE_PERMESSO Permissions 1,161
TOPE_RUOLO_PERMESSO Role-permission mapping 6,082
TOPE_DEF_RUOLO Role definitions 79
TOPE_DEF_PERMESSO Permission definitions 2,059

Key columns

TWOR_WORKFLOW (Workflow Instance)

Column Type Nullable Description
ID_WORKFLOW NUMBER N Workflow ID
ID_DEF_WORKFLOW NUMBER N Workflow definition ID
ID_ENTITA NUMBER Y Entity ID (e.g. application)
COD_STATO VARCHAR2(10) Y Status code
DT_INIZIO DATE Y Start date
DT_FINE DATE Y End date
COD_ESITO VARCHAR2(10) Y Outcome code

TWOR_STEP (Workflow Step)

Column Type Nullable Description
ID_STEP NUMBER N Step ID
ID_WORKFLOW NUMBER N Parent workflow
ID_DEF_STEP NUMBER N Step definition
COD_STATO VARCHAR2(10) Y Status
DT_INIZIO DATE Y Start date
DT_FINE DATE Y End date
ID_OPERATORE NUMBER Y Assigned operator

TRUE_REGOLA (Rule)

Column Type Nullable Description
ID_REGOLA NUMBER N Rule ID
ID_DEF_REGOLA NUMBER N Rule definition
COD_STATO VARCHAR2(10) Y Status
DT_ESECUZIONE DATE Y Execution date
ESITO VARCHAR2(10) Y Outcome
ID_ENTITA NUMBER Y Target entity

TWOR_TASK (Task)

Column Type Nullable Description
ID_TASK NUMBER N Task ID
ID_STEP NUMBER Y Parent step
ID_OPERATORE NUMBER Y Assigned operator
COD_STATO VARCHAR2(10) Y Status
DT_CREAZIONE DATE Y Creation date
DT_SCADENZA DATE Y Due date
DT_COMPLETAMENTO DATE Y Completion date
PRIORITA NUMBER Y Priority

Data flow

See diagram: Workflow Data Flow

Integration points

Inbound

  • All Modules: Entity creation triggers workflow
  • Events: System events trigger rule evaluation
  • User Actions: Task completion advances workflow

Outbound

  • All Modules: Workflow status updates entity state
  • Notifications: Tasks generate user notifications
  • Audit: Full audit trail of process execution

Key packages

Package Purpose
WORKFLOW_PCK Main workflow engine
WORKFLOW_ROUTINE_PCK Workflow routines
RULE_ENGINE_PCK Rule evaluation
TASK_PCK Task management
ASSEGNAZIONE_PCK Assignment logic
TRANSIZIONE_PCK State transitions
EVENTO_PCK Event handling

Key views

View Purpose
VWOR_WORKFLOW Workflow summary
VWOR_STEP Step view
VWOR_TASK Task list
VWOR_TASK_UTENTE User task queue
VTRUE_REGOLA Rule view
VOPE_OPERATORE Operator view

Workflow states

Code Description
NEW Newly created
ACT Active/in progress
WAI Waiting for user action
SUS Suspended
COM Completed
CAN Cancelled

Rule engine

The rule engine (TRUE_* tables) provides:

  • Expressions: Conditional logic evaluated against entity data
  • Actions: Operations executed when expressions match
  • Events: Triggers that invoke rule evaluation
  • Invocations: Record of rule calls and results

Operator roles

Users are assigned roles via TOPE_RUOLO which grant permissions from TOPE_PERMESSO. Role definitions in TOPE_DEF_RUOLO include:

  • Administrator
  • Supervisor
  • Processor
  • Auditor
  • Read-only viewer

Quick reference

  • Acronyms — full abbreviation list
  • Glossary — term definitions and Italian translations
  • Home — system overview