Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Setup Request: Benefit premium multiplied by percentage depending on EEs salary range
Summary
Looking for setup to fulfill requirement of monthly premiums being multipled by a percentage based on the employees salary range. Please see below example.Content
| Health Plan | Premium Amount |
| Single | 740 |
| Employee & Spouse | 1480 |
| Family | 2116 |
| Parent & Child | 1376 |
| Salary Range | |
| less than $25,000 | 4% |
| 25 - 29,999.99 | 5% |
| 30 - 34,999.99 | 6% |
| 35 - 39,999.99 | 7% |
| 40 - 44.999.99 | 8% |
Example: Employee enrolled in Employee + Spouse that makes $42,000/year = 1480* 8% = $118.40
Question: I know we will have to do the below, but how do we get the premium to multiply by the percentage amount (8%) based on the salary range?
- Derived Factor based on Salary ranges
- Eligibility profiles based on Salary Ranges
- Variable rate for each salary range using calculation method multiple of compensation
Tagged:
0