swo_wsati_amend_task_pos_dtl
Workscope : Amendment Task Position details
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Records task position changes introduced through amendments, including revised task sequences, placement, or alignment in relation to other shop work order activities.
This table is the canonical store for the AmendTaskPos entity.
Primary key
wsatipos_trackid
Columns (19)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | wsatipos_amendunique_id | varchar | Created by user for the impacted task |
| 2 | wsatipos_created_by | datetime | Date when the impacted task record was created |
| 3 | wsatipos_created_date | varchar | Disposition code indicating the status or action for the impacted task |
| 4 | wsatipos_dispositioncode | varchar | User who modified the impacted task |
| 5 | wsatipos_modified_by | datetime | Date when the impacted task record was modified |
| 6 | wsatipos_modified_date | varchar | NHA part number for the impacted task |
| 7 | wsatipos_nhapartno | varchar | NHA serial number for the impacted task |
| 8 | wsatipos_nhaserialno | int | Organization unit instance for the impacted task |
| 9 | wsatipos_ouinstance | varchar | Part number associated with the impacted task |
| 10 | wsatipos_partno | varchar | Position code for the impacted task |
| 11 | wsatipos_positioncode | varchar | Root component ID of the associated work order |
| 12 | wsatipos_root_componentid | varchar | Serial number of the impacted task |
| 13 | wsatipos_serialno | varchar | Shop work order number impacted by the task |
| 14 | wsatipos_swo_no | varchar | Task number for the impacted task |
| 15 | wsatipos_taskno | bigint | Unique identifier for the impacted task |
| 16 | wsatipos_task_uniqueid | Bigint | Track ID for the existing task, if applicable |
| 17 | wsatipos_trackid 🔑 | bigint | Unique identifier for the line level record |
| 18 | wsatipos_uniqueid | bigint | Visit line level identifier for task tracking |
| 19 | wsatipos_visitlineid | varchar | Shop work order number for amendment task |
Relationships (1)
- SWOTask (swo_swostk_sub_task_details) →
TASK_HAS_AMEND_POSITION(this table is target)- Join:
swo_swostk_sub_task_details.swostk_swo_no = swo_wsati_amend_task_pos_dtl.wsatipos_swo_no - SWO task has amendment position
- Join:
Sample rows (from live DB)
wsatipos_amendunique_id | wsatipos_created_by | wsatipos_created_date | wsatipos_dispositioncode | wsatipos_modified_by | wsatipos_modified_date |
|---|---|---|---|---|---|
| — | DMUSER | 2023-03-24 10:19:00 | — | — | — |
| -2147482643.0 | DMUSER | 2024-03-12 10:19:00 | — | — | — |
| -2147482539.0 | DMUSER | 2024-07-17 09:36:00 | — | — | — |
Showing 3 of 24 rows.