Hi Debbie Kulling

Please Find Below 3Cs :

Affected EEs List :
AffectedEmployeesAtc.xls
We will share password in separate mail.

Please Let us know in case of any query.

Thanks And Regards,
Abhilash Warkari

CC :Satya, Amruta Lohiya, Jyoti Mayne, Umesh Kadam

Hi Hrishikesh Deshpande

Please verify corrections on HSPL.

Thanks and Regards,
Abhilash Warkari

CC : Satya, Amruta Lohiya, Jyoti Mayne, Umesh Kadam

Hi Abhilash Warkari,

CC:Hrishikesh Deshpande,Amruta Lohiya,Satya,Jyoti Mayne,Umesh Kadam

I have verified credit pool on confirmation statement for employees attached in the sheet.
It is showing the correct amount on HSPL copy. You can proceed to do the correction on the main company.

Thanks,
Rashmita

Hi Rashmita Dudhe

We have done corrections on main company and also recalculated credit pool.
Please verify and confirm.

Hi Jaideep Vinchurkar
Can you please check this and find the root cause of this?

Thanks and Regards,
Abhilash Warkari

CC : Amruta Lohiya, Jyoti Mayne, Umesh Kadam

Hi Debbie Kulling,

We have corrected Affected employees records in attached sheet.
Jaideep Vinchurkar will update you related the root cause of the issue.

Thanks,
Rashmita

Please send the root cause

Hi Debbie Kulling,

During the data load, while uploading the life file, the import failed due to some reason. The issue occurred due to the import failure which did not update/terminated the previous rate. Hence the calculation was showing value in negative.

Regards,
Ankur

Is there some kind of error that happens when the import fails? How do we prevent this from happening in the future?

Ankur Deshpande Do we have any more information for Debbie? Are we able to see why the import failed?

Hi Debbie Kulling,

Here is log for import failure 1027201761350AM_5182_13122.txt . This error was related to inconsistent data and that was because a yet to finish back end routine. Developer mistakenly loaded another file before finishing processing of last file.
Data was corrected and the file was loaded again. But since, enrollment was already terminated, import did not touched the rates related to that enrollment.
To overcome such issues, we have started adding our email address in templates. We do receive emails of import completion and then only we start to load new files.

We have corrected the records. There is not code fix is Identified hence marking this as completed