Document toolboxDocument toolbox

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
keywordvarchar2(12)  (error)
minfloat(126)Use database negative limit. (tick)
maxfloat(126)Use database positive limit. (tick)
decimal_placesnumber Use database limit.(tick)
field_idvarchar2(100) Key to language translations for keyword. (error) 

Keys

primary key (keyword) 
foreign key (field_id) references sp900_language_translation (field_id)

Primary Key Referenced From

 

Column Descriptions

FieldDescription
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_idKey to language translations for keyword.