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.
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).
In the Input Values window, create the following input values, being careful to enter the names exactly as shown:
Coverage (Character)
Select US_BENEFIT_COVERAGE as the Lookup and select the appropriate value (such as Employee only) as the Default.
ER Contr (Money)
EE Contr (Money)
In the Benefit Contributions window, select the appropriate coverage levels and default contribution amounts.
See: Establishing Health Care Plan Coverage and Default Contributions
In the Element window, create a nonrecurring ER Liability shadow element for indirect results.
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 =============================*/ |
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.
In the Formula Results region, select the new formula result (ER_Contr) and create the following result rule:
Type: Indirect Result
Element: the ER Liability element you created in step 4
Input Value: Pay Value
Link the benefit plan element. Also link the ER Liability element if you want to establish costing.