Matching a factor in the rate table

After finding the most appropriate rate table, the rating query determines the most suitable factor in the rate table and returns the factor to the rating engine.

The query takes a list of input values, corresponding to the parameters relevant to the rate table. The query compares the input values to the rate table rows to determine the best match. The query returns the value of the matching row.

In PolicyCenter, the rate table displays the parameters in columns from left to right; relaxing parameters proceeds from right to left. The query looks for a complete match. In a complete match, all parameters must have a matching value. If found, the query returns the factor from the matching row. If not, the query matching requirements are relaxed by removing the rightmost parameter from the matching criteria. The query matches a row in which the rightmost parameter is blank and all other parameters match. The relaxing of parameters continues until a match is found or all parameters have been relaxed.