swo_wsati_amend_maint_lvl_dtl
Workscope : Amendment Task Maintenance level details
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Stores details of amendments at the maintenance level for shop work orders, defining revised maintenance classifications, responsibility levels, or execution standards
Primary key
wsati_tasktrackid
Columns (14)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | wsati_amend_uniqueid | varchar | Unique identifier for the amendment at task level |
| 2 | wsati_created_by | datetime | User who created the task level record |
| 3 | wsati_created_date | varchar | Date when the task level record was created |
| 4 | wsati_level_eff_flag | varchar | Flag indicating whether the maintenance level is effective |
| 5 | wsati_maint_level | varchar | Task maintenance level for the impacted task |
| 6 | wsati_modified_by | datetime | User who modified the task record |
| 7 | wsati_modified_date | int | Date when the task record was modified |
| 8 | wsati_ouinstance | varchar | Organization unit instance for the task |
| 9 | wsati_swo_no | Bigint | Shop work order number impacted by the task |
| 10 | wsati_tasktrackid 🔑 | varchar | Task track ID for tracking the task |
| 11 | wsati_task_no | varchar | Impacted task number |
| 12 | wsati_task_rev | bigint | Revision number for the impacted task |
| 13 | wsati_task_uniqueid | bigint | Unique identifier for the impacted task in the amendment |
| 14 | wsati_uniqueid | bigint | Line level unique identifier for the task |
Sample rows (from live DB)
wsati_amend_uniqueid | wsati_created_by | wsati_created_date | wsati_level_eff_flag | wsati_maint_level | wsati_modified_by |
|---|---|---|---|---|---|
| -2147483308 | DMUSER | 2023-03-24 10:19:00 | — | 1.1.1 | — |
Showing 1 of 1 rows.