sp315_custom_number_keyword
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. |