You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Alert Composer Token source

edited Jan 15, 2025 3:27PM in Recruiting, Opportunity Marketplace 2 comments

Summary:

Hi Team,

Is that possible to figure out what is the database table that stores the tokens used in the alert composer "Notify offer team, start date has been changed for candidate" - IRC_ChangeStartDate_Internal_External?

We found out that the data comes from seed data source at hcm/irc/db/data/HcmRecruitingTop/HcmRecruitingHiring/HcmRecHiringOffersCore/AlertsSD.xml.

And the XML is stored alerts_run table under parameters column. We have the data there.


However, to extract that, we would need to do a bit of SQL manipulation so were are wondering if those ${JobOfferStartDate} and ${JobOfferNewStartDate} tokens are saved somewhere else in the database.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!