The Provider Coverage Rate Field (PROV_COVRG_RATE) was Removed From the Rate Table for HRMS Versions 9.x (Doc ID 779657.1)

Last updated on JUNE 08, 2023

Applies to:

Goal

Per Release HRMS 9.x Upgrade documentation, all benefit rate data is consolidated into a single common structure. The individual Age-Graded, Flat, Salary-Percent and Service tables will be dropped, and all rate data migrated to the new Benefit Rate Tables.

This refers to AGE_COVG_TBL, FLAT_RATE_TBL, SALARY_RATE_TBL and AGE_RATE_TBL are being replaced by BN_RATE_TBL and BN_RATE_DATA.

A viable replacement for the PROV_COVRG_RATE field in HRMS 9.x is requested.

This field is used to establish the total amount that is paid to an insurance provider including the administration fees.

For example:  Employee Amount: 50% Employer Amount: 50% Provider Amount: 99%

In this example, the total deduction amount (Non-Taxable Benefit and Before-Tax) is not paid to the provider. The difference (in this example 1%) is kept by the employer as an internal administration fee.

Solution

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