-
Type:
Bug
-
Status: Closed
-
Priority:
High
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Environment:QA
-
Module:BenAdmin - Report
-
Reported by:Harbinger
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
| Description |
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) {color:#d04437}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{color} * 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 - [~deepalit] [~hrishikesh.deshpande] [~venkatesh.pujari] [~rakeshr] This is associated to |
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) {color:#d04437}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{color} * 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 {color:#d04437} 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{color} CC - [~deepalit] [~hrishikesh.deshpande] [~venkatesh.pujari] [~rakeshr] This is associated to |
| Assignee | Prasanna Karlekar [ prasanna ] | Jyoti Agrawal [ jyoti.agrawal ] |
| Dev Due Date | 24/Feb/2017 |
| Dev Due Date | 24/Feb/2017 | 17/Feb/2017 |
| Remaining Estimate | 5h [ 18000 ] | 4.25h [ 15300 ] |
| Time Spent | 0.75h [ 2700 ] | |
| Worklog Id | 25973 [ 25973 ] |
-
- Time Spent:
- 0.75h
-
Issue verification and discussion.
| Code Reviewed By | Prasanna Karlekar [ 11907 ] | |
| Dev Due Date | 17/Feb/2017 | 22/Feb/2017 |
Hi Venkatesh Pujari,
We have verified this issue from our end. Seems working well. Please verify from your end.
Thanks,
Jyoti Agrawal
Jyoti Agrawal (Inactive)
added a comment - Hi Venkatesh Pujari ,
We have verified this issue from our end. Seems working well. Please verify from your end.
Thanks,
Jyoti Agrawal Jyoti Agrawal (Inactive)
made changes -
| Assignee | Jyoti Agrawal [ jyoti.agrawal ] | Venkatesh Pujari [ venkatesh.pujari ] |
Jyoti Agrawal (Inactive)
logged work - 20/Feb/17 01:27 PM -
- Time Spent:
- 4h
-
Analysis, scenario creation, verification, discussion
Jyoti Agrawal (Inactive)
made changes -
| Remaining Estimate | 4.25h [ 15300 ] | 0.25h [ 900 ] |
| Time Spent | 0.75h [ 2700 ] | 4.75h [ 17100 ] |
| Worklog Id | 26170 [ 26170 ] |
| Remaining Estimate | 0.25h [ 900 ] | 0h [ 0 ] |
| Time Spent | 4.75h [ 17100 ] | 5.25h [ 18900 ] |
| Worklog Id | 26172 [ 26172 ] |
| Status | Open [ 1 ] | In Development [ 10007 ] |
Tested this issue on LB Caiso company. Adjustments displayed as expected.
| Resolution | Fixed [ 1 ] | |
| Status | In Development [ 10007 ] | Rejected [ 10004 ] |
| Time Spent | 5.25h [ 18900 ] | 6.25h [ 22500 ] |
| Worklog Id | 26538 [ 26538 ] |
| Status | Rejected [ 10004 ] | Closed [ 6 ] |
| Environment_New | LB [ 18444 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
67d 20h 8m | 1 |
|
35s | 1 |
|
34d 20h 30m | 1 |
Hi Alankar Chavan,
Above mentioned scenario have multiple entries in same month. With current implementation this is not working proper while invoice generation. Also until and unless the intermediate enrollment is inserted in InvoiceBenefitwiseBilling table, its enrollmentID will not change.
This is a different issue and not related to effective date service.
cc: Hrishikesh Deshpande