How do I timestamp the states of applicants as they move through the recruiting process?
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:
0