swo_swoprm_task_param_det
Parameter update details table for SWO system configuration. This table tracks changes to system parameters, configuration updates, and maintains version control for system settings and operational parameters.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Task-level parameter details for SWO execution
This table is the canonical store for the SWOTaskParam entity.
Primary key
swoprm_param_seq_no
Columns (23)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swoprm_created_by | varchar | Created by |
| 2 | swoprm_created_datetime | datetime | Created date |
| 3 | swoprm_exe_remarks | varchar | Remarks |
| 4 | swoprm_followup_action | varchar | Follow-up action defined for parameter |
| 5 | swoprm_followup_task | varchar | Follow-up task defined for parameter |
| 6 | swoprm_modified_by | varchar | Modified by |
| 7 | swoprm_modified_date | datetime | Modified date |
| 8 | swoprm_ouinstance | int | SWO instance |
| 9 | swoprm_param_code | varchar | Parameter code |
| 10 | swoprm_param_mandatory | varchar | Mandatory flag for parameter value reporting |
| 11 | swoprm_param_ou | int | Task component instance |
| 12 | swoprm_param_seq_no 🔑 | int | Parameter sequence number, primary key |
| 13 | swoprm_param_type | varchar | Parameter type |
| 14 | swoprm_param_value | varchar | Parameter value |
| 15 | swoprm_subtsk_seq_no | int | Subtask sequence number |
| 16 | swoprm_sub_task_desc | varchar | Subtask description |
| 17 | swoprm_swo_no | varchar | SWO number |
| 18 | swoprm_task_track_id | bigint | Task track ID |
| 19 | swoprm_trigg_val_max | numeric | Maximum triggering value |
| 20 | swoprm_trigg_val_min | numeric | Minimum triggering value |
| 21 | swoprm_updated_by | varchar | Updated by |
| 22 | swoprm_updated_date | datetime | Updated date |
| 23 | swoprm_upd_mode | varchar | Update mode (new/delta) |
Relationships (1)
- SWOTask (swo_swostk_sub_task_details) →
SWO_HAS_PARAM(this table is target)- Join:
swo_swostk_sub_task_details.swostk_swo_no = swo_swoprm_task_param_det.swoprm_swo_no - SWO task has parameters
- Join:
Sample rows (from live DB)
swoprm_created_by | swoprm_created_datetime | swoprm_exe_remarks | swoprm_followup_action | swoprm_followup_task | swoprm_modified_by |
|---|---|---|---|---|---|
| 00067714 | 2011-11-16 15:46:24.800 | — | — | — | — |
| 00019454 | 2011-11-17 19:28:03.903 | — | — | — | — |
| 00019454 | 2011-11-17 19:28:03.903 | — | — | — | — |
Showing 3 of 621 rows.