Multiple Rate Tables in Benefit Plan

I am trying to figure out how to get the employee contribution to calculate both the employee supplemental life and the dependent supplemental life. 

Can I have two rate tables under employee contributions in the benefit set up tab.  

i have both rate tables set up

  • 0

    Hi Blythe,

    Unfortunately you can only use a single rate table in the tab. Yeah, I know it would be great if you could do iif statements or math with the values from different rate tables. In the actual rate table itself, the rate value can be an iif statement so that can help with a more complex calculation. Kind of a weird workaround, but you can also put one rate table in the other amount and another in the coverage. That way the employee contribution could be OtherAmount+Coverage.

  • 0

    Blythe,

    You should be able to add a rate table to the Dependent Premium tab to calculate the amount for the dependent. So you would have the EE contribution calculating on the EE premium tab, the dependent portion calculating on the dependent premium tab, and in the contribution tab you can enter the expression be.b_epremium + be.b_dpremium. This will add both premiums together.

    If the dependent premium is based on the dependent age then make sure you set the option "Premium Amount Represents" is set to "premium for Each Individual Dependent". If you font then HRMS will calculate off of the age of the first dependent listed in the dependents and beneficiaries page.

    If the dependent premium tab is already being used for something else then you can use the dependent coverage tab on the benefit setup. By default this tab is grayed out but can be activated by following the steps below.

    Go to Setup > Employees > Insurance Benefits, select the plan in question, click on the coverage amount tab and change the option "Coverage Amount is For"  to Employee Only. This will activate the tab labeled Dependent Coverage