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 14 changed one line
!Step 1 - Define User Fields For [IEEI] Employment Screen in [IMUF]
!Step 1 - Define User Fields For [IEEI] Employment Screen & [IPPH] Employee Pays in [IMUF]
At line 16 changed one line
There are user fields on the [IEEI] Employment screen to be used by the UPROEF. If the user fields do not exist on [IMUF] screen, UPROEF program will generate the user fields automatically.
There are user fields on the [IEEI] Employment screen and the [IPPH] Employee Pays screen to be used by the UPROEF. If the user fields do not exist on [IMUF] screen, UPROEF program will generate the user fields automatically.
At line 21 changed one line
If you are a first time user for UPROEF (ROE XML) or in a new database environment, please run UPROEF in Trial mode for any one employee. UPROEF will generate all user-defined fields on IMUF for ROE processing to be entered on IEEI, IPCL, IDTR and IDGR screens.
If you are a first time user for UPROEF (ROE XML) or in a new database environment, please run UPROEF in Trial mode for any one employee. UPROEF will generate all user-defined fields on IMUF for ROE processing to be entered on IEEI, IPCL, IDTR, IDGR and IPPH screens.
At line 23 changed one line
!Step 2 - Define User Fields for ROE in [IEEI]
!Step 2 - Define User Fields for ROE in [IPPH]
On the ‘Final Pay’ of the employee on IPPH screen, user can manually enter the Vacation Pay amount, Start Date, End Date, Statutory Holiday Pay and all the information that is required for Box 17, Box 19 for this pay
If the employee has no ‘Final Pay’ and the user wants to review the ROE by running UPROEF, then the most recent Pay Header that is closed will be used, Box 17 / 19 information can be entered
The default Box 17, 19 information will be derived by UPROEF using the IPPE ROE Elements for the Final Pay or the most recent Closed Pay if IPPH or IEEI UDF ROE information are not manually entered, please see below for list of ROE Elements
The Pay Header’s Group is used to retrieve the IDGR Government Registration Number (BN), the IPPH ROE UDF information will be reported under this
Defining ROE Box 17, 19 information at the Pay Header UDF level allows the user to pay and keep all related monetary amounts at the ‘Final Pay’ and to specify all DATES related to this ‘Final Pay’, e.g. Statutory Holiday Date, Special Payment Date etc
When employee is paid by Multiple Government Registration number (Group), the user can enter ROE Box 17, 19 information on Pay Header of the ‘Final Pay’ that is for a specific BN
When UPROEF is run in non-Trial mode, the UDF of this ‘Final Pay’ or the most recent Pay Header will be updated
Note: IPPH UDF ‘Prev ROE Upto’, ‘ROE 1ST Work Date’, ‘ROE Last Work Date’ are system maintained, no need to enter this
;Multiple Government Registration Examples:
An employee can be paid by more than one Government Registration Number (i.e. BN Business Number), the ‘Final Pay’ of the Pay Header will be used to retrieve ROE information
Example (1) – one Employment record on IEEI, two BN
* an employee has one IEEI employment, two IEAS Assignments belong to two Groups (Full time and Part time), each Group has different IDGR Government Registration Number
* IPPH has been paid for 2 Groups: Fulltime and Parttime
Example (2) – Multiple Employment records on IEEI, same BN
* an employee has been terminated and re-hired, multiple records on IEEI for the same BN
* IPPH has been paid for the subsequent IEEI record
* On 'Final Pay', user can enter ROE Box 17 / 19 information on Pay Header
* Employee will be reported under same BNe
!Step 3 - Define User Fields for ROE in [IEEI]
At line 57 added 2 lines
NOTE: User can manually enter Box 17, Box 19 information on IPPH UDF or IEEI UDF. The IPPH UDF level will be used if it exists, otherwise the IEEI UDF level will be used.
At line 60 added one line
At line 29 changed one line
For a list of User Defined fields for ROE and what they are used for review the page [ROE User Defined Fields|ROE USER DEFINED FIELDS].
When UPROEF is run in non-Trial mode, the UDF of the 'Final Pay' (or for most recent) will be updated, however the IEEI UDF will only be udpated for the following general information:
* Prev ROE Upto
* ROE 1st Work Date
* ROE Last Work Date
* ROE Submitted 1
* ROE Submitted 2
At line 31 changed one line
!Step 3 - Define User Fields For Pay Calendars - Pay Period Type in [IMUF]
__ROE User Defined Fields__
[{InsertPage page='ROE_USER_DEFINED_FIELDS'}]
!Step 4 - Define User Fields For Pay Calendars - Pay Period Type in [IMUF]
At line 34 changed one line
!Step 4 - Request For ROE in [IEEI]
!Step 5 - Request For ROE in [IEEI]
At line 37 changed one line
!Step 5 - Define Pay Period Type For ROE in [IPCL]
!Step 6 - Define Pay Period Type For ROE in [IPCL]
At line 47 changed one line
You may enter one of the above letters in the [ROE Pay Frequency|ROE PAY FREQUENCY (UDF)] field on [IPCL], otherwise the [IPCL] Pay Frequency description first letter will be used.
You may enter one of the above letters in the [ROE Pay Frequency(UDF)|ROE PAY FREQUENCY (UDF)] field on [IPCL], otherwise the [IPCL] Pay Frequency description first letter will be used.
At line 51 changed 3 lines
!Step 6 - Define Termination Reason Code [IDTR]
The user may enter the 3 character [ROE Reason Code|ROE REASON CODE (UDF)] on [IDTR] screen for the termination code.
To enter this user field on [IDTR] screen, you must click the header section and then click the UDF button.
!Step 7 - Define Termination Reason Code [IDTR]
There are 3 ways in which the ROE Reason Code can be defined for employees
||Form||Column Name||Prompt||Lexicon||Length||Processing Order
|IEEI|ROE_LETTER|ROE Letter|X_ROE_LETTER|1 Digit|If populated this value will be used
|IDTR|ROE_REASON|ROE Reason Code|X_ROE_REASON|3 Digits|If the IEEI is not populated this value will be used
|IDTR|ROE_LETTER|ROE Reason|X_ROE_LETTER|1 Digit|If the IEEI and UDF are not populated this value will be used
The system will first check to see if a value has been entered into the IEEI in the ROE Letter field.
If the IEEI is not updated, the system will pull the value from the TERMINATION_REASON set up on [IDTR] and used when [IETR] is called.
On the IDTR there are 2 options for entering an ROE reason on the IETR if the IEEI ROE Reason Code is left blank.
1) The user may enter the 3 character [ROE Reason Code|ROE REASON CODE (UDF)] on [IDTR] screen for the termination code.
This UDF is linked to the lexicon [X_ROE_REASON].
To enter this user field on [IDTR] screen, you must click the header section and then click the UDF button.
Optionaly this field can also be added to the form using the IMFDH.
2) If the UDF is left blank then the value selected in the ROE_REASON field found on the IDTR can be used.
This column uses the [X_ROE_LETTER] lexicon for the ROE.
At line 119 added 2 lines
\\
\\If ROE Reason is with the old format with one character only, UPROEF will concatenate with ‘00, e.g. ‘K’ is changed to ‘K00’
At line 56 changed 2 lines
!Step 7 - Define FolderCD User Field [IDGR]
The user may enter the [ROE FolderCD|ROE FolderCD (UDF)] on [IDGR] screen for the Group code.
!Step 8 - Define FolderCD User Field [IDGR]
The user may enter the following information on the [IDGR] screen for the Group code:
* [ROE FolderCD|ROE FolderCD (UDF)] - it is used to identify in which folder the ROE in the payroll extract file is to be filed
* [ROE ORGNUM|ROE ORGNUM (UDF)] - is used to identify the owner's organization number of the CRA Payroll Account Number
At line 60 changed one line
!Step 8 – Request for ROE [IEEI]
!Step 9 – Request for ROE [IEEI]
At line 64 changed one line
!Step 9 - Define Pay Elements For ROE Box 17 and 19 in [IPPE]
!Step 10 - Define Pay Elements For ROE Box 17 and 19 in [IPPE]
At line 68 removed one line
[{Table
At line 78 changed one line
|Box 17C| Other Monies| 'ROE OTHER1 AMT'|'ROE OTHER1 ANT'
|Box 17C| Other Monies| 'ROE OTHER1 AMT'|'ROE OTHER1 AMT'
At line 86 changed 2 lines
| |Oboslete Element List: | |'ROE SPEC PYMT1'
| |Special Payments ||'ROE STATHOL1 DAT'
| |Oboslete Element List:
|| ||'ROE SPEC PYMT1'
|| ||'ROE STATHOL1 DAT'
At line 89 changed 2 lines
|| | |'ROE STATHOL3 DAT'
|| | |'ROE OTHER1 DESC'
|| ||'ROE STATHOL3 DAT'
|| ||'ROE OTHER1 DESC'
At line 92 changed one line
|| | |'ROE OTHER3 DESC'
|| ||'ROE OTHER3 DESC'
At line 97 changed one line
!Step 10 - Define Interface Format in [IDIF]
!Step 11 - Define Interface Format in [IDIF]
At line 100 changed one line
SEED_IDIF_HL$CAN-ROE-XML.sql
01_SEED_IDFD_HLCAN_ROE_XML_2020.sql
At line 144 changed one line
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.
If the user has entered an overridden 'ROE Box 17 Period' on [IPPH] / [IEEI] user fields, then this overridden pay period is used for Box 17 and 19 processing.
At line 149 changed one line
If the 'Trial' prompt = ‘Yes’, then the EMPLOYMENT information will not be updated.
If the 'Trial' prompt = ‘Yes’, then the EMPLOYMENT and PAY HEADER information will not be updated.
At line 159 changed one line
;[Employment UDF (User Defined Fields)|]
;[Pay Header UDF and Employment UDF (User Defined Fields)|]
At line 255 added 2 lines
!Amend / Replace ROE
If an ROE needs to be replaced or amended to correct information on the ROE form, the following steps need to be followed:
At line 258 added 5 lines
* Make the necessary changes to the employee’s records
** On IEEI 'ROE Status' field – change to ‘ROE Required/Request’
** On IEEI User Field – ‘Prev ROE Upto’ – remove the value in this field
** On IEEI User Field – ‘ROE Amend/Replace Serial#’ – specify the Serial Number of the ROE that is being amended or replaced. This value will be put into Box 2 of the ROE.
** On IPPH User Field – ‘Prev ROE Upto’ – remove the value in this field
At line 188 changed one line
\\ \\
At line 197 changed one line
|As of Date| This date is used to retrieve employee demographic information if necessary.
|As of Date| This date is used to retrieve employee demographic information if necessary. Also to retrieve the closed pays with the pay issue date up to this date.
At line 244 changed one line
[{Image src='UPROEF-1.JPG' width='500' align='center' link='attach/UPROEF-1.JPG'}]
At line 256 changed one line
[{Image src='UPROEF-2.JPG' width='500' align='center' link='attach/UPROEF-2.JPG'}]
At line 259 removed 2 lines
- User must enter the Vacation Code on IEEI UDF [ROE VACN CODE] and re-run UPROEF
- If this {ROE VACN CODE] UDF is not set up, then IDIF screen HL$CAN-ROE-XML ‘Vacation Pay Code’ derivation expression will default to Code ‘2-Paid – no longer working’
At line 262 changed one line
- User must enter the Vacation Code on IEEI UDF [ROE VACN CODE (UDF)] and re-run UPROEF
- If this [ROE VACN CODE (UDF)] UDF is not set up, then IDIF screen HL$CAN-ROE-XML ‘Vacation Pay Code’ derivation expression will default to Code ‘2-Paid – no longer working’
At line 339 added 3 lines
[{Image src='UPROEF-3.JPG' width='500' align='center' link='attach/UPROEF-3.JPG'}]
At line 265 changed 2 lines
- The user must enter the Other Monies Code on IEEI UDF [ROE OTHER1 CODE] for UPROEF, otherwise the xml file is invalid
- If this {ROE OTHER1 CODE] UDF is not set up, then IDIF screen HL$CAN-ROE-XML ‘Other Monies Code 1’ derivation expression will default to Code ‘O00 – Other’
- The user must enter the Other Monies Code on IEEI UDF [ROE OTHER1 CODE (UDF)] for UPROEF, otherwise the xml file is invalid
- If this {ROE OTHER1 CODE (UDF)] UDF is not set up, then IDIF screen HL$CAN-ROE-XML ‘Other Monies Code 1’ derivation expression will default to Code ‘O00 – Other’
At line 346 added one line
[{Image src='UPROEF-4.JPG' width='500' align='center' link='attach/UPROEF-4.JPG'}]
At line 271 removed 2 lines
At line 276 changed one line
[{Image src='UPROEF-5.JPG' width='151' align='center' link='attach/UPROEF-5.JPG'}]
[{Image src='UPROEF-5.JPG' width='750' align='center' link='attach/UPROEF-5.JPG'}]
At line 282 changed one line
[{InsertPage page='Internal.UPROEF' default
[{InsertPage page='Internal.UPROEF' default}]