swo_swostk_sub_task_details
Contains SWO resource requirement details specifying tools, equipment, facilities, and personnel needed for maintenance tasks. This table helps in resource planning and allocation for work order execution.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Details of sub-tasks under each SWO
This table is the canonical store for the SWOSubTask entity.
Primary key
swostso_sub_task_seq_no
Columns (23)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swostk_created_by | varchar | Name of the person who created the stock record |
| 2 | swostk_created_date | Datetime | Date and time when the stock record was created |
| 3 | swostk_emp_code | varchar | Employee code associated with the stock record |
| 4 | swostk_modified_by | varchar | Name of the person who last modified the stock record |
| 5 | swostk_modified_date | Datetime | Date and time when the stock record was last modified |
| 6 | swostk_ouinstance | int | Organizational unit instance associated with the stock record |
| 7 | swostk_recorded_by | varchar | Name of the person who recorded the stock entry |
| 8 | swostk_reported_by | varchar | Name of the person who reported the stock information |
| 9 | swostk_reported_datetime | Datetime | Date and time when the stock information was reported |
| 10 | swostk_resource_group | varchar | Resource group associated with the stock task |
| 11 | swostk_seq_no | int | Sequence number indicating the running order of the subtask |
| 12 | swostk_sign_off_comments | varchar | Comments provided during sign off of the subtask |
| 13 | swostk_sign_off_date | Datetime | Date when the subtask was signed off |
| 14 | swostk_sign_off_status | varchar | Status of the sign off process for the subtask |
| 15 | swostk_skill_code | varchar | Skill code required to perform the subtask |
| 16 | swostk_skill_ou | int | HR operating unit instance associated with the skill |
| 17 | swostk_SUBTsk_Uniqueid | Bigint | Unique identifier for the subtask |
| 18 | swostk_sub_task_desc | varchar | Description of the subtask being performed |
| 19 | swostk_sub_trackid | Bigint | Tracking number associated with the subtask |
| 20 | swostk_swo_no | varchar | Shop work order number linked to the subtask |
| 21 | swostk_task_track_id | bigint | Task tracking identification number specific to the subtask or sign off |
| 22 | swostk_timestamp | int | Timestamp when the subtask record was created or updated |
| 23 | swostso_sub_task_seq_no 🔑 | bigint | Subtask sequence number, primary key |
Relationships (17)
SWO_HAS_PARAM→ TaskParam (swo_swoprm_task_param_det)- Join:
swo_swostk_sub_task_details.swostk_swo_no = swo_swoprm_task_param_det.swoprm_swo_no - SWO task has parameters
- Join:
SWO_HAS_OBSERVATION→ SWOObservation (swo_swoobs_observation_list)- Join:
swo_swostk_sub_task_details.swostk_swo_no = swo_swoobs_observation_list.swoobs_swo_no - SWO task has observations
- Join:
SWO_HAS_CHILD_DISC→ ChildDiscrepancy (swo_chdis_chd_discrepancy_det) (no automatic join)- SWO task has child discrepancies
SWO_HAS_EO_RELATED→ EORelatedTask (swo_eo_reltsk_dtl) (no automatic join)- SWO task has EO related tasks
TASK_HAS_AMEND_DETAIL→ TaskAmendDetail (swo_wsatsk_task_amend_dtl) (no automatic join)- SWO task has amendment detail
TASK_HAS_AMEND_POSITION→ AmendTaskPos (swo_wsati_amend_task_pos_dtl)- Join:
swo_swostk_sub_task_details.swostk_swo_no = swo_wsati_amend_task_pos_dtl.wsatipos_swo_no - SWO task has amendment position
- Join:
- ShopWorkOrder (swo_swoh_shop_wo_hdr) →
SWO_CONTAINS_TASK(this table is target)- Join:
swo_swoh_shop_wo_hdr.swoh_swo_no = swo_swostk_sub_task_details.swostk_swo_no - Shop work order contains tasks
- Join:
SWO_HAS_SUBTASK→ SWOSubTask (swo_swostk_sub_task_details) (no automatic join)- SWO task has subtasks
- SWOTask (swo_swostk_sub_task_details) →
SWO_HAS_SUBTASK(this table is target) (no automatic join)- SWO task has subtasks
SWO_HAS_PART→ SWOPartDetail (swo_swoprt_part_details)- Join:
swo_swostk_sub_task_details.swostk_task_track_id = swo_swoprt_part_details.swoprt_task_track_id - SWO task has part details
- Join:
SWO_HAS_RESOURCE→ SWOResourceDetail (swo_swores_swo_res_det) (no automatic join)- SWO task has resource details
SWO_HAS_CHARGE→ ChargeDetail (swo_swocrg_charge_details)- Join:
swo_swostk_sub_task_details.swostk_task_track_id = swo_swocrg_charge_details.swocrg_task_track_id - SWO task has charge details
- Join:
SWO_HAS_EMP_ACTUAL→ SWOEmpActuals (TA_TD_TIMEBOOKING_DTL) (no automatic join)- SWO task has employee actuals
SWO_TASK_ADDITIONAL→ TaskAdditionalDtl (swo_swotad_shop_wo_tsk_addl_dtl)- Join:
swo_swostk_sub_task_details.swostk_task_track_id = swo_swotad_shop_wo_tsk_addl_dtl.swotad_task_track_id - SWO task has additional details
- Join:
SWO_HAS_DISCREPANCY→ SWODiscrepancy (swo_swodes_discrepancy_list)- Join:
swo_swostk_sub_task_details.swostk_swo_no = swo_swodes_discrepancy_list.swodes_swo_no - SWO task has discrepancies
- Join:
SWO_HAS_PART_TAG→ PartTag (swo_swoptg_part_tag_list)- Join:
swo_swostk_sub_task_details.swostk_swo_no = swo_swoptg_part_tag_list.swoptg_swo_no - Task has part tags
- Join:
SWO_HAS_PREF_SERIAL→ PrefSerialNo (swo_swopsl_prefserlno_dtl)- Join:
swo_swostk_sub_task_details.swostk_task_track_id = swo_swopsl_prefserlno_dtl.swopsl_task_track_id - Task has preferred serial numbers
- Join:
Sample rows (from live DB)
swostk_created_by | swostk_created_date | swostk_emp_code | swostk_modified_by | swostk_modified_date | swostk_ouinstance |
|---|---|---|---|---|---|
| DMUSER | 2013-04-01 18:07:21.720 | — | DMUSER | 2013-04-01 18:07:21.720 | 2 |
| DMUSER | 2013-04-01 18:07:21.720 | — | DMUSER | 2013-04-01 18:07:21.720 | 2 |
| DMUSER | 2013-04-06 11:02:51.183 | — | DMUSER | 2013-04-06 11:02:51.183 | 2 |
Showing 3 of 17,249 rows.