swo_swodes_discrepancy_list
Maintains SWO discrepancy details identified during maintenance operations. This table records all discrepancies found during inspection, repair, or maintenance activities, including descriptions, severity levels, and resolution status.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Employee work details including indirect work and actual time records
This table is the canonical store for the SWODiscrepancy entity.
Primary key
swodes_task_track_id, swodes_discrepancy_no
Columns (31)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swodesc_swo_no | varchar | Action change flag for the Shop Work Order component task |
| 2 | swodes_action_chg_flag | varchar | Action flag for the Shop Work Order component task |
| 3 | swodes_action_flag | varchar | Action analysis number for the Shop Work Order component task |
| 4 | swodes_atano | varchar | Created by for the Shop Work Order component task |
| 5 | swodes_created_by | varchar | Creation date for the Shop Work Order component task |
| 6 | swodes_created_date | datetime | Discrepancy description for the Shop Work Order component task |
| 7 | swodes_discrepancy_desc | varchar | Discrepancy type for the Shop Work Order component task |
| 8 | swodes_discrepancy_no 🔑 | varchar | Last corrective action for the Shop Work Order component task |
| 9 | swodes_discrepancy_type | varchar | Last corrective action sequence for the Shop Work Order component task |
| 10 | swodes_last_corr_action | varchar | Last transfer component ID for the Shop Work Order component task |
| 11 | swodes_last_corr_action_seq | int | Last transfer manufacturer number for the Shop Work Order component task |
| 12 | swodes_last_trns_comp_id | varchar | Last transfer manufacturer part number for the Shop Work Order component task |
| 13 | swodes_last_trns_mfr_no | varchar | Last transfer manufacturer serial number for the Shop Work Order component task |
| 14 | swodes_last_trns_mfr_part_no | varchar | Last transfer part number for the Shop Work Order component task |
| 15 | swodes_last_trns_mfr_serial_no | varchar | Last transfer serial number for the Shop Work Order component task |
| 16 | swodes_last_trns_part_no | varchar | Modified by for the Shop Work Order component task |
| 17 | swodes_last_trns_serial_no | varchar | Modified date for the Shop Work Order component task |
| 18 | swodes_modified_by | varchar | Organization instance for the Shop Work Order component task |
| 19 | swodes_modified_date | datetime | Parent discrepancy reference for the Shop Work Order component task |
| 20 | swodes_ouinstance | int | Reference number for the Shop Work Order component task |
| 21 | swodes_parentdp_ref | varchar | Reference task code for the Shop Work Order component task |
| 22 | swodes_ref_no | varchar | Reference task track ID for the Shop Work Order component task |
| 23 | swodes_ref_task_code | varchar | Reported by for the Shop Work Order component task |
| 24 | swodes_ref_task_track_id | bigint | Reported datetime for the Shop Work Order component task |
| 25 | swodes_reported_by | varchar | Repair task code for the Shop Work Order component task |
| 26 | swodes_reported_datetime | datetime | Repair task track ID for the Shop Work Order component task |
| 27 | swodes_rep_task_code | varchar | Root discrepancy reference for the Shop Work Order component task |
| 28 | swodes_rep_task_track_id | Bigint | Task track ID for the nonroutine task generated during discrepancy reporting |
| 29 | swodes_rootdp_ref | varchar | Timestamp for the Shop Work Order component task |
| 30 | swodes_task_track_id 🔑 | bigint | Task Track for the Non rountine task generated during Discrepency reporting |
| 31 | swodes_timestamp | int | Timestamp of the record. |
Relationships (1)
- SWOTask (swo_swostk_sub_task_details) →
SWO_HAS_DISCREPANCY(this table is target)- Join:
swo_swostk_sub_task_details.swostk_swo_no = swo_swodes_discrepancy_list.swodes_swo_no - SWO task has discrepancies
- Join:
Sample rows (from live DB)
swodesc_swo_no | swodes_action_chg_flag | swodes_action_flag | swodes_atano | swodes_created_by | swodes_created_date |
|---|---|---|---|---|---|
| FWO-000001-2011 | — | CLSD | 100 | MDASILVA | 2011-11-20 14:48:01.053 |
| CWO-000113-2012 | — | CLSD | 00-00 | DMUSER | 2012-01-03 19:38:45.910 |
| CWO-000017-2011 | — | UNRES | 00-00 | DMUSER | 2012-01-06 19:36:29.610 |
Showing 3 of 1,760 rows.