LB
TIBCO

• employee is enrolled in STD plan from 01/01/2014
• waived this plan
• enrolled again with future effective date say 20th Dec 2016 (hence above entry is waived on 19th Dec)

Ideally InvoiceBenefitwiseBilling table should have contain the same entry from Employee_Intermediate_Enrollment now - which It does not have. The Employee_Intermediate_Enrollment table is still having the older enrollment entries

• Current Date is say - 16th Dec 2016
• Changed the election effective date from back end to current date say 16th Dec 2016 and ran Effective Date Service
  
  Ideally the election entry should be getting moved from Employee_Intermediate_Enrollment
  to Employee_Enrollment Table - and the same entry (same enrollment ID) should get updated in InvoiceBenefitwiseBilling table with Is Intermediate = 0
  Here - InvoiceBenefitwiseBilling table still had the older election entries, Not the ones moved from intermediate to main enrollment table

CC - Deepali Tidke Hrishikesh Deshpande Venkatesh Pujari Rakesh Roy

This is associated to WT-7067