swo_swotad_separated_tsk_addl_dtl
Backup table for separated tasks with additional details. This table stores information about tasks that have been separated from the main work order, maintaining historical data and additional context.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Additional details for separated tasks in SWO
Primary key
swotad_task_track_id
Columns (9)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swotad_eng_instruction | varchar | Remarks related to re estimation of the task |
| 2 | swotad_est_remarks | varchar | Reference to the parent task tracking identification number |
| 3 | swotad_exec_comments | varchar | Flag indicating whether the task is a reference parent task |
| 4 | swotad_ReEst_Remarks | varchar | Reference parent task identification |
| 5 | swotad_swbstsk_id | Bigint | Task tracking number associated with the additional comments |
| 6 | swotad_swbs_flg | varchar | Notes regarding the work scope for the task |
| 7 | swotad_swbs_task | varchar | Workscoping revision comments for the task |
| 8 | swotad_task_track_id 🔑 | bigint | Operating unit instance associated with the task parameters |
| 9 | swotad_wrk_scp_notes | varchar | Parameter code specifying the task or component measurement |
Sample rows (from live DB)
swotad_eng_instruction | swotad_est_remarks | swotad_exec_comments | swotad_ReEst_Remarks | swotad_swbstsk_id | swotad_swbs_flg |
|---|---|---|---|---|---|
| — | — | — | — | — | — |
| — | — | — | — | — | — |
| — | — | — | — | — | — |
Showing 3 of 521 rows.