-
Type:
Change Request
-
Status: Closed
-
Priority:
Critical
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Module:BenAdmin - Report
-
Reported by:Harbinger
-
Item State:Production Complete - Closed
-
Issue Importance:Must Have
-
Sprint:WT Sprint 18
We have done changes in effective date service to update the Invoice table, when enrollment is shifted from Enrollment Intermediate to Main table.
- relates to
-
WT-6331 BCC Invoice Management - Adjustments in future Invoice
-
- Closed
-
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Vijay Siddha [ vijays ] | Alankar Chavan [ alankar.chavan ] |
| Status | New Request [ 10029 ] | Pending for Approval [ 10002 ] |
| Status | Pending for Approval [ 10002 ] | Approved for Development [ 10003 ] |
| Status | Approved for Development [ 10003 ] | In Development [ 10007 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Sprint | WT Sprint 18 [ 34 ] |
| Account Executive | Debbie Kulling [ dkulling ] | |
| Code Review Date | 09/Dec/2016 | |
| Code Reviewed By | Saurabh Sablaka [ 11909 ] | |
| Dev Due Date | 09/Dec/2016 | |
| Dev Estimates | 3 | |
| Developer | Prasanna Karlekar [ prasanna ] | |
| QA | Alankar Chavan [ alankar.chavan ] | |
| QA Estimates | 2 |
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
| Status | Local Testing [ 10200 ] | Reopen in Local [ 10018 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: Re-open(10212) |
| Assignee | Alankar Chavan [ alankar.chavan ] | Prasanna Karlekar [ prasanna ] |
-
- Time Spent:
- 6h
-
Local testing
Reopened withWT-7201and WT - 7194
| Remaining Estimate | 8h [ 28800 ] | |
| Original Estimate | 8h [ 28800 ] |
| Remaining Estimate | 8h [ 28800 ] | 2h [ 7200 ] |
| Time Spent | 6h [ 21600 ] | |
| Worklog Id | 13999 [ 13999 ] |
Hi Alankar Chavan,
Please close this issue.
Have updated comments in WT-7201 and the scenario mentioned is different from this ticket.
| Assignee | Prasanna Karlekar [ prasanna ] | Alankar Chavan [ alankar.chavan ] |
-
- Time Spent:
- 0.5h
-
Root cause analysis and update.
| Remaining Estimate | 2h [ 7200 ] | 1.5h [ 5400 ] |
| Time Spent | 6h [ 21600 ] | 6.5h [ 23400 ] |
| Worklog Id | 15326 [ 15326 ] |
| Remaining Estimate | 1.5h [ 5400 ] | 1h [ 3600 ] |
| Time Spent | 6.5h [ 23400 ] | 7h [ 25200 ] |
| Worklog Id | 15327 [ 15327 ] |
This is ready for Stage - 26th Dec 2016
[WT - 7201 is open - we will track this individually]
| Item State | Parent values: LB QA(10201)Level 1 values: Re-open(10212) | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
| Status | Reopen in Local [ 10018 ] | In Development [ 10007 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) |
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
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) |
| Remaining Estimate | 1h [ 3600 ] | 0h [ 0 ] |
| Time Spent | 7h [ 25200 ] | 9.5h [ 34200 ] |
| Worklog Id | 15974 [ 15974 ] |
| Status | Local Testing [ 10200 ] | Pending for Stage Approval [ 10300 ] |
| Assignee | Alankar Chavan [ alankar.chavan ] | Venkatesh Pujari [ venkatesh.pujari ] |
I cannot test this feature on Production as I will need write access also for DB.
Alankar Chavan,Rakesh Roy,Sachin Hingole
Thanks,
Venkatesh
| Status | Pending for Stage Approval [ 10300 ] | Approved for Stage [ 10030 ] |
| Status | Approved for Stage [ 10030 ] | Stage Testing [ 10201 ] |
| Module | Parent values: BenAdmin(10100) | Parent values: BenAdmin(10100)Level 1 values: Report(10109) |
| Item State | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) |
| Status | Stage Testing [ 10201 ] | Pending for Production Approval [ 10301 ] |
| Status | Pending for Production Approval [ 10301 ] | Approved for production [ 10034 ] |
| Status | Approved for production [ 10034 ] | Production Testing [ 10202 ] |
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
| Time Spent | 9.5h [ 34200 ] | 10.5h [ 37800 ] |
| Worklog Id | 30237 [ 30237 ] |
| Resolution | Done [ 10000 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Resolution | Done [ 10000 ] | Fixed [ 1 ] |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Time Spent | 10.5h [ 37800 ] | 10.75h [ 38700 ] |
| Worklog Id | 30564 [ 30564 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
2d 1h 36m | 1 |
|
3s | 1 |
|
2s | 1 |
|
2d 1h 57m | 1 |
|
9d 19h 6m | 1 |
|
4s | 2 |
|
6d 1h 18m | 1 |
|
25d 23h 43m | 1 |
|
2s | 1 |
|
41d 22h 10m | 1 |
|
3s | 1 |
|
2s | 1 |
|
2d 21h 23m | 1 |
|
18s | 1 |
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.