This table specifies the number of minutes a job must be overdue before it will appear in the jeopardy report. If the job is not listed on the jeopardy report, then it is not in jeopardy.

Table Definition

Field	Type	Default	Nullable
resp_unit_no	number(4)
priority_lowest	number(2)
priority_highest	number(2)
tol_overdue	number(5)

Keys

primary key (resp_unit_no, priority_lowest, priority_highest)
foreign key (resp_unit_no) references sp058_responsibility_units(resp_unit_no)

Column Descriptions

Field	Description
resp_unit_no	Number of the Responsibility Unit to which this tolerance value relates.
priority_lowest	Lower end of the range of job priorities to which this tolerance value relates.
priority_highest	Higher end of the range of job priorities to which this tolerance value relates.
tol_overdue	Overdue tolerance value in minutes; only jobs (in the given RU and priority range) which are overdue by at least this value will be listed on the jeopardy report.

Browser not supported