Allocation Compliance for RM – SQL

The Allocation Compliance by Resource (Resource Manager) portlet gives a view of resource allocation compliance for all active resources the logged in user is the Resource Manager for.  It allows the RM to see resources they manage over the coming months and whether they are over or under allocated.  This portlet leverages the daily allocation and daily availability slices as well as only active investments.  The portlet provides filters for specific dates, filtering by resource ID, and resource name may also be added.