SQL to report on draft applications?
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?
Version (include the version you are using, if applicable):