Document toolboxDocument toolbox

sp208_dispatch_breaks

Owned by Jason Andrew
Oct 02, 2024
1 min read

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)  (error)
break_namevarchar(20)    (error)
break_type  number(1)   (error)
break_start_earliest  date (error)
break_start_latest date   (error)
break_durationnumber(6) (error)

Keys 

primary key (message_no, break_name)

foreign key (message_no) references sp207_dispatch_messages (message_no)

Column Descriptions

FieldDescription

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_durationThe duration in minutes of the break