(CAN) Converting ROE Data

This topic discusses how to convert ROE data.

Payroll for North America generates ROEs for your employees, if the data is available. The system updates PS_INS_EARNS_BAL during the Pay Confirmation COBOL SQL process (PSPCNFRM), so after the system has been in production long enough, the ROE Creation process uses data that is generated by Payroll for North America. Until then, you have two options:

  • Convert all the necessary data.

  • Manually combine the PeopleSoft ROE with the previous system data.

The Create Record of Employment SQR Report process (PAY124CN) uses the following records:

  • PS_INS_EARNS_BAL

  • PS_JOB

  • PS_ROE

  • PS_PAYGROUP_TBL

  • PS_EMPLOYMENT

  • PS_PERSONAL_DATA

Consequently, you must convert all of these records accurately to have the system produce an accurate ROE.