-
Type:
Bug
-
Status: Closed
-
Priority:
Medium
-
Resolution: Bug Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: UI Refresh
-
Labels:None
-
Environment:Production
-
Bug Severity:Medium
-
Module:BenAdmin
-
Reported by:White Label
-
Company:City of Walnut Creek
-
Item State:Stage QA - Ready for Production
Hi,
Per BCC:
We are experiencing issues with the Medical rates for City of Walnut Creek. It appears that even though the 2017 rates are end dated 12/31/17, they are still being assigned to some of the enrollees for 2018.
This came to light because we had to correct the 2018 rates that were in the system. The rates have been updated, but when we went to Extend and Recalc the rates, we noticed there were two entries for some of the Employees.
EXAMPLE: A. Mitcalf - She has been enrolled in the BlueShield HMO plan since 1/1/2017. On her Confirmation Statement the system is adding together the rates from 2017 and 2018. This is also apparent in the SA Toolbox. When we went to extend and recalculate her rate, the toolbox shows that she has two entries for 1/1/18 – 12/31/18. One is the rate for 2017, the other is the rate for 2018.
This is happening sporadically on all Medical plans (BlueShield HMO, BlueShield HDHP, Kaiser HMO, Kaiser HDHP).
Could you please have development correct this issue?
We have not extended and recalculated the rates for all Medical plans yet as we need to have this resolved prior to doing so.
Thank you,
Kira Hamilton
Debbie Kulling
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Satya [ ID10004 ] | Jyoti Mayne [ jyoti.mayne ] |
| Assignee | Jyoti Mayne [ jyoti.mayne ] | Rohit Shete [ rohit.shete ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
-
- Time Spent:
- 1h
-
- Company Restore
- initial Analysis
- data audit
- Comment add
Hi Kira Hamilton,
- The sub-rate 'PMA (FT) POA (FT)' of the rate 'BS HMO 2018' is deleted from system on date time '2018-01-10 09:33:10.920' but still allocation was there in system. Hence rate is doubling.
- We have working on data correction and we will update you tomorrow EOD.
Thanks and Regards,
Rohit Shete.
| Developer | Rohit Shete [ rohit.shete ] |
| Remaining Estimate | 0h [ 0 ] | |
| Time Spent | 0.5h [ 1800 ] | |
| Worklog Id | 100914 [ 100914 ] |
| Attachment | EmployeeCorrectionList(WT-13001).xls [ 71978 ] |
Hi Kira Hamilton,
Please find below 3C's:
Concern: SA toolbox shows that EE has two entries for 1/1/18 – 12/31/18.
Cause:
- EE 'MITCALF AMEILIA' have election in plan 'Blue Shield HMO' from 01/01/2017 to Null.
- Please find below rate allocation detail for this election.
DateTimeStamp EffectiveDate TerminationDate RateName SubRate 2016-12-05 09:00:04.123 01/01/2017 12/31/2017 BS HMO PMA (FT) POA (FT) 2017-12-06 01:34:49.940 01/01/2018 12/31/2018 BS HMO 2018 PMA (FT) POA (FT) 2018-01-12 08:31:52.413 01/01/2018 12/31/2018 BS HMO 2018 PROF (FT) CIV POL (FT) POA FT - The sub-rate 'PMA (FT) POA (FT)' of the rate 'BS HMO 2018' is deleted from system on date time '2018-01-10 09:33:10.920' but still allocation was there in system. Hence for the EE system has shows two entries for 1/1/18 – 12/31/18.
- Additionally, we have found another sub-rate 'PMA (FT) POA (FT)' of the rate 'BS PPO HDHP 2018' is deleted from system on date time '2018-01-10 11:59:10.520' but still allocation was there in system and we have also corrected this records.
Correction: We have done correction for attached employee's EmployeeCorrectionList(WT-13001).xls
.
Please confirm and let us know in case any query.
Thanks and Reagrds,
Rohit Shete.
| Status | In Progress [ 3 ] | Waiting for Customer Input [ 10500 ] |
| Assignee | Rohit Shete [ rohit.shete ] | Kira Hamilton [ kira.hamilton ] |
Verified given Sheet of records 'City of Walnut Creek for hspl' on production.,
It showing proper rate. Cross Verified on Enroll now screen, view enrollment summary, Confirmation statement and enrollment report
| Time Spent | 0.5h [ 1800 ] | 3.5h [ 12600 ] |
| Worklog Id | 100931 [ 100931 ] |
-
- Time Spent:
- 5h
-
- Impacted Data analysis
- Script Creation
- Execution on hspl
- Verify on hspl
- Rate Recal
- correction on main
- verify
- and comment add
Hi Rohit Shete
Thank you for the update. Can you tell us why the rate was still showing although it was deleted from the system?
Thank you,
Kira Hamilton
Debbie Kulling
-
- Time Spent:
- 0.5h
-
Analysis and discussion with Rohit S.
Data correction and verification on LIVE copy
-
- Time Spent:
- 2h
-
- Issue Reproduce
- Data analysis
- Impact analysis
- check customization
- Comment add
| Attachment | RateCustomization.png [ 72064 ] |
Hi Kira Hamilton,
Please find below 3C's:
Concern: Sub-rate is deleted if it is in use.
Cause:
- There is issue with grid pagination.
- On rates matrices tab, shows only max 10 records and other records shows with pagination.
- If sub rate is an use but it shows on except 1 paging, that time checkbox selection is not disable for allocated sub-rate, hence system is allow to delete.
- For these reason sub-rate is deleted but allocation was still exist in system.
Correction: We have to need code fix for this and we need approval for code fix.
Cc: Jyoti Mayne
| Time Spent | 3.5h [ 12600 ] | 3.75h [ 13500 ] |
| Worklog Id | 101768 [ 101768 ] |
| Time Spent | 3.75h [ 13500 ] | 4h [ 14400 ] |
| Worklog Id | 101769 [ 101769 ] |
| Time Spent | 4h [ 14400 ] | 5h [ 18000 ] |
| Worklog Id | 102315 [ 102315 ] |
| Time Spent | 5h [ 18000 ] | 10h [ 36000 ] |
| Worklog Id | 102318 [ 102318 ] |
| Time Spent | 10h [ 36000 ] | 12h [ 43200 ] |
| Worklog Id | 102333 [ 102333 ] |
Hi Jyoti Mayne,
I have cross verified this issue on Production and Pre-Prod it is not working.
We are able to delete used sub-rate when it crosses the limit of first matrices tab (10 sub-rate) or 1st paging.
Thanks,
Rashmita
| Assignee | Kira Hamilton [ kira.hamilton ] | Jyoti Mayne [ jyoti.mayne ] |
| Time Spent | 12h [ 43200 ] | 14h [ 50400 ] |
| Worklog Id | 102782 [ 102782 ] |
Please check.
| Assignee | Jyoti Mayne [ jyoti.mayne ] | Harshawardhan Phalake [ harshawardhan ] |
| Status | Open [ 1 ] | In Development [ 10007 ] |
| Stage Due Date | 3/Feb/18 [ 2018-02-03 ] | |
| Original Estimate | 0h [ 0 ] |
| Item State | Parent values: Development(10200)Level 1 values: Ready for Review(10208) |
| Code Reviewed By | Rohan Khandave [ 11903 ] |
-
- Time Spent:
- 8h
-
Analysis coding and Testing and check other pages for the similar issue.
| Time Spent | 14h [ 50400 ] | 22h [ 79200 ] |
| Worklog Id | 103157 [ 103157 ] |
| Item State | Parent values: Development(10200)Level 1 values: Ready for Review(10208) | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) |
Hi Sachin Hingole,
Please test the issue once deployed on code-map, We have fixed the data table related issue.
Now if rates are in use then it will not be able to delete from system
Thanks,
Harshawardhan.
CC: Rohan J Khandave
| Assignee | Harshawardhan Phalake [ harshawardhan ] | Sachin Hingole [ sachin.hingole ] |
-
- Time Spent:
- 3h
-
Code check in and testing
| Time Spent | 22h [ 79200 ] | 24h [ 86400 ] |
| Worklog Id | 103472 [ 103472 ] |
| Time Spent | 24h [ 86400 ] | 25h [ 90000 ] |
| Worklog Id | 103472 [ 103472 ] |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Sachin Hingole (Inactive)
made changes -
| Assignee | Sachin Hingole [ sachin.hingole ] | Rashmita Dudhe [ rashmita.dudhe ] |
| 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 | In Development [ 10007 ] | Local Testing [ 10200 ] |
-
- Time Spent:
- 4h
-
Scenario writing and testing
| Attachment | NF-5842_Scenarios.xls [ 73011 ] |
Verified on code map
all attached scenarios it working fine
| Time Spent | 25h [ 90000 ] | 29h [ 104400 ] |
| Worklog Id | 103719 [ 103719 ] |
| Time Spent | 29h [ 104400 ] | 29.25h [ 105300 ] |
| Worklog Id | 103728 [ 103728 ] |
| 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) |
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Time Spent | 29.25h [ 105300 ] | 31.25h [ 112500 ] |
| Worklog Id | 103989 [ 103989 ] |
Verified on pre prod
all attached scenarios it working fine
| 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) |
Nidhi Kaul (Inactive)
made changes -
| Component/s | UI Refresh [ 10902 ] |
| Status | Stage Testing [ 10201 ] | In Production Testing [ 10202 ] |
Verified on prod
all attached scenarios it working fine
| Time Spent | 31.25h [ 112500 ] | 34.25h [ 123300 ] |
| Worklog Id | 111142 [ 111142 ] |
| Resolution | Bug Fixed [ 10402 ] | |
| Status | In Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
1d 13h 36m | 1 |
|
1d 2h 57m | 1 |
|
12d 18h 51m | 1 |
|
23h 38m | 1 |
|
5d 23h 53m | 1 |
|
2d 3h 30m | 1 |
|
51d 12h 44m | 1 |
|
56s | 1 |
|
14s | 1 |
Hi Kira Hamilton,
Due to other priority issues, we couldn't work on this. We will update you on its progress.