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.