sp279_range_defaults
- Jason Andrew
Owned by Jason Andrew
Oct 02, 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 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. |