I need help joining recruitment tables
Summary:
I need to validate the inbound "step" for an application managed in 3rd party CRM
Content (please ensure you mask any confidential information):
I know that irc_submissions (process_id) maps to irc_routing_steps_b (process_id) but from there I am having trouble connecting to irc_step_transitions
I believe that irc_routing_steps_b maps to irc_step_transitions (from_step) but I am unable to confirm that in my data extracts with any of the columns
I also think the corresponding to_step value from irc_step_transitions will map to irc_routing_steps_b (routing_step_id) in order to get the corresponding phase/state combination
Tagged:
0