swo_wsatsk_amend_task_impacted_dtl
Workscope : Amendment Tasks details
Process: COMPMAINTENANCE 路 Component: BasSWO 路 Table type: Transaction Table Category: Tracks details of tasks impacted due to amendments, capturing dependency changes, affected schedules, and adjusted task execution plans
Primary key
wsati_tasktrackid
Columns (62)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | wsati_amdws_swono | varchar | Amendment number |
| 2 | wsati_amend_no | bigint | Line level unique identifier for amendment task details |
| 3 | wsati_amend_tskuniqueid | Bigint | Amendment unique identifier |
| 4 | wsati_amend_uniqueid | varchar | Capex proposal number, if applicable |
| 5 | wsati_capex_proposal_no | varchar | Type of change to be performed, e.g., add or remove work scoping or engineering order, upgrade |
| 6 | wsati_changetype | varchar | Component ID associated with the task |
| 7 | wsati_componentid | varchar | User who created the task record |
| 8 | wsati_created_by | datetime | Date when the task record was created |
| 9 | wsati_created_date | numeric | Elapsed time display for the task |
| 10 | wsati_display_est_elap_Time | varchar | Unit of measure for elapsed time display |
| 11 | wsati_display_time_uom | numeric | Elapsed time in minutes for task completion |
| 12 | wsati_est_elapsed_time_mins | varchar | Execution action to be performed on the impacted task |
| 13 | wsati_execaction | varchar | Execution category of the task |
| 14 | wsati_exec_category | varchar | Execution phase of the task |
| 15 | wsati_exec_phase | int | Priority number for task execution |
| 16 | wsati_exec_priority_no | varchar | Flag indicating execution facility applicability |
| 17 | wsati_exefacility_flag | varchar | Type of expense associated with the task |
| 18 | wsati_expensetype | varchar | Impacted shop work order number |
| 19 | wsati_impacted_swo_no | varchar | Level code indicating task hierarchy |
| 20 | wsati_levelcode | varchar | Mandatory flag indicating if task execution is required |
| 21 | wsati_mandatoryflag | varchar | User who modified the task |
| 22 | wsati_modified_by | datetime | Date when the task record was modified |
| 23 | wsati_modified_date | varchar | NHA part number associated with the task |
| 24 | wsati_nhapartno | varchar | NHA serial number associated with the task |
| 25 | wsati_nhaserialno | int | Organization unit instance for the task |
| 26 | wsati_ouinstance | varchar | Parent task code, if applicable |
| 27 | wsati_parenttaskcode | varchar | Part number for the task |
| 28 | wsati_partno | datetime | Planned start date for the task |
| 29 | wsati_plan_endate | datetime | Planned end date for the task |
| 30 | wsati_plan_startdate | varchar | Position code associated with the task |
| 31 | wsati_poscode | varchar | Reason for non-execution of the task, if applicable |
| 32 | wsati_reason_nonexec | varchar | Reference document revision number |
| 33 | wsati_ref_doc_revno | varchar | Reference source document number |
| 34 | wsati_ref_src_docno | varchar | Reference source document type |
| 35 | wsati_ref_src_doctype | varchar | Remarks related to task execution |
| 36 | wsati_remarks | varchar | Repair agency associated with the task |
| 37 | wsati_repagency | varchar | Repair classification of the task |
| 38 | wsati_repair_class | datetime | Repair process code for the task |
| 39 | wsati_repair_proc_code | varchar | Root task code associated with the hierarchy |
| 40 | wsati_roottaskcode | varchar | Flag indicating whether routing is required |
| 41 | wsati_rout_req_flag | varchar | Flag indicating if the task is separated |
| 42 | wsati_seperatedflag | varchar | Separation rule applied to the task |
| 43 | wsati_seperation_rule | varchar | Task serial number |
| 44 | wsati_serialno | datetime | Station associated with the task |
| 45 | wsati_station | varchar | Context shop work order number |
| 46 | wsati_swono | varchar | Impacted task number |
| 47 | wsati_taskno | varchar | Task revision number for the impacted task |
| 48 | wsati_taskrevno | int | Repeat sequence number for the impacted task |
| 49 | wsati_taskseqno | varchar | Status of the impacted task |
| 50 | wsati_taskstatus | Bigint | Task track ID for the impacted task |
| 51 | wsati_tasktrackid 馃攽 | varchar | Not applicable field to be removed |
| 52 | wsati_task_impact_flag | varchar | Task hierarchy identifier |
| 53 | wsati_tskhierarchyid | bigint | Line level unique identifier |
| 54 | wsati_uniqueid | Bigint | Upgraded parent task track ID |
| 55 | wsati_upgraded_prnttrackid | varchar | Upgraded task number |
| 56 | wsati_upgraded_task | Bigint | Upgraded task track ID |
| 57 | wsati_upgraded_tasktrackid | Bigint | Upgraded work scoping task track ID |
| 58 | wsati_upgraded_wstasktrackid | varchar | Flag indicating task upgrade |
| 59 | wsati_upgrade_flag | varchar | Work breakdown structure code |
| 60 | wsati_wbscode | varchar | Work center associated with the task |
| 61 | wsati_workcenter | varchar | Flag indicating whether the work order is specific |
| 62 | wsati_wo_specific_flag | varchar | Amendment number |
Sample rows (from live DB)
wsati_amdws_swono | wsati_amend_no | wsati_amend_tskuniqueid | wsati_amend_uniqueid | wsati_capex_proposal_no | wsati_changetype |
|---|---|---|---|---|---|
| NULL | AMD000143-2023 | -2147483327 | -2147483276 | NULL | ADDWS |
| NULL | AMD000234-2023 | -2147483152 | -2147483120 | NULL | RMWS |
| NULL | NULL | NULL | NULL | NULL | NULL |
Showing 3 of 326 rows.