6.8 Configuring Notifications

This parameter specifies the list of attributes used in the display of Notifications. The attributes include the number of days to be used to identify near due CTR, the number of days until the notification is displayed on the UI, and the number of days when the notifications will be purged.

The following table describes the attributes which must be configured for Notification parameter.

Table 6-4 ConfiguringAttributes for Notification Parameters

Attribute	Description	Column Name
CTR_NEAR_DUE_DATE	This attribute specifies number of days before the due date of CTR that a notification of Near due date category should be generated. This attribute value accepts only natural numbers.	attr_1_value_tx
UI_DISPLAY_DAYS	This attribute specifies number of days for which a notification continues to be displayed on the UI once it is triggered. If no particular action is taken on the notification, once this value is exceeded the notification will no longer be displayed. This attribute value accepts only natural numbers.	attr_2_value_tx
EXM_NEAR_DUE_DATE	This attribute specifies number of days before the expiry date of Exemption that a notification of Near due date category should be generated. This attribute value accepts only natural numbers.	attr_3_value_tx
PURGE_NOTIFICATION	This attribute specifies number of days after which the notification will be purged. PURGE_NOTIFICATION should be set greater than the UI_Display_Days value. This attribute value accepts only natural numbers.	attr_4_value_tx

To modify the Notification parameter or its attribute, an update query must be executed in the MANTAS Schema of the Database with an appropriate user.

To update the Notification parameter to Y, execute the following query:

UPDATE kdd_install_param t SET t.param_value_tx = 'Y' WHERE t.param_id = 101

To update the CTR_NEAR_DUE_DATE attribute to 5 days, execute the following query:

UPDATE kdd_install_param t SET t.attr_1_value_tx = '5' WHERE t.param_id = 101