-
Type:
Bug
-
Status: Closed
-
Priority:
Medium
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Environment:QA
-
Module:BenAdmin - Report
-
Reported by:Harbinger
-
Item State:Production Complete - Closed
Plan - Vision [existing enrollment from Sept to Dec 2016]
Rate 1 - Non Self Insured (billed rate = $20)
Rate 2 - Non Self Insured (billed rate = $7)
Hence system invoices showed total cost $27 - expected
Now make second rate ineligible for an employee and recalculate the same
fetched invoice for Sept Oct Nov 2016 -> billing details shown as $20 - Expected
Now again make second rate eligible for employee and recalculate the same
fetched Dec 2016 Invoice
Expected & Actual Results -
Dec 2016 billing Detail of $27 - worked well
Adjustment for Sept Oct Nov 2016 should have come as $ +20 and $ + $07 - it came as $27
This is not wrong
But we are showing two entries everywhere in adjustments - not summing u the costs.
Please decide one approach and make it uniform everywhere
CC - Deepali Tidke Rakesh Roy Prasanna Karlekar Venkatesh Pujari
- relates to
-
WT-6953 WT -> BCC Invoice Enhancement -> Scenarios related to Future Elections
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
Jyoti Agrawal (Inactive)
logged work - 30/Dec/16 12:26 PM -
- Time Spent:
- 1h
-
Analysis, scenario generation, code fix, unit testing
Jyoti Agrawal (Inactive)
made changes -
| Field | Original Value | New Value |
|---|---|---|
| Remaining Estimate | 3h [ 10800 ] | 2h [ 7200 ] |
| Time Spent | 1h [ 3600 ] | |
| Worklog Id | 16418 [ 16418 ] |
| Assignee | Prasanna Karlekar [ prasanna ] | Jyoti Agrawal [ jyoti.agrawal ] |
| Priority | Medium [ 3 ] | High [ 2 ] |
Jyoti Agrawal (Inactive)
made changes -
| Priority | High [ 2 ] | Medium [ 3 ] |
| Dev Due Date | 24/Feb/2017 |
| Dev Due Date | 24/Feb/2017 | 16/Feb/2017 |
Jyoti Agrawal (Inactive)
made changes -
| Remaining Estimate | 2h [ 7200 ] | 0h [ 0 ] |
| Time Spent | 1h [ 3600 ] | 3h [ 10800 ] |
| Worklog Id | 25153 [ 25153 ] |
Jyoti Agrawal (Inactive)
logged work - 15/Feb/17 01:47 PM -
- Time Spent:
- 4h
-
Analysis, Discussion, Coding , Scenario creation
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 3h [ 10800 ] | 7h [ 25200 ] |
| Worklog Id | 25274 [ 25274 ] |
Jyoti Agrawal (Inactive)
logged work - 16/Feb/17 02:33 PM -
- Time Spent:
- 5h
-
Discussion, code change, scenario generation
-
- Time Spent:
- 1.5h
-
Analysis
Discussion
Pair programming
Jyoti Agrawal (Inactive)
made changes -
Jyoti Agrawal (Inactive)
logged work - 17/Feb/17 02:06 PM -
- Time Spent:
- 4h
-
Analysis, discussion, coding, scenario generation
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 7h [ 25200 ] | 11h [ 39600 ] |
| Worklog Id | 25938 [ 25938 ] |
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 11h [ 39600 ] | 16h [ 57600 ] |
| Worklog Id | 25959 [ 25959 ] |
| Status | Open [ 1 ] | In Development [ 10007 ] |
| Time Spent | 16h [ 57600 ] | 17.5h [ 63000 ] |
| Worklog Id | 25965 [ 25965 ] |
| Time Spent | 17.5h [ 63000 ] | 18.5h [ 66600 ] |
| Worklog Id | 25966 [ 25966 ] |
-
- Time Spent:
- 1h
-
Pair programming for issue fix.
| Dev Due Date | 16/Feb/2017 | 24/Feb/2017 |
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 18.5h [ 66600 ] | 19.75h [ 71100 ] |
| Worklog Id | 26732 [ 26732 ] |
-
- Time Spent:
- 1.25h
-
Pair programming and discussion.
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 19.75h [ 71100 ] | 20.75h [ 74700 ] |
| Worklog Id | 27044 [ 27044 ] |
-
- Time Spent:
- 1h
-
Analysis on bringing adjustments for complete election.
| Time Spent | 20.75h [ 74700 ] | 21.75h [ 78300 ] |
| Worklog Id | 27889 [ 27889 ] |
| Dev Due Date | 24/Feb/2017 | 14/Mar/2017 |
Jyoti Agrawal (Inactive)
made changes -
| Severity | Medium [ 13102 ] |
| Dev Due Date | 14/Mar/2017 | 29/Mar/2017 |
| Item State | Parent values: Development(10200)Level 1 values: On Hold(10207) |
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 21.75h [ 78300 ] | 23.75h [ 85500 ] |
| Worklog Id | 33726 [ 33726 ] |
| Dev Due Date | 29/Mar/2017 | 07/Apr/2017 |
Lalit Kumar (Inactive)
made changes -
| Attachment | WT-7288.docx [ 43483 ] |
Lalit Kumar (Inactive)
made changes -
| Attachment |
|
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 23.75h [ 85500 ] | 27.75h [ 99900 ] |
| Worklog Id | 35177 [ 35177 ] |
| Time Spent | 27.75h [ 99900 ] | 28.5h [ 102600 ] |
| Worklog Id | 35318 [ 35318 ] |
Jyoti Agrawal (Inactive)
logged work - 03/Apr/17 01:30 PM -
- Time Spent:
- 5h
-
Analysis, coding, discussion
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 28.5h [ 102600 ] | 33.5h [ 120600 ] |
| Worklog Id | 35805 [ 35805 ] |
| Item State | Parent values: Development(10200)Level 1 values: On Hold(10207) | Parent values: Development(10200)Level 1 values: In Progress(10206) |
| Developer | Jyoti Agrawal [ jyoti.agrawal ] |
Jyoti Agrawal (Inactive)
logged work - 04/Apr/17 01:16 PM -
- Time Spent:
- 6h
-
Discussion, scenario creation, testing
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 33.5h [ 120600 ] | 39.5h [ 142200 ] |
| Worklog Id | 36020 [ 36020 ] |
Jyoti Agrawal (Inactive)
made changes -
| Dev Due Date | 07/Apr/2017 | 12/Apr/2017 |
Jyoti Agrawal (Inactive)
logged work - 05/Apr/17 01:30 PM -
- Time Spent:
- 7h
-
Coding, analysis, discussion, testing
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 39.5h [ 142200 ] | 46.5h [ 167400 ] |
| Worklog Id | 36321 [ 36321 ] |
-
- Time Spent:
- 1.5h
-
Scenarion discussion
Discussion on testing approach
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 46.5h [ 167400 ] | 48h [ 172800 ] |
| Worklog Id | 36636 [ 36636 ] |
Jyoti Agrawal (Inactive)
logged work - 07/Apr/17 01:26 PM -
- Time Spent:
- 8h
-
Scenario creation, testing with Billed rate , Self Insured
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 48h [ 172800 ] | 56h [ 201600 ] |
| Worklog Id | 36927 [ 36927 ] |
-
- Time Spent:
- 0.5h
-
Invoice Scenario discussion
| Time Spent | 56h [ 201600 ] | 56.5h [ 203400 ] |
| Worklog Id | 37012 [ 37012 ] |
| Time Spent | 56.5h [ 203400 ] | 58h [ 208800 ] |
| Worklog Id | 37027 [ 37027 ] |
Jyoti Agrawal (Inactive)
logged work - 10/Apr/17 01:37 PM -
- Time Spent:
- 7h
-
Coding,testing,discussion,analysis
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 58h [ 208800 ] | 65h [ 234000 ] |
| Worklog Id | 37244 [ 37244 ] |
-
- Time Spent:
- 1.5h
-
Scenario discussion and analysis for issue fix in case of 0 cost adjustments
Jyoti Agrawal (Inactive)
logged work - 11/Apr/17 01:07 PM -
- Time Spent:
- 5h
-
Coding, discussion, analysis
-
- Time Spent:
- 1h
-
Discussion on Indexing and Performance for Invoice
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 65h [ 234000 ] | 70h [ 252000 ] |
| Worklog Id | 38285 [ 38285 ] |
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 70h [ 252000 ] | 71h [ 255600 ] |
| Worklog Id | 38306 [ 38306 ] |
Jyoti Agrawal (Inactive)
logged work - 18/Apr/17 03:53 PM -
- Time Spent:
- 6h
-
Coding, discussion, testing
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 71h [ 255600 ] | 73h [ 262800 ] |
| Worklog Id | 39480 [ 39480 ] |
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 73h [ 262800 ] | 79h [ 284400 ] |
| Worklog Id | 39481 [ 39481 ] |
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 79h [ 284400 ] | 82h [ 295200 ] |
| Worklog Id | 39491 [ 39491 ] |
Jyoti Agrawal (Inactive)
logged work - 20/Apr/17 02:16 PM -
- Time Spent:
- 6h
-
Coding, discussion, testing
-
- Time Spent:
- 1.5h
-
Scenario discussion:
1. Terminated elections getting rate when new rate is eligible
2. Free in - pay out policy
Jyoti Agrawal (Inactive)
logged work - 21/Apr/17 02:16 PM -
- Time Spent:
- 9h
-
Coding, discussion, testing
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 82h [ 295200 ] | 88h [ 316800 ] |
| Worklog Id | 40111 [ 40111 ] |
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 88h [ 316800 ] | 97h [ 349200 ] |
| Worklog Id | 40113 [ 40113 ] |
-
- Time Spent:
- 2h
-
Discussion on:
1. Mid month Tier Scenario when new rate is assigned for Terminated as well as active election
2. Free in - Pay out policyPair Programming:
Query changes to fetch the latest record for election irrespective of positive / negative cost.
Jyoti Agrawal (Inactive)
logged work - 24/Apr/17 02:24 PM -
- Time Spent:
- 5h
-
Coding, discussion, testing
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 97h [ 349200 ] | 102h [ 367200 ] |
| Worklog Id | 40460 [ 40460 ] |
| Time Spent | 102h [ 367200 ] | 103.5h [ 372600 ] |
| Worklog Id | 40568 [ 40568 ] |
| Time Spent | 103.5h [ 372600 ] | 105.5h [ 379800 ] |
| Worklog Id | 40575 [ 40575 ] |
| Time Spent | 105.5h [ 379800 ] | 107h [ 385200 ] |
| Worklog Id | 40585 [ 40585 ] |
| Time Spent | 107h [ 385200 ] | 107.5h [ 387000 ] |
| Worklog Id | 40596 [ 40596 ] |
Jyoti Agrawal (Inactive)
logged work - 25/Apr/17 01:32 PM -
- Time Spent:
- 3h
-
Unit Testing, discussion with Prasanna
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 107.5h [ 387000 ] | 110.5h [ 397800 ] |
| Worklog Id | 40678 [ 40678 ] |
Jyoti Agrawal (Inactive)
made changes -
| Item State | Parent values: Development(10200)Level 1 values: In Progress(10206) | Parent values: Development(10200)Level 1 values: Ready for Review(10208) |
Jyoti Agrawal (Inactive)
made changes -
| Code Review Date | 27/Apr/2017 | |
| Code Reviewed By | Prasanna Karlekar [ 11907 ] | |
| Dev Due Date | 12/Apr/2017 | 27/Apr/2017 |
| QA | Venkatesh Pujari [ venkatesh.pujari ] |
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 110.5h [ 397800 ] | 114.5h [ 412200 ] |
| Worklog Id | 41134 [ 41134 ] |
| Time Spent | 114.5h [ 412200 ] | 115.5h [ 415800 ] |
| Worklog Id | 41575 [ 41575 ] |
| Time Spent | 115.5h [ 415800 ] | 117h [ 421200 ] |
| Worklog Id | 41798 [ 41798 ] |
| Time Spent | 117h [ 421200 ] | 118h [ 424800 ] |
| Worklog Id | 41901 [ 41901 ] |
| Time Spent | 118h [ 424800 ] | 119h [ 428400 ] |
| Worklog Id | 42182 [ 42182 ] |
Jyoti Agrawal (Inactive)
made changes -
| Code Review Date | 27/Apr/2017 | 02/May/2017 |
3c's:-
Concern :- Incorrect adjustments in case of multiple rates mapped to a plan
Cause :- Adjustments for multiple rates were not handled properly
Correction :- Handled Adjustments for multiple rate mapped to a plan. Implemented to show adjustments at subrate level
Affected areas :- Adjustment of all benefit types
Affected files :- OES_SP_GetRetroBillingDetails_InvoiceBenefitWise
Tested following scenarios :-
1) Health benefits
a) With two billed rates
- Retro enrollment and future enrollment
- Eligibility change of rates
- Cost change of one rate
- Cost swap of both rate
- Addition of new rate
- Tier change
- Change in cost of one subrate
b) With two Self insured rates - tested all of above scenarios
c) With one billed rate and other self insured rate - tested all of above scenarios
2) Non health benefits
a) Life benefits - tested all of above with coverage change
b) Transit benefits - tested with cost change
Note :-
1) As per new implementation the adjustements will appear at subrate level
2) This item needs regression testing of adjustment for all benefit types
Jyoti Agrawal (Inactive)
added a comment - 3c's:-
Concern :- Incorrect adjustments in case of multiple rates mapped to a plan
Cause :- Adjustments for multiple rates were not handled properly
Correction :- Handled Adjustments for multiple rate mapped to a plan. Implemented to show adjustments at subrate level
Affected areas :- Adjustment of all benefit types
Affected files :- OES_SP_GetRetroBillingDetails_InvoiceBenefitWise
Tested following scenarios :-
1) Health benefits
a) With two billed rates
Retro enrollment and future enrollment
Eligibility change of rates
Cost change of one rate
Cost swap of both rate
Addition of new rate
Tier change
Change in cost of one subrate
b) With two Self insured rates - tested all of above scenarios
c) With one billed rate and other self insured rate - tested all of above scenarios
2) Non health benefits
a) Life benefits - tested all of above with coverage change
b) Transit benefits - tested with cost change
Note :-
1) As per new implementation the adjustements will appear at subrate level
2) This item needs regression testing of adjustment for all benefit types 
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: Development(10200)Level 1 values: Ready for Review(10208) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Jyoti Agrawal (Inactive)
logged work - 02/May/17 04:07 PM -
- Time Spent:
- 0.5h
-
Code check-in, ticket update
Jyoti Agrawal (Inactive)
made changes -
| Assignee | Jyoti Agrawal [ jyoti.agrawal ] | Sachin Hingole [ sachin.hingole ] |
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 119h [ 428400 ] | 119.5h [ 430200 ] |
| Worklog Id | 42762 [ 42762 ] |
| 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:
- 8h
-
Testing for Health Benefit plans
Hi Jyoti Agrawal,
After the fix on LB. I have verified the following scenarios on ASML company on LB:-
1] Health Benefits :- a] With a single billed rate
b] With two billed rates
This is verified for Retro and Future enrollments both
c] Also changed the eligibility of rates,cost change of one rate,swapping the cost one rate to other rate,added one new rate,tier change and also changed cost of only one subrate.
d] Verified the above scenarios for Self Insured components also.
e] Verified the above scenarios for one self insured component and one billed rate
f] Verified the above scenarios for Add Term Policies.
g] Now Non Health benefits plans are in testing will update once done
Sachin Hingole,Prasanna Karlekar
Thanks,
Venkatesh
| Time Spent | 119.5h [ 430200 ] | 127.5h [ 459000 ] |
| Worklog Id | 42901 [ 42901 ] |
-
- Time Spent:
- 0.5h
-
Code review (Not complete)
| Assignee | Sachin Hingole [ sachin.hingole ] | Venkatesh Pujari [ venkatesh.pujari ] |
-
- Time Spent:
- 0.5h
-
Code Review (Not Complete)
| Time Spent | 127.5h [ 459000 ] | 128h [ 460800 ] |
| Worklog Id | 43392 [ 43392 ] |
| Time Spent | 128h [ 460800 ] | 128.5h [ 462600 ] |
| Worklog Id | 43403 [ 43403 ] |
-
- Time Spent:
- 2h
-
Testing of non health plans
HI Jyoti Agrawal,
Tested the Non health benefit plans scenarios like coverage change,transit cost change and also without cost change.
Ready for Stage.
Sachin Hingole,Prasanna Karlekar
Thanks,
Venkatesh
| Time Spent | 128.5h [ 462600 ] | 130.5h [ 469800 ] |
| Worklog Id | 43663 [ 43663 ] |
| 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) |
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) |
| Status | Local Testing [ 10200 ] | 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) |
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 130.5h [ 469800 ] | 131.5h [ 473400 ] |
| Worklog Id | 45708 [ 45708 ] |
| Time Spent | 131.5h [ 473400 ] | 138h [ 496800 ] |
| Worklog Id | 45747 [ 45747 ] |
| Time Spent | 138h [ 496800 ] | 139h [ 500400 ] |
| Worklog Id | 46190 [ 46190 ] |
Hi Jyoti Agrawal,
After the fix on Stage. I have verified the following scenarios on on AFI For Hspl company:-
1] Health Benefits :- a] With a single billed rate
b] With two billed rates
This is verified for Retro and Future enrollments both
c] Also changed the eligibility of rates,cost change of one rate,swapping the cost one rate to other rate,added one new rate,tier change and also changed cost of only one subrate.
d] Verified the above scenarios for Self Insured components also.
e] Verified the above scenarios for one self insured component and one billed rate
f] Verified the above scenarios for Add Term Policies.
g]Tested the Non health benefit plans scenarios like coverage change,transit cost change and also without cost change.
Ready for Production
Prasanna Karlekar,Sachin Hingole
Only one concern is that if we are blocking 2016 adjustments then why are they displayed on the Invoice of 2017 year.
Thanks,
Venkatesh
| Time Spent | 139h [ 500400 ] | 141h [ 507600 ] |
| Worklog Id | 46221 [ 46221 ] |
| 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) |
Khandu Kshirsagar (Inactive)
made changes -
| 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) |
-
- Time Spent:
- 1.25h
-
Testing on production
| Time Spent | 141h [ 507600 ] | 142.25h [ 512100 ] |
| Worklog Id | 46752 [ 46752 ] |
Jyoti Agrawal (Inactive)
logged work - 18/May/17 04:25 PM -
- Time Spent:
- 0.25h
-
code check-in on production
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 142.25h [ 512100 ] | 142.5h [ 513000 ] |
| Worklog Id | 46852 [ 46852 ] |
| Time Spent | 142.5h [ 513000 ] | 145.5h [ 523800 ] |
| Worklog Id | 47253 [ 47253 ] |
Hi Jyoti Agrawal,
After the fix on Production. I have verified the following scenarios on AFI For Hspl company on Production:-
1] Health Benefits :- a] With a single billed rate
b] With two billed rates
This is verified for Retro and Future enrollments both
c] Also changed the eligibility of rates,cost change of one rate,swapping the cost one rate to other rate,added one new rate,tier change and also changed cost of only one subrate.
d] Verified the above scenarios for Self Insured components also.
e] Verified the above scenarios for one self insured component and one billed rate
f] Verified the above scenarios for Add Term Policies.
Now Non Health benefits plans are in testing will update once done
Thanks,
Venkatesh
| Time Spent | 145.5h [ 523800 ] | 147.5h [ 531000 ] |
| Worklog Id | 47670 [ 47670 ] |
HI Jyoti Agrawal,
Tested the Non health benefit plans scenarios like coverage change,transit cost change and also without cost change.
Sachin Hingole,Prasanna Karlekar
Thanks,
Venkatesh
| Item State | Parent values: Production QA(10203)Level 1 values: In Testing(10218) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Resolution | Fixed [ 1 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Time Spent | 147.5h [ 531000 ] | 150.5h [ 541800 ] |
| Worklog Id | 47888 [ 47888 ] |
| Environment_New | LB [ 18444 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
58d 7h 18m | 1 |
|
74d 12h 12m | 1 |
|
12d 1h 17m | 1 |
|
3d 7h 9m | 1 |
|
4d 18h 6m | 1 |
|
2s | 1 |
Somewhere I also think - showing the adjustment amounts buy summing up them will be more appropriate. But as in other cases we are not summing up the adjustment amounts - logging this discrepancy in above ticket
Ie, say if it is $20 and $ 30 - we can show it as $50
if it is $ - 20 and $ 30 - we can show it as $10
we can have a call with client and decide the approach