swo_core_status_metadata
This table contains metadata about the core status of Shop Work Orders (SWO). It helps track the overall lifecycle, including initiation, progress, completion, and closure statuses.
Process: COMPMAINTENANCE 路 Component: BasSWO 路 Table type: Transaction Table Category: stores metadata related to the core status of Shop Work Orders (SWO). It maintains detailed information about the current state, progress, and lifecycle of each work order, including status codes, timestamps, and associated operational details. The table enables tracking of work order execution at a granular level, supports reporting and analysis of maintenance workflows, and ensures traceability of status changes for compliance and auditing purposes
Primary key
swomd_taskcode
Columns (7)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swomd_core_status | varchar | Current status of the core in the work order |
| 2 | swomd_issu_flag | varchar | Flag indicating whether the issue is recorded |
| 3 | swomd_ret_flag | varchar | Flag indicating relation with other tasks |
| 4 | swomd_rout_flag | varchar | Flag indicating the routing status |
| 5 | swomd_setopt_flag | varchar | Flag indicating whether an option is set |
| 6 | swomd_taskcode 馃攽 | varchar | Code of the task associated with the record |
| 7 | swomd_taskdesc | varchar | Description of the task associated with the record |
Sample rows (from live DB)
swomd_core_status | swomd_issu_flag | swomd_ret_flag | swomd_rout_flag | swomd_setopt_flag | swomd_taskcode |
|---|---|---|---|---|---|
| ERB | NA | NA | NA | NA | FULLSCRAP |
| I | Y | NA | N | NA | RETCAN |
| R | NA | NA | NA | NA | RETCREATE |
Showing 3 of 10 rows.