swo_swosts_status_control_metadata
Metadata for status change control in the SWO system. This table defines valid status transitions, approval requirements, and business rules governing work order status changes throughout the maintenance lifecycle.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Metadata for status and workflow control in SWO
Primary key
replication_key
Columns (9)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | REPLICATION_KEY | Bigint | Action to be performed on the destination system |
| 2 | swosts_destination_action | varchar | Destination status of the subtask or task |
| 3 | swosts_destination_status | varchar | Event code indicating the action selected for the task append or upgrade |
| 4 | swosts_event_code | varchar | Status from which the task is changing |
| 5 | swosts_from_action | varchar | Comments or notes associated with the rules applied to the task |
| 6 | swosts_from_status | varchar | Status to which the task is changing |
| 7 | swosts_rule_comments | varchar | Engineering instructions provided for the task |
| 8 | swosts_to_action | varchar | Remarks related to task estimation |
| 9 | swosts_to_status | varchar | Comments on task execution |
Sample rows (from live DB)
REPLICATION_KEY | swosts_destination_action | swosts_destination_status | swosts_event_code | swosts_from_action | swosts_from_status |
|---|---|---|---|---|---|
| — | DC | DL | Append | E | FRH |
| — | DC | DL | Append | E | PLN |
| — | DC | DL | Append | E | INPRG |
Showing 3 of 16 rows.