sp279_range_defaults

This table contains a list of default trigger level ranges (number of days).

Table Definition

Field	Type	Default
start_day	number(3,0)	0
default_trigger_value	number(3,0)
description	varchar2(30)
field_id	varchar2(100)

primary key (start_day)
unique (description)
foreign key (field_id) references sp900_language_translation (field_id)

Field	Description
start_day	Earliest day to which this range applies.
default_trigger_value	Default trigger value.
description	Textual Description.
field_id	Look up into sp900 for language translations of description.