Question

2
Replies
573
Views
TawSernTan Member since 2015 40 posts
M1 Ltd
Posted: 1 year ago
Last activity: 1 year 5 months ago
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
Share this page LinkedIn