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