14.1 sp279_range_defaults
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
This table contains a list of default trigger level ranges (number of days).
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| start_day | number(3,0) | 0 |  |
| default_trigger_value | number(3,0) | | |
| description | varchar2(30) | | |
| field_id | varchar2(100) | |
Keys
primary key (start_day)
unique (description)
foreign key (field_id) references 14.1 sp900_language_translation (field_id)
Primary Key Referenced From
Column Descriptions
| 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. |