-
Type:
Bug
-
Status: Closed
-
Priority:
Medium
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:
-
Environment:Production
-
Bug Type:Functional
-
Bug Severity:Critical
-
Module:BenAdmin - Report
-
Reported by:Client
-
Company:All Clients/Multiple Clients
-
Item State:Production Complete - Closed
-
Sprint:WT Sprint 41
Please review the Billing Summary Report in Production - Client Name - Superheat FGH. This needs to be corrected as soon as possible, this is affecting the client and they as many other clients use this report to submit their volume and counts to their Life carriers to pay their premiums.
The following plan premiums are not calculating correctly:
Plan 1:
Basic Life - Basic Life - Lincoln Financial Group
Rate Name: 2016 - 2018 Basic Life-Basic Life
Report shows $3,134.56, but when you manually calculate it the premium comes out to be $3,134.05 (volume*rate/coverage divisor) (16072050.00*0.1950/1000). There is a difference of $0.51.
Plan 2:
Plan: Basic AD&D-Basic AD&D-Lincoln Financial Group
Rate Name: 2016 - 2018 Basic AD&D-Basic AD&D
Report shows $401.33, but when you manually calculate it the premium comes out to be $400.83 (volume*rate/coverage divisor) (16033050.00*0.0250/1000). There is a difference of $0.50.
Plan 3:
Plan: Voluntary Child Life-Voluntary Child Life-Lincoln Financial Group
Rate Name: 2016 - 2018 Vol Child life-Child Life
Report shows $75.62, but when you manually calculate it the premium comes out to be $75.73 (volume*rate/coverage divisor) (380000.00*0.1993/1000). There is a difference of $0.11.
This is also similar to WT 9738.
-
- Time Spent:
- 2.25h
-
Issue verification - Stored Procedure debug
Script to pull the affected records
JIRA update
-
- Time Spent:
- 1.5h
-
Code analysis for round up issue fix
-
- Time Spent:
- 0.75h
-
JIRA update on queries
-
- Time Spent:
- 6h
-
Existing implementation analysis
-
- Time Spent:
- 7.75h
-
Analysis of existing implementation and changes required
Code changes
-
- Time Spent:
- 9h
-
Code changes
Unit testing
Internal discussion
Code changes merge
-
- Time Spent:
- 0.75h
-
Discussion on output provided by Billing Summary report
-
- Time Spent:
- 8h
-
Code changes and Unit testing
JIRA update and Review request
-
- Time Spent:
- 1.5h
-
Code review
Discussion on Billing Report
-
- Time Spent:
- 1h
-
Analysis
Interna;l discussion with Developer
-
- Time Spent:
- 0.25h
-
internal discussion with QA
-
- Time Spent:
- 2h
-
Analysis
Testing
Cost Calculations
JIra updates
-
- Time Spent:
- 2h
-
Analysis
Jira update
Testing on stage
-
- Time Spent:
- 0.5h
-
Verified reopened points on stage
JIRA Update
Discussion with QA
-
- Time Spent:
- 4h
-
Analysis
Test Scenarios Writing
-
- Time Spent:
- 0.25h
-
Internal discussions with QA
-
- Time Spent:
- 2h
-
Understanding and testing on production