Document toolboxDocument toolbox

14.1 sp113_shift_assignments

Owned by Billy Sewell (Unlicensed)
Jan 26, 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 14.1 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 14.1 sp210_employees (employee_no) 
foreign key (shift_spec) references 14.1 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.