-
Type:
Bug
-
Status: Production Complete
-
Priority:
Medium
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
-
Environment:Production
-
Bug Severity:Medium
-
Module:BenAdmin - Enrollment
-
Reported by:Client
-
Company:TIBCO
-
Item State:Production Complete - Closed
-
Sprint:WT Sprint 41
-
Dev Estimates:28
-
QA Estimates:8
-
Code Reviewed By:Amruta Lohiya
-
Development Approval:Yes
-
Deployment Approval:Approved for production deployment
Hi!
Per the client:
Employee wanted to update his HSA contribution effective 11/1/2017.
Employee made the update but the EE cost is not appearing and the yearly Employer cost is showing $4000 but the Employer Coverage max is only $2000
The 2017 Plans have not been altered
Example EE: A. Yen
Please research and advise us as to why the EE cost is not appearing and why the Employer cost is showing $4000 when the Employer Coverage max is only $2000. Also, if necessary, please outline how the plan should be customized to prevent this from happening with other employees.
Please be advised the group is currently in Open Enrollment.
Thank you,
Kira Hamilton
Debbie Kulling
- is cloned by
-
NF-5604 TIBCO-HSA issue
-
- Closed
-
This explanation regarding the ER contribution does not make sense. The ER contribution should not change if the employee is just changing their election.
Also the max ER contribution is 2000. How is the system applying 4000. I went into the employees record and posted an event 1/1/2017 and the ER contribution is showing 4000 on 1/1/2017. Something is not right and the explanation above does not address the issue
Can some one please advise asap
Jyoti Mayne
This is an issue, user should never get ER coverage more than max, pro-ration is also there. Can you please debug and provide 3c's?
Regards,
Amruta
Hi Debbie Kulling,
Please find below details:
Issue 1:
Concern: For EE 'ADAM YEN' Employer cost is showing $4000 when the Employer Coverage max is only $2000
Cause: This is scenario specific issue for retro election of 2017 HSA plan.
There are two HSA plans.
1. 'Health Savings Account 2017' is contingent on 'Cigna CDHP' medical plan
2. 'Health Savings Account 2018' is contingent on 'Cigna Consumer Driven Health Plan' medical plan
EE is enrolled following in Health plan.
Effective Date | Termination date Date | Tier |
1/1/17 | 12/31/17 | EE+SP+2CH |
1/1/18 | NULL | EE+SP+2CH |
Here while doing election in 2017 HSA plan with 11/1/17 effective date, system is considering both parent plan election. Hence giving 2000 + 2000 = 4000 ER Coverage.
Correction: We are working on code fix and will update.
Please let us know shall we update ER contribution of 11/1/17 to 12/31/17 election to 2000 and correct ER cost.
Note: There is no issue for 2018 HSA election. We have verified same.
Issue 2:
Concern: EE cost is not appearing for 11/1/2017 HSA election
Cause: This is not an issue.
2017 HSA plan is having customization of 'Consider previous paid coverage in cost calculation ' to Yes.
EE is having election in HSA plan with 1/1/17 to 10/31/17 2860 as EE coverage. So when EE did election with 11/1/17 effective date with 595 EE coverage its cost is not calculated as he already paid 2833.33.
Here are the calculations:
Total Payroll Cycles= 24
Lapsed pay cycle from 1/1/17 to 10/31/17 = 20
EE cost per period is 2860/24 = 119.16
so cost paid for 1/1 to 10/31 is 119.16*20 = 2383.33
If EE elect more than 2383 coverage with 11/1/17 effective date, then cost will come.
Please let us know in case more details are required on this.
Cc: Amruta Lohiya
Yes please correct the ER cost to 2000. This must be occurring on all employees if they have made a change to their HSA. Please scan the elections. Also when will the code be release to correct this issue
Hi Debbie Kulling,
We have updated above mentioned ER coverage and its cost.
We will update on scanning and code fix part by tomorrow.
Cc: Amruta Lohiya
Hi Debbie Kulling,
Please find below list of impacted EEs. We have corrected their ER contribution and rates. Issue is for 'Health Savings Account 2017' plan only.
First Name | Last Name |
Govarthanan | Kollampallikadu Rajappan |
Tao | Peng |
Qidong | Xu |
Bo | Tong |
Shuhuan | Yan |
UDAY BHANU PRAS | KANAGALA |
Prashant | Anand |
Samuel | Ervin |
Chandrasekhara | Guttapalli |
Chetan | Punekar |
Cc: Amruta Lohiya
Hi Debbie Kulling,
Todday, we scanned all EEs and corrected data for following:
First Name | Last Name |
Xiaofan | Gao |
Daniel | O'Connor |
Venkateswar | Madireddi |
KYLE | THOMAS |
We are working on analyzing code fix part. Till code get deployed, we will do scanning and correct data if found any.
Cc: Amruta Lohiya, Samir
Hi,
Regarding ticket WT-12264
-Per the client, when an employee creates a QE to change their HSA the Employer Yearly contribution amount reverts back to $4,000. Hence, it does not see like changing the employee record on the backend stays corrected. BCC needs this corrected quickly, hence until the code fix is complete, what can be done so that the employees can change their HSA election amounts?
-When will the code fix be put in place?
-Once the code fix in place please review H. Chaparala record to make sure the Employer yearly amount is correct so she is then able to make her employee election.
Thank you,
Kira Hamilton
Debbie Kulling
Hi All,
Attaching the development approval email for reference: Unable to embed resource: FW Development approval for 9-Nov-2017.msg of type application/octet-stream
Regards
Gaurav
Hi Debbie Kulling,
We have scanned all EE data and corrected following impacted EEs records.
First Name | Last Name |
Toby | Dinh |
Elise | Hii |
Chandrasekhara | Guttapalli |
Mahimaa | Ramkumar |
Candace | Woltz |
Cc: Amruta Lohiya, Satya, Gaurav Sodani
have the employees above been corrected?
Hi Debbie Kulling,
Yes, we have corrected their ER contribution and cost for 2017 HSA plan.
Cc: Amruta Lohiya
Hi Jyoti Mayne,
Per BCC:
The participant involved in the original origin of this ticket wanted to increase the employee yearly coverage effective 12/1/2017 to 3000.00. When I create an event to make the update it changes the employer annual to 4,000 and only allows the employee to have 2750.00.
Can you do anything on the back end to correct the yearly employee amount to 3,000 and once again correct the employer amount to 2,000?
Can this be fixed as soon as possible as we need to manually adjust payroll file for this participant, see screen shot.
Participant is Harika Chaparala the update needs done only to the Health Savings Account 2017 plan.
Thank you,
Kira Hamilton
Debbie Kulling
Hi Kira Hamilton,
We have updated 'Harika Chaparala' employee coverage amount to $3000 with 12/1 effective date for 2017 health saving account plan.
Cc: Amruta Lohiya
Please test for following scenarios that HSA are getting proper Employer Coverage for multiple increase in and decrease in tiers for same year and different year cases:
1. There is ongoing election in parent plan e.g 1/1/16 to NULL
2. There is terminated election in parent plan e.g. 1/1/17 to 1/31/2018 and 2/1/18 to NULL
Cc: Amruta Lohiya
Hi Kira Hamilton,
We have scanned today and corrected following EE.
First Name | Last Name |
Shuhuan | Yan |
Shalini | Muthukrishnan |
Testing in progress
Verified on Lb Environment consider belwo scenarios:
Scenario #1
Parent plan with ongoing election 1/1/2016 to NULL.
HSA plan with Effective date 01/01/2017 to NULL
1]Increases tier in parent plan like EE, EE+SP, EE+SP+Ch, In the same year 2017
2]Increased tier in parent plan like EE, EE+SP, EE+SP+Ch, In the year 2017 and 2018
3]Decreased tier in parent plan like EE, EE+SP, EE+SP+Ch, In the same year 2017
4]Decreased tier in parent plan like EE, EE+SP, EE+SP+Ch, In the year 2017 and 2018
Scenario #2
Parent plan with ongoing election 1/1/2016 to NULL.
2017 HSA plan with Effective date 01/01/2017 to 12/31/2017
2018 HSA plan with Effective date 01/01/2018 to 12/31/2018
1]Increases tier in parent plan like EE, EE+SP, EE+SP+Ch, In the same year 2017
2]Increased tier in parent plan like EE, EE+SP, EE+SP+Ch, In the year 2017 and 2018
3]Decreased tier in parent plan like EE, EE+SP, EE+SP+Ch, In the same year 2017
4]Decreased tier in parent plan like EE, EE+SP, EE+SP+Ch, In the year 2017 and 2018
Scenario #3
Parent plan1 effective from 01/01/2017 to12/31/2017
Parent plan 2 Effective from 01/01/2018 to12/31/2018
HSA plan with Effective date 01/01/2017 to NULL
1]Increases tier in a parent1 plan like EE, EE+SP, EE+SP+Ch, In the same year 2017
2]Increased tier in the parent2 plan like EE, EE+SP, EE+SP+Ch, In the year 2018
3]Decreased tier in parent plan like EE, EE+SP, EE+SP+Ch, In the same year 2017
4]Decreased tier in parent plan like EE, EE+SP, EE+SP+Ch, In the year 2018
Scenario #4
Enroll now screen, confirmation statement for current and future enrollment
working fine as expected.
Hi Kira Hamilton,
No records found during today's scanning.
Thanks and Regards,
:: Umesh Kadam
CC : Satya, Gaurav Sodani, Amruta Lohiya, Jyoti Mayne
Hi Kira Hamilton,
We didn't found any record(s) during scanning on yesterday (12/19/2017) and today (12/20/2017)
Thanks and Regards,
:: Umesh Kadam
CC : Satya, Gaurav Sodani, Amruta Lohiya, Jyoti Mayne
Hi All,
This ticket has been approved for stage deployment on 12/21/17.
Regards
Gaurav
Hi Kira Hamilton,
In today's scan, we found 1 EE 'Salil Joshi' and corrected his ER coverage and cost.
Cc: Amruta Lohiya
Verified in Stage Environment consider below scenarios:
Scenario #1
Parent plan with ongoing election 1/1/2016 to NULL.
HSA plan with Effective date 01/01/2017 to NULL
1]Increases tier in parent plan like EE, EE+SP, EE+SP+Ch, In the same year 2017
2]Increased tier in parent plan like EE, EE+SP, EE+SP+Ch, In the year 2017 and 2018
3]Decreased tier in parent plan like EE, EE+SP, EE+SP+Ch, In the same year 2017
4]Decreased tier in parent plan like EE, EE+SP, EE+SP+Ch, In the year 2017 and 2018
Scenario #2
Parent plan with ongoing election 1/1/2016 to NULL.
2017 HSA plan with Effective date 01/01/2017 to 12/31/2017
2018 HSA plan with Effective date 01/01/2018 to 12/31/2018
1]Increases tier in parent plan like EE, EE+SP, EE+SP+Ch, In the same year 2017
2]Increased tier in parent plan like EE, EE+SP, EE+SP+Ch, In the year 2017 and 2018
3]Decreased tier in parent plan like EE, EE+SP, EE+SP+Ch, In the same year 2017
4]Decreased tier in parent plan like EE, EE+SP, EE+SP+Ch, In the year 2017 and 2018
Scenario #3
Parent plan1 effective from 01/01/2017 to12/31/2017
Parent plan 2 Effective from 01/01/2018 to12/31/2018
HSA plan with Effective date 01/01/2017 to NULL
1]Increases tier in a parent1 plan like EE, EE+SP, EE+SP+Ch, In the same year 2017
2]Increased tier in the parent2 plan like EE, EE+SP, EE+SP+Ch, In the year 2018
3]Decreased tier in parent plan like EE, EE+SP, EE+SP+Ch, In the same year 2017
4]Decreased tier in parent plan like EE, EE+SP, EE+SP+Ch, In the year 2018
Scenario #4
Enroll now screen, confirmation statement for current and future enrollment
working fine as expected.
Hi Jyoti Mayne,
Per the client Salil Joshi record is still not correct. Employee attached should have the Health Savings Account 2017 plan from 12/1 to 12/31 with a yearly employer contribution amount of $2,000, system is showing $2500.00 on enroll now screen but $500.00 on Confirm.
Please see attached print screens.
Thank you,
Kira Hamilton
Debbie Kulling
Hi Kira Hamilton,
EE 'Salil Joshi' having election in 'Cigna CDHP' health plan with 12/1/17 to 12/31/2017 with EE+SP+2CH. So he is eligible for $500 ER contribution as election is in last quarter. Total ER contribution is 2000. If health plan election falls under last quarter, EE will get 2000/4 = $500.
Once code fix will get deployed on production 12/29, system will show proper ER coverage on Enroll Now screen.
Cc: Amruta Lohiya
Hi Kira Hamilton,
No record found during today's scanning.
Verified in Production Environment consider below scenarios:
Scenario #1
Parent plan with ongoing election 1/1/2016 to NULL.
HSA plan with Effective date 01/01/2017 to NULL
1]Increases tier in parent plan like EE, EE+SP, EE+SP+Ch, In the same year 2017
2]Increased tier in parent plan like EE, EE+SP, EE+SP+Ch, In the year 2017 and 2018
3]Decreased tier in parent plan like EE, EE+SP, EE+SP+Ch, In the same year 2017
4]Decreased tier in parent plan like EE, EE+SP, EE+SP+Ch, In the year 2017 and 2018
Scenario #2
Parent plan with ongoing election 1/1/2016 to NULL.
2017 HSA plan with Effective date 01/01/2017 to 12/31/2017
2018 HSA plan with Effective date 01/01/2018 to 12/31/2018
1]Increases tier in parent plan like EE, EE+SP, EE+SP+Ch, In the same year 2017
2]Increased tier in parent plan like EE, EE+SP, EE+SP+Ch, In the year 2017 and 2018
3]Decreased tier in parent plan like EE, EE+SP, EE+SP+Ch, In the same year 2017
4]Decreased tier in parent plan like EE, EE+SP, EE+SP+Ch, In the year 2017 and 2018
Scenario #3
Parent plan1 effective from 01/01/2017 to12/31/2017
Parent plan 2 Effective from 01/01/2018 to12/31/2018
HSA plan with Effective date 01/01/2017 to NULL
1]Increases tier in a parent1 plan like EE, EE+SP, EE+SP+Ch, In the same year 2017
2]Increased tier in the parent2 plan like EE, EE+SP, EE+SP+Ch, In the year 2018
3]Decreased tier in parent plan like EE, EE+SP, EE+SP+Ch, In the same year 2017
4]Decreased tier in parent plan like EE, EE+SP, EE+SP+Ch, In the year 2018
Scenario #4
Enroll now screen, confirmation statement for current and future enrollment
working fine as expected.
This is deployed and verified in the Production environment.
Kindly check and update Jira accordingly.
Thanks,
Rashmita
Hi All,
Attaching the production deployment approval email for reference
Regards
Gaurav
Hi Kira Hamilton,
We scanned all EE and none of them having duplicate ER coverage. As code fix is deployed on production, there is no need to do scanning further.
Hello Kira,
Plan Customization:
Amount $4000 is shown because: on plan customization Is Prorate Employer Contribution is selected as Yes therefore the amount shown is the addition of previous ER coverage and the new ER coverage.
Also,
No Employee cost is not shown because: on plan customization Consider previous paid coverage in cost calculation is selected as Yes since this takes previous coverage into consideration and for which the rate has ended on 10/31/2017 therefore the cost is not shown.
(Please confirm with AE is this intentionally done for some purpose)
Plan Customization changes needed:
1) Is Prorate Employer Contribution is selected as No
2) Consider previous paid coverage in cost calculation is selected as No
Please find new enrollment tried on HSPL Copy:
Thanks,
S Prashant.
---------------------------------------------------------------------------------------
Kira Hamilton Satya Rajendra Pawar Avnish Yadav