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 224 added 56 lines
!!!ROE XML FILE VALIDATION
!!ROE XML Schema
• ROE government website is: http://www.esdc.gc.ca/en/ei/roe/user_requirements/appendix_d.page
• The user should download and save the following PayrollExtractXmlV2.xsd (20kb) file into your own directory in order to validate the payroll extract file structure before transferring the file using ROE Web. To perform this kind of validation, you need a tool that is capable of validating an XML schema.
• The ‘2016 XMLSPY software’ is used in the following example to perform the ROE XML Validation with the ROE XML Schema
!!ROE XML Validation
• After UPROEF is run, the user can open the ROE XML file that is generated by UPROEF with XMLSpy
• Then click ‘DTD/Schema’ to ‘Assign Schema’ and select PayrollExtractXmlV2.xsd (20kb) that you have saved before
• Then click the ‘Yellow Tick’ to check the ROE XML file is well-formed
• Then click the ‘Green Tick’ to validate the ROE XML file with the XML Schema
• If there is no issues, then it will display the xml is valid and this file is ready to transmit to the government ROEWEB
!!ROE XML File Error
• Although the ROE XML file is always well-formed, but the XML Schema may have some dependency fields that are causing the XML file invalid and thus will be rejected by the government.
• When there are errors with the ROE XML file, the file is displayed as ‘xml is not valid’ in XMLSPY
• Then click the incorrect ‘Element’ to go to the Error location, and you can click the link to the government website to cross reference the incorrect Tag to find out what causes the problem
• In this error below, Box 17A Vacation Amount requires a mandatory Vacation Code and therefore the xml file is invalid
- 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’
- If Box 17C Other Money Amount is not zero, it requires a mandatory Other Money Code
- 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’
- UPROEF report will issue the following Warning messages when an amount is on the xml file and the code is missing.
- Users should manually enter the appropriate codes on IEEI UDF and then re-run UPROEF.