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
21
Views
7
Comments
edited Apr 26, 2021 9:45PM in Reporting and Analytics for HCM 7 comments

Content

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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