My Assignments – SQL

The My Assignments portlet will display the assignments for the logged in user – pulling data from the timeslices. It is used as a quick reference for the users to view their assignments across all of the projects. The portlet also displays work posted against the task, expressed in Actuals, and remaining work to be done, expressed as an Estimate to Complete (ETC).  The Effort Variance reflects what the ETC variance is compared to the last current baseline of the project.