Rate Tables

Price components are comprised of one or more rate tables that define how and when a charge, discount, grant, refund, or forfeiture is applied during rating.

Rate tables combine a decision table with one or more rating formulas to determine the rating to use for a particular set of normalized values.

Rate tables include the following information:
  • A decision table associated with one or more rating formulas that define the impacts to the balance. For rate tables that have different conditions that must be valid at the time of rating for the rating formula to apply, the associated decision table must contain one or more normalizers and a separate row for each set of parameter values.
  • What is being measured to determine the rate: usage quantity (applies to usage price components), balance quantity, MATRIXX Data Container (MDC) field quantity, charge quantity, or event quantity. This is the scale basis for the rate table and the values depend on the type and the application (usage, recurring, purchase, first-use, cancel) of the price component that contains the rate table.
  • For discounts, what the rate applies to: the original charge amount or the remaining charge amount.
  • For rates based on usage quantity, the beat at which to apply the rate.
  • An optional default formula, that gets added to each row in the rate table automatically so you do not need to enter it manually. This is useful if you have multiple rates that use the same formula.
  • For charges, whether the credit limit can be exceeded.
  • The balance that gets impacted during rating and the measurement unit of the impact, such as megabytes or bytes.
  • Optional metadata added to the rate table.
  • An optional default data modify profile that defines a list of data modify actions for manipulating MDC fields during the lifetime of the rating event. After performing the data modify actions listed in the profile, MATRIXX applies the selected formula or performs a SKIP.
  • Optional filters to allow percentage discount components from a catalog item within a purchase package to apply to charges in other specific catalog items in the same purchase package. For more information, see the discussion about purchase package discount filters in MATRIXX Pricing and Rating.
Although one rate table can impact only one balance, one event can impact multiple balances. Therefore, a set of rate tables determine the rates to apply. For example, one rating formula might define an impact to a free minutes balance and another rating formula might define an impact to a currency balance. Each rating formula is specified in a separate rate table.
Note: There is a size limit of 65535 rows for rate tables. This limit also applies to decision tables, policy tables, and normalizers.