Hi Jaideep Vinchurkar,

This is not implemented in Import yet. Can we convert this to Enhancement?

Hi Jaideep Vinchurkar,

Please let us know your decision on this. Is this supposed to be implemented? if yes, Enhancement or bug?

Hi ,

We have done code changes and its pending for review. it will deployed on LB next deployment patch once we done with review.

Thanks !

Hi Vishal Bajad,

Verified on LB and Found below issues :

1) Spouse Data Imported successfully , But Marital Status is not updated if Spouse effective date is given in file
2) Import Failed if Null Replacement Character is given in file for Spouse effective date field.
3) Import Failed if date is not given [ i.e. blank ] in file for Spouse effective date field.

Error Log :
ErrorID : 0
ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportValidation.ImportData->ImportValidation.ProcessImportDataFile->ImportValidation.ValidateAndInsertData->ImportValidation.ExecuteDependentQueries
ErrorMessage: Conversion failed when converting character string to smalldatetime data type

Thanks,
[~meghana joshi]

Hi Ankur Deshpande,

Vishal has made some changes. Please take latest code and look into the issue reported by Meghana.

Hi All,

We are looking into this issue.

Regards,
Ankur

Hi Ankur Deshpande,

Verified on LB
Company - City of durham

Martial status is not updated on demographics when spouse is imported.
Hence Re-opening this jira

Thanks
Jayshree

Concern : Import - Marital Status is not updated Properly.
Cause : The MaritialStatusID was NULL in Employee table, due to this where clause was getting failed.
Correction : Modified where clause for the same.

Hi Ankur Deshpande,

Verified on LB
Company - City of Durham

Verified below scenario :
1)Spouse Data Imported successfully , Marital Status is updated as "Married" on Demographics Page of Employee for newly added spouse(Spouse relationship status - Spouse)
2)Verified for Spouse import When Spouse Relationship status are Ex-spouse, Domestic Partner,Common law spouse - Not updating Martial status, it will remains blank (working as As per UI)
2)Verified for spouse import when effective date is ~, Blank - Import done successfully
3)Verified Updating of Martial status through import from Martial to single - Pass(verified through Demographics import->Mapped Martial status field)

Also verified impact testing which is not working as its not implemented under this jira
1)Updating Relationship Status Ex-Spouse to Spouse -> Martial status must update from blank to Married (As per UI)
2)Updating Martial Status from Married to Divorced - Spouse Relation status must update from Spouse to Ex-spouse
Will create separate jira for this issues

Will move this jira Ahead ready for stage as its implemented functionality is working properly.

Thanks,
Jayshree

CC : Rakesh Roy Prasad Pise

Verified on Stage
Company - Caiso for hspl

Verified below scenario : - Working as expected

1)Spouse Data Imported successfully , Marital Status is updated as "Married" on Demographics Page of Employee for newly added spouse(Spouse relationship status - Spouse)
2)Verified for Spouse import When Spouse Relationship status are Ex-spouse, Domestic Partner,Common law spouse - Not updating Martial status, it will remains blank (working as As per UI)
2)Verified for spouse import when effective date is ~, Blank - Import done successfully
3)Verified Updating of Martial status through import from Martial to single - Pass(verified through Demographics import->Mapped Martial status field)

Marking item state as Ready for production

Thanks,
Jayshree

Cc : Rakesh Roy Prasad Pise

Verified on Production
Company - Caiso for hspl

Working as expected
Marking item state as production complete

Thanks,
Jayshree

CC; Rakesh Roy Prasad Pise