14.1 sp235_ext_data_attr_changes

This table stores a record of the time at which employees have had data changed in certain attributes (potentially) relevant to external systems.

Table Definition

Field	Type	Default	Nullable
employee_no	number (9)
sp_emp_attribute_type	number (2)
last_update_time	date

Keys

Primary key (employee_no, sp_emp_attribute_type)
Foreign key (employee_no) references sp210_employees (employee_no)
Foreign key (sp_emp_attribute_type) references sp233_ext_data_emp_attr_types (sp_emp_attribute_type)

Column Descriptions

Field	Description
employee_no	Internal identifier of the affected employee
sp_emp_attribute_type	Attribute which has been changed
last_update_time	Date/time at which the attribute was changed (Uses the time zone of the DBMS server machine)