14.1 sp072_job_category_parameters
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
This table allows selected scheduler parameters to be overridden for a particular job category. The parameter may be specified per FRU (fru_no is not null) or at system level (fru_no is null). An FRU level parameter is used in preference to a system level parameter. If neither FRU nor system level is available for a job category then the value sp083_system_parameters will be used.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| job_category | number(1) | ||
| fru_no | number(4) |  | |
| name | varchar2(30) | ||
| value | varchar2(80) | |
Keys
unique (job_category, fru_no, name)
foreign key (job_category) references 14.1 sp071_job_categories (job_category)
foreign key (fru_no) references /wiki/spaces/SCH141/pages/27099986 (resp_unit_no)
foreign key (name) references 14.1 sp083_system_parameters (name)
Column Descriptions
| Field | Description |
|---|---|
| job_category | unique identifier for the job category |
| fru_no | if not null, the FRU for which this parameter applies. NULL denotes this applies to all FRUs which do not have a value set up. |
| name | the name of the parameter - currently this is a limited set, only WODC (overdue cost weighting) and WDRJ (deferred job weighting) are valid |
| value | the value of the parameter. A NULL value denotes that this parameter is not set and that the parameter should be fetched from the next level in the hierarchy. |