sp072_job_category_parameters

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 sp071_job_categories (job_category)
foreign key (fru_no) references sp058_responsibility_units (resp_unit_no)
foreign key (name) references 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.