ROE Report
The ROE Report allows you to produce a listing of any of the three types of ROE's. This report can report preliminary, finalized or voided ROE's.
This report includes an option to generate an export file, ######.CSV, where ###### is the job number. The CSV file is generated in the work directory of the payroll, pointed to by the logical SRB$OPSWRK. The CSV file can be opened directly in Excel or emailed/Uploaded from the Email process on the main menu. Note: This extract file is for information purposes only. This format cannot be submitted to HRDC.
The export file includes the following fields:
Fields | Fields |
|---|---|
Payroll ID | Other Code 1 to 3 |
Employee Number | Other Pay 1 to 3 |
Employee Name | Other Start Date 1 to 3 |
SIN | Other End Date 1 to 3 |
Employer Constants | Special Code 1 to 4 |
Pay Cycle | Special Pay 1 to 4 |
First Day Worked | Special Type 1 to 4 |
Last Day Paid | Special Start Date 1 to 4 |
Final Pay End Date | Special End Date 1 to 4 |
Reason Code | Comments |
Occupation | ROE Number |
Returning | Amended ROE Number |
Recall Date | Taxation Number |
Total Hours | Pay Type |
Total Earnings | Language |
PP 1 to 52 insurable earnings | Reason Contact |
Vacation Code | Reason Phone |
Vacation Amount | Issuer |
Vacation Start Date | Issuer Phone |
Vacation End Date | Issuer Extension |
Stat Date 1 to 10 | Signer |
Stat Pay 1 to 10 | Export File, if applicable |
Creation Date |
Report Preliminary, Finalized or Voided ROEs
Enter 'P' to produce a report of preliminary ROE's.
Enter 'F' to produce a report of finalized ROE's.
Enter 'V' to produce a report of voided ROE numbers. When Voided ROEs is selected, the following prompts do not apply. There is no extract for the Voided ROE option.
When 'P'reliminary ROE report was selected:
Sort by Employee Name, Number, Date, Employer
Enter 'E' to produce the preliminary ROE report in employee number sequence.
Enter 'N' to produce the preliminary ROE report in employee name sequence.
Enter 'D' to produce the preliminary ROE report in status date sequence.
Enter 'M' to produce the preliminary ROE report in ROE Employer number sequence.
When 'D'ate or E'M'ployer sequence is selected on preliminary ROE's:
Secondary Sort by Employee Name Or Number
Enter 'E' to produce the preliminary ROE report sorted by employee number within Date or Employer number.
Enter 'N' to produce the preliminary ROE report sorted by employee name within Date or Employer number.
When 'F'inalized ROE report was selected:
Sort By Employee Name, Number, Date Or ROE Number
Enter 'E' to produce the finalized ROE report by employee number sequence.
Enter 'N' to produce the finalized ROE report in employee name sequence.
Enter 'D' to produce the finalized ROE report in finalized date sequence.
Enter 'R' to produce the finalized ROE report in ROE number sequence.
When 'D'ate sequence is selected on finalized ROE's:
Secondary Sort by Employee Name Or Number
Enter 'E' to produce the finalized ROE report sorted by employee number within date.
Enter 'N' to produce the finalized ROE report sorted by employee name within date.
Select By Employee No, Pay Cycle, Employer Constants
Enter 'E' to select ROEs by employee number.
Enter 'C' to select ROEs by pay cycle code.
Enter 'R' to select ROEs by employer constants code.
When selected by 'E'mployee was chosen:
Report all or selected employees
When Selected by Pay 'C'ycle was chosen:
Pay Cycle Codes for selection
Enter one or up to 15 pay cycle codes. ROEs created with the selected pay cycle codes will be included.
When selected by 'R' Employer Constants was Chosen:
ROE Employer Constant Number for Selection
Enter the employer constant to be used to select the ROEs created using the defined ROE constant.
The report lists the following:
For Preliminary ROE Report:
Employee number, name and SIN
XML format flag Y/N
Employee's pay cycle code
ROE Employer number
Status date and status description
Total number of preliminary ROE's printed
For Finalized ROE Report:
Employee number and name
ROE and Amended ROE number
ROE Employer number and status date
Total number of finalized ROE's printed
For Voided ROE Report:
ROE number
Date and comment
Total number of voided ROE's printed