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

SQL to report on draft applications?

Question
11
Views
0
Comments

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):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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