Document toolboxDocument toolbox

sp113_shift_assignments

Owned by Jason Andrew
Oct 02, 2024

This table records the allocation of employees to particular shift patterns. An employee can only be allocated to one shift pattern on a given date. The Shift Patterns are defined in Scheduling Constraints Tables

HouseKeeping

This table is tidied by sp_dbtidy's Global group.

 

Table Definition

Field
Type
Default
Nullable
employee_nonumber(9) (error)
shift_specnumber(4)  (error)
start_datedate (error)
end_datedate (tick)

Keys

primary key (employee_no, start_date) 
foreign key (employee_no) references sp210_employees (employee_no) 
foreign key (shift_spec) references sp114_shift_specifications (shift_spec)

Column Descriptions

FieldDescription
employee_no Employee's identifier.
 shift_spec Identifier of the shift pattern.
start_dateThe date on which the employee commences working to the specified shift pattern. Uses employee's Time Zone.
end_dateThe date on which the employee ceases to work to the specified shift pattern. Uses employee's Time Zone.

 

Â