-
Type:
Enhancement
-
Status: Production Complete
-
Priority:
Medium
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Module:BenAdmin - Report
-
Reported by:Support
-
Item State:Production Complete - Closed
-
Severity:Simple
We need to export the correct coverage for child life plans having family rate
Examples
Employee has multiple children covered on a child life plan. The plan is offer in 1000, 5000, 10000 increments. All child are enrolled in 10,000 increments and the rate is a family rate
Currently the invoice is showing the correct premium with a coverage amount of 30,000. This is not correct the coverage amount should show as 10,000
You should always be able to calculate the premium based on the coverage shown on the invoice.
- is blocked by
-
WT-10360 BCC Invoice Management - Export Coverage corresponding to Rate for child life plans having family rate issue
-
- Closed
-
Developer | Harshada Borole [ harshada.borole ] |
Assignee | Jyoti Agrawal [ jyoti.agrawal ] | Harshada Borole [ harshada.borole ] |
Dev Due Date | 21/Jul/2017 |
Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) |
Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | Parent values: Development(10200)Level 1 values: In Progress(10206) |
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 ] |
-
- Time Spent:
- 7.5h
-
Coding,Testing, discussion.
Remaining Estimate | 0h [ 0 ] | |
Time Spent | 7.25h [ 26100 ] | |
Worklog Id | 65237 [ 65237 ] |
Time Spent | 7.25h [ 26100 ] | 12.75h [ 45900 ] |
Worklog Id | 65243 [ 65243 ] |
Time Spent | 12.75h [ 45900 ] | 19.75h [ 71100 ] |
Worklog Id | 65253 [ 65253 ] |
Time Spent | 19.75h [ 71100 ] | 28.25h [ 101700 ] |
Worklog Id | 65278 [ 65278 ] |
Remaining Estimate | 0h [ 0 ] | 1h [ 3600 ] |
Time Spent | 28.25h [ 101700 ] | 27.25h [ 98100 ] |
Worklog Id | 65278 [ 65278 ] |
-
- Time Spent:
- 0.25h
-
Query resolution - Max coverage not appearing correct for last record in Spouse Info
-
- Time Spent:
- 4.25h
-
Tested the scenario's and discussion.
-
- Time Spent:
- 3h
-
Code review, discussion with Harshada, issue analysis
-
- Time Spent:
- 0.75h
-
Document Review and Discussion
Remaining Estimate | 1h [ 3600 ] | 0.75h [ 2700 ] |
Time Spent | 27.25h [ 98100 ] | 27.5h [ 99000 ] |
Worklog Id | 65914 [ 65914 ] |
-
- Time Spent:
- 2h
-
Changes suggested and testing.
Remaining Estimate | 0.75h [ 2700 ] | 0.25h [ 900 ] |
Time Spent | 27.5h [ 99000 ] | 28h [ 100800 ] |
Worklog Id | 66907 [ 66907 ] |
Remaining Estimate | 0.25h [ 900 ] | 0h [ 0 ] |
Time Spent | 28h [ 100800 ] | 31h [ 111600 ] |
Worklog Id | 66909 [ 66909 ] |
Time Spent | 31h [ 111600 ] | 35.25h [ 126900 ] |
Worklog Id | 66914 [ 66914 ] |
Worklog Id | 66914 [ 66914 ] |
Time Spent | 35.25h [ 126900 ] | 36.25h [ 130500 ] |
Worklog Id | 66917 [ 66917 ] |
Code Review Date | 25/Jul/2017 | |
Code Reviewed By | Prasanna Karlekar [ 11907 ] | |
Original Estimate | 0h [ 0 ] |
Time Spent | 36.25h [ 130500 ] | 38.25h [ 137700 ] |
Worklog Id | 66941 [ 66941 ] |
Time Spent | 38.25h [ 137700 ] | 40.25h [ 144900 ] |
Worklog Id | 66942 [ 66942 ] |
Remaining Estimate | 0h [ 0 ] | 2h [ 7200 ] |
Time Spent | 40.25h [ 144900 ] | 38.25h [ 137700 ] |
Worklog Id | 66941 [ 66941 ] | |
Worklog Time Spent | 2h [ 7200 ] |
Remaining Estimate | 2h [ 7200 ] | 1h [ 3600 ] |
Time Spent | 38.25h [ 137700 ] | 39.25h [ 141300 ] |
Worklog Id | 66948 [ 66948 ] |
Remaining Estimate | 1h [ 3600 ] | 0h [ 0 ] |
Time Spent | 39.25h [ 141300 ] | 41.25h [ 148500 ] |
Worklog Id | 66951 [ 66951 ] |
Time Spent | 41.25h [ 148500 ] | 44.25h [ 159300 ] |
Worklog Id | 66957 [ 66957 ] |
Item State | Parent values: Development(10200)Level 1 values: In Progress(10206) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Attachment | WT-10129-Coverage for Child Plans.doc [ 56992 ] |
Assignee | Harshada Borole [ harshada.borole ] | Sachin Hingole [ sachin.hingole ] |
Assignee | Sachin Hingole [ sachin.hingole ] | Venkatesh Pujari [ venkatesh.pujari ] |
Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
-
- Time Spent:
- 0.5h
-
Go through of code changes done
Time Spent | 44.25h [ 159300 ] | 44.5h [ 160200 ] |
Worklog Id | 68010 [ 68010 ] |
Time Spent | 44.5h [ 160200 ] | 45.25h [ 162900 ] |
Worklog Id | 68030 [ 68030 ] |
Item State | Parent values: LB QA(10201)Level 1 values: In Testing(10210) | Parent values: LB QA(10201)Level 1 values: Re-open(10212) |
Status | Local Testing [ 10200 ] | Reopen in Local [ 10018 ] |
Assignee | Venkatesh Pujari [ venkatesh.pujari ] | Harshada Borole [ harshada.borole ] |
Time Spent | 45.25h [ 162900 ] | 49.75h [ 179100 ] |
Worklog Id | 68159 [ 68159 ] |
Time Spent | 49.75h [ 179100 ] | 50.25h [ 180900 ] |
Worklog Id | 68486 [ 68486 ] |
Attachment | InvoiceCoverageChange_Testcases.xls [ 57266 ] |
Time Spent | 50.25h [ 180900 ] | 51.75h [ 186300 ] |
Worklog Id | 68551 [ 68551 ] |
Time Spent | 51.75h [ 186300 ] | 52.25h [ 188100 ] |
Worklog Id | 68992 [ 68992 ] |
Time Spent | 52.25h [ 188100 ] | 53.25h [ 191700 ] |
Worklog Id | 69005 [ 69005 ] |
Item State | Parent values: LB QA(10201)Level 1 values: Re-open(10212) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Assignee | Harshada Borole [ harshada.borole ] | Venkatesh Pujari [ venkatesh.pujari ] |
Time Spent | 53.25h [ 191700 ] | 54.5h [ 196200 ] |
Worklog Id | 69759 [ 69759 ] |
Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
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: In Testing(10210) | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
Time Spent | 54.5h [ 196200 ] | 60h [ 216000 ] |
Worklog Id | 70035 [ 70035 ] |
Time Spent | 60h [ 216000 ] | 60.5h [ 217800 ] |
Worklog Id | 70035 [ 70035 ] |
Status | Local Testing [ 10200 ] | Pending for Stage Approval [ 10300 ] |
-
- Time Spent:
- 0.25h
-
Coverage discussion with QA
3C's update discussion with Dev
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) |
Status | Pending for Stage Approval [ 10300 ] | Approved for Stage [ 10030 ] |
Status | Approved for Stage [ 10030 ] | Stage Testing [ 10201 ] |
Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
Time Spent | 60.5h [ 217800 ] | 62.5h [ 225000 ] |
Worklog Id | 70864 [ 70864 ] |
Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) |
Time Spent | 62.5h [ 225000 ] | 66.5h [ 239400 ] |
Worklog Id | 71117 [ 71117 ] |
Status | Stage Testing [ 10201 ] | Pending for Production Approval [ 10301 ] |
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) |
Account Executive | Debbie Kulling [ dkulling ] |
Status | Pending for Production Approval [ 10301 ] | Approved for production [ 10034 ] |
Status | Approved for production [ 10034 ] | Production Testing [ 10202 ] |
Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production QA(10203)Level 1 values: In Testing(10218) |
Item State | Parent values: Production QA(10203)Level 1 values: In Testing(10218) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
-
- Time Spent:
- 3h
-
Testing on Production
Resolution | Done [ 10000 ] | |
Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
Assignee | Venkatesh Pujari [ venkatesh.pujari ] | Debbie Kulling [ dkulling ] |
Time Spent | 66.5h [ 239400 ] | 70h [ 252000 ] |
Worklog Id | 71949 [ 71949 ] |
Remaining Estimate | 0h [ 0 ] | 0.5h [ 1800 ] |
Time Spent | 70h [ 252000 ] | 69.5h [ 250200 ] |
Worklog Id | 71949 [ 71949 ] |
Remaining Estimate | 0.5h [ 1800 ] | 0.25h [ 900 ] |
Time Spent | 69.5h [ 250200 ] | 69.75h [ 251100 ] |
Worklog Id | 72547 [ 72547 ] |
Transition | Time In Source Status | Execution Times |
---|
|
5d 20h 15m | 1 |
|
13s | 1 |
|
2s | 1 |
|
3d 2h 57m | 1 |
|
7d 20h 22m | 1 |
|
8d 21h 3m | 2 |
|
9h 54m | 1 |
|
1d 15h 14m | 1 |
|
3s | 1 |
|
1d 6h 27m | 1 |
|
5d 16h 15m | 1 |
|
4s | 1 |
|
2h 38m | 1 |
Affected Area's:
Coverage Amount in Invoice
File's Affected:
OES_SP_Report_GetBillingDetailsColumnWise_InvoiceBenefitWise
Tested Scenario's:
Enrolled Child only.
Enrolled Child.
Enrolled Spouse.
Enrolled Child as well as Spouse.
Enrolled Child.
Enrolled Spouse.
Enrolled Child as well as Spouse.
Please refer the attached document.
WT-10129-Coverage for Child Plans.doc