Category for Applications Created via Import

I'm working with a client who is thinking about configuring Create Users Upon Import (CUUI) and they're concerned about those the dashboard data about the total drafted vs submitted general applications. I believe they like to report these statistics to offices around campus to share the effectiveness of the platform or show where more outreach is needed.

When CUUI is turned on, all the applications that are created are set at Drafted. This means that they would potentially have thousands of drafted applications, which doesn't exactly tell them how many applicants have at least logged into the AW platform.

This client has lots of general application questions, so sorting via blank answers isn't exactly ideal. Additionally, any filtering down within the general application grid would not produce information as nicely as the current dashboard does. 

The following is my workaround is to capture the handy drafted vs submitted numbers:

1. Create a saved grid view within the general application that filters each general application column for blank answers by typing BLANK in each field.
2. Make note of the number of applications that have no answers; these will be all of the applications created via import and not touched by students. 
3. Go back to the Complete View to get the total number of applications. 
4. Subtract the number from step #2 from the total number of applications; this will give you all of the acted upon applications. 
5. Use the default system view of Submitted or toggle for the just the Submitted applicants to get all of the applicants who have completed the general application. 
6. Subtract the number from step #5 from the number in step #2 to get the number of truly Drafted applications.

(This is the ZD ticket for future reference: #58046.)

If there was a category or a way to differentiate the created via applications from the student acted upon by still drafted applications, it would be really helpful. Thanks!

  • Deleted User
  • Jul 20 2017
  • Reviewed: Voting Open
Employee Name Dana Griffin
Client Name "shard name" sfasu, ucdavis
User System Admin , Opportunity Admin
Functional Unit General Application , Application Categories, CUUI
  • Attach files
  • Deleted User commented
    October 25, 2017 15:21

    UC Davis is also looking for a way to search on all actual drafted general applications opposed to loaded create users upon import drafted applications.  These folks review on the general application level and would like to contact and see who began the process to finish if needed.  At present, there is no way to do this as they all come in drafted with CUUI.

     

    https://ucdavis.academicworks.com/