Missing Time by OBS – SQL

The Missing Time by OBS portlet displays all missing or late timesheets for resources staffed within a specific OBS.   Resources will be included if they are open for time entry, have the track mode of ‘Clarity’ and have a timesheet that is not posted. The portlet accommodates for hire and termination dates.  Also, the portlet only shows resources that the active user has the security rights to view.

Administrators and the Project Management Office may use this portlet to determine the timesheet status of all resources within a specific OBS in open time periods. This portlet allows a user to quickly search by OBS and view all timesheets under that area. After selecting the OBS, the user can also filter on time period start date, Resource Manager and/or Project Manager. The portlet will display a ‘Stop Light’ indicator based on timesheet status, the status, period start, Resource Name, Resource Manager and any actual hours entered for the timesheet.