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