/
14.1 sp313_overdue_tolerance
14.1 sp313_overdue_tolerance
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Analytics
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. |
, multiple selections available,
Related content
sp313_overdue_tolerance
sp313_overdue_tolerance
More like this
14.1 sp502_rsched_lookup_tables
14.1 sp502_rsched_lookup_tables
More like this