Actuals/ETC/Allocations per Resource – SQL

The portlet displays posted time by project for the logged in user based on time period and date range.  This allows the user to see at a glance their ETC and actuals on the projects.

The portlet displays the Total Allocation and Total Actuals to Date for the user on the projects they are allocated/assigned to.  The actuals are displayed per month in the form of TSVs.