Hi,

As discussed, following are the further action items of this change request.

1. Scan existing data in production for dead and waived enrollments
2. Remove dead and waived enrollments before and of year 2015 (2016 and onward records will be move by Effective Date service)
3. Coding :

• Make sure new IDs of dead enrollments are getting reflected for Rate Change Log and Billing details
• As Nandkumar Prabhakar Karlekar mentioned, make sure Termination date of Enrollments and Rate change logs are moving properly (check for Billing details as well)

Thanks and Regards,
:: Umesh Kadam

CC : Satya, Nandkumar Prabhakar Karlekar, Amruta Lohiya, Jaideep Vinchurkar, Prasanna Karlekar, Vinayak Kulkarni, Jyoti Mayne, Shailendra Honrao

Please find attached WT_8417_Data_Scanned.xls for data scanning of dead enrollments on Production.

cc:Alankar Chavan, Prasad Pise

Please find attached WT_8417_Change_Request_Implementation.doc analysis document for the change request.

We tested this on WT Stage - LONG COMPANY
(tested with LIFE as well as Health Plan)

*Scenarios *

• Enrolled an employee in plan with future effective date
• Changed the Effective Date to the Current Date (so as Effective Date Service will pick this record to move in the Current Enrollments, Coverage & Rate Changes Log tables)
• Also changed the Termination Date to the date which is lesser that the Effective Date above - to make these future elections as Dead Elections
• Executed the Effective Date Service

Expected and Actual Result : the Dead Election Entries from employee_enrollment_intermediate, Employee_Enrollment_Coverage_intermediate & RateChanges_Log_Intermediate moved to employee_enrollment, Employee_Enrollment_Coverage & RateChanges_Log

CC - Shailendra Honrao Jyoti Mayne Umesh Kadam Prasad Pise Sachin Hingole Hrishikesh Deshpande Rakesh Roy

This is ready for Stage

Can not test this on Stage right now - as the stage services are still running over companies.
I will try testing this tomorrow (31st May 2017) morning before services start running

CC - Prasad Pise Rakesh Roy

This is tested on Stage - Working well

Ready for Production

CC - Prasad Pise Sachin Hingole Hrishikesh Deshpande Rakesh Roy

There are two dependent tickets for change, which must move along with this ticket.

1] For export WT-7604, ready for stage.

Prasanna Karlekar I believe there are some changes on your side as well, can you link that jira to this so that we can track all three tickets together.

Hi Vinayak Kulkarni / Umesh Kadam,

For reports, have linked WT-8172. This will get deployed on LB today i.e. 15-Jun-2017.

Thank you!

Mentioned scenarios tested on Production - Worked as per the expectations

CC - Sachin Hingole Prasad Pise Hrishikesh Deshpande Rakesh Roy

This patch has been reverted from Production today, 07/27/2017.

Regards,
Satya Prakash

Cc: Umesh Kadam Jyoti Mayne Vinayak Kulkarni Amruta Lohiya