Duplicate Key Error Generating TN TCRS





Description of Issue

Generating TN retirement and received an error. 

Violation of PRIMARY KEY constraint 'pl_prtneretc.' Cannot insert duplicate key in object 'dbo.prtnretc.'



Context
  • Payroll

  • Tennessee

  • TN TCRS Maintenance

  • TN TCRS Reporting 



Cause

More than one TN TCRS Maintenances record.



Resolution

Delete all but one TN TCRS Maintenance record for each employee.



Additional Information

The Employer Code used to report the employee will come from the Employer Code defined on the TN TCRS Reporting Generate screen and not from Maintenance.  Don't create one Maintenance record for each Employer Code that an employee should be reported under.