/
sp203_holiday_assignments
sp203_holiday_assignments
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
Analytics
Loading data...
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) | |
Keys
primary key (employee_no, holiday_spec)
foreign key (employee_no) references sp210_employees (employee_no)
foreign key (holiday_spec) references sp106_holiday_specifications (holiday_spec)
Column Descriptions
| Field | Description |
|---|---|
| employee_no | Internal number for this employee. |
| holiday_spec | Internal number for this Holiday specification. |
, multiple selections available,
Related content
14.1 sp203_holiday_assignments
14.1 sp203_holiday_assignments
More like this
14.1 sp106_holiday_specifications
14.1 sp106_holiday_specifications
More like this
14.1 sp107_holidays
14.1 sp107_holidays
More like this