-
Type:
Bug
-
Status: Closed
-
Priority:
High
-
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 - Life Plan
Rate - Sub rate A for class A | sub rate B for class B
- class A employee enrolled from 01/01/2016 (date time stamp in Dec 2016)
- employee got sub rate A
- fetched invoices for Jan Feb March April 2016 -> shown me billing details as per the sub rate A which is right
- partner went on change class page and changed employee's class to B with Eff Date 03/01/2016 (find the rate changes log in attached screenshot)
- Hence employee has sub rate A in Jan Feb 2016 | he has got sub rate B from March 2016
- now fetched invoice for May 2016
Expected Result & Actual Result
1. billing details as per the sub rate B in May 2016 - worked well
2. billing adjustment of (+ sub rate B cost) in March April 2016 - worked well
3. billing adjustment of (- sub rate A cost) in March April 2016 - DID NOT SHOW
CC - Deepali Tidke Rakesh Roy Venkatesh Pujari Hrishikesh Deshpande
- relates to
-
WT-6331 BCC Invoice Management - Adjustments in future Invoice
-
- Closed
-
| Assignee | Prasanna Karlekar [ prasanna ] | Jyoti Agrawal [ jyoti.agrawal ] |
| Remaining Estimate | 5h [ 18000 ] | 4.5h [ 16200 ] |
| Time Spent | 0.5h [ 1800 ] | |
| Worklog Id | 14573 [ 14573 ] |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Jyoti Agrawal (Inactive)
logged work - 21/Dec/16 01:37 PM -
- Time Spent:
- 1.5h
-
Unit testing, LB code check-in
Jyoti Agrawal (Inactive)
made changes -
| Remaining Estimate | 4.5h [ 16200 ] | 3h [ 10800 ] |
| Time Spent | 0.5h [ 1800 ] | 2h [ 7200 ] |
| Worklog Id | 14797 [ 14797 ] |
Below are 3C's :-
Concern :- Incomplete Adjustment data shown in case of class change - eligible rates change scenarios
Cause :- Joins in query were made based on healthtier. Non-health benefits do not have healthtier. So this was failing for non-health benefits
Correction :- Removed healthtier join query and considered enrollment only.
Jyoti Agrawal (Inactive)
added a comment - Below are 3C's :-
Concern :- Incomplete Adjustment data shown in case of class change - eligible rates change scenarios
Cause :- Joins in query were made based on healthtier. Non-health benefits do not have healthtier. So this was failing for non-health benefits
Correction :- Removed healthtier join query and considered enrollment only. Jyoti Agrawal (Inactive)
made changes -
| Assignee | Jyoti Agrawal [ jyoti.agrawal ] | Alankar Chavan [ alankar.chavan ] |
| Status | Open [ 1 ] | In Development [ 10007 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Hello Jyoti Agrawal,
This is working well for Non Health Plans.
But it has broken the existing working functionality for Health Plans now.
When I tried above scenarios with Health Plans - I am getting Zero cost for health plan in billing as well as in billing adjustment sections.
CC - Deepali Tidke Rakesh Roy Hrishikesh Deshpande Prasanna Karlekar Venkatesh Pujari
Jyoti Agrawal (Inactive)
logged work - 22/Dec/16 01:23 PM -
- Time Spent:
- 7h
-
Analysis, discussion, coding, scenario generation, unit testing, LB code check-in
Jyoti Agrawal (Inactive)
made changes -
| Remaining Estimate | 3h [ 10800 ] | 0h [ 0 ] |
| Time Spent | 2h [ 7200 ] | 9h [ 32400 ] |
| Worklog Id | 15075 [ 15075 ] |
-
- Time Spent:
- 1.5h
-
Discussion and issue resolution for cost not appearing for Non Health plans
Issue resolution for cost not appearing for Health plans.
| Time Spent | 9h [ 32400 ] | 10.5h [ 37800 ] |
| Worklog Id | 15130 [ 15130 ] |
This is tested on WT Stage - 23rd Dec 2016
Working Well for Health (Billed Rate and Self Insured Component) & Non Health Plans.
Proper adjustments were shown in the mentioned scenarios
CC - Deepali Tidke Hrishikesh DeshpandeVenkatesh PujariRakesh Roy
Ready for Stage
[please deploy this on Stage with it's parent item ie, WT-6331]
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
| Time Spent | 10.5h [ 37800 ] | 12.5h [ 45000 ] |
| Worklog Id | 15248 [ 15248 ] |
| 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) |
| Time Spent | 12.5h [ 45000 ] | 14h [ 50400 ] |
| Worklog Id | 15404 [ 15404 ] |
| Assignee | Alankar Chavan [ alankar.chavan ] | Venkatesh Pujari [ venkatesh.pujari ] |
| 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) |
This is tested on Stage on AFI For Hspl company - 27th Dec 2016
Working Well for Health (Billed Rate and Self Insured Component) & Non Health Plans.
Proper adjustments were shown in the mentioned scenarios
CC - Alankar Chavan,Prasanna Karlekar
Ready for Production
[please deploy this on Production with it's parent item i.e WT-6331]
| 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 | 14h [ 50400 ] | 15.5h [ 55800 ] |
| Worklog Id | 15734 [ 15734 ] |
| Time Spent | 15.5h [ 55800 ] | 16h [ 57600 ] |
| Worklog Id | 15743 [ 15743 ] |
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) | Parent values: Production QA(10203)Level 1 values: In Testing(10218) |
| Time Spent | 16h [ 57600 ] | 17h [ 61200 ] |
| Worklog Id | 18269 [ 18269 ] |
| Resolution | Unresolved [ 10200 ] | |
| Status | Production Testing [ 10202 ] | Reopen in Production [ 10027 ] |
| Item State | Parent values: Production QA(10203)Level 1 values: In Testing(10218) | Parent values: Production QA(10203)Level 1 values: Re-open(10220) |
| Time Spent | 17h [ 61200 ] | 18h [ 64800 ] |
| Worklog Id | 18369 [ 18369 ] |
| Status | Reopen in Production [ 10027 ] | In Development [ 10007 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
| Item State | Parent values: Production QA(10203)Level 1 values: Re-open(10220) | Parent values: Production QA(10203)Level 1 values: In Testing(10218) |
| Comment |
[ Tested this on Production on ASML for Hspl company. Rate - Sub rate A for class A | sub rate B for class B class A employee enrolled from 01/01/2016 (date time stamp in Dec 2016) employee got sub rate A fetched invoices for Jan Feb March April 2016 -> shown me billing details as per the sub rate A which is right partner went on change class page and changed employee's class to B with Eff Date 03/01/2016 Hence employee has sub rate A in Jan Feb 2016 | he has got sub rate B from March 2016 now fetched invoice for May 2016 Expected Result :- 1. billing details as per the sub rate B in May 2016 2. billing adjustment of (+ sub rate B cost) in March April 2016 3. billing adjustment of (- sub rate A cost) in March April 2016 Actual Result:- Invoice generation failed because no record was found [~alankar.chavan],[~prasanna][~jyoti.agrawal] ] |
This is tested on Production on ASML For Hspl company
Working Well for Health (Billed Rate and Self Insured Component) & Non Health Plans.
Proper adjustments were shown in the mentioned scenarios
| Resolution | Unresolved [ 10200 ] | Fixed [ 1 ] |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Item State | Parent values: Production QA(10203)Level 1 values: In Testing(10218) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Environment_New | LB [ 18444 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
2d 5h 28m | 1 |
|
17h 25m | 1 |
|
15m 26s | 1 |
|
4s | 2 |
|
4d 23h 47m | 2 |
|
14d 53m | 2 |
|
11m 49s | 1 |
|
6s | 1 |
please also check below scenario -
Expected and Actual in Dec 2016 Invoice -
CC - Prasanna KarlekarVenkatesh Pujari Rakesh Roy