Running the Import Record of Employment Data Program

For information on the processes that you must run to generate amended Records of Employment (ROE), see: Amended Record of Employment (ROE) Processes.

After the Record of Employment Interface XML submission, serial numbers generated by the ROE Web program can be imported by the employer. Employers must extract and store these serial numbers in their database as these are required for the submission of amended Records of Employment.

The Import Record of Employment Data program enables you to extract serial numbers of the Records of Employment and store them in your database. This process generates a PDF output file indicating the serial numbers tagged to the corresponding employees. When you run this process, the serial numbers are stamped in the output XML so those employees for whom amendments are made are tracked correctly. If an employee has more than one assignment, then the corresponding serial number for each assignment is stored.

Run the Import Record of Employment Data program from the Submit Request window.

Prerequisites

arrow icon   To run the Import Record of Employment Data program:

  1. Select Import Record of Employment Data in the Name field.

  2. Click in the Parameters field to open the Parameters window.

  3. In the File Name field, enter the file name of the Import file obtained from the government. For example, Import-025831-20160322.xml.

  4. The Validate Mode field has the following values:

  5. Click OK and then Submit.

arrow icon   Program Output:

A PDF document is generated that shows a list of employees in each GRE for whom the ROE serial number has been updated. The document displays the employee name, social insurance number, corresponding date range, and serial number. You can also view the Status of the serial number update. The status indicates whether the update is successful or has failed.

A serial number imported through this process is stored in the "ROE Serial Number" read-only field in the Terminate and Absence Detail windows. Users cannot update the serial number in these windows. If an employee has multiple assignments, then multiple serial numbers are stored in the ROE Serial Number field in the Terminate and Absence Detail windows using a separator. For example if there are 3 serial numbers to be stored for an employee, they are stored as W12312312 | W23423423 | W34534534