-
Type:
Bug
-
Status: Production Complete
-
Priority:
High
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
Environment:Production
-
Bug Severity:Medium
-
Module:BenAdmin - Report
-
Reported by:Support
-
Item State:Production Complete - Closed
-
Issue Importance:Must Have
Attached is a spreadsheet with the errors I have found for Intrepid. This thing is a mess. Rates are doubling, Coverages are doubling, I have included notes next to each line item.
The billing details coverage amounts don't match the enrollment coverage amounts. Is there anyway to stop the report from pulling life ltd std etc when they are still pending approval? These should not be billed for until we have approved coverage on them.
Also on the child life this is a problem with all clients with this type of coverage - If the coverage is per family - ie - you have 1 child and elect $10,000 in coverage the approved coverage amount on the bill should be $10,000, likewise if you have 3 children. But the report pulls $30,000. This amount is incorrect. In most cases, however the premium is correct, not in all but in most. if we could find a fix for this across the board that would be great.
- relates to
-
-
- Closed
-
Lisa Hernandez (Inactive)
created issue -
| Field | Original Value | New Value |
|---|---|---|
| Module | Parent values: BenAdmin(10100) | Parent values: BenAdmin(10100)Level 1 values: Report(10109) |
Vijay Siddha (Inactive)
made changes -
| Assignee | Vijay Siddha [ vijays ] | Prasanna Karlekar [ prasanna ] |
| Assignee | Prasanna Karlekar [ prasanna ] | Aditya Vishwakarma [ aditya.vishwakarma ] |
| Remaining Estimate | 0h [ 0 ] | |
| Time Spent | 0.75h [ 2700 ] | |
| Worklog Id | 28134 [ 28134 ] |
| Status | Open [ 1 ] | In Development [ 10007 ] |
Hello Lisa Hernandez
Here is primary analysis-
Attached is a spreadsheet with the errors I have found for Intrepid. This thing is a mess. Rates are doubling, Coverages are doubling, I have included notes next to each line item.
- 3c
Concern: Rates are doubling, Coverage are doubling
Cause: In Code summing up cost for main and Intermediate record.
Correction: Code fix required
The billing details coverage amounts don't match the enrollment coverage amounts. Is there anyway to stop the report from pulling life ltd std etc when they are still pending approval? These should not be billed for until we have approved coverage on them.
- This is already implemented. we only pull approved coverage on report.
Also on the child life this is a problem with all clients with this type of coverage - If the coverage is per family - ie - you have 1 child and elect $10,000 in coverage the approved coverage amount on the bill should be $10,000, likewise if you have 3 children. But the report pulls $30,000. This amount is incorrect. In most cases, however the premium is correct, not in all but in most. if we could find a fix for this across the board that would be great.
- I have created new ticket for this
WT-8642
We are working on it will keep you posted.
Thanks
-
- Time Spent:
- 6.5h
-
Analysis done for reported records.
| Time Spent | 0.75h [ 2700 ] | 7.25h [ 26100 ] |
| Worklog Id | 28175 [ 28175 ] |
-
- Time Spent:
- 0.75h
-
Issue Discussion
Root Cause Analysis
| Dev Due Date | 28/Feb/2017 | |
| Original Estimate | 0h [ 0 ] |
Hello Sachin Hingole
Can you please verify the fix for only issue mentioned below or first point of my last comment
Attached is a spreadsheet with the errors I have found for Intrepid. This thing is a mess. Rates are doubling, Coverages are doubling, I have included notes next to each line item
The fix should go in next LB build.
Thanks
| Assignee | Aditya Vishwakarma [ aditya.vishwakarma ] | Sachin Hingole [ sachin.hingole ] |
| Item State | Parent values: Production Complete(10222) | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) |
Sachin Hingole (Inactive)
made changes -
| Item State | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) | Parent values: LB QA(10201) |
| Code Reviewed By | Prasanna Karlekar [ 11907 ] |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: LB QA(10201) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Sachin Hingole (Inactive)
made changes -
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Sachin Hingole (Inactive)
made changes -
| Assignee | Sachin Hingole [ sachin.hingole ] | Meghana Kulkarni [ meghana.kulkarni ] |
Sachin Hingole (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
| Stage Due Date | 6/Mar/17 [ 2017-03-06 ] |
| Developer | Aditya Vishwakarma [ aditya.vishwakarma ] | |
| QA | Meghana Kulkarni [ meghana.kulkarni ] |
| 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 | 7.25h [ 26100 ] | 12.25h [ 44100 ] |
| Worklog Id | 28506 [ 28506 ] |
Khandu Kshirsagar (Inactive)
made changes -
| 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) |
Sachin Hingole (Inactive)
made changes -
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
Sachin Hingole (Inactive)
made changes -
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
| Production Due Date | 13/Mar/2017 | |
| Stage Due Date | 6/Mar/17 [ 2017-03-06 ] | 8/Mar/17 [ 2017-03-08 ] |
| 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) |
Verified First Point on Stage for Life and LTD benefit types.
It is working Fine
CC - Sachin Hingole
| Production Due Date | 13/Mar/2017 | 14/Mar/2017 |
| Time Spent | 12.25h [ 44100 ] | 13.75h [ 49500 ] |
| Worklog Id | 30007 [ 30007 ] |
| 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 ] | 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) |
Hi Tracy Kot,
Verified issue #1 on Production and it's working fine.
Can you please check from your side and close ticket accordingly.
CC - Sachin Hingole
Thanks,
Meghana Kulkarni
| Item State | Parent values: Production QA(10203)Level 1 values: In Testing(10218) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Assignee | Meghana Kulkarni [ meghana.kulkarni ] | Tracy Kot [ tkot ] |
| Resolution | Fixed [ 1 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Time Spent | 13.75h [ 49500 ] | 14.75h [ 53100 ] |
| Worklog Id | 30797 [ 30797 ] |
Lisa Hernandez, hi Lisa, did you want to check this? I'm out until Monday but call me cell if you need my help. My Cell is 832-741-7269.
| Assignee | Tracy Kot [ tkot ] | Lisa Hernandez [ lhernandez ] |
We will check it since it is supposed to be fixed now. I will pull the reports tonight and check them .
Thanks, Lisa
Lisa Hernandez (Inactive)
added a comment - We will check it since it is supposed to be fixed now. I will pull the reports tonight and check them .
Thanks, Lisa Lisa Hernandez, hi Lisa, I know you were going to check this mid March. IS this all corrected now and reports all provided to Intrepid? Thanks.
We had already pulled the bills by the time the corrections were made for this ticket and I have not had time to go back and pull new reports to check for errors. I will have Cindy Sanchez let me know if there are any errors when she pulls the bill for May in April.
Thanks,
Lisa
Lisa Hernandez (Inactive)
added a comment - We had already pulled the bills by the time the corrections were made for this ticket and I have not had time to go back and pull new reports to check for errors. I will have Cindy Sanchez let me know if there are any errors when she pulls the bill for May in April.
Thanks,
Lisa | Bug Severity | Medium [ 16702 ] | |
| Dev Due Date | 28/Feb/2017 | 28/Feb/2017 |
| Production Due Date | 14/Mar/2017 | 14/Mar/2017 |
| Stage Due Date | 8/Mar/17 [ 2017-03-08 ] | 8/Mar/17 [ 2017-03-08 ] |
Lisa Hernandez (Inactive)
added a comment - Cindy Sanchez | Environment_New | Production [ 18442 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
9h 50m | 1 |
Sachin Hingole (Inactive)
made transition
-
|
21h 52m | 1 |
Sachin Hingole (Inactive)
made transition
-
|
6d 20h 44m | 1 |
|
6d 4m | 1 |
|
1h 17m | 1 |
password is Recon2017