After running the Record of Employment or the Record of Employment by Assignment Set concurrent program, you can generate a preview of the actual ROE by processing the ROE worksheet. To generate the ROE worksheet, run the ROE Work Sheet (XML) concurrent program.

The ROE Work Sheet (XML) program uses Oracle Business Intelligence (BI) Publisher to generate the ROE data in PDF format. The ROE Data parameter enables you to generate a worksheet for an employee's amended ROE information. Run the ROE Work Sheet (XML) program before you run the Record of Employment Interface program.

The following parameters are common to both the ROE Work Sheet and ROE Work Sheet (XML) programs:

• Start Date

• End Date

• Selection Type

• Employee Name

• Assignment Set

For more information, see Running the ROE Work Sheet Program.

The ROE Data parameter is available only to the ROE Work Sheet (XML) program. Select any one of the options for the ROE Data parameter:

• Original: If you select this value, then only original ROE data is displayed. Amended ROE data is not included.

• Amended: If you select this value, then the amended ROE data is reported. The output also displays the original ROE data that corresponds to the amended ROE data.

• Both: If you select this value, then both the original and amended ROE worksheets are displayed in the output.

  When you select the Both option, the worksheets will display amended ROE data but will not display the original ROE data that corresponds to the amended ROE data.

   Reporting the Serial Number:

When you select the Amended option, the ROE Work Sheet (XML) program reports the serial number of the original ROE in field 2 of the amended ROE worksheet. The program also reports the original ROE serial number in field 1 of the original ROE so that you can associate the amended ROE data with the original ROE data. The program does not report serial numbers for Original and Both options.