14.1 sp641_break_overrides

This table identifies break override details for a shift override referenced in sp064.

HouseKeeping

This table is tidied by sp_dbtidy's Global group

Table Definition

Field	Type	Default	Nullable
employee_no	number(9)
override_date	date
break_name	varchar(20)
break_type	number(4)
break_start	number(4)
break_end	number(4)
duration	number(4)

primary key (employee_no, override_date, break_name)

foreign key (employee_no, override_date) references 14.1 sp064_overrides (employee_no, override_date)

Field	Description
employee_no	Identifies the employee.
override_date	Identifies the date. Uses FRU local time zone.
break_name	Identifies the break.
break_type	The type/status: Default scheduled = 0 Overridden = 1 Fixed = 2 Started = 3 Finished=4
break_start	The break earliest start time (minutes after midnight). Uses employee (operative) time zone.
break_end	The break latest start time (minutes after midnight). Uses employee (operative) time zone.
duration	The duration in minutes of the break.