Time Off by Day – SQL

The Time Off by Day portlet displays resource availability by day. The portlet results may be filtered on: Resource Manager, Booking Manager, Resource, OBS Unit, and Date Range. This portlet will display the availability for each resource by day in separate columns and obtains the information from the time slices. When the portlet encounters an exception day (personal day off, or holiday on the base calendar), a yellow caution icon will appear within the same cell. Using this portlet, resource managers are able to quickly determine availability for their resources over a set time range.