Thursday, November 13, 2014

Email Addresses in PeopleSoft

PeopleSoft stores email addresses in following tables
  1. PSOPRDEFN
  2. PS_ROLEXLATOPR
  3. PSUSEREMAIL
  4. PS_EMAIL_ADDRESES
First three are used in email notifications and it depends on the application. It is best to update all of these tables when testing a notification process so you don't spam the whole company just in case something goes south.