-
Type:
Support Activity
-
Status: Closed
-
Priority:
High
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
Support Task Type:Data Correction
-
Reported by:Client
-
Company:University of Notre Dame
-
Module:BenAdmin - Enrollment
The CI when approved gets a code, but the HRA and HRB do not.
Their system requires a QE code for every change. HRA and HRB plans are not going over with a QE code. As per a meeting with Damion and Jenni, this is made in to a WT ticket for Development to find a solution to.
I would like Devp to tell me if the following could be a quick fix.
Devp to update HRA and HRB enrollments in the database to inherit the QE code from their parent medical enrollments. Once done, EDI will be able to pull the QE code from HRA and HRB enrollments.
In the long run, we could have the auto enroll benefits to ALWAYS inherit QE from their parent enrollments on which they are contingent.
| Field | Original Value | New Value |
|---|---|---|
| Link | This issue causes CT-931 [ CT-931 ] |
| Priority | Medium [ 3 ] | High [ 2 ] |
Hello Again,
This is also for UND: if the team can also look on how to achieve QE codes for the HRA benefits. From EDI perspective we dont get a code because the plan is contingent on a Medical plan. The QE is based off of the Medical Plan ONLY. UND would like to see QE codes on these benefits in relation to the elected Medical benefit.
Thankyou
| Assignee | Vijay Siddha [ vijays ] | Vinayak Kulkarni [ vinayak.kulkarni ] |
| Module | Parent values: BenAdmin(10100) | Parent values: BenAdmin(10100)Level 1 values: Export(10110) |
Hi Damion,
We need to work with Enrollment team to achieve this, I remember that we have worked on this in past to get QE codes on banner payroll file and at that time we had revised logic for contingent benefits to get codes on file. However that seems to be not working correctly and we will check this and get back to you.
Jyoti Mayne Can we check this, HRA benefits is not getting code on file because it is contingent on Medical and medical requires admin approval. When admin approves medical then HRA is getting added into system, instead it should have added already along with Medical with pending status.
Recent example :Tyler O'hara (empid: 901882086)
Also, Can we make data correction as mentioned by Abhay for below plans to get codes from their parent medical enrollment if they are added into system with Review change approval mode
2017 Health Reimbursement Account - Employee - After to 7/1
2017 Health Reimbursement Account - Employee - Prior to 7/1
2017 Health Reimbursement Account - Family - After to 7/1
2017 Health Reimbursement Account - Family - Prior to 7/1
Let us know if you have any questions on this. Thanks.
| Module | Parent values: BenAdmin(10100)Level 1 values: Export(10110) | Parent values: BenAdmin(10100)Level 1 values: Enrollment(10107) |
| Assignee | Vinayak Kulkarni [ vinayak.kulkarni ] | Jyoti Mayne [ jyoti.mayne ] |
| Remaining Estimate | 24h [ 86400 ] | |
| Original Estimate | 24h [ 86400 ] |
| Remaining Estimate | 24h [ 86400 ] | 22h [ 79200 ] |
| Time Spent | 2h [ 7200 ] | |
| Worklog Id | 24907 [ 24907 ] |
Vijay Siddha (Inactive)
made changes -
| Environment | Production [ 10005 ] | |
| Issue Type | Change Request [ 10002 ] | Support Activity [ 10301 ] |
| Status | New Request [ 10029 ] | Open [ 1 ] |
| Support Task Type | Data Correction [ 11203 ] | |
| Workflow | WT_Features [ 32027 ] | WT_Support [ 32630 ] |
| Assignee | Jyoti Mayne [ jyoti.mayne ] | Umesh Kadam [ umesh.kadam ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
We are working on this, will keep you updated about its status.
Thanks and Regards,
:: Umesh Kadam
CC : Jyoti Mayne
-
- Time Spent:
- 3h
-
Analysis
Scenario discussion with Jyoti
Code Debugging to find root cause of an issue
| Attachment | WT_8282_Affected_Employee_List.xls [ 39922 ] |
Please find below 3Cs,
| Concern | HRA and HRB plans are not going over with a QE code |
| Cause | HRA plan is force contingent on Medical plan. For 2017 HRA plan, "Enrolled In" macro is added in eligibility. For "Enrolled In" macro case only, system is not adding child plan election (i.e.HRA) with parent plan (i.e.Medical) QE mode. |
| Correction | We have fixed code for this and changes are at database level. We deployed this fix on UND main company at Stage and Production. |
Note: We have scanned all employees for HRA and HRB plans and found 14 employees affected who were missing code. We have corrected their data and our testing for them is in progress. Please find attached list for the same WT_8282_Affected_Employee_List.xls
. Please confirm.
Thanks and Regards,
:: Umesh Kadam
CC : Vijay Siddha, Satya, Jaideep Vinchurkar, Vinayak Kulkarni, Jyoti Mayne, Aniruddha Dev
| Remaining Estimate | 22h [ 79200 ] | 21h [ 75600 ] |
| Time Spent | 2h [ 7200 ] | 3h [ 10800 ] |
| Worklog Id | 25658 [ 25658 ] |
| Remaining Estimate | 21h [ 75600 ] | 12h [ 43200 ] |
| Time Spent | 3h [ 10800 ] | 12h [ 43200 ] |
| Worklog Id | 25672 [ 25672 ] |
-
- Time Spent:
- 3.5h
-
code debug,scenario discussion with Umesh, data correction review and verification
-
- Time Spent:
- 9h
-
Analysis of an issue
Debugging code to find root cause of an issue
Discussion with Amruta, Jyoti, Vinayak, Girija and Avnish
Data correction
Shared details with Client
A record for HRB passed in last night production file and had a QE CODE!!!!Joseph Gaboury haqd a Qualifying event and received an 07 in the file. Once your testing is final please let us know and we can close out the ticket
Thanks Umesh.
| Remaining Estimate | 12h [ 43200 ] | 8.5h [ 30600 ] |
| Time Spent | 12h [ 43200 ] | 15.5h [ 55800 ] |
| Worklog Id | 25704 [ 25704 ] |
Hi Aniruddha Dev,
We have corrected data for affected employees yesterday and also did unit testing for them. Please test the some scenario(s) related to enrollments and their impact on File and share your details.
Thanks and Regards,
:: Umesh Kadam
CC : Vijay Siddha, Satya, Jaideep Vinchurkar, Vinayak Kulkarni, Jyoti Mayne
| Assignee | Umesh Kadam [ umesh.kadam ] | Aniruddha Dev [ aniruddha.dev ] |
Verified the affected employees along with New Hire Enrollment and Qualifying Event scenarios on QE Illusion Banner HRA 2017 file. QE codes are populating correctly on export file.
We have corrected affected employees data and verified those on QE Illusion Banner HRA 2017 file. Can you please check this at your end and close the JIRA if resolved ?
Please let us know in case of any queries/issues.
CC: Abhay Patil Hrishikesh Deshpande Vinayak Kulkarni
Thanks & Regards,
Aniruddha Dev
| Assignee | Aniruddha Dev [ aniruddha.dev ] | Damion Velasquez [ damion.velasquez ] |
| Remaining Estimate | 8.5h [ 30600 ] | 6h [ 21600 ] |
| Time Spent | 15.5h [ 55800 ] | 18h [ 64800 ] |
| Worklog Id | 25806 [ 25806 ] |
Aniruddha Dev
I cloned the template that passes these benefits, and set to Full File. The list of Employees that you mentioned are getting the proper codes. There are 3 not getting a code but this is expected as the Event Name is Open Enrollment. This event does not have a code and should be NULL>
Thank you
CC Deborah MascotAbhay PatilCindy WibbingHrishikesh DeshpandeVinayak Kulkarni
| Resolution | Done [ 10000 ] | |
| Status | In Progress [ 3 ] | Resolved [ 5 ] |
| Status | Resolved [ 5 ] | Closed [ 6 ] |
| Resolution | Done [ 10000 ] | |
| Status | Closed [ 6 ] | Reopened [ 4 ] |
| Assignee | Damion Velasquez [ damion.velasquez ] | Vinayak Kulkarni [ vinayak.kulkarni ] |
| Assignee | Vinayak Kulkarni [ vinayak.kulkarni ] | Damion Velasquez [ damion.velasquez ] |
| Resolution | Done [ 10000 ] | |
| Status | Reopened [ 4 ] | Resolved [ 5 ] |
| Status | Resolved [ 5 ] | Closed [ 6 ] |
| Resolution | Done [ 10000 ] | |
| Status | Closed [ 6 ] | Reopened [ 4 ] |
| Assignee | Damion Velasquez [ damion.velasquez ] | Umesh Kadam [ umesh.kadam ] |
| Status | Reopened [ 4 ] | In Progress [ 3 ] |
| Assignee | Umesh Kadam [ umesh.kadam ] | Damion Velasquez [ damion.velasquez ] |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Resolved [ 5 ] |
| Remaining Estimate | 6h [ 21600 ] | 3h [ 10800 ] |
| Time Spent | 18h [ 64800 ] | 21h [ 75600 ] |
| Worklog Id | 26224 [ 26224 ] |
| Status | Resolved [ 5 ] | Closed [ 6 ] |
| Transition | Time In Source Status | Execution Times |
|---|
Vijay Siddha (Inactive)
made transition
-
|
11d 17h 56m | 1 |
|
2h 44m | 1 |
|
3h 25m | 1 |
|
3d 5h 26m | 2 |
|
2s | 1 |
|
2d 7h 9m | 2 |
|
2m 10s | 3 |
CC Vinayak Kulkarni, Amit Thorve Damion M Velasquez Jennifer Johnson