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).
- Start - start date of this row’s week
- End - end date of this row’s week
- Year - year
- Week - week number in the year.
- 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
Please sign in to leave a comment.