14.1 sp230_ext_data

This table stores the actual value (or mapping to employee attribute) for data required by external systems pertaining to individual employees.

Table Definition

Field	Type	Default	Nullable
employee_no	number(9)
external_data_type	number(9)
sp_emp_attribute_type	number(2)
value	varchar2(50)
last_update	date

primary key (employee_no, external_data_type)
foreign key (employee_no) references sp210_employees(employee_no)

Field	Description
employee_no	The identifier of the employee to whom this data relates.
external_data_type	The identifier of the data type related to the external system.
sp_emp_attribute_type	Denotes whether this data item is mapped to an attribute of the ServiceScheduling employee data and, if so, which attribute.
value	If sp_emp_attribute_type = 0 this is the actual value supplied for the external system data item. If sp_emp_attribute_type is not 0 this field should be null.
last_update	The date and time at which this data was last updated (Uses the time zone of the DBMS server machine).