Application should send email notification when List is Reviewed, Approved and Published.

[zmeenakshi]

Email notification enhancements: (Database): 1) Added below configurations required for the email notification enhancement in the table REF_CONFIGURATION_CODELIST: 1a) SMTP Server codelist : SMTP_SERVER (CODELIST_CONFIGURATION_TYPE) 1b) Sender email codelist: SENDER_CONFIG (CODELIST_CONFIGURATION_TYPE 1c) For notification messages codelist: EMAIL_NOTIFICATION_MSG (CODELIST_CONFIGURATION_TYPE) 1d) Admin email address codelist: USER_EMAIL_ADDRESS (CODELIST_CONFIGURATION_TYPE)

(Application): 1) Add the email notification configurations to the Administration module drop-down. SMTP_SERVER as "SMTP Server Configuration" SENDER_CONFIG as "Sender Configuration" EMAIL_NOTIFICATION_MSG as "Email notification messages" USER_EMAIL_ADDRESS as "User email address"

2) The email notification enhancements should cover the Create, Update Copy and Publish Current modules. 3) The notification should be sent to the List's Designees and the System Administrator. Note: The Administrator email will come from the configuration codelist, while Designees' email address will be fetched from Active Directory (PXED). (Confirm with SGS about the Designees part).

4) Notification should be sent when; 4a) The list is set to ‘Reviewed’ and the notification message should be "< List Name > < Extension > < WORLKFLOW_ST1 > to the List designees. One List is set to Reviewed at a time from the Confirm form by clicking the Review button. Email Subject: ** Message: List has been REVIEWED and is ready for approval. Per SRM01-GSOP-RF03, if Clinical has authored and hence ‘reviewed’ the list, Safety should ‘approve’ the list, or vice versa.".

4b) The list is set to ‘Approved’ and the notification message should be "< List Name > < Extension > < WORLKFLOW_ST2 > to the List designees. One List is Approved at a time from the Confirm form by clicking Approve the button. ** Message: List has been APPROVED and is ready for publishing.".

4c) The list is set to ‘Published’ and the notification message should be "< List Name > < Extension > < WORLKFLOW_ST3 > to the List designees. Multiple Lists can be published together from Promote to Publish by clicking the Promote button. ** Message: List is now ACTIVE/PUBLISHED.

Note: < List Name > < Extension > should be replaced with the actual list name (CMQ_NAME) and list extension (CMQ_TYPE_CD) in the notification message.

[zmeenakshi]

Changes Requested: => The notification should be sent ONLY for TME Lists. => Change email subject to => The notification message for Reviewed has hyperlink " [CAETeLiSt] (https://caetelist.pfizer.com/cqt/index.xhtml?faces-redirect=true) " which cannot be added in the database (codelist). => Meenakshi to insert codelist for Email Subject: EMAIL_CODELIST and update the length of CODELIST_VALUE column to 4000 characters in table REF_CONFIG_CODELIST.