14.1 sp013_non_working_days
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
This table contains a list of which public holidays or days of the week are considered to be non-working days. These days are excluded from any auto-scheduling and affect the calculations of various data for reporting purposes.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| resp_unit_no | number(4,0) |  | |
| day_or_specno | number(4,0) | | |
| type | number(1,0) | 0 | |
Keys
primary key (resp_unit_no, type, day_or_specno)
foreign key (resp_unit_no) references sp058_responsibility_units (resp_unit_no)
Column Descriptions
Field | Description |
|---|---|
| resp_unit_no | responsibility Unit |
| day_or_specno | Weekday number or Holiday Spec number - which it is depends upon type column - if weekday: 0 - Sunday 1 - Monday 2 - Tuesday 3 - Wednesday 4 - Thursday 5 - Friday 6 - Saturday |
| type | Type of entry: 0 - weekday 1 - holiday spec |