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

Alerts using Per_Periods_of_Service

Summary:

Can Alerts reference fields from the Per_Periods_of_Service table?

Content (required):

We need to automate an email that is sent to new hires after 90 days from their date of hire. Comparing the Per_Person.Start_Date with the Sysdate is not working as it's picking up a person's earlier pending worker record. i.e. the Alert run on 28-Sep returned two employees. One whose actual hire date is 28-Jun but also a pending worker record that was created on 28-Sep but whose hire date is 11-Jul. As the employment category is automatically created by the Taleo interface I cannot this to filter out the pending worker record.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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