iCare Knowledge Base

To make sure all the punch activity data has been properly accounted into the Payroll Hours reports you need cross check the Punch Activity report with the Payroll Hours report.

Also you can use the query given below to do the cross checking. The query below has to be run according to the instructions in the article: http://www.orgamation.com/KB/solution_id_1222.html.

The cross check query for the Payroll Hours report is:

SELECT pa_PunchActivity.Id, sr_Staff.LastName, sr_Staff.FirstName, pa_PunchActivity.Date
FROM sr_Staff INNER JOIN pa_PunchActivity ON sr_Staff.Staff_Id = pa_PunchActivity.Id
WHERE (((pa_PunchActivity.CheckChild)=False) AND ((pa_PunchActivity.IsVoid)=False))
GROUP BY pa_PunchActivity.Id, sr_Staff.LastName, sr_Staff.FirstName, pa_PunchActivity.Date
HAVING (((pa_PunchActivity.Date)>=#8/1/2009# And (pa_PunchActivity.Date)<=#8/31/2009#));

In the query you will need to replace the date values at 2 places; the first date represnts the start date of the period and the second date represents the end date of the period.