Flat Amount Rate For EE Based On Age & Salary (rounded To The Nearest 25,000 Of Salary) (Doc ID 2491425.1)

Last updated on SEPTEMBER 09, 2020

Applies to:

Goal

Flat Amount Rate for EE based on Age & Salary (rounded to the nearest 25,000 of Salary)

Requirement:

Employees Monthly Premium Flat Amount Rate is determined by their Age and Salary Rounded to the Nearest $25,000.
Employees Spouse Monthly Premium Flat Amount rate is determined by the Spouses Age and 50% of the Employees Salary which is rounded to the nearest $25,000.

Example:

-If Employees age is 30-34 and their rounded salary to the nearest 25,000 is $50,000 annually, the monthly flat amount rate is $4.50.

-If the Spouse of the Employees age is 30-34 and 50% of the rounded salary to the nearest 25,000 is $25,000 annually (50% of 50,000 is $25,000), the monthly flat amount rate is $2.25.

-Please see attached for Screen shot of two above Examples.

Notes:

-I understand to capture the age, we will make derived factors and eligibility profiles.

Question:

-How will we assign a flat amount rate based on age AND rounded salary to the nearest $25,000?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.