The view ResourceNonWorkingDaySettings returns all non working days for a resource that is inherited from System, Global Workgroup, Workgroups and User Setup.
The NonWorkingDay column is a code to define selected days as follows:
- 1 & r.NonWorkingDay 'Sunday',
- 2 & r.NonWorkingDay 'Monday',
- 4 & r.NonWorkingDay 'Tuesday',
- 8 & r.NonWorkingDay 'Wednesday',
- 16 & r.NonWorkingDay 'Thursday',
- 32 & r.NonWorkingDay 'Friday',
- 64 & r.NonWorkingDay 'Saturday'
For example, 65 means Saturday and Sunday.
The NonworkingDay column also exists in:
- ServerSettings -- System Level
- globalworkgroup
- workgroup
- nonworkingdays -- Resource level