Creating a rate table

Create rate table

Select the "Create rate table" link from the left pane.
The "Create Rate Table" page appears.
The system displays the following fields.

Date Format	The date that is applicable to the login user.
	If the user does not define the date format, the system will display the date format applicable to the Organization Unit; this date format is predefined in the “Enterprise Modeller Company Definitions”
Benefits General Info Unit	The benefit general information unit for which rate table is to be created. If there is more than one value the system will display all the organization units in which the Benefits General Information component has been deployed and interacts with the login organization unit.

From the drop-down list box select the organization unit for which details of the rate table must be created. The drop-down list box displays
Enter the following fields.

Rate Table Code	A unique code to identify a rate table.
Rate table Short Description	A brief description to identify the rate table.
Rate table Description	The full description of the rate table.
	For example, if you have identified the rate table code as “RA002”, you can enter “Rttbl” as the short description and “Rate table” as the long description.
Currency	From the drop-down list box select the currency in which the premium rates are computed. The drop-down list box displays list all the currencies defined CCUR component of financials and select.
Frequency	From the drop-down list box select the frequency for which the rate table is created. The drop-down list box contains the following values viz. "Daily", "Weekly", "Biweekly", "Semimonthly", "Monthly", "Quarterly", "Semiannually", and “annually". One among them must be selected.
Effective From Date	The date from which the rate table will be in effect.
Effective To Date	The date until which the rate table will be in effect.
Country	By default, the system will display all the countries defined in the CCUR Component of financials. Select the country for which the rate table is applicable.
State	From the drop-down list box select the state for which the rate table is applicable. The drop-down list box will display all the states defined for the specified country.

Enter the following values in the multiline.

Priority	A number to indicate the sequence in which the variables must be considered in computing the rated for employer or employee’s contribution. Example, 1, 2, 3,4.
	Entering the priority is applicable when you intend to enter more than one factor in determining rates for employer or employee’s contribution towards the premium amount. If you do not enter the priority, the system will take the sequence in which the variables are specified.
Age From	The start of the range of the age for which the particular rate is applicable.
Age To	The maximum range, beyond which the rate is not applicable
Service Month From	The start of the range of the service month for which the particular rate is applicable. Service months are the number of months the employee has worked in the organization. For example, six months, eight months, etc.
Service Month To	The maximum range, beyond which the rate is not applicable
Gender	By default the drop-down list box will display with a blank value. From the drop-down list box select the gender (Male /Female) for which the rate is applicable.
Union Affiliation code	From the drop-down list box select the union code for which the rate table is applicable. The drop-down list box contains list all the unions names defined in the general masters component of HRMS and interact with the Benefit General Masters component.
Benefit Group	Enter the benefit group code for which the rate is applicable.
Coverage Level	From the drop-down list box select the coverage category for which rate is applicable. The drop-down list box contains all the coverage categories defined in the "Create Coverage Category" activity.
Coverage Amount From	The start range of the coverage amount for which the particular rate is applicable.
Coverage Amount To	The maximum range, beyond which the rate is not applicable
Employee Contribution Non smoker	The amount to be paid by the employee if he is a non-smoker.
Employee Contribution smoker	The amount to be paid by the employee if he is a smoker.
Employer Contribution Non smoker	The amount to be paid by the employer if the employee is non-smoker.
Employer Contribution smoker	The amount to be paid by the employer if the employee is smoker.

Mapping to Org. Units:

From the drop-down list box select the value

Applicable to Org. Units	Select one of the three options available in the drop-down list box: “All Org. Units”, “Login Org. Units” or “Selective Org. Units”. If you select
	“All Org. Units”, the rate table record will be made available to all organizational units of the group company.
	“Login Org. Units”, the rate table record will be mapped to the organizational unit to which the login user is attached.
	“Selective Org. Units”, the rate table record will be available only to specific organizational units.

Note: The actual mapping of the rate table record to the organizational units is carried out in a separate page called “Map Org. Units”.

Enter your comments, opinions, etc. in the “Comments” field.
Select the “Save” pushbutton to create the new rate table.
As you select the pushbutton, the system saves all the details and displays the sum of the contributions made by the employee and the employer either in the “Total Contribution Smoker” or “Total Contribution Non- Smoker” columns of the multiline.

What you can do in this page

You can use this page to create a rate table.