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