Please note - this is in stage

HI Jennifer Melgoza

Is this rate issue or View history server error?
Can you please confirm?

Thanks,
Swapnil P.

There are all 3 issues occuring

Hi Prasanna Karlekar,
Please refer the screenshot, system shows sever error on stage for enrollment details in employee view history. Could you please check this? Thanks.

Hi Jennifer Melgoza,
Could you please let me know the plan and rate name? Thanks.

Hi Vikas,

Please give the fix for View History issue.

cc: Saurabh Sablaka

Hi Prasanna,
3C's for this issues are as follows

Concern Act Report and View History was not working
Cause OES_UDF_GetDescriptionForWaivedEnrollment UDF was missing on stage.
Correction OES_UDF_GetDescriptionForWaivedEnrollment UDF is added on stage.

Mandar Kulkarni I provided you the people, it will show you what rates they are supposed to get. the rates are right in the system but not for those people.

Hi Amruta Lohiya,

Could you please check for the cause of below two points(2 & 3) :

2. Confirmation statements having incorrect future effective dates, some dates are 2/1/2016 or 2/1/2017 2/29/2016

• I have checked the future enrollment summary shows the current year dates and are displaying in current as well as in future enrolments : EE - Joseph

3. Rates for ee 5% of salary and also retirees over or under any years of service (please see exampled names in the ticket) or not showing accurately per the rates in the system.

• Employee is not getting the correct rate, checked for EE - Glenn Anderson.

Hi Jennifer Melgoza, This is now fixed.
1. Server errors when looking at view history or checking confirmation statements.

Mandar Kulkarni or Amruta Lohiya can we have a call this AM?

need a call Satya swapnil says he is till busy.

the attached spreadsheet of rates that are correct and rates that are wrong.

I also explained that
ACTIVE rate - is 5% of the employees salary + rate in the system for more than ee tier
RETIREES are just the rates in the system and they are not working for some of the retirees
We also added EE+3 tiers in the system on Friday ALL 2017 rates need to be recalculated.

Hi Jennifer Melgoza

I have emailed Mandar for below things. Please add if anything is missing on it :
Below are things needs to be done :
1. Rate recalculation. Below given are incorrect rates. It seems they never got correct rates.
2. Not able to fetch enrollment report correctly.
3. Their OE is starting 10/17. But they are currently testing in stage for OE.

Thanks,
Swapnil P.

Hi Swapnil Pandhare,

Please provide below details:
1. Rate recalculation. Below given are incorrect rates. It seems they never got correct rates.

• Please provide exact plan and Rate name

2. Not able to fetch enrollment report correctly.

• Please provide employee names, we verified with few sample employees and it seems to be correct.

-------------------------------------------
CC: Vijay Siddha, Samir

2017 COBRA EIA Health PPO 80/60 01/01/2017 - 12/31/2017 [Health] 1 Plan Mapped

2017 EIA HEALTH PPO 80/60 ACTIVE 01/01/2017 - 12/31/2017 [Health] 1 Plan Mapped

2017 Retiree Over 25+ Yrs of Serv. 01/01/2017 - 12/31/2017 [Health] 1 Plan Mapped

2017 Retiree Over 65 16-20 Yrs of Serv. 01/01/2017 - 12/31/2017 [Health] 1 Plan Mapped

2017 RETIREE OVER 65 21-24 YR.SERV. 01/01/2017 - 12/31/2017 [Health] 1 Plan Mapped

2017 RETIREE PPO OVER 65 10-15 YR. SERV. 01/01/2017 - 12/31/2017 [Health] 1 Plan

2017 Retiree PPO Under 21- 24 Yrs of Srv 01/01/2017 - 12/31/2017 [Health] 1 Plan Mapped

2017 Retiree PPO Under 25+ Yrs of Serv 01/01/2017 - 12/31/2017 [Health] 1 Plan Mapped

2017 Retiree PPO Under 65 10-15 Years of Service 01/01/2017 - 12/31/2017 [Health] 1 Plan Mapped

2017 Retiree PPO Under 65 16-20 years of service 01/01/2017 - 12/31/2017 [Health]

Mandar Kulkarni I have just attached the rates. I will next send you the correct rates for those who have incorrect rates currently in the system. Per our phone call today - we have added updated tiers for the rates.

Hi Jennifer Melgoza,
It seems the spreadsheet you attached is password protected. Could you please share the password via email? request you to please copy Avnish Yadav too ( avnish.yadav@harbingergroup.com ) in the email, since he will be working on this now.

-----------------------------------------
CC: Avnish Yadav, Amruta Lohiya

Mandar Kulkarni workterra123

Avnish Yadav do yo have any questions? do you need to discuss?

Hi Jennifer Melgoza,

We have investigated this issue at our end and please refer attached excel sheet for Employee rates calculation.
Employees_Rates_Calcualtion.xls

Thanks,
Avnish Y

CC-Amruta Lohiya,Rohan J Khandave,Vishal Bajad,Satya

Hi Jennifer Melgoza,

As per our discussion on call we have recalculated below rates on stage:-

1. 2017 RETIREE PPO OVER 65 10-15 YR. SERV.
2. 2016 EIA HEALTH PPO 80/60 ACTIVE
3. 2017 EIA HEALTH PPO 80/60 ACTIVE

Please verify same at your end and let us know in case of any issue/concern.

Thanks,
Avnish Y