When you create a rate schedule, you must enter a code defining the frequency in which the charges are expressed, e.g., monthly, quarterly, biannual, etc. To set up frequency codes, open
.Description of Page
Enter a unique Frequency ID and Description for each frequency.
Before entering the remaining fields, you must analyze the 'proration provisions' in your rates. For example, consider a rate used to calculate a tax exemption that is typically granted for bi-annual periods. Assume this rate's amount will not be prorated when the taxpayer qualifies for the exemption between 20 and 160 days. This rate requires a frequency that indicates:
2 Periods / Year (because it's a bi-annual rate).
Offset for Minimum Days equal to 16 0.
Offset for Maximum Days equal to -20 .
When the system creates a bill using a rate with this frequency, it compares the number of days that the taxpayer qualified for the exemption to the minimum and maximum number of days inferred by the rate's frequency. In the example above, the minimum number of days would be 20 (365 days / 2 period per year - 160 offset for minimum days). The maximum number of days would be 163 (365 days / 2 periods per year + (-20) offset for maximum days). Therefore, if a taxpayer qualifies for the exemption for less than 20 days or more than 163 days, the exemption's value is prorated. In this case, prorating the exemption will give the taxpayer some of the benefit while not prorating will either give the taxpayer no exemption or the full exemption value.
Overriding the system's standard proration logic. If the standard proration logic does not satisfy your requirements, you may plug in an override proration algorithm to calculate the proration factors as required by your implementation. For example, we have encountered companies who treat a year as having 360 days rather than 365 days. Such a company would need to develop an override proration algorithm and plug it on the Installation record.
Where Used
Every Rate Schedule must have a frequency. Refer to Rate Schedule - Main for more information.
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.