14.1 sp236_ext_data_state_changes

This table stores a record of the time at which the employee is effectively created or deleted for the purposes of the external systems.

Table Definition

Primary key (employee_no)
Foreign key (employee_no) references sp210_employees(employee_no)

Field	Description
employee_no	Internal identifier of the affected employee
time_created	Date on which the employee should be created in the external system – is equivalent to the date of the start of the (current) first posting (Employee time zone)
time_deleted	Date after which the employee should be deleted in the external system – is equivalent to the date of the end of the (current) last posting (Employee time zone)