14.1 sp203_holiday_assignments

This table records the allocation of employees to particular holiday specifications (e.g. a particular set of public holidays).

Table Definition

Field	Type	Default	Nullable
employee_no	number(9)
holiday_spec	number(4)

primary key (employee_no, holiday_spec)
foreign key (employee_no) references 14.1 sp210_employees (employee_no)
foreign key (holiday_spec) references 14.1 sp106_holiday_specifications (holiday_spec)

Field	Description
employee_no	Internal number for this employee.
holiday_spec	Internal number for this Holiday specification.