14.1 sp316_custom_number_emp_value

This table holds numeric custom values associated with employees. Valid keywords for these values are held in sp315_custom_number_keyword. For example, if a keyword 'RATE' is defined in sp315, some or all of the employees in sp210_employees could have 'RATE' values stored in this table. Note that these values are never used in any way for scheduling.

Table Definition

Field	Type	Default	Nullable
keyword	varchar2(12)
employee_no	number(9)
value	float(126)

Keys

primary key (keyword, employee_no)
foreign key (keyword) references 14.1 sp315_custom_number_keyword (keyword)
foreign key (employee_no) references 14.1 sp210_employees (employee_no)

Column Descriptions

Field	Description
keyword	The keyword column of sp315_custom_number_keyword.
employee _no	An index into the table of the entity to which this keyword is being mapped. For operatives this is the index column of sp210_employees.
value	The value this keyword is given for this employee.