Hi Rajendra, Please check this.

Checked this yesterday, But effective date service only inserting dead enrollments, not inserting new entry for coverage.

Modified dead enrollment check and enrollment and coverage is moving to main table .. needs to check export file.

Below are the 3C's.

Concern : Error Logged While Exporting feed Data.

Cause : The thing is, there was future election and that were sent on file as active previously. After that election got dead. When effective date service runs, then this is not considering dead enrollments for move operation. so dead enrollment remains in intermediate table. After that when feed runs, it checks that dead enrollment in main table. but it is actually in interminable. Export is looking in main table because effective date is less than current date. So this is causing failures in export.

Correction : To handle such failures we need to move dead enrollments through effective date service. And there is one more change in export UDF (OES_UDF_Export_GetExportedDeadEnrollmentIDs) logic to consider such moved dead enrollments.

Rohan J Khandave Vinayak Kulkarni Ganesh Sadawarte Rakesh Shahane

This change will be done after WT-8417 is completed.

We are done with export changes and those are checked-into trunk. We can not move this without completing WT-8417.

HI Pallavi Kulkarni,

Can you please check this and take it forward. Please let me know in case of any help required from my side

CC: Mandar Kulkarni Hrishikesh Deshpande

Thanks & Regards,
Aniruddha Dev

Hi Aniruddha Dev,

Verified on LB working as expected, following scenarios checked,

1.Future Dead Enrollment
2.Current Dead Enrollment
3.Back Date Dead Enrollment
4. Current and Future flag effect on respective enrollment.

Details of template are as follows,

Environment:LB
Template name:New_CAISO EDeduct Payroll Flex Pre Tax Employee Limit_UPDATED
Group Template name:A

Can you please verify at you end.

Thanks,
Pallavi Kulkarni

Verified this fix on Stage on CAISO for HSPL company . Working as expected. Ready for Production