This table provides a persistent store for dispatch messages generated as result of changes to breaks so that they can be recovered in the event of system failure. This record references the SP207_dispatch_messages There will be one sp208 record for each break.

HouseKeeping

This table is tidied by sp_dbtidy’s Global group (messages that have lost their ‘posting’ as the engineer has move to another FRU), and by the Job group (specific jobs)

Table Definition

Field	Type	Default	Nullable
message_no	number(9)
break_name	varchar(20)
break_type	number(1)
break_start_earliest	date
break_start_latest	date
break_duration	number(6)

Keys

primary key (message_no, break_name)

foreign key (message_no) references 14.1 sp207_dispatch_messages (message_no)

Column Descriptions

Field	Description
Message_no	The unique id references SP207_dispatch_messages
Break_name	Identifies the break
Break_type	The type/status: Default scheduled = 0 Overridden = 1 Fixed = 2 Started = 3 Finished=4
Break_start_earliest	The earliest start time for the break (FRU time zone)
Break_start_latest	The latest start time for the break (FRU time zone)
Break_duration	The duration in minutes of the break

Browser not supported