sp502_rsched_lookup_tables

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 sp058_responsibility_units (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.