Close popover
Taw Sern Tan (TawSernTan)
M1 Ltd

M1 Ltd
TawSernTan Member since 2015 40 posts
M1 Ltd
Posted: March 25, 2019
Last activity: April 1, 2019

Sent SMS


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***

Pega Marketing Case Management Data Integration
Moderation Team has archived post