/
sp202_trigger_values
sp202_trigger_values
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
Analytics
Loading data...
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 sp058_responsibility_units (resp_unit_no)
foreign key (start_day) references 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. |
, multiple selections available,
Related content
14.1 sp202_trigger_values
14.1 sp202_trigger_values
More like this
sp279_range_defaults
sp279_range_defaults
More like this