RateTable configuration

The RateTable configuration defines settings for the rate tables that Infor Public Sector uses to calculate charges in Billing and CDR.

The root RateTable node can have up to twelve children. Other than the PROCESSINGRULES and ROUNDING nodes, all of these nodes have the same structure, with one or more Source nodes as children:

  • ASSESSMENTBASED
  • BUILDINGPERMITS
  • CODEENFORCEMENT
  • LICENSE
  • ONEOFFCHARGE
  • PLANNING
  • PROCESSINGRULES
  • PROJECT
  • ROUNDING
  • SERVICEBASED
  • TRADELICENSE
  • USEPERMITS

Each Source node defines one of the options that are showed in the Most Common Sources grid when you define a rate table detail. Each of these sources defines a node in the rate structure that you’re building based on a selected business object property.

You can add source nodes to the RateTable configuration to make additional properties available in the Most Common Sources grid, but only certain business objects are supported.

A Source node can have these attributes:

Attribute Description
Display Name Display name for the source. This is the name that is displayed in the Most Common Sources grid.
Description Description of the source.
Node Source Business object property that the source is based on.
Moniker Moniker of the business object that the node source is based on.
Note: The business objects that are supported for rate table details depend on the parent node that you selected. For example, each source under the BUILDINGPERMITS node must specify a property of the Hansen.CDR.Building.BuildingApplication object.

Sources under the SERVICEBASED node can use properties of the Hansen.Billing.Account or Hansen.Billing.AccountService object.

The PROCESSINGRULES node indicates how Infor Public Sector will process a rate table when a branch has multiple nodes for different meter sizes. See the Rate Table help for more information. This node has these attributes:

Attribute Description
Garbage Rate Processing Mode Indicates whether rate table details for garbage fields are processed when the value of a garbage field is 0. Specify one of these options:
  • All: Rate details for garbage fields are always processed, including if the value is 0.
  • ProcessOnlyNonZeroQuantity: Rate details for garbage fields are processed only when the value is greater than 0.

Rate table details are normally skipped if the source value is zero, but there might be cases where a garbage service must be billed after the garbage field changes from a positive value to 0 during a billing period. This setting ensure that those services are billed correctly.
Meter Size Processing Mode Indicates how Infor Public Sector will process details that are based on the Water Meter Size property. You can specify one of these options:
  • None: The consumption for all meters is added together and then run through each meter size node.
  • Average: The entire consumption for all meters is run through each meter size node. Infor Public Sector then takes the average of the results.
  • Split: Consumption for each meter is run through the node for its meter size only.
  • Highest: The entire consumption for all meters is run through the node for the largest meter size.
  • Lowest: The entire consumption for all meters is run through the node for the smallest meter size.

The ROUNDING node defines rounding and truncating options for consumption-based and stepped rate tables. By default, Infor Public Sector calculates intermediate values (that is, consumption values and stepped rate values) to four decimal places. Using the ROUNDING node, you also have the option of rounding or truncating consumption values to the nearest integer value, such as whole gallons; and you can round or truncate step values to the nearest dollar or cent.

The ROUNDING node has these attributes:

Attribute Description
Converted UOM Indicates how Infor Public Sector will round or truncate intermediate consumption values. Can be set to one of these values:
  • None: No rounding or truncating.
  • Round: Round consumption values to the nearest integer. For example, 10.8675 gallons will be rounded to 11 gallons.
  • Truncate: Truncate consumption values to integers. For example, 10.8675 gallons will be truncated to 10 gallons.
Detail Node Indicates how Infor Public Sector will round or truncate rate table detail nodes. Can be set to one of these values:
  • None: No rounding or truncating.
  • RoundToCent: Round step values to the nearest cent. For example, $3.2675 will be rounded to $3.2700. (The last two digits are placeholders.)
  • RoundToDollar: Round step values to the nearest dollar.
  • TruncateToCent: Truncate step values to two decimal places. For example, $3.2675 will be truncated to $3.2600. (The last two digits are placeholders.)
  • TruncateToDollar: Truncate step values to the dollar amount.
Steps Indicates how Infor Public Sector will round or truncate intermediate step values. Can be set to one of these values:
  • None: No rounding or truncating.
  • RoundToCent: Round step values to the nearest cent. For example, $3.2675 will be rounded to $3.2700. (The last two digits are placeholders.)
  • RoundToDollar: Round step values to the nearest dollar.
  • TruncateToCent: Truncate step values to two decimal places. For example, $3.2675 will be truncated to $3.2600. (The last two digits are placeholders.)
  • TruncateToDollar: Truncate step values to the dollar amount.