sp313_overdue_tolerance
- Jason Andrew
Owned by Jason Andrew
Oct 02, 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 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.  |