Configuring Components for Health Care Benefit Plans (Basic Benefits)

If you want to enter coverage levels and default employee and employer contribution amounts in the Benefit Contributions window for health care benefit plans, you must complete a number of additional setup steps.

These steps apply to elements in the benefits classifications Medical, Dental, and Vision.

arrow icon   To configure generated components for health care benefit plans:

  1. Query the element in the Element window and set your effective date to the element's start date (that is, the date you used to define or initiate the element).

  2. In the Input Values window, create the following input values, being careful to enter the names exactly as shown:

    See: Defining an Element's Input Values

  3. In the Benefit Contributions window, select the appropriate coverage levels and default contribution amounts.

    See: Establishing Health Care Plan Coverage and Default Contributions

  4. In the Element window, create a nonrecurring ER Liability shadow element for indirect results.

  5. In the Formula window, modify the generated Oracle Payroll formula for the pre-tax deduction as shown in the following table:

    In the section . . . Replace this text . . . With this text . . .
    INPUT VALUES DEFAULTs Default for Amount is 0 Default for EE_Contr is 0 Default for ER_Contr is 0
    INPUTS SECTION INPUTS are Amount, Period_Type(text) INPUTS are EE_Contr, ER_Contr, Period_Type (text)
    Main formula body THEN (IF Amount WAS DEFAULTED AND /* NOT Flat Amount */ Percentage WAS DEFAULTED THEN /* NOT Percent either! */ THEN (IF EE_Contr WAS DEFAULTED AND /* NOT Flat Amount */ Percentage WAS DEFAULTED THEN /* NOT Percent either! */
      dedn_amt = Amount * deduction_freq_factor IF Period_Type = UPPER('Calendar Month') AND (dedn_amt + AMY_MED_PRETAX_ASG_GRE_MONTH - Amount ) <= .02 AND (AMY_MED_PRETAX_ASG_GRE_MONTH + dedn_amt) > Amount THEN dedn_amt = Amount - AMY_MED_PRETAX_ASG_GRE_MONTH)ELSE /* Percentage calculation */( dedn_amt = EE_Contr * deduction_freq_factor IF Period_Type = UPPER('Calendar Month') AND (dedn_amt + AMY_MED_PRETAX_ASG_GRE_MONTH - EE_Contr ) <= .02 AND (AMY_MED_PRETAX_ASG_GRE_MONTH + dedn_amt) > EE_Contr THEN dedn_amt = EE_Contr - AMY_MED_PRETAX_ASG_GRE_MONTH) ELSE /* Percentage calculation */(
      ,to_within/*========================= End Program =============================*/ ,to_within, ER_Contr /*============= ============ End Program =============================*/

    See: Writing or Editing a Formula

  6. In the Formula Result Rules window, select the benefit plan element and choose the Find button. Click on the processing rule that was generated from the Deductions window.

  7. In the Formula Results region, select the new formula result (ER_Contr) and create the following result rule:

    See: Defining Formula Processing and Result Rules

  8. Link the benefit plan element. Also link the ER Liability element if you want to establish costing.