/
sp315_custom_number_keyword
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. |
, multiple selections available,
Related content
14.1 sp315_custom_number_keyword
14.1 sp315_custom_number_keyword
More like this
sp316_custom_number_emp_value
sp316_custom_number_emp_value
More like this