1)Login with Partner on Lb
2)Select and Search for company
3)Go to import/Export
4)Create spouse template->Browse the file for spouse template->Import getting fail
5)create emergency template->Browse the file for emergency contact->Import getting fail
6)create beneficiary template->Browse the file for beneficiary import->File went to bad with "plan design does not exists"

Expected Result:Import should be done successfully and beneficiary import should be done successfully

Actual Result:Import getting fail for salary and spouse import and issue with Plan design identifier for beneficiary import.

Emergency contact:
ErrorID : 0
ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportValidation.ImportData->ImportValidation.ProcessImportDataFile->ImportValidation.ValidateAndInsertData->ImportValidation.ExecuteAllQueries
ErrorMessage: Violation of UNIQUE KEY constraint 'IX_Employee_Emergency_EmployeeID'. Cannot insert duplicate key in object 'dbo.Employee_Emergency'. The duplicate key value is (979).
The statement has been terminated. INSERT INTO Employee_Emergency(EmployeeID,SecondaryPostalCode,SecondaryStateID,SecondaryCountryID,SecondaryWorkPhone,SecondaryHomePhone,EffectiveDate,UserID) Values( 979,'98562', 5 , 1 ,'9874561232','7894561235','2/14/2017',1); IF NOT EXISTS( SELECT * FROM ImportEmployeeInfoForBackendRoutine WHERE ImportExportBadFileID = 1560 AND EmployeeID = 979 AND DATEDIFF(DAY, EffectiveDate, '2/14/2017') = 0 AND InsertORUpdate = 1 AND MemberTypeID = 1 ) BEGIN INSERT INTO ImportEmployeeInfoForBackendRoutine (ImportExportBadFileID, EmployeeID, EffectiveDate, InsertORUpdate, MemberTypeID, MemberID, CorePlanStatus, EligibilityStatus) VALUES( 1560, 979, '2/14/2017' , 1, 1, 979 , 0, 0 ) END

Spouse: ErrorID : 0
ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportValidation.ImportData->ImportValidation.ProcessImportDataFile->ImportValidation.ProcessLineForBadRecord->ImportValidation.ValidateData->ImportValidation.ValidatePhoneNumber
ErrorMessage: Object reference not set to an instance of an object.