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.