14.1 sp502_rsched_lookup_tables
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
Each job has an initial priority when it is input into ServiceOptimizer. On initialisation the optimizer will read in and set up an internal version of this table to be applied to the overdue penalty for a job depending on its degree of lateness and its job priority.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| resp_unit_no | number(4) |  | |
| start_priority_range | number(2) | | |
| end_priority_range | number(2) |  | |
| start_overdue_range | number(5) | | |
| end_overdue_range | number(5) | | |
| cost_factor | number(3) | |
Keys
primary key (resp_unit_no, start_priority_range, start_overdue_range)
foreign key (resp_unit_no) references /wiki/spaces/SCH141/pages/27099986 (resp_unit_no)
Column Descriptions
| Field | Description |
|---|---|
| resp_unit_no | Responsibility unit identifier. |
| start_priority_range | Lower end of Job Priority Range. |
| end_priority_range | Higher end of Job Priority Range. |
| start_overdue_range | Lower end of Degree of Lateness range in minutes. |
| end_overdue_range | Higher end of Degree of Lateness range in minutes. |
| cost_factor | Overdue Penalty factor. |