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

How do I timestamp the states of applicants as they move through the recruiting process?

Accepted answer
edited Apr 26, 2021 9:45PM in Reporting and Analytics for HCM 7 comments


Hello all,

I'd like to create a report that timestamps the movement of candidates as they move through the recruiting process. Ideally, the report would look something like this:

Submission_ID Phase State Candidate Name State Event Date
1 NEW Resume Review Bob 2/20/21
1 NEW Hiring Manager Review Bob 2/21/21
1 INTERVIEW First Interview Bob 3/1/21
1 INTERVIEW Rejected Bob 3/6/21


The primary issue is where timestamped data lives. I've used the IRC_LC_HISTORY, IRC_ROUTING_STEPS_B, IRC_STEP_TRANSITIONS_B, and a few other variations to find the timestamped data. I can find the phases and their timestamps, but it seems impossible to find the states and their effective dates.


Howdy, Stranger!

Log In

To view full details, sign in.


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