Hi Debbie Kulling,

As discussed in call, following are the action items for us

1. Change the effective date of given 13 rates to 01/01/2018
2. Re-Calculate given rates after changing their effective date
3. Make sure if costs are populating correctly for self insured component(s)
4. Provide details of Classes mapped with given rates

Thanks and Regards,
:: Umesh Kadam

CC : Satya, Gaurav Sodani, Amruta Lohiya, Jaideep Vinchurkar, Prasanna Karlekar, Jyoti Mayne, Snehal Shabade, Abhilash Warkari, Rashmita Dudhe

Hi Prasanna Karlekar,

As discussed, we have updated effective dates of given rates and also recalculate them (i.e. #1 and #2) in HSPL copy. Please verify on billing reports and also make sure costs populating correctly for self insured components.

Thanks and Regards,
:: Umesh Kadam

CC : Amruta Lohiya, Abhilash Warkari, Snehal Shabade

Do you think that I will get the query today?

Hi Debbie Kulling,

After enrollment team's correction on HSPL copy, we verified Billing Report.
We observed that, the component costs are appearing 0 for some records.

Following is the scenario:
Employee does election with EE + SP + CH tier and gets Health Tier ID equivalent to this combination.
On Rate matrics, EE + SP + CH tier is not defined, but EE + Family tier is defined.

Following happens while executing Billing Report:
EE and ER cost will appear correctly. As, EE and ER cost data that report displays is readily available. But while fetching the component cost, we check, if Heath Tier ID stored against an enrollment is there in Rate Matircs or not. If the Health Tier is present in RateMatrics and the component is billable, we show the component cost else we show 0.
In our scenario, enrollment is having HealthTierID for EE + SP + CH and RateMatrics is having component cost defined for EE + Family tier. As we are unable to find EE + SP + CH tier defined in Rates Matrics, 0 cost is appearing for components on Billing Report.

Code fix will be required, so that cost will appear on Billing Report for this scenario.

Please note that, corrections will be done by enrollment team on main company tomorrow i.e. 22-Dec-2017.
We will also check, if we can have some workaround so that component cost appears on Billing Report in this scenario. If we cannot find a work around, then for now, 0 component cost will be displayed for all records having this scenario.

We will update you accordingly tomorrow.

Thank you!

cc: Umesh Kadam, Amruta Lohiya, [~parmeshwar.jumbade], Gaurav Sodani

When will this be done on the production copy. I really need to provide the report to the client today

Hi Debbie Kulling,

As discussed over call, we have prepared query to get all classes mapped to given rates.

Please find more details in attached document Rate_Details.xls.

Thanks and Regards,
:: Umesh Kadam

CC : Satya. Gaurav Sodani. Amruta Lohiya, Prasanna Karlekar

Can we please have a call this morning before you leave

Hi Debbie Kulling,

As discussed over call, we have updated effective dates of given rates and also recalculate them (i.e. #1 and #2) on LIVE copy in PRODUCTION. Please check and verify.

As discussed, Prasanna Karlekar will help you regarding wrong cost populating for self insured component.

Thanks and Regards,
:: Umesh Kadam

CC : Satya. Gaurav Sodani. Amruta Lohiya, Prasanna Karlekar, Snehal Shabade, Abhilash Warkari

Hi Debbie Kulling,

As discussed over call, please find attached document Rate_Details.xls for details of classes mapped with rates. I have updated same document and re-uploaded it. Please check and confirm.

Thanks and Regards,
:: Umesh Kadam

CC : Satya. Gaurav Sodani. Amruta Lohiya, Prasanna Karlekar, Snehal Shabade, Abhilash Warkari

Sorry one more incorrect effective date. Please change to 1/1/2018

2018 ANTHEM PPO 30TZ - SC04/01/2018 - 12/31/2018

Hi Debbie Kulling,

We have changed effective date of "2018 ANTHEM PPO 30TZ - SC" rate from 04/01/2018 to 01/01/2018 and also recalculated the same. Please check and confirm.

Thanks and Regards,
:: Umesh Kadam

CC : Satya. Gaurav Sodani. Amruta Lohiya, Prasanna Karlekar, Snehal Shabade, Abhilash Warkari

Hi Debbie Kulling,

We tried for a work around to get the component cost on Billing Report but could not find a way.
Permanent fix is required to bring the component cost on billing report for mentioned scenario. For this we need development approval so that analysis and code fix can be done.

Thank you!

cc: [~parmeshwar.jumbade], Gaurav Sodani

I really need to be able to pull the self insured components. Is there any way to run a query to get the self insured components out for each employee. I will need

SSN
Employee Name
Club
Plan Name
Coverage tier
Self insured components
Total Cost

I need this asap

Hi Debbie Kulling,

We are working on this.
You can expect an update on this by tomorrow 4-Jan-2018.

Thank you!

cc: Gaurav Sodani

Hi Debbie Kulling,

We have done some script changes only on California Golf company to make the billing report with Self Insured Component workable for equivalent health tier scenario. As this is a temporary fix and not a permanent fix, we have tried our best to verify the data at our end. You can refer, report named "HSPL - Self Insured Components" configured under Standard reports. It is configured with fields that you have mentioned for Medical, Dental and Vision Benefit types for Jan 2018.
Please note that:
-Total Amount field on report is sum of EE and ER cost and not the component cost.
-Billing period polices are only applied on EE and ER cost indirectly on total amount. They are not applied on Self Insured Component cost.
-At times Total amount and component cost may vary, if component is configured incorrectly or billing policy is getting applied while calculating the total amount.

It would have been helpful, if this was development approved ticket. We would have got dedicated time to fix the issue and get it QA verified.

Kindly verify the data at your end once. Do let us know in case of issue.

Thank you!

cc: Gaurav Sodani

Thank you that report worked! What do I need to do to get a permanent fix done.

Hi Debbie Kulling,

Thank you for responding back.
For permanent fix, different bug ticket needs to be created, which needs to be discussed with Nagini and Jennifer Reed for approval. Only then, it can be scheduled and worked upon.

Thank you!

cc: Gaurav Sodani