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
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

Browser not supported