Maintain Rate Table

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.

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. (Display Only)

Effective To Date

The date until which the rate table will be in effect. (Display Only)

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.

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.

Employee Status

From the drop-down list box select the status of the employee. The drop-down list box contains “Current”, “Separated” and “All”.

Employee Benefit Category

From the drop-down list box select the employee benefit category for which rate is applicable. The drop-down list box contains “Highly Compensated Employee” and “Non Highly Compensated Employee”.

Union Affiliation

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 union names defined in the general masters component of HRMS and interact with the Benefit General Masters component.

Benefit Group

From the drop-down list box select the benefit group code for which the rate is applicable. The drop-down list box contains all the benefit groups defined in the “Create Benefit Group” activity in the "Benefit Definition" component.

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 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

Annual Salary From

The start range of the annual salary for which the particular rate is applicable.

Annual Salary To

The maximum range, beyond which the rate is not applicable.

Coverage From

The start range of the coverage rate for which the particular rate is applicable.

Coverage To

The maximum range, beyond which the rate is not applicable

Rate / Amount

From the drop-down list box select the option as rate or amount.

  • When the option is selected as “Rate” then specify only the Rate per 1000 USD in the respective columns.

  • When the option is selected as “Amount” then specify only the Amount of contribution in the respective columns.

Employee Rate per 1000 USD

Indicates the employee rate per 1000 USD based on the coverage level.

Employer Rate per 1000 USD

Based on the coverage level the employer rate per 1000 USD gets varied.

Employee contribution

The amount to be paid by the employee.

Employer contribution

The amount to be paid by the employer.

Applicable to Org. Units

Select the applicable organization unit for which the rate table is applicable.

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

Modification Option

Use the drop-down list box to specify the modification option. The combo is loaded with “Select”, “Correct” and “Update”. The system by default displays “Select” on launch of the page.

  • Correct: The modified details are saved with the current date.

  • Update: The modified details are updated with the new effective date.

New Effective From

The new effective date of updated records.

To Proceed