swo_separatedtsk_sub_task_details
Maintains backup information of separated tasks at the sub-task level. This table allows detailed monitoring of each sub-task, its dependencies, and execution status within a larger work orde
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: SWO Associated Main Core Details
Primary key
swostso_sub_task_seq_no
Columns (23)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swostk_created_by | varchar | User who created the sub-task record |
| 2 | swostk_created_date | Datetime | Date and time of sub-task creation |
| 3 | swostk_emp_code | varchar | Employee code of the user who signed off |
| 4 | swostk_modified_by | varchar | User who last modified the sub-task |
| 5 | swostk_modified_date | Datetime | Date and time of last modification |
| 6 | swostk_ouinstance | int | Organizational unit instance for sub-task |
| 7 | swostk_recorded_by | varchar | User who recorded the sub-task |
| 8 | swostk_reported_by | varchar | User who reported the sub-task |
| 9 | swostk_reported_datetime | Datetime | Date and time when the sub-task was reported |
| 10 | swostk_resource_group | varchar | Resource group associated with sub-task |
| 11 | swostk_seq_no | int | Sequence number for the sub-task |
| 12 | swostk_sign_off_comments | varchar | Comments provided during sign off |
| 13 | swostk_sign_off_date | Datetime | Date of sub task sign off |
| 14 | swostk_sign_off_status | varchar | Status of the sub-task sign-off |
| 15 | swostk_skill_code | varchar | Skill code required for sub-task |
| 16 | swostk_skill_ou | int | Organizational unit for skill assignment |
| 17 | swostk_SUBTsk_Uniqueid | Bigint | Unique identifier for the sub-task |
| 18 | swostk_sub_task_desc | varchar | Description of the sub-task |
| 19 | swostk_sub_trackid | Bigint | Tracking ID for the sub-task |
| 20 | swostk_swo_no | varchar | Shop work order number associated with sub-task |
| 21 | swostk_task_track_id | bigint | Task tracking ID for sub-task |
| 22 | swostk_timestamp | int | Timestamp of sub-task record |
| 23 | swostso_sub_task_seq_no 🔑 | bigint | Unique sequence number for sub-task |
Sample rows (from live DB)
swostk_created_by | swostk_created_date | swostk_emp_code | swostk_modified_by | swostk_modified_date | swostk_ouinstance |
|---|---|---|---|---|---|
| DMUSER | 2022-04-07 16:56:55.067 | — | DMUSER | 2022-04-07 16:56:55.067 | 2 |
| DMUSER | 2022-04-08 11:40:28.010 | — | DMUSER | 2022-04-08 11:40:28.010 | 2 |
| DMUSER | 2022-04-13 15:01:05.390 | — | DMUSER | 2022-04-13 15:01:05.390 | 2 |
Showing 3 of 520 rows.