Allowed transitions between states within a module workflow
Data model
Fields
| Field | Type | Description |
|---|---|---|
| is_active* | BIT | Logical Deletion: 1 = Active Record, 0 = Retired |
| requires_approval* | BIT | Indicates whether the transition requires approval |
| sla_hours | INT | SLA hours to complete the transition |
| source_status_id* | UNIQUEIDENTIFIER | Transition source state (module catalog GUID, APMO_CATALOG_MAP.module_guid) |
| target_status_id* | UNIQUEIDENTIFIER | Transition target state (module catalog GUID, APMO_CATALOG_MAP.module_guid) |
| transition_id* | UNIQUEIDENTIFIER | Unique identifier of the transition |
| transition_rule | NVARCHAR (MAX) | Additional transition rule |
| workflow_id* | UNIQUEIDENTIFIER | Workflow to which the transition belongs |
Primary Key
| PK_APMO_WORKFLOW_TRANSITION |
|---|
| transition_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| workflow_id* | dbo.APMO_WORKFLOW | workflow_id | FK01_APMO_WORKFLOW_TRANSITION |