6.2 Configuring the Exemption Expiry

The Exemption Expiry parameter specifies the Exemption expiration period. Values for these column should be set in number of days.

Table 6-2 Configuring Exemption Expiry Attributes

Attribute	Description	Column Name
INTIATE_RECERTIFY_PRD	This attribute specifies number of days to start Initiate receritification process before expiration date of Exemption. This is given in terms of number of days. This attribute value accepts only natural numbers.	attr_1_value_tx
RECERTIFICANTION_NOT_REQ UIRED_CATEGORY	This attribute specifies the categories that do not require yearly recertification. The values mentioned should be separated with comma (,). (For Example:P1BANK,P1GOV)

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

To update the Exemption Expiry parameter to 365 days, execute the following query:

UPDATE kdd_install_param t
SET t.param_value_tx = '365' WHERE t.param_id = 103

To update the INTIATE_RECERTIFY_PRD attribute to 65 days, execute the following query:

UPDATE kdd_install_param t 
SET t.attr_1_value_tx = '65' WHERE t.param_id = 103