swo_swoobs_observation_list
Stores metadata for routing details within the SWO system. This table contains routing rules, workflow definitions, approval hierarchies, and routing logic used to manage work order processing and approvals.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: List of observations recorded during SWO execution
This table is the canonical store for the SWOObservation entity.
Primary key
swoobs_obs_id
Columns (12)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swoobs_created_by | varchar | Created by |
| 2 | swoobs_created_date | datetime | Created date |
| 3 | swoobs_modified_by | varchar | Modified by |
| 4 | swoobs_modified_date | datetime | Modified date |
| 5 | swoobs_obs_desc | varchar | Observation description |
| 6 | swoobs_obs_id 🔑 | bigint | Observation ID, primary key |
| 7 | swoobs_ouinstance | int | SWO instance |
| 8 | swoobs_reported_by | varchar | Reported by |
| 9 | swoobs_reported_datetime | datetime | Reported date |
| 10 | swoobs_swo_no | varchar | SWO number |
| 11 | swoobs_task_code | varchar | Task code associated with discrepancy/observation |
| 12 | swoobs_task_track_id | int | Task track ID for task code |
Relationships (1)
- SWOTask (swo_swostk_sub_task_details) →
SWO_HAS_OBSERVATION(this table is target)- Join:
swo_swostk_sub_task_details.swostk_swo_no = swo_swoobs_observation_list.swoobs_swo_no - SWO task has observations
- Join:
Sample rows (from live DB)
swoobs_created_by | swoobs_created_date | swoobs_modified_by | swoobs_modified_date | swoobs_obs_desc | swoobs_obs_id |
|---|---|---|---|---|---|
| DMUSER | 2013-04-06 11:33:43.227 | DMUSER | 2013-04-06 11:33:43.227 | Dent | -2147483648 |
| DMUSER | 2013-04-06 12:01:38.310 | DMUSER | 2013-04-06 12:01:38.310 | Dent | -2147483647 |
| DMUSER | 2013-04-15 12:02:44.700 | DMUSER | 2013-04-15 12:02:44.700 | Dent | -2147483646 |
Showing 3 of 317 rows.