Wiki: ROE USER DEFINED FIELDS

Prev ROE UpTo: This is system maintained, UPROEF stores the pay period the ROE has been issued up to for each employment in update mode. This 'Up To Pay Period' is used when the subsequent ROE is issued for an employee for this employment record. You may change this pay period so that the ROE can be issued from this pay period onward. The format of this field is 'Pay Period + Period End date', i.e. 'CCYYPP DDMON- CCYY'. E.g. '200520 30-Apr-2005' means Pay Period 200520 with Period End date 30-Apr-2005

ROE 1st Work Date: This is system maintained, stores the First Work Date issued on ROE. If an employee has multiple ROE for one Employment, this field contains the First Work Date printed on the most recent ROE. This is maintained by UPROEF and is for information purpose only

ROE Last Work Date: This is system maintained, stores the Last Work Date issued on ROE. If an employee has multiple ROE for one Employment, this field contains the Last Work Date printed on the most recent ROE. This is maintained by UPROEF and is for information purpose only

OVD ROE 1st Work Date: You may enter an overridden date for the First Day Worked. This should be used if the system generated First Work Date is incorrect and you want to override the system derived First Day Work on the IEEI screen. You should remove the content of this field after each ROE

OVD ROE Last Work Date: You may enter an overridden date for the Last Day Worked. This should be used if the system generated Last Work Date is incorrect and you want to override the system derived Last Day Work on the IEEI screen. You should remove the content of this field after each ROE

ROE Reason Code: You may override the ROE reason code for terminated employee whose termination reason is incorrect from ROE Letter from the IDTR form. Effective 2016, ROE XML reporting, the ROE Reason Code is changed from 1 character to 3 characters and the valid list is defined in the Lexicon X_ROE_REASON. You may enter the ROE reason code for an employee who has not been terminated but needs an ROE. If IEEI screen 'ROE REASON CODE' is defined for the employee, then IEEI 'ROE REASON CODE' is used, otherwise 'ROE REASON' is from ROE Letter of termination code. If ROE Reason is with the old format with 1 character only, UPROEF will concatenate with ’00’, e.g. ‘K’ is changed to ‘K00’.

ROE Vacn Code: This specifies the Vacation Pay Code for the Vacation amount being paid. Refer to Table 11: 17A.1 – Vacation Pay information (from website) below:

Code	Description	Start Date	End Date	Amount
1	Included with each pay	Must be blank	Must be blank	Must be blank
2	Paid because no longer working	Must be blank	Must be blank	Mandatory
3	Paid for a vacation leave period	Optional	Optional	Mandatory
4	Anniversary(Paid on a specific date each year)	Optional	Must be blank	Mandatory

ROE Vacn Startdt: This specifies the Vacation Start Date for the Vacation amount being paid. Must be in the DD-Mon-CCYY format and will be converted to the ‘YYYY-MM-DD’ format by IDIF Format Mask.

ROE Vacn Enddt: This specifies the Vacation End Date for the Vacation amount being paid. Must be in the DD-Mon-CCYY format and will be converted to the ‘YYYY-MM-DD’ format by IDIF Format Mask.

ROE Vacn Pay: This specifies the Vacation Pay amount for the employee. If this UDF is not entered, then the value from the Element ‘ROE VACN PAY’ is retrieved from the Final Pay.

ROE Stathol1 Code: Not used for ROE XML interface, used for ROE Laser interface only

ROE Stathol1 Date: Specifies the Statutory Holiday Date to be printed on ROE. This must be in DD-Mon-CCYY format, e.g. 23-May-2016. This will be converted to ‘YYYY-MM-DD’ format by IDIF Format Mask

ROE Stathol1 Amt: This specifies the Stat Holiday amount for the employee. If this UDF is not entered, then the value from the Element ‘ROE STATHOL1 AMT’ is retrieved from the Final Pay.

ROE Stathol2 Code: Not used for ROE XML interface, used for ROE Laser interface only

ROE Stathol2 Date: Specifies the Statutory Holiday Date to be printed on ROE. This must be in DD-Mon-CCYY format, e.g. 23-May-2016. This will be converted to ‘YYYY-MM-DD’ format by IDIF Format Mask

ROE Stathol2 Amt: This specifies the Stat Holiday amount for the employee. If this UDF is not entered, then the value from the Element ‘ROE STATHOL2 AMT’ is retrieved from the Final Pay.

ROE Stathol2 Code: Not used for ROE XML interface, used for ROE Laser interface only

ROE Stathol3 Date: Specifies the Statutory Holiday Date to be printed on ROE. This must be in DD-Mon-CCYY format, e.g. 23-May-2016. This will be converted to ‘YYYY-MM-DD’ format by IDIF Format Mask

ROE Stathol3 Amt: This specifies the Stat Holiday amount for the employee. If this UDF is not entered, then the value from the Element ‘ROE STATHOL3 AMT’ is retrieved from the Final Pay.

……Up To

ROE Stathol10 Code: Not used for ROE XML interface, used for ROE Laser interface only

ROE Stathol10 Date: Specifies the Statutory Holiday Date to be printed on ROE. This must be in DD-Mon-CCYY format, e.g. 23-May-2016. This will be converted to ‘YYYY-MM-DD’ format by IDIF Format Mask

ROE Stathol10 Amt: This specifies the Stat Holiday amount for the employee. If this UDF is not entered, then the value from the Element ‘ROE STATHOL10 AMT’ is retrieved from the Final Pay.

ROE Other1 Desc: This is Obsolete.

ROE Other1 Code: This specifies the Code for Other Monies.

ROE Other1 Startdt: This specifies the Start Date for the Other1 Money. Must be in the DD-Mon-CCYY format and will be converted to the ‘YYYY-MM-DD’ format by IDIF Format Mask.

ROE Other1 Enddt: This specifies the End Date for the Other1 Money. Must be in the DD-Mon-CCYY format and will be converted to the ‘YYYY-MM-DD’ format by IDIF Format Mask.

ROE Other1 Amt: This specifies the Other1 Money amount for the employee. If this UDF is not entered, then the value from the Element ‘ROE OTEHR1 AMT’ is retrieved from the Final Pay.

……Note OTHER2 / OTHER3 are the same as OTHER1

ROE Primary EEM: If employee has multiple Employments for one or more Government Business Numbers (BN), you should indicate which Employment is the primary Employment so that the ROE Occupation can be retrieved according to the primary Employment's Assignment information

ROE Spec Pymt1 Code: This specifies the Code for Special Payments.

ROE Spec Pymt1 Startdt: This specifies the Start Date for the Special Payments. Must be in the DD-Mon-CCYY format and will be converted to the ‘YYYY-MM-DD’ format by IDIF Format Mask.

ROE Spec Pymt1 Enddt: This specifies the End Date for the Special Payments. Must be in the DD-Mon-CCYY format and will be converted to the ‘YYYY-MM-DD’ format by IDIF Format Mask.

ROE Spec Pymt1: This specifies the Special1 Payment amount for the employee. If this UDF is not entered, then the value from the Element ‘ROE SPEC PYMT1’ is retrieved from the Final Pay.

…..Note PYMT2 / PYMT3 / PYMT4 are the same as PYMT1

ROE Amend Serial: This specifies the Serial Number of the ROE amended or replaced. If used, it must be a 9 alphanumeric value.

ROE Box 17 Period: This specifies an overridden pay period to be used for Box 17 amounts. If an employee is terminated and has been paid with a 'Final Pay', then Box 17 amounts will be derived from the 'Final Pay' pay period. The user may override the 'Final Pay' pay period to a different pay period on this field in order to report Box 17 amounts. If employee has not been terminated and requires an ROE or 'Final Pay' has not been paid to a terminated employee, Box 17 will be derived from IEEI 'ROE BOX 17 PERIOD' pay period if specified or from the most recent pay period. The format of this field is 'CCYYPP', e.g. 200516

Obsolete User Fields: If these UDF already exists in the database, these are not removed due to Database constraint error. For new user or database, UPROEF will not create these obsolete UDF. #

ROE Sick LV Date: This specifies the Paid Sick / Maternity / Parental or Group Wage Loss Insurance Date to be printed on ROE. This must be in DD-Mon-CCYY format, e.g. 23-May-2005. It will be converted to DD/MM/YYYY format by IDIF Format Mask

ROE Sick LV D/ W: This specifies the Period Code for Paid Sick / Maternity / Parental or Group Wage Loss Insurance Date to be printed on ROE

Obsolete User Fields: If these UDF already exists in the database, these are not removed due to Database constraint error. For new user or database, UPROEF will not create these obsolete UDF. #

Notes #