Example of finding a factor with a range parameter in a rate table

This example is similar to Example of finding a factor in a rate table. However, this example defines salary with a range matching rule rather than a greater than or equal matching rule.

A range parameter for salary appears as two columns in the rate table and has a priority for each column. The two arguments of the range parameter are Min (>=) and Max (<=). The Min (>=) argument is priority 10, the Max (<=) argument is priority 20. PolicyCenter relaxes the range parameter as a single unit.

In PolicyCenter, the rate table has Min (>=), Max (<=), and * Factor columns.The following table has additional Row and Description columns.

Row #	Jurisdiction (exact)	Min (>=)	Max (<=)	* Factor	Description
1				1.00	Matches any salary when both the salary range parameter and Jurisdiction are relaxed. This factor is the default factor.
2	NY			1.25	Matches any salary in New York when the salary range parameter is relaxed.
3	CA	0	30,000	1.25	Matches any salary in California when the amount is between $0 and $30,000.
4	CA	30,001	50,000	1.50	Matches any salary in California when the amount is between $30,001 and $50,000.
5	CA	50,001	80,000	1.75	Matches any salary in California when the amount is between $50,001 and $80,000.
6	CA	80,001		2.00	Matches any salary in California of $80,001 or greater.

A person in California who has a $35,000 salary falls between Min (>=) and Max (<=) in row 4 and gets a 1.50 factor. A person in California who has a $90,000 salary matches row 6 and gets a 2.00 factor. A person in New York who has a $50,000 salary does not match any row. Row 2 matches when salary, Min (>=) and Max (<=), is relaxed. A person in Florida who has a $35,000 matches row 1 after both salary and Jurisdiction are relaxed.

Performance considerations

The data in the previous table can also be represented using a less than or equal match (<= ). However, the range match is more efficient than the <= match. When looking up [CA, 15,000] with range parameters, row 3 is the only row that matches the range. With the <= parameter, the lookup matches rows 3 through 6, eventually returning row 3 as the best match.

Row #	Jurisdiction (exact)	Salary (<=)	* Factor
1			1.00
2	NY		1.25
3	CA	30,000	1.25
4	CA	50,000	1.50
5	CA	80,000	1.75
6	CA		2.00