14.1 sp372_op_day_breaks

This table specifies break details that are persisted.

Table Definition

Field	Type	Default	Nullable
employee_no	number(9)
schedule_date	date
break_name	varchar(20)
break_start_time	date
break_duration	number(6)
break_type	number(1)
is_dispatched	number(1)
isdst	number(1)

primary key (employee_no, schedule_date, break_name)

Field	Description
employee_no	Identifies the employee.
schedule_date	Identifies the date. In ServiceScheduling 9.0.x, uses FRU local time zone. In ServiceScheduling 9.1.x and greater, uses UTC time zone.
break_name	Identifies the break.
break_start_time	The actual date and start time of the break. In ServiceScheduling 9.0.x, uses FRU local time zone. In ServiceScheduling 9.1.x and greater, uses UTC time zone.
break_duration	The duration in minutes of the break.
break_type	The type/status: Default scheduled = 0 Overridden = 1 Fixed = 2 Started = 3 Finished = 4
is_dispatched	The dispatch status of the break.
isdst	The daylight saving flag.