This page (revision-96) was last changed on 08-Nov-2023 21:53 by Karen Parrott

This page was created on 26-Nov-2021 10:22 by JEscott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
96 08-Nov-2023 21:53 24 KB Karen Parrott to previous
95 04-Nov-2023 16:55 24 KB Karen Parrott to previous | to last
94 04-Nov-2023 16:46 24 KB Karen Parrott to previous | to last
93 07-Mar-2023 11:54 24 KB Karen Parrott to previous | to last
92 26-Nov-2021 10:22 24 KB Kevin Higgs to previous | to last
91 26-Nov-2021 10:22 23 KB Kevin Higgs to previous | to last
90 26-Nov-2021 10:22 23 KB Kevin Higgs to previous | to last
89 26-Nov-2021 10:22 22 KB kparrott to previous | to last
88 26-Nov-2021 10:22 22 KB kparrott to previous | to last
87 26-Nov-2021 10:22 22 KB kparrott to previous | to last
86 26-Nov-2021 10:22 22 KB kparrott to previous | to last
85 26-Nov-2021 10:22 22 KB kparrott to previous | to last
84 26-Nov-2021 10:22 22 KB kparrott to previous | to last
83 26-Nov-2021 10:22 22 KB kparrott to previous | to last
82 26-Nov-2021 10:22 22 KB kparrott to previous | to last
81 26-Nov-2021 10:22 19 KB kparrott to previous | to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 212 added 71 lines
;ROE Interface Code:
*mandatory, 'HL$CAN-ROEWEB-53' or 'HL$CAN-ROE-WEB', e.g. HL$CAN-ROEWEB-53 or your own ROE Interface code
* NOTE: please copy the supplied HL$CAN-ROEWEB-53 Interface code to a user defined Interface Code and use your code on UPROEF
* if 'HL$CAN-ROEWEB-53' Interface Code is used, the interface file format is generated with the Box 15C 53 weeks format
* if 'HL$CAN-ROE-WEB' Interface Code is used, the interface file format is generated with the Box 15C 27 weeks format
From this ROE Interface Code, the [IDIF] screen Form Type determines the number of pay periods to be used for the Pay Frequency.
If Form Type is 'CDN ROEWeb 53 Weeks', then Box 15A, 15B, 15C number of pay periods used are according to the ROE Guide Chart III as below:
||Pay Frequency|| Box 15A periods|| Box 15B periods ||Box 15C periods
|Weekly| last 53| last 27| last 53
|Bi -Weekly |last 27 |last 14| last 27
|Semi-Monthly| last 25| last 13| last 25
|Monthly |last 13 |last 7 |last 13
If Form Type is 'CDN ROE Definition', then Box 15A, 15B, 15C number of pay periods used are according to the previous ROE guide Box 15A, 15B, 15C requirement, this requirement will be obsolete in the future and replaced by the ROE 53 Weeks reporting.
The UPROEF program can generate ROE Web Interface file in either (1) 53 weeks file format or (2) 27 weeks file format depending on the [IDIF] Form Type You MUST be very careful in choosing the correct ROE Interface Code
;Box 17 Pay Period
If the employee is terminated and has been paid for final pay, the pay header that is marked with 'FINAL PAY METHOD' = '01' will be used to derive Box 15, 17 and 19.
If an employee has not been paid for the 'Final Pay', the system will retrieve the most recent pay header that has the pay category marked as Regular Pay with the Pay Period Ending date on or prior to the user selected As of Date or the Assignment Detail's Leave date (whichever is earlier), this most recent pay period is used to derive Box 15, 17 and 19.
If the user has entered an overridden 'ROE Box 17 Period' on [IEEI] user fields, then this overridden pay period is used for Box 17 and 19 processing.
;Update Mode
You may run UPROEF in Trial mode and verify the ROE information prior to running in Update mode.
If the 'Trial' toggle is checked, then the EMPLOYMENT information will not be updated. If the 'Trial' toggle is not checked (i.e. in Update mode), the following EMPLOYMENT information will be updated if the ROE-STATUS = '01-ROE Required/Request', '03-Duplicate Requested'
;[IEEI] Employment screen
;[ROE-STATUS|ROE_STATUS]:If ROE-STATUS = '01', then ROE-STATUS is updated to '02 - ROE Issued'. If ROE-STATUS = '03 - Duplicate Requested', then update to '04 - Duplicate Issued'
;[ROE-ISSUE-DATE|ROE_ISSUED_DATE]: Update to the ROE Issued Date from parameter of UPROEF run
;[ROE-LETTER|ROE_LETTER]: Update to the ROE Letter of the Termination Reason for the employee or the ROE reason that is overridden for this employee on [IEEI] screen user field 'ROE REASON CODE'
;[IEEI] Employment UDF (User Defined Fields):
;[Prev ROE Upto|??]: The system will update this UDF to store the pay period that the ROE has issued up to. This 'PREV ROE UPTO' UDF will be used for the next ROE so that the information reported on the next ROE will not be prior to this pay period. If you want to re-issue the ROE, you should change this UDF pay period such that the next ROE will generate Box 15 information from this pay period onward
;[ROE 1st Work Date|??]: The system will update this UDF to store the First Work Date the ROE has been issued
;[ROE Last Work Date|??]: The system will update this UDF to store the Last Work Date the ROE has been issued
!Multiple Employments
If employee has multiple Employments on IEEI screen, please request ROE on the 'ROE Status' field for each of the Employment record on IEEI screen.
If multiple Employments belong to the same Government Registration Number, these Employments are combined together and report on one ROE.
If multiple Employments belong to different Government Registration Number, then multiple ROEs will be issued for different Government Registration numbers for the same employee.
You must pay attention to the user-defined fields for each of the Employment record prior to running UPROEF
!Multiple Government Registration Numbers (BN)
From Pay Headers Group code, it determines the Government Registration Number to be reported on ROE.
If employee has been paid by different Group codes, either by multiple Employments or Assignments, then the employee can be paid by one or multiple Government Registration Numbers.
When UPROEF is run, you may request to run for one or multiple Government Registration Numbers.
The design of the ROE Web Training environment only allows HRSDC to create one unique CRA BN for each employer. However, ROE Web Production allows you to create as many BNs as the employer requests/uses. Although you cannot test the multiple BNs in training
environment, this is normal business practice for many Canadian employers so this will be seamless in the production environment.
As well in production, HRSDC have a feature called the "ROE Overlap rule" that enables employers to issue multiple ROEs to the same employee for same periods of employment under different BNs. This must be requested by the employer when they register for ROE Web at a local HRSDC office.
When reporting for multiple Government Registration Numbers for one employee, the employee's most recent pay period that is paid is used to report on multiple ROEs.