Project Time Summary – SQL

Project managers may use this portlet to show the planned effort and the remaining effort on projects.  Includes actual hours as well as estimate at completion. You may narrow the results by filtering by project name, project manager, project OBS, or active flag. The portlet will display each project by ID, name, project manager, planned effort (total allocation hours), actual hours, remaining effort (ETC), and estimate at complete (actual + ETC).