14.1 sp315_custom_number_keyword
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
This table defines the set of possible custom keywords that can be assigned numeric values.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| keyword | varchar2(12) |  | |
| min | float(126) | Use database negative limit. |  |
| max | float(126) | Use database positive limit. | |
| decimal_places | number | Use database limit. | |
| field_id | varchar2(100) | Key to language translations for keyword. | |
Keys
primary key (keyword)
foreign key (field_id) references sp900_language_translation (field_id)
Primary Key Referenced From
Column Descriptions
| Field | Description |
|---|---|
| keyword | The name of the keyword. |
| min | The minimum value that this keyword can be given for this employee. If undefined then this corresponds the most negative possible value. |
| max | The maximum value that this keyword can be given for this employee. If undefined then this corresponds the most positive possible value. |
| decimal_places | The number of permissible digits that can follow the decimal point. This number may not be negative and is enforced by a constraint. |
| field_id | Key to language translations for keyword. |