Hi Jaideep Vinchurkar,

Salary of EE 'Helen Manzano' updated/increased on 10/17/2017, due to which election got terminated with 12/31/2017.
But it seems that import was failed on 10/17/2017 hence new election effective from 01/01/2018 was not get allocated to EE as per salary change.
Could you check this from import side?

Thanks,
Shailendra Honrao

Cc: Jyoti Mayne

Hello Shailendra Honrao and Jaideep Vinchurkar,

Please provide an update. The client would like these terminations to be reinstated a.s.a.p., before the next payroll file is generated. Please note that management has been alerted on this item.

Thank you.

Amber

Hello Alex Nguyen & Amber Love-Jones,

We are working on finding affected Employees and their Enrollments. We will share list with you once all data scanning is done.

Thanks,
Vinanti

CC : Jyoti Mayne, Rohan Dhamorikar

Thank you Vinanti Yadav,

We had an EDI discussion on this issue and may be caused by age band or the salary didn't load all the way through. Just wanted to point that out, because the two example employees affected share the same age around 56 yrs old. Another example is John Maxson, who is close to that age and coverage also terminated after the salary loaded.

Alex

Hello Vinanti Yadav,

Will scanning be done for all facilities, or just CHMC?

Also, please advise when the affected employees under CHMC will be updated. Client is urgently asking for an ETA.

Thank you.

Amber

Alex Nguyen, Jyoti Mayne, Rohan Dhamorikar

Hi Amber Love-Jones,

Their next payroll file is due next week 1/25/18. If we need to re-enroll them manually we might have to go in that direction. Running the change/term report from 10/17/17-10/18/17 should help with the manual process. It doesn't seem like the age band is the cause of it, because I tried it a day ago by opening a qualifying event as suggested by the team to see if the same plan is available for the employees. The plans are still available for them to select.

It might have been the load didn't go all the way through. I'm not sure. Or may have timed out at some point during the load. Prime Healthcare and some facilities file load are known to take a long while to process especially there's so many records. Hopefully the enrollments can be reinstated in the backend.

Alex

Hello Alex Nguyen,

If these employees need to be re-enrolled, please let me know. I can either do them all, or if there's hundreds of them, I can see if I can get CT to assist. These employees need to be updated before the next payroll file is sent to CHMC - Kelly Kyle from that facility was on our weekly call this week to express her displeasure and has involved upper management at Prime.

Thank you!

Alex

Hi Alex Nguyen,

Below is our analysis for the root cause:
Enrollments have "Coverage" which tell about the members and coverage amount of that enrollment. During the Eligibility routine (Salary Change routine to be specific) after the Import on 10/17/2017, coverage was inserted in wrong format for Employee : JOSEPH GARCIA.

In Salary change Routine, Enrollments with coverage based on old salary are terminated and new enrollments with coverage based on new enrollments are inserted. This is a step by step process. Due to the wrong coverage as mentioned above for an Employee, a batch of employee had failure in completing the Salary change routine. So old enrollments were terminated but process stopped before inserting new ones.

So, the employees from that batch including the examples given by you have terminated enrollments.

Hi Amber Love-Jones,

We have scanned all employes on CHMC only, as salary import was failed on this company for few EEs.

PFA list of impacted employees CHMC Affected EE List.xlsx. We have corrected data on CHMC for HSPL on production. We have given access rights of this HSPL company to username 'alove' and 'AlexNg'.

As there are around 291 employees, we request you to go through coverage listed in attached sheet for confirmation.

After your approval, we will do same correction on live company on Monday 1/22 IST.

Password will be share in separate mail.

Cc: Alex Nguyen, Satya, Rohan J Khandave, Jyoti Mayne

Thank you Suraj Sokasane and Jyoti Mayne for the detail explanation. We will also have client review and confirm, before giving the approval for the update.

Alex

Hello Jyoti Mayne,

Based on the attachment, please make all corrections for CHMC by Monday 1/22.

Thank you.

Amber

Alex Nguyen, Satya, Rohan J Khandave

Thank you Amber Love-Jones for completing the review. Jyoti Mayne and Suraj Sokasane how can we avoid this from happening again in the future? We want to prepare for it the next time another salary load is requested.

Alex

Hi Amber Love-Jones and Alex Nguyen,

We have done mentioned corrections on live company.

Cc: Rohan J Khandave

Hi Alex Nguyen,

Answering to your question "how can we avoid this from happening again in the future?"
This is called as "Back-end Routine failure" after Import. We monitor this under WT-13017 on daily basis. Additionally, we get an email whenever back-end routine fails. So we do the corrections if required and re-execute the routines.

Thank you Suraj Sokasane for taking care of the issue. I will make note it.

Alex

Thank you all for helping to resolve this.

Amber

Hello,

Please look at confirmation statement for ee Helen Manzano. There are no Employee costs showing for the Optional Life Plan. Was this something that should have been updated in WorkTerra along with the updates Dev made for the other 290 entries? Please see screenshot attached.

Please advise a.s.a.p.

Thank you.

Amber

Hello,

Just discovered that the employee actually waived the Voluntary Life benefit; this is separate from the STD and LTD benefits that she was to remain enrolled in that were taken care of previously on this ticket.

My apologies.

Amber