Timesheets by Resource – SQL

The Timesheets by Resource portlet gives the ability to highlight the time periods where resources are working overtime or working less than 25 hours a week. The filter requires timesheet Start Date and End Date to be provided. Additionally, the information can be filtered by Resource, Resource ID, OBS Unit, Employment Type, Resource Manager, Open for Time, and Active status.

This portlet displays Resource, Resource ID, Active (yes/no), Employment Type, Primary Role, Resource Manager, and Timesheet Hours Flag. The flags are set with the logic

• Yellow = timesheets not posted / zero hour timesheets
• Green = where number of hours posted is > 25 and less than 45
• Red = where number of hours posted is < 25 or > 45

The thresholds can, of course, be modified.