Atrieve Payroll

Employee Earnings Report

This report provides a detailed report for a range of pay periods, listing the employee name and number, pay code and description and the number of hours and earnings against each pay code selected.

This report includes an option to generate an export file, ######.CSV, where ###### is the job number. The export file is generated where the logical SRB$OPSWRK is defined. All fields within the export file have extra spaces removed from front and back of the fields and all fields are separated by a comma.

The export file includes the following fields:

  • Payroll ID code

  • Employee name

  • Employee number

  • Pay code

  • Pay code description

  • Hours

  • Amount

  • Start Period

  • End Period

  • Short pay and deduction code descriptions applied when applicable.

Enter Start Period

  • Enter the period you wish to start the report.

Enter End Period

  • Enter the last period to be included on the report.

Enter Pay Code

  • Accept default to report all pay codes.

  • Enter the pay codes one at a time for a list of pay codes to be reported.

Report All or Selected Employees     

Sort by Employee Number or Name

  • Enter 'E' to produce the report in employee number order.

  • Enter 'N' to produce the report in employee name order.

Include Generation of CSV Export File

  • Enter 'N' to omit the generation of the export file.

  • Enter 'Y' to include the generation of the export file with this report.

The report lists the following:

  • The employee's number and name

  • Pay code and description

  • Total hours and earnings per pay code for an employee for pay periods selected

  • A summary listing total hours and earnings per pay code