swo_swores_swo_res_det
Stores quick codes used throughout the SWO system for efficient data entry and standardization. This table contains predefined codes for common operations, statuses, and categories to streamline data input and ensure consistency.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Resource details linked to each SWO
This table is the canonical store for the SWOResourceDetail entity.
Primary key
swores_res_seq_no, swores_task_track_id
Columns (32)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swoprt_confirmed_nos | numeric | Number of resources confirmed after execution |
| 2 | swoprt_confirmed_time | numeric | Time confirmed for the execution of resources |
| 3 | swoprt_req_nos | numeric | Number of resources required for the task |
| 4 | swoprt_req_time | numeric | Time required to complete the task |
| 5 | swores_baseline_rev_no | int | Baseline revision number incremented upon confirmation |
| 6 | swores_coa_flag | varchar | Flag indicating COA applicability |
| 7 | swores_created_by | varchar | Records the user who created the resource estimation entry |
| 8 | swores_created_date | datetime | Captures the creation date for the resource estimation entry |
| 9 | swores_curr_rev_no | int | Current revision number for the work order or resource estimation |
| 10 | swores_est_cost | numeric | Estimated cost for the task or resource |
| 11 | swores_est_done | varchar | Flag indicating whether estimation is complete |
| 12 | swores_est_nos | numeric | Estimated number of resources required |
| 13 | swores_est_rate | numeric | Rate applied for the estimated resources |
| 14 | swores_est_remarks | varchar | Remarks related to estimation |
| 15 | swores_est_time | numeric | Estimated time for completing the task |
| 16 | swores_est_time_uom | varchar | Unit of measure for the estimated time |
| 17 | swores_modified_by | varchar | Records the user who modified the resource estimation entry |
| 18 | swores_modified_date | datetime | Captures the modification date for the resource estimation entry |
| 19 | swores_ouinstance | int | Organizational unit instance associated with the resource estimation |
| 20 | swores_plan_unplan_flag | varchar | Flag identifying whether the estimation is for planned or unplanned work |
| 21 | swores_rep_class | varchar | Repair classification for the resource estimation |
| 22 | swores_res_code | varchar | Code identifying the resource |
| 23 | swores_res_seq_no 🔑 | bigint | Unique identifier for the resource estimation record |
| 24 | swores_res_type | varchar | Type of resource being estimated |
| 25 | swores_std_nos | numeric | Standard number of resources required based on task requirements |
| 26 | swores_std_time | numeric | Standard time allocated for the task |
| 27 | swores_std_time_uom | varchar | Unit of measure for the standard time |
| 28 | swores_task_track_id 🔑 | bigint | Task track ID linked to discrepancies or observations |
| 29 | swores_timestamp | int | Timestamp for the resource estimation record |
| 30 | swores_used_nos | numeric | Number of resources used in execution |
| 31 | swores_used_time | numeric | Time spent in execution |
| 32 | swores_warranty_flag | varchar | Flag indicating if the task is under warranty |
Relationships (1)
- SWOTask (swo_swostk_sub_task_details) →
SWO_HAS_RESOURCE(this table is target) (no automatic join)- SWO task has resource details