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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

SQL to report on draft applications?

Received Response
21
Views
1
Comments
in Recruiting, Opportunity Marketplace 1 comment

Summary:

We have been trying to figure out for months the best way to report on incomplete applications. Through multiple CC posts, conversations with OCS, we still aren't 100% how to do this. Many people saying it can be done using SQL.

We have created the attached SQL to pull this, but the numbers do not look right - only 3% incomplete rate compared to almost 25% on our previous platform.

What we have used: The records where they have source information in the IRC_SOURCE_TRACKING table but no submission would these be draft applications?

Content (required):


Version (include the version you are using, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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