swo_separated_tsk_maint_lvl_dtl
Stores a backup of separated tasks along with maintenance level details. This table is used for auditing, analyzing task-level maintenance activities, and ensuring that work orders are executed according to the specified maintenance standards
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Separated Task Maintenance Level Details
This table is the canonical store for the SeparatedTask entity.
Primary key
swotsk_uniqueid
Columns (9)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swotsk_created_by | varchar | User who created the maintenance task |
| 2 | swotsk_created_date | datetime | Date and time of task creation |
| 3 | swotsk_maint_level | varchar | Maintenance level for the task |
| 4 | swotsk_modified_by | varchar | User who modified the maintenance task |
| 5 | swotsk_modified_date | datetime | Date and time of last modification |
| 6 | swotsk_ouinstance | int | Organizational unit instance for task |
| 7 | swotsk_swo_no | varchar | Shop work order number associated with task |
| 8 | swotsk_trackid | Bigint | Task tracking ID |
| 9 | swotsk_uniqueid 🔑 | bigint | Unique identifier for task |
Sample rows (from live DB)
swotsk_created_by | swotsk_created_date | swotsk_maint_level | swotsk_modified_by | swotsk_modified_date | swotsk_ouinstance |
|---|---|---|---|---|---|
| — | — | NA | — | — | 2 |
| — | — | NA | — | — | 2 |
| — | — | NA | — | — | 2 |
Showing 3 of 12 rows.