Query Cheat Sheet

Welcome to our Query Cheat Sheet! On this page you’ll find a list of query templates that the Admissions team has pre-built, ready for you to use as needed. You can also scroll down to see some of the most common exports and filters that you may use when building queries of your own.

How to Use Query Templates

To use any of these query templates, click the down arrow that is next to the Edit button to the right of the query’s name. In that dropdown, select Copy Query.

In the next box that pops up, enter a descriptive name for your query using our Labeling Queries guidelines. Change the User to your own name, and change the Folder to your department’s folder. Click Save.

You will automatically be brought to the main page for your new, copied query! You will need to click Edit Query on the right in order to add the “Program Interest (App) Code” filter to filter for your specific department codes.

Query Templates

Commonly Used Exports

  • Name: applicant’s name listed as “Last, First”

  • Ref: Slate application reference number - helpful to have when you’re asking us about a specific person!

  • Program Interest (App): the program the applicant has applied to

  • Entry Term: the entry term the applicant has applied to

  • Degree Type: the degree conferred by the program the applicant has applied to

    • Note that this is not going to show you a degree they earned previously at a different institution and listed in their Academic History - contact your admissions liaison for assistance with that!

  • Department Review Forms (#1 - #5): any department review forms that were submitted

  • Workflow Bin: the bin the application is currently in

  • Citizenship: the country of primary citizenship the applicant reported when they submitted their application

  • UCSD Email

  • ISIS-Verified PID

  • GRE Verified: will show which applicants have submitted verified GRE scores

Commonly Used Filters

  • Entry Term: Filter applications by specific term or multiple terms (e.g., FA24 entry term only, or FA23 & FA24 entry term)

  • Program Interest (App) OR Program Interest (App) Code: Filter applications by specific program name or major code

  • Degree Type: the degree conferred by the program the applicant has applied to

    • Note that this is not filtering by the degree the applicant holds from a previous institution - contact your admissions liaison for assistance with that!

  • Decision (Confirmed with dates): Filter applicants who have been admitted, accepted, declined, denied, deferred, etc. You can leave the field for dates blank, or enter a date range to see applicants who had that decision assigned within those dates.

  • Workflow Bin: Filter applicants who are currently assigned to a specific bin

  • Application Submitted: Filter applications that were submitted before or on specific dates

  • Citizenship Status: Filter applicants by reported citizenship status

  • Visa Type: Filter applicants by their Visa Type

 

How to Pin Exports/Filters

If there are some exports or filters that you find yourself using often, you should Pin them! When you are adding/editing a filter or export, just click on “Edit Pinned” in the top right corner of the pop-up box. This will open a new page where you can set your pinned filters and exports.

Any exports and filters you put into the new page will then show at the top of your options every time you are building a new query!