Report lists Hours, Days and Weeks worked by a Payee over 12 months prior to a user defined Date. Report also filters by Employment Start Date (Defaulted to 1 year) and Pay Company. The Employed Before date defaults to 1 year prior to the Tenure As At and excludes Payees who's Employment Start Date is after this date. Data is sorted by Payee Name (Surname, First name). The report has 2 date filters the first filter is the as at date. This is the date the report is run from. The report will return a summary of all Hours, Days and Weeks worked within the 12 month period prior to the as at date. The Pay Period/ Adjustment Period End Date is use to determine what falls within this time frame. Hours are calculated based on the Pay Code Type of Hours only. If a Pay Code is set as Units it will not appear in the calculation. Days are calculated based off distinct Days worked where a pay code has been paid with the Pay Code Type of Hours has been paid. Weeks Worked are calculated based off distinct Weeks worked. The Employed Before date is used to filter out Employees based on their Employment Start date. This date Default to 1 year prior to the time of running the report. If an employee is employed after this date they will not show on this report. As each Pay Company has it’s own ABN the report is grouped by Pay Company. If a Payee works across multiple Pay Companies then the calculations are only based for hours worked under that Pay Company, the calculations are not combined. |