Question

2
Replies
611
Views
Close popover
Taw Sern Tan (TawSernTan)
M1 Ltd

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

Sent SMS

Hi,

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.

Regards.

***Edited by Moderator: Pallavi to update platform capability tags***

Pega Marketing Case Management Data Integration
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.