Rate Overview

Rates are uploaded into the Oracle Insurance Policy Administration (OIPA) system using excel spreadsheets that populate the rate tables in the database.  In order to upload rates, a rate group that describes the rates must first be created.  A rate group bands rates together according to their designated purpose and provides a means of describing and retrieving rates.  Usually rates are created for a specific plan.  

Once a rate group is created, the actual rates may be uploaded as aggregate, select or you may enter rates manually.  The rates needed for uploading are usually provided in an Excel spreadsheet by the business, client or party responsible for supplying rate information for a plan.

The two rate tables that are populated are AsRateGroup and AsRate.