14.1 sp202_trigger_values

This table contains the 'trigger at' values. When the number of changes for the given day or range of days reaches the trigger at value, this causes the Optimizer to be run for that day or range of days.

Table Definition

Field	Type	Default	Nullable
resp_unit_no	number(4,0)
trigger_value	number(3,0)
start_day	number(3,0)

Keys

primary key (resp_unit_no, start_day)
foreign key (resp_unit_no) references /wiki/spaces/SCH141/pages/27099986 (resp_unit_no)
foreign key (start_day) references 14.1 sp279_range_defaults (start_day)

Column Descriptions

Field	Description
resp_unit_no	Responsibility Unit number.
trigger_value	Trigger at value .
start_day	Earliest day to which this value applies.