14.1 sp313_overdue_tolerance
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
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 /wiki/spaces/SCH141/pages/27099986(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. |