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

Joining the IRC_SUBMISSIONS table to the PER_ALL_ASSIGNMENTS_M table

edited Oct 3, 2019 1:01PM in Recruiting, Opportunity Marketplace 2 comments

Content

I have a requirement to get the incompleted mandatory onboarding checklist for a pending Worker/Employee. The need is to pull the STATE and PHASE as well. we have an employee where he has two offers in HR/Processing status processed in two different dates for different requisitions. Due to this when I join the per_all_assignments_m table to the IRC_submissions table, I get two rows of data.

Can anyone please let me know using which id should i join these table to get the latest row of data.

Thanks and Regards,

Amrit

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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