Following needs to be verified:
When future election is moved from Intermediate to main table by effective date service, EnrollmentId and IsIntermediate flag should get updated in Invoice table.

This is tested for Health as well as for Non Health enrollments

Scenarios Tested -

• employee enrolled in a plan with future effective date say 20th Dec 2016
  Now Employee_enrollment_Intermediate table has this entry
  Same entry is in the InvoiceBenefitwiseBilling table with enrollment ID (from Employee_enrollment_Intermediate table) and Is Intermediate Flag = 1

• changed the election effective date to current date say 16th Dec 2016
• Ran Effective Date Service
  Now - enrollment entry got moved from Employee_enrollment_Intermediate table to Employee_enrollment table [with different Enrollment ID]
  Same entry is in the InvoiceBenefitwiseBilling table with enrollment ID (from Employee_enrollment table) and Is Intermediate Flag = 0

This is as per the expectations

This is reopened cause of WT-7201. Once it is fixed and deployed - please assign this back to us

CC - Deepali Tidke Venkatesh Pujari Rakesh Roy Hrishikesh Deshpande

Hi Alankar Chavan,

Please close this issue.
Have updated comments in WT-7201 and the scenario mentioned is different from this ticket.

cc: Hrishikesh Deshpande

This is ready for Stage - 26th Dec 2016

[WT - 7201 is open - we will track this individually]

This is tested for Health [self insured and billed] as well as for Non Health enrollments

Scenarios Tested -

• employee enrolled in a plan with future effective date say 20th Dec 2016
• Now Employee_enrollment_Intermediate table has this entry
• Same entry is in the InvoiceBenefitwiseBilling table with enrollment ID (from Employee_enrollment_Intermediate table) and Is Intermediate Flag = 1
• changed the election effective date to current date say 16th Dec 2016
• Ran Effective Date Service
• Now - enrollment entry got moved from Employee_enrollment_Intermediate table to Employee_enrollment table [with different Enrollment ID]
• Same entry is in the InvoiceBenefitwiseBilling table with enrollment ID (from Employee_enrollment table) and Is Intermediate Flag = 0

This is as per the expectations

Ready for Production

CC - Prasanna KarlekarRakesh Roy Venkatesh Pujari Hrishikesh Deshpande

Hi Prasanna Karlekar,

I cannot test this feature on Production as I will need write access also for DB.

Alankar Chavan,Rakesh Roy,Sachin Hingole

Thanks,
Venkatesh

Tested this on Production on AFI for Hspl company.

Scenarios Tested -

Employee enrolled in a plan with future effective date say 10th March 2017
Now Employee_enrollment_Intermediate table has this entry
Same entry is in the InvoiceBenefitwiseBilling table with enrollment ID (from Employee_enrollment_Intermediate table) and Is Intermediate Flag = 1

After the Effective Date Service

Now - enrollment entry got moved from Employee_enrollment_Intermediate table to Employee_enrollment table [with different Enrollment ID]
Same entry is in the InvoiceBenefitwiseBilling table with enrollment ID (from Employee_enrollment table) and Is Intermediate Flag = 0

This is as per the expectations

Thanks,
Venkatesh