Custom Report: Employees - Timeclock - Previous Week Comparison

Report Description:
Shows one row for each of past 5 week’s time clock counts by jobcode with columns for each day and week’s total, plus rows for last two years numbers for the first week displayed in the report (the week prior to current week).


Columns Displayed:

  • Start - start date of this row’s week
  • End - end date of this row’s week
  • Year - year  
  • Week - week number in the year.
  • Jobcode
  • Column for hourly counts for each day of the week (Mon, Tue...Sat) and Total




Download the SQL code as a .txt file


Disclaimer: Custom SQL reports can be used or modified by RGP customers at their own discretion. However, due to the custom nature of each report and the varying size of a customer's database, some reports may be slow to run (or may not run at all).  All support and/or modifications requested of these public, custom reports will follow the standard Custom SQL Report fee structure.

Please also see: Adding Custom SQL Reports

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request



Please sign in to leave a comment.