Notification Config system table

This topic describes the NotificationConfig system table provided in the base configuration of PolicyCenter. PolicyCenter uses this table to return a notification lead time for the following events:

  • Renewal process
  • Nonrenewal by insurer
  • Cancellation effective date

See also

Lead time in NotificationConfig system table

The NotificationPlugin plugin retrieves the lead time from the NotificationConfig system table. The following table describes the columns in the NotificationConfig system table.

Column

Description

EffectiveDate

Required. Date the row becomes effective. The row is effective on or after this date.

ExpirationDate

Date the row expires. The row is effective until the end of the day prior to this date. If omitted, the row is effective indefinitely.

LeadTime

Required. Lead time in days.

ActionType

Type of action to which this row applies. Click Search to display the ActionType ­(NotificationActionType) dialog box where you can select a value from the NotificationActionType typelist.

The NotificationActionType typelist can also specify the NotificationCategory that each action type belongs to. If the Category column in the NotificationConfig system table is null, the getMaximumLeadTime method uses the NotificationCategory.

Category

Category of action to which this row applies. The action is a value from the NotificationCategory typelist. For example, if the value is Renewal, this row applies to any type of renewal.

Jurisdiction

Value from the Jurisdiction typelist representing the jurisdiction in which this row applies.

LineOfBusiness

String matching the pattern code of the line of business to which this row applies.

PremiumIncreaseThreshold

Not used in lead time calculation.

RateIncreaseThreshold

Not used in lead time calculation.

Wildcards that match any value are supported for ActionType, Category, Jurisdiction, and LineOfBusiness. If the value is null, a row matches all inputs for the column. Because this situation can lead to multiple matches for any particular combination of criteria, an order of precedence determines which row is returned.

The order of precedence for determining rows that match is as follows (listing highest precedence first). The priority of the columns is Jurisdiction, LineOfBusiness, and Category. The ActionType column is not used. However, if the Category column is null, the plugin checks the value of NotificationCategory on the ActionType column.

For more information on the Notification plugin, see Notification plugin.

Precedence example

This example shows precedence during a renewal job. The same precedence rules apply to cancellation.

Consider the following hypothetical rows from the NotificationConfig table. The rows are sorted from highest to lowest priority. An asterisk (*) indicates a wildcard that matches any value.

Lead time

Jurisdiction

Line of

business

Action type

Category

1

CA

BOP

Material Change Renewal

Renewal

2

CA

BOP

Other Renewal

*

3

CA

BOP

*

Renewal

4

CA

BOP

*

*

5

CA

*

Material Change Renewal

Renewal

6

CA

*

Other Renewal

*

7

CA

*

*

Renewal

8

CA

*

*

*

9

*

BOP

Material Change Renewal

Renewal

10

*

BOP

Other Renewal

*

11

*

BOP

*

Renewal

12

*

BOP

*

*

13

*

*

Material Change Renewal

Renewal

14

*

*

Other Renewal

*

15

*

*

*

Renewal

16

*

*

*

*

The PolicyRenewalPlugin plugin calls the getMaximumLeadTime method that takes a NotificationCategory. The input parameters are:

Parameter

Value

LineOfBusiness

WorkersCompLine

Jurisdiction

California [CA]

Category

Renewal [renewal]

The ActionType column is ignored. The filter matches eight different rows: the ones with lead times 5 through 8 and 13 through 16. Of these values, two rows tie for most specific: 5 and 7. Because the PolicyRenewalPlugin plugin requested the maximum lead time, the plugin method returns 7.

Action type and notification category example

This example shows precedence when the action type uses the notification category in a renewal job. The same precedence rules apply to cancellation.

In the NotificationActionType typelist, each action type can also specify the NotificationCategory that the action type belongs to. If the Category column is null, then the getMaximumLeadTime method uses the NotificationCategory on ActionType.

The input parameters are:

Parameter

Value

LineOfBusiness

WorkersCompLine

Jurisdiction

California [CA]

Category

Renewal [renewal]

The row with lead time 2 matches because the NotificationCategory is renewal. The row with lead time 1 is not a match because the NotificationCategory is cancel.

Lead time

Jurisdiction

Line of

business

Action type

Category

1

CA

*

Other Cancellation

  NotificationCategory = cancel

*

2

CA

*

Other Renewal

  NotificationCategory = renewal

*