previous | index | next |
This content is also available in pdf format (176 kb) and can be printed.
Notes:
Tag Name | Tag Level | Required Tag (Y/N) |
Data Size (Min/Max) |
Description |
---|---|---|---|---|
Note: The tag level represents if the tag is contained within another tag or not. The parent tag would be the first previous tag with a lower tag level number. |
||||
ROEHEADER | 0 | Y | N/A |
This tag serves as the root tag of the bulk file therefore it must be present even though it contains only other tags within it. The following attributes must be present with a corresponding value —Refer to the List of Attributes Used in the XML Structure: • Application |
Roe | 1 | Y | N/A |
This tag indicates the beginning of each ROE record. The following attributes must be present with a corresponding value — Refer to the List of Attributes Used in the XML Structure: • Printing Language |
B2 | 2 | N | 0/9 |
S.N. of ROE Amended or replaced • May be blank |
B3 | 2 | N | 15/15 |
Employer’s payroll reference number • May be blank |
B5 | 2 | Y | 15/15 |
Canada Revenue Agency Business Number • Must not be blank |
B6 | 2 | Y | 1/1 |
Pay period type • Must not be blank B = Bi-weekly |
B8 | 2 | Y | 9/9 |
Social Insurance Number of the employee for whom the ROE will be issued • Must not be all zeros |
B9 | 2 | Y | N/A |
This is the parent tag for the Employee information • Must be present |
FN | 3 | Y | 1/20 |
First name of the employee for whom the ROE will be issued • Must not be blank |
MN | 3 | N | 0/4 |
Initial of the employee for whom the ROE will be issued • May be blank |
LN | 3 | Y | 1/28 |
Last name of the employee for whom the ROE will be issued • Must not be blank |
A1 | 3 | Y | 1/35 |
Line 1 of the address of the employee for whom the ROE will be issued — Number and street name • Must not be blank |
A2 | 3 | N | 0/35 |
Line 2 of the address of the employee for whom the ROE will be issued — Place, City and Municipality • May be blank |
A3 | 3 | N | 0/35 |
Line 3 of the address of the employee for whom the ROE will be issued — Province, Country and Postal Code • May be blank |
B10 | 2 | Y | 8/8 |
First day worked • Must not be blank The First day worked and Last day for which paid for the current ROE must not be overlapped with the First day worked and Last day for which paid for all previous ROEs issued by the same employer Canada Revenue Agency Business Number (CRABN), for the same employee Social Insurance Number (SIN), unless the Employer Business Number has been registered with the capability to issue overlapped Records of Employment. |
B11 | 2 | Y | 8/8 |
Last day for which paid • Must not be blank |
B12 | 2 | Y | 8/8 |
Final Pay Period Ending Date • Must not be blank Weekly “W”: cannot be more than 6 days after Last day for which paid |
B13 | 2 | N | 0/40 |
Employee occupation • May be blank |
B14 | 2 | N | N/A |
This is the parent tag for the Expected recall information • It only contains other tags |
CD | 3 | N | 0/1 |
Expected recall code • May be blank Y-Date of recall • If the code is Y, the Expected date of recall must be entered |
DT | 3 | N | 8/8 |
Expected date of recall • May be blank |
B15A | 2 | Y | 1/4 |
Total insurable hours • Must not be blank |
B15B | 2 | Y | 0/9 |
Total insurable earnings • Must not be blank |
B15C | 2 | Y | N/A |
This is the parent tag for the insurable earnings from B15C information • Must be present |
PP | 3 | Y | N/A |
This is the parent tag for each Pay Period information • It only contains other tags |
AMT | 4 | Y | 0/9 |
Earnings for Pay Period 1 — See instructions for Block 15C at the end of Appendix A, Chart III Earnings for Pay Period 2…53 — See instructions for block 15C at the end of Appendix A, Chart III |
B16 | 2 | Y | N/A |
This is the parent tag for the Reason for issuing and Contact person information • Must be present |
CD | 3 | Y | 1/1 |
Reason for issuing this ROE • Must not be blank A = Shortage of Work • If 'K' — 'Other' is indicated then additional information must be given in the Comments Section — Block 18 |
FN | 3 | Y | 1/20 |
First name — only — for the contact person • Must not be blank |
LN | 3 | Y | 1/28 |
Last name for the contact person • Must not be blank |
AC | 3 | Y | 3/3 |
Phone area code for the contact person • Must not be blank |
TEL | 3 | Y | 7/7 |
Phone number for the contact person • Must not be blank |
EXT | 3 | N | 0/5 |
Phone extension for the contact person • May be blank |
B17A | 2 | N | 0/9 |
Vacation Pay amount • May be blank |
B17B | 2 | N | N/A |
This is the parent tag for the list of Statutory Holiday information |
SH | 3 | N | N/A |
This is the parent tag for each specific Statutory Holiday information |
DT | 4 | N | 8/8 |
Statutory Holiday Pay Date • May be blank |
AMT | 4 | N | 0/9 |
Statutory Holiday Pay amount • Must be blank if no date is specified in the corresponding Statutory Holiday Pay Date |
B17C | 2 | N | N/A |
This is the parent tag for the list of Other Monies information • It only contains other tags |
OM | 3 |
This is the parent tag for each specific Other Monies information • It only contains other tags |
||
CD | 4 | N | 0/1 |
Other monies code • May be blank A = Anniversary Payout • If Other monies code is not blank, there must be a corresponding amount in Other monies amount |
AMT | 4 | N | 0/9 |
Other monies amount • Must be blank if corresponding ‘‘Other monies code’’ is blank |
B18 | 2 | N | 0/160 |
Comments • May be blank |
B19 | 2 | N | N/A |
This is the parent tag for the list of Special Payment information • It only contains other tags |
SP | 3 |
This is the parent tag for each specific Special Payment information •It only contains other tags |
||
DT | 4 | N | 0/8 |
Special Payment Date • May be blank |
AMT | 4 | N | 0/9 |
Special Payment Amount • May be blank |
Period | 4 | N | 0/1 |
Special Payment Period • May be blank D : Per Day |
B20 | 2 | N | 1/1 |
Communication Preferred In • May be blank E: English |
The two XSD files — BulkRoeHeader.xsd - 4kb and BulkRoe.xsd - 11kb — can be used to validate the XML and the bulk file structure prior to transfer the file using ROE Web. In order to perform this kind of validation, a tool which is capable of validating an XML Schema is necessary.
Sample of most basic Bulk XML structure that could be submitted and accepted as a valid file — 277 bytes/characters:
<ROEHEADER Application="RoeWeb" FileVersion="1.00"> <Roe> <B5>100000000RP9999</B5> <B6>B</B6> <B8>999999999</B8> <B9> <FN>Xxxxxx </FN> <LN>Xxxxxxxxxxxxx</LN> <A1>123 Xxxxxxxxxxx </A1> </B9> <B10>01012005</B10> <B11>14012005</B11> <B12>15012005</B12> <B15A>80</B15A> <B15B>800.00</B15B> <B15C> <PP nbr="1"> <AMT>800.00</AMT> </PP> </B15C> <B16> <CD>A</CD> <FN>Xxxxxxxxx</FN> <LN>Xxxxxxxxxxx</LN> <AC>819</AC> <TEL>6831234</TEL> </B16> </Roe> <Roe> <B5>100000000RP9999</B5> <B6>B</B6> <B8>999999998</B8> <B9> <FN>Xxxx</FN> <LN>Xxxxxxxxxxxxxxxxx</LN> <A1>789 XXXXXXXXXXXX</A1> </B9> <B10>01012005</B10> <B11>14012005</B11> <B12>15012005</B12> <B15A>70</B15A> <B15B>700.00</B15B> <B15C> <PP nbr="1"> <AMT>700.00</AMT> </PP> </B15C> <B16> <CD>A</CD> <FN>Xxxxxxxxx</FN> <LN>Xxxxxxxxxxxxxx</LN> <AC>819</AC> <TEL>1234567</TEL> </B16> </Roe> <Roe> … </Roe> </ROEHEADER> |
Sample of most complete Bulk XML structure that could be submitted and accepted as a valid file:
<ROEHEADER Application="RoeWeb" FileVersion="1.00"> <Roe PrintingLanguage="F" Issue="S"> <B3>9999-12345</B3> <B5>100000000RP9999</B5> <B6>W</B6> <B8>999999999</B8> <B9> <FN>Xxxxxx</FN> <MN>Xxxx</MN> <LN>Xxxxxxxxxxxxx</LN> <A1>123 Xxxxxxxxxxx</A1> <A2>Xxxxxxxx</A2> <A3>Xxxxxxx, Xxxxxxx</A3> </B9> <B10>01012005</B10> <B11>31122005</B11> <B12>31122005</B12> <B13>Xxxxxxxxxxxxxxx</B13> <B14> <CD>Y</CD> <DT>06022006</DT> </B14> <B15A>1040</B15A> <B15B>10400.00</B15B> <B15C> <PP nbr="1"> <AMT>200.00</AMT> </PP> <PP nbr="2"> <AMT>200.00</AMT> </PP> … <PP nbr="53"> <AMT>200.00</AMT> </PP> </B15C> <B16> <CD>A</CD> <FN>Xxxxxxxxx</FN> <LN>Xxxxxxxxxxxxxx</LN> <AC>819</AC> <TEL>1234567</TEL> <EXT>12345</EXT> </B16> <B17A>250.00</B17A> <B17B> <SH nbr="1"> <DT>01012005</DT> <AMT>50.00</AMT> </SH> <SH nbr="2"> <DT>28042005</DT> <AMT>50.00</AMT> </SH> <SH nbr="3"> <DT>25122005</DT> <AMT>50.00</AMT> </SH> </B17B> <B17C> <OM nbr="1"> <CD>A</CD> <AMT>75.00</AMT> </OM> <OM nbr="2"> <CD>B</CD> <AMT>125.00</AMT> </OM> <OM nbr="3"> <CD>H</CD> <AMT>25.00</AMT> </OM> </B17C> <B18>Xxxxx xxxxx xxxxxxx xxx xxxxxxx.</B18> <B19> <SP cd="psl"> <DT>01112005</DT> <AMT>25.00</AMT> <Period>W</Period> </SP> </B19> <B20>F</B20> </Roe> </ROEHEADER> |
previous | index | next |