Check and Correct Employment-Related Data Issues

Use the Correct Employment Data Integrity Issues process to detect and correct any employment data integrity-related issues. Run this process from the Scheduled Processes work area.

The process reports and fixes the following issues:

  • Invalid Person Type Usage Records

  • Legal Employer Varies for Assignment and Work Relationship

  • Work Terms With Primary Assignment Field Set to Y

  • Business Unit Varies for Assignment and Work Terms

  • Inactive Work Relationship Active Work Terms or Assignment

  • Legislation Varies for Assignment and Work Relationship

  • Assignment With People Group Without Structure Information

  • Person Type Missing in Assignment Record

  • User and System Person Types Vary in Assignments

  • Supervisor Records Created After Termination Date

  • Supervisor Records Extending Beyond Termination Date

  • User and System Person Types Vary in Person Type Usages

  • Overlapping Working Hour Pattern Records

  • Flexfield Structure and People Group Vary in Assignments

  • Primary Field Set to Y When Manager Type Not Line Manager

You must run the following procedures in the order specified to detect and correct any issues, and verify the results:

  1. Selecting the process

  2. Using Summary mode

  3. Using Report mode

  4. Using Update mode

  5. Confirming whether issues are corrected

Selecting the Process

  1. Click Navigator > Tools > Scheduled Processes.

  2. Click Schedule New Process, and click Job in the Type field.

  3. Expand the Name list, and click Search.

  4. Type Employment in the Name box, and click Search.

  5. In the search results table, select Correct Employment Data Integrity Issues, and click OK.

  6. In the Schedule New Process dialog box, click OK.

Using Summary Mode

Run the process in Summary mode to generate a .csv file listing the count of the issues, if any. You can run the process in this mode for a person or all people.

  1. In the Process Details dialog box, select Summary from the Mode list.

  2. In the Name list, select the person for whom you want to run the process.

    Note: If you don't select a name from the list, the process runs for all people.
  3. Click Submit, and click OK in the Confirmation dialog box. Note the process ID.

  4. Click Close in the Process Details dialog box.

You can view the .zip file when you select the row containing the process ID in the search results table in the Overview page.

Using Report Mode

If you find any issues in the .csv file, run the process in Report mode to generate a .zip file. The .zip file contains a .csv file for each integrity check. The .csv file provides details of the issues and the people affected by it

  1. Click Schedule New Process. Select Correct Employment Data Integrity Issues from the Name list, and click OK.

  2. In the Process Details dialog box, select Report from the Mode list.

  3. Click Submit, and click OK in the Confirmation dialog box. Note the process ID.

  4. Click Close in the Process Details dialog box.

You can view the .zip file when you select the row containing the process ID in the search results table in the Overview page.

Using Update Mode

Run the process in Update mode to correct the issues. After you run the process, a .zip file is generated that contains a .csv file for each integrity check. The .csv file provides details of the issues post the update.

  1. Click Schedule New Process. Select Correct Employment Data Integrity Issues from the Name list, and click OK.

  2. In the Process Details dialog box, select Update from the Mode list.

  3. Click Submit, and click OK in the Confirmation dialog box. Note the process ID.

  4. Click Close in the Process Details dialog box.

You can view the .zip file when you select the row containing the process ID in the search results table in the Overview page.

Confirming Whether Issues are Corrected

Run the process again in Summary mode to confirm that the issues are corrected.