For column wise paycheck import is getting failed

See below error Log:

ErrorID : 0
ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportValidationColumnWise.ImportData->ImportValidationColumnWise.ProcessImportDataFile->ImportValidationColumnWise.GetDataForInsertCheck
ErrorMessage: Incorrect syntax near the keyword 'from'.

I analysed the issue, It was because only socialsecurityno was set as isunique.
SocialSecurityNo, EffectiveDate and LineItemName should be set as is unique. This will solve the issue.

Verified on LB Environment.
For Column Wise Import consider below scenarios:
1]Tab File format
2]CSV file Format
3]Single employee records.
4]Multiple Employee In Same file
5]Also Verified on View paycheck Page Imported Data is proper for all employee.

Working fine as expected.

Verified on Stage Environment.
For Column Wise Import consider below scenarios:
1]Tab File format
2]CSV file Format
3]Single employee records.
4]Multiple Employee In Same file
5]Also Verified on View paycheck Page Imported Data is proper for all employee.
Working fine as expected.

Waiting for Client Confirmation

Closed