This page (revision-5) was last changed on 26-Nov-2021 10:22 by kparrott

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

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
5 26-Nov-2021 10:22 11 KB kparrott to previous
4 26-Nov-2021 10:22 11 KB kparrott to previous | to last
3 26-Nov-2021 10:22 11 KB kparrott to previous | to last
2 26-Nov-2021 10:22 11 KB kparrott to previous | to last
1 26-Nov-2021 10:22 11 KB kparrott to last

Page References

Incoming links Outgoing links
HL$CAN-ROE-XML
HL$CAN-ROE-XML

Version management

Difference between version and

At line 22 changed one line
| Block 2 – Serial Number of ROE amended or replaced | B2|358031|- IPPH UDF: ‘ROE AMEND SERIAL’ \\- Optional, but if completed: \\ * Must be 9 alphanumeric characters\\ * First character must be “W” followed by 8 numbers
| Block 2 – Serial Number of ROE amended or replaced | B2|Block 2 – Serial Number of ROE amended or replaced|- IEEI UDF: ‘ROE AMEND SERIAL’ \\- Optional, but if completed: \\- Must be 9 alphanumeric characters\\First character must be “W” followed by 8 numbers
At line 32 removed one line
| Employee Initial | FN|353104|Middle Name (EID)
At line 36 changed one line
| Employee Prov. Country | A3|353224\\353225|Mail State+Cntry (EPS)
| Employee Prov. Country | A3|353224/353225|Mail State+Cntry (EPS)
At line 45 changed one line
| Block 15A – Total Insurable hours (Box 15A) | B15A|358021| Internal Total for Amt 1\\- Box 15A and 15C are derived by UPROEF according to the number of Pay Periods required by the ROE specification for each Pay Frequency\\- rounded to nearest hours, no decimals\\- For each Pay Header of the qualified reporting Pay Period, the EI Hours is retrieved from the Pay Component with PC Usage '5022' EI Hours (PPE), then the Total EI Hours are accumulated
| Block 15A – Total Insurable hours (Box 15A) | B15A|358021| Internal Total for Amt 1\\- Box 15A and 15C are derived by UPROEF according to the number of Pay Periods required by the ROE specification for each Pay Frequency\\- rounded to nearest hours, no decimals/ /- For each Pay Header of the qualified reporting Pay Period, the EI Hours is retrieved from the Pay Component with PC Usage '5022' EI Hours (PPE), then the Total EI Hours are accumulated
At line 49 changed one line
| Earnings for Pay Period 1 | AMT|358013| Internal Table Amt 3\\- the number of pay periods to be reported is defined by Pay Frequency\\- Box 15C is retrieved from Internal Table Amt 2 and 3\\- if a Pay Period has zero amount, then 0.00 is reported, otherwise Null\\ \\- For each Pay Header of the qualified reporting Pay Period, the EI Earnings is retrieved from the Pay Component with PC Usage '5021' EI Earnings (PPE), then the Total EI Earnings are accumulated for one pay period\\ \\- For Period 1 (this is usually the Final Pay or the most recent pay period that was paid), the EI Earnings should have been paid in UPCALC/UPCLOZ to include the Vacation pays, Statutory Holiday pays, Other monies and any Special Payments that should be reported in Box 17 and Box 19
| Earnings for Pay Period 1 | AMT|358013| Internal Table Amt 3\\- the number of pay periods to be reported is defined by Pay Frequency\\- Box 15C is retrieved from Internal Table Amt 2 and 3\\- if a Pay Period has zero amount, then 0.00 is reported, otherwise Null/ /- For each Pay Header of the qualified reporting Pay Period, the EI Earnings is retrieved from the Pay Component with PC Usage '5021' EI Earnings (PPE), then the Total EI Earnings are accumulated for one pay period/ /- For Period 1 (this is usually the Final Pay or the most recent pay period that was paid), the EI Earnings should have been paid in UPCALC/UPCLOZ to include the Vacation pays, Statutory Holiday pays, Other monies and any Special Payments that should be reported in Box 17 and Box 19
At line 51 changed one line
| Earnings for Pay Period 2 | AMT|358013| Internal Table Amt 3
| Earnings for Pay Period 1 | AMT|358013| Internal Table Amt 3
At line 70 changed one line
| …. Continue up to the # of PP by Pay Frequency: \\Biweekly – last 27 periods\\Monthly – Last 13 Periods\\SM – Last 25 periods\\Weekly – Last 53 periods| | | |
| …. Continue up to the \\ # of PP by Pay Frequency: \\Biweekly – last 27 periods\\Monthly – Last 13 Periods\\SM – Last 25 periods\\Weekly – Last 53 periods| | | |
At line 75 changed one line
| Block 16 – Reason for Issue ROE | CD|353394| Reason issue (ROE) \\- Effective 2016 ROE XML file reporting, ROE Reason is changed from 1 character to 3 characters \\- from IPPH/IEEI UDF ‘ROE REASON CODE’ if specified, otherwise from IEEI ROE_LETTER concatenate with ‘00’, e.g. ‘K’ is reported as ‘K00’\\- if IPPH/IEEI does not specify the ROE Reason, then when employee is terminated, the IEEI EMPLOYMENT specifies a Termination Reason\\- the ‘Termination Reason’ is defined on IDTR screen \\- then from IDTR UDF ‘ROE REASON CODE’ of the Termination Reason, if specified, use it, otherwise from IDTR ROE_LETTER concatenate with ‘00’, e.g. ‘K’ is reported as ‘K00’\\- otherwise ROE Reason is Null
| Block 16 – Reason for Issue ROE | CD|353394| Reason issue (ROE) \\- Effective 2016 ROE XML file reporting, ROE Reason is changed from 1 character to 3 characters \\- from IEEI UDF ‘ROE REASON CODE’ if specified, otherwise from IEEI ROE_LETTER concatenate with ‘00’, e.g. ‘K’ is reported as ‘K00’\\- if IEEI does not specify the ROE Reason, then when employee is terminated, the IEEI EMPLOYMENT specifies a Termination Reason\\- the ‘Termination Reason’ is defined on IDTR screen \\- then from IDTR UDF ‘ROE REASON CODE’ of the Termination Reason, if specified, use it, otherwise from IDTR ROE_LETTER concatenate with ‘00’, e.g. ‘K’ is reported as ‘K00’\\- otherwise ROE Reason is Null
At line 83 changed 4 lines
| Block 17A – Vacation Pay Code | CD|358031|- from IPPH/IEEI UDF: ‘ROE VACN CODE’ , Lexicon: X_ROE_VACN_CODE
| Block 17A – Vacation Pay Start Date | SDT|358031|- IPPH/IEEI UDF: ‘ROE VACN STARTDT’
| Block 17A – Vacation Pay End Date | EDT|358031|- IPPH/IEEI UDF: ‘ROE VACN ENDDT’
| Block 17A – Vacation Pay Amount | AMT|358014| Internal Table Amt 4 of Index 1700\\- from IPPH/IEEI UDF: ‘ROE VACN PAY’ if exists, otherwise from Element ‘ROE VACN PAY’ of the Final Pay or Last Pay
| Block 17A – Vacation Pay Code | CD|358031|- from IEEI UDF: ‘ROE VACN CODE’ , Lexicon: X_ROE_VACN_CODE
| Block 17A – Vacation Pay Start Date | SDT|358031|- IEEI UDF: ‘ROE VACN STARTDT’
| Block 17A – Vacation Pay End Date | EDT|358031|- IEEI UDF: ‘ROE VACN ENDDT’
| Block 17A – Vacation Pay Amount | AMT|358014| Internal Table Amt 4 of Index 1700\\- from IEEI UDF: ‘ROE VACN PAY’ if exists, otherwise from Element ‘ROE VACN PAY’ of the Final Pay or Last Pay
At line 90 changed 2 lines
| Statutory Holiday Date 1 | DT|358031|- IPPH/IEEI UDF: ‘ROE STATHOL1 DATE’
| Statutory Holiday 1 Amount | AMT|358014| Internal Table Amt 4 of Index 1721\\- from IPPH/IEEI UDF: ‘ROE STATHOL1 AMT’ if exists, otherwise from Element ‘ROE STATHOL1 AMT’ of the Final Pay or Last Pay
| Statutory Holiday Date 1 | DT|358031|- IEEI UDF: ‘ROE STATHOL1 DATE’
| Statutory Holiday 1 Amount | AMT|358014| Internal Table Amt 4 of Index 1721\\- from IEEI UDF: ‘ROE STATHOL1 AMT’ if exists, otherwise from Element ‘ROE STATHOL1 AMT’ of the Final Pay or Last Pay
At line 93 changed 3 lines
| Statutory Holiday Date 2 | DT|358031|- IPPH/IEEI UDF: ‘ROE STATHOL2 DATE’
| Statutory Holiday 2 Amount | AMT|358014| Internal Table Amt 4 of Index 1721\\- from IPPH/IEEI UDF: ‘ROE STATHOL2 AMT’ if exists, otherwise from Element ‘ROE STATHOL2 AMT’ of the Final Pay or Last Pay
| …. Continued up to Statutory Holiday 10| | | |
| Statutory Holiday Date 2 | DT|358031|- IEEI UDF: ‘ROE STATHOL2 DATE’
| Statutory Holiday 2 Amount | AMT|358014| Internal Table Amt 4 of Index 1721\\- from IEEI UDF: ‘ROE STATHOL2 AMT’ if exists, otherwise from Element ‘ROE STATHOL2 AMT’ of the Final Pay or Last Pay
| …. Continued up to/ Statutory Holiday 10| | | |
At line 97 changed 2 lines
| Statutory Holiday Date 10 | DT|358031|- IPPH/IEEI UDF: ‘ROE STATHOL10 DATE’
| Statutory Holiday 10 Amount | AMT|358014|Internal Table Amt 4 of Index 1721\\- from IPPH/IEEI UDF: ‘ROE STATHOL10 AMT’ if exists, otherwise from Element ‘ROE STATHOL10 AMT’ of the Final Pay or Last Pay
| Statutory Holiday Date 10 | DT|358031|- IEEI UDF: ‘ROE STATHOL10 DATE’
| Statutory Holiday 10 Amount | AMT|358014|Internal Table Amt 4 of Index 1721\\- from IEEI UDF: ‘ROE STATHOL10 AMT’ if exists, otherwise from Element ‘ROE STATHOL10 AMT’ of the Final Pay or Last Pay
At line 102 changed 5 lines
| Other Monies Code 1 | CD|358031|- IPPH/IEEI UDF: ‘ROE OTHER1 CODE’
| Other Monies Start Date 1 | SDT|358031|- IPPH/IEEI UDF: ‘ROE OTHER1 STARTDT’
| Other Monies End Date 1 | EDT|358031|- IPPH/IEEI UDF: ‘ROE OTHER1 ENDDT’
| Other Monies Amount 1 | AMT|358014| Internal Table Amt 4 of Index 1751\\- from IPPH/IEEI UDF: ‘ROE OTHER1 AMT’ if exists, otherwise from Element ‘ROE OTHER1 AMT’ of the Final Pay or Last Pay
| …. Continue up to Other Monies 3| | | |
| Other Monies Code 1 | CD|358031|- IEEI UDF: ‘ROE OTHER1 CODE’
| Other Monies Start Date 1 | SDT|358031|- IEEI UDF: ‘ROE OTHER1 STARTDT’
| Other Monies End Date 1 | EDT|358031|- IEEI UDF: ‘ROE OTHER1 ENDDT’
| Other Monies Amount 1 | AMT|358014| Internal Table Amt 4 of Index 1751\\- from IEEI UDF: ‘ROE O THER1 AMT’ if exists, otherwise from Element ‘ROE OTHER1 AMT’ of the Final Pay or Last Pay
| …. Continue up to/ Other Monies 3| | | |
At line 110 changed 6 lines
| Special Payment Code 1 | <OM nbr="1">| 358031|- IPPH/IEEI UDF: ‘ROE SPEC PYMT1 CODE’
| Special Payment 1 Start Date|SDT|358031|- IPPH/IEEI UDF: ‘ROE SPEC PYMT1 STARTDT’
| Special Payment 1 End Date|EDT|358031|- IPPH/IEEI UDF: ‘ROE SPEC PYMT1 ENDDT’
| Special Payment 1 Amount|AMT|358014|Internal Table Amt 4 of Index 1751\\- from IPPH/IEEI UDF: ‘ROE SPEC PYMT1 AMT’ if exists, otherwise from Element ‘ROE SPEC PYMT1 AMT’ of the Final Pay or Last Pay
| Special Payment 1 Period|PRD|358031|- IPPH/IEEI UDF: ‘ROE SPEC PYMT1 ENDDT’
|…. Continue up to Special Payment 4| | | |
| Special Payment Code 1 | <OM nbr="1">| 358031|- IEEI UDF: ‘ROE SPEC PYMT1 CODE’
| Special Payment 1 Start Date|SDT|358031|- IEEI UDF: ‘ROE SPEC PYMT1 STARTDT’
| Special Payment 1 End Date|EDT|358031|- IEEI UDF: ‘ROE SPEC PYMT1 ENDDT’
| Special Payment 1 Amount|AMT|358014|Internal Table Amt 4 of Index 1751\\- from IEEI UDF: ‘ROE SPEC PYMT1 AMT’ if exists, otherwise from Element ‘ROE SPEC PYMT1 AMT’ of the Final Pay or Last Pay
| Special Payment 1 Period|PRD|358031|- IEEI UDF: ‘ROE SPEC PYMT1 ENDDT’
|…. Continue up to/ Special Payment 4| | | |
This page (revision-5) was last changed on 26-Nov-2021 10:22 by kparrottTop