Summary

The Employee Rates Report shows employees' rates for the rate codes that you specify in report settings as at the date/time the report is run.

The report is designed to produce 2 files every time you run it. One copy respects the Report Destination Format settings. The other is txt file.

RBVersion

RB14

Report Settings

Details Tab

Employee

Select the employee you want to run the report for or leave empty to run for all employees as per other filtering options.

The field respects user security and adhoc queries applied to the Employee table.

Selecting an employee deactivates the Query field

Query

The Query field allows you to run the report for a subset of employees without needing to select values from the Filter tab (Department, Location, CostCentre, DIMs1-4).

The Query field is only active if the Employee field is empty.

You can select any Query record on the Employees entity that does not have the Security field ticked.

Export filename (for the txt file)

The Export filename field allows you to set an alternative filename and file directory to the Report Destination Format settings.

Include Terminated Employees

Select:

• Yes to include
• No to exclude

Rate Codes (Rate 1 - Rate 10)

There is a separate field for each rate code you wish to see a reported value. The report caters for a maximum of 10 rate codes.

Filters

If you only want to run the report for certain areas of your organisation, then instead of populating the Employee or Query field on the Details tab you can apply selection criteria on the following tab pages:

• Departments
• Location
• CostCentre
• DIMs1-4

Sorting

Use the Sorting tab to define the order that you want your results presented.

The default sort order for this report is Employee Name.

You can apply also sort by:

• Departments
• Location
• CostCentre
• DIMs1-4

And then by either Employee Name or Employee code

Output

This report is designed to out a PDF and a txt file only.

Other than a Group Header if you applied sorting by: Department, Location, CostCentre or DIMs1-4, the report will display the following fields:

• Employee Code
• Employee Name (format: Lastname, Firstnames
• Rate Code and Rate Description - one column per rate code

Most Rates will show a rate as at 'today's' date (i.e. date/time you run the report. In respect to the NZ Holiday Act Rates that use the Rate Calculations "PW" and "QW" you will see the following:

• PW - Abides the OWP 4 week lookback rule as:

  Employee.LastPaid minus 4 weeks plus 1 day or back to employment start date whichever is the smallest range.

• QW - Abides the AWE 12 month lookback rule as: Employee.LastPaid minus 12 months plus 1 day or back to employment start date whichever is the smallest range.

If the OWP or AWE weekly rate is converted to an Hourly/Daily rate using a Factor Calculation, then the divisor uses the Employee’s DOW record where “today” falls within DOW record date range.