NYSLRS Contributions Generate failed - String or binary data would be truncated
Description of Issue
When generating we get an error message:
usp_NYSLRS_Contribuitions_Generate Failed: <?xml version="1.0" encoding+"windows-1252"?> <SQLError> <row Value+"8152|String or binary data would be truncated. Line in SP: 550"/> </SQLError>
Context
- Payroll
- New York
- NYSLRS Report
Cause
Indicates that an invalid value was entered in State Reporting Codes.
Resolution
Review Employee ID Codes and Crosswalk Codes for invalid data.
- Navigate to State Reporting Codes
- Select Employee ID Codes
- Select Define
- Select NYSLRS Employment Instance
- Select Accept
- Click the Employment Instance ID column header to sort the column
- Review the data to confirm that the Crosswalk Code value on every line of the Crosswalk is a 3 digit number
- If an invalid Employment Instance ID value is found, select Update to correct it. Otherwise, select Back to return to State Reporting Codes.
- Select Crosswalk Codes
- Review each of the following Crosswalk Type codes:
- PAY FREQ - Confirm that the Crosswalk Code value on every line of the Crosswalk is a single capital letter
- PERS STAT - Confirm that the Crosswalk Code value on every line of the Crosswalk is either R, or T
- SLRS FTPT - Confirm that the Crosswalk Code value on every line of the Crosswalk is either F or P
- SLRS JOB - Confirm that the Crosswalk Code value on every line of the Crosswalk is populated with a 6 character code
- SLRS PAY - Confirm that the Crosswalk Code value on every line of the Crosswalk only contains 3 letters (i.e. EAR, not EARN).
- SLRS REAS - Confirm that the Crosswalk Code value on every line of the Crosswalk is either blank, or populated with LOA, MED or MIL.
- If an invalid value is found, select Update to correct it.
Additional Information