AAI_USER_PREFERENCE Table

In this table, you can set the user preference for receiving the notification emails.

Email Notification User Preference

Table 13-1 Email Notification User Preference

V_USER_ID	N_EMAIL_NOTIF_REQ
USER1	1
USER2	2

• 0 – To receive no notification emails
• 1 – To get mails instantly
• 2 – To get bulk mail (Additionally, you need to set V_BULK_MAIL_TRIGGER value to Y in the AAI_WF_BULK_MAIL_TRIGGER table). A single mail is sent with all the pending notifications from the last trigger, as a PDF attachment. After the bulk mail is sent, the V_BULK_MAIL_TRIGGER value is automatically set to N.
• 3 – To get mail with attachment