Previous page

Next page

Fixing foreign key errors

Foreign key errors use the error code FOREIGNKEY. Foreign key errors generally occur if incorrect data has been imported into PayGlobal.

This topic shows an example of a foreign key error and how to correct it.

Example

Audit log information:

Checking table 'Employee'...

Executing rule 'Foreign keys valid'...

Found 1 violations for foreign key AwardCode:

Error code: [FOREIGNKEY] - EmployeeID: 5, AwardCode: C010

In this example, the employee with EmployeeID 5 has an AwardCode that does not exist.

To correct this problem:

  1. Navigate to Employees.
  2. Customise columns and display the Employee ID column.
  3. Open the employee with Employee ID = "5" and correct their award.

Topic: 9478