Parameters tab of Rate Table Definition screen
In the Rate Table Definition screen, use the Parameters tab to maintain the parameter columns in the table definition. This tab contains a list of defined parameters at the top of the screen and a Details pane to display the details for the selected parameter in the list.
For more information on making changes to parameters, see Changes to parameters in rate table definitions.
Matching rules
On the Parameters tab of a rate table definition, the Matching Rule for a parameter specifies how to compare a policy value to the parameter value in the rate table. In the default implementation, PolicyCenter includes the following matching rules:
- Exact Match – The policy value must match the parameter value exactly. For example, the coverage code or vehicle make must match exactly.
- Range Match with Excluded Max – The policy value must be greater than or equal to the minimum value in the range and less than the maximum value in the range. This rule is useful for ranges such as limits. For example, assume the ranges are 1 to 1,000,000 and 1,000,000 to 2,000,000. You do not have to specify 999,999.99 as a max value.
- Range Match with Included Max – The policy value must be greater than or equal to the minimum value in the range and less than or equal to the maximum value. Use this rule for ranges without any overlap, such as 16 to 25, 26 to 40, and 41 to 50.
- Longest Substring Match – Matches the parameter value which is the longest initial substring of the policy value.
- Greater Than Or Equal Match – The policy value must be greater than or equal to the parameter value. If multiple matches exist, the closest parameter value matches. For example, a rate table has rows for values 1 through 10. The policy value 5.5 is greater than or equal to rows 1 through 5. Therefore, row 5 matches.
- Greater Than Match – The policy value must be greater than the parameter value.
- Less Than Or Equal Match – The policy value must be less than or equal to the parameter value. If the policy value matches multiple parameter values, the closest parameter value matches. For example, a rate table has rows for parameter values 1 through 10. The policy value 5.5 is less than or equal to rows 6 through 10. Therefore, row 6 matches.
- Less Than Match – The policy value must be less than the parameter value.
- Interpolation - with Relax –
If the policy value matches the parameter value exactly, return the factor.
If the policy value falls between two parameters values, then the interpolated
factor is proportionally between the two factors.
Interpolation with relaxing allows the bounds to be found at different levels of relaxation.
- Interpolation
- no Relax – If the policy value matches the parameter
value exactly, return the factor. If the policy value falls between two
parameters values, then the interpolated factor is proportionally between
the two factors.
Interpolation without relaxing requires that both bounds for the input parameter be found at the same level of relaxation.
For more information, see:
Parameter Details fields
The fields on the Parameter Details pane vary based on the parameter’s matching rule.
For Exact Match, Greater Than Or Equal Match, and Less Than Or Equal Match parameters, the screen displays one set of the parameter details fields.
For Range Match with Included Max or Range Match with Excluded Max parameters, the screen displays three sets of parameter fields. One defines the range (Matching Rule, Code, and Data Type). The second defines the minimum value (Priority through Value Provider). The third defines the max value (Priority through Value Provider).
The following table describes the fields on the Parameters tab.
Field |
Description |
|---|---|
Matching Rule |
Set to the Matching Rule selected as part of the Add action. For a description of the matching rules, see Parameters tab of Rate Table Definition screen. |
Code |
The name used to identify the parameter input value in rating queries. The name is required, and all parameter names must be unique within a rate table definition. PolicyCenter does not make certain that this name is unique across parameters and factors. However, Guidewire recommends that you define unique names across the whole rate table definition. |
Label |
The label that appears as the column header in the Rate Table Editor and is exported to Excel files. This field is localizable so an entry field appears for each locale defined in the environment. A label for the default locale is required. |
Data Type |
A drop-down list of the data types in the physical table and supported by the Matching Rule. If the Physical Table is DefaultRateFactorRow, the Exact Match choices are: String, Integer, Decimal, Boolean, and Date. The Range choices are: Integer, Decimal, and Date. |
Decimal Places |
The number of decimal places that the user can enter when entering decimal parameters. This field applies to both values of a range parameter. This field only appears for the Decimal data type. |
Priority |
A numeric priority that controls the display order of the columns on this screen, in the Rate Table Editor and in exported Excel files. The rate table displays the parameters from left to right in descending priority order. Lower numbers have higher priority, so that column 0 is higher priority than 10. Priority affects how factors in a rate table match. For more information, see Matching a factor in the rate table. |
Column Code |
A name for the (logical) column. This field is visible only for range parameters. For other parameters, the value is not visible but is set to the same value as Code. |
Column Label |
The label that appears as the column header in the Rate Table Editor and is exported to Excel files. This field is localizable so an entry field appears for each locale defined in the environment. A label for the default locale is required. This field is visible only for range parameters. For other parameters, the value is not visible but is set to the same value as Label. |
Display Type |
A drop-down list to describe the width of the column for the Rate Table Editor. In the default implementation the choices are: Small, Normal, and Large. |
Physical Column |
The physical table
column to map this logical column to. This is a drop-down list whose
values depend upon the Physical Table defined on the Basics tab and the Data Type defined on this
tab. The generic physical table has the following column choices: 8 string columns, 8 integer columns, 6 decimal columns, 2 date columns, and 2 boolean columns. The custom
|
Value Provider |
Drop-down list of available value providers. Select one of the choices for Arguments, described in the following row. You can add custom value providers. See Configuring value providers for more information. |
Allow Multiple Values |
Select Yes to allow multiple values in rate table content for this parameter. This field is selectable if all of the following are true:
For more information, see Rate table definition. |
Arguments |
These are arguments to the value provider. For Typelist Value Provider, the Arguments are the list of typelists defined in PolicyCenter. For the other value provide types, the default implementation does not include any validation on this field, but you can configure it if required. The the custom value providers in the default implementation take the following arguments:
|
Depends On |
Defines a dependency from one column of a rate table to another. This dependency forces the target rate table column to perform post-on-change in the Rate Table Editor. For example, if one rate table column stores coverage terms, it has to do one of the following:
A parameter cannot depend upon a parameter that allows multiple values. |
