Document toolboxDocument toolbox

sp641_break_overrides

Owned by Jason Andrew
Oct 02, 2024
1 min read

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_nonumber(9) (error)
override_datedate (error)
break_namevarchar(20) (error)
break_typenumber(4) (error)
break_startnumber(4) (error)
break_endnumber(4) (error)
durationnumber(4) (error)

Keys

primary key (employee_no, override_date, break_name)

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

Column Descriptions

FieldDescription
employee_noIdentifies the employee.
override_date

Identifies the date.

Uses FRU local time zone.

break_nameIdentifies 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.

durationThe duration in minutes of the break.