Posted: 25 Mar 2019 0:02 EDT Last activity: 1 Apr 2019 3:13 EDT
I understand that for outgoing SMS/emails, they are stored in the staging tables: pr_data_corr_sms and pr_data_corr_email respectively. Upon successful sending of the sms/emails, the records will be deleted the above tables, and there is no way for us to confirm that if the actual SMS/emails has been sent out (at least reached the SMSC or SMTP Server).
I am thinking of writing a trigger to output these transaction to another table so that user can verify the transaction there. Looking through the components created by Pega, I found that there is a table: pg_data.pr_History_Data_Corr_SMS, but there are no data in this table. May I know under what circumstances will this table be populated, and/or housekept? What about a corresponding table for emails?
Hope to hear advises from the expert here soon.
***Edited by Moderator: Pallavi to update platform capability tags***