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

 Click here to read about how to use these 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

• Customizable Admit, No Reply Query

• Customizable Admit/Accepts Query

• Customizable Student Contact Information Query 

• Customizable URM Applications Query

• Customizable Education Experiences Count Query

• Customizable GRE Details Query 

• Customizable Provisional Admit Query 

• Customizable Fellowship Eligible Applicants Query

Commonly Used Exports

• Name: applicant’s full name, including both legal and preferred (in parentheses)

• Preferred Name: applicant’s preferred name as entered on application

• Ref: Slate application reference number

• Program Interest (App): the program listed on the application

• Entry Term: the entry term listed on the application

• Degree Type: the degree level listed on the application

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

• Workflow Bin: the bin the application is currently in

• Citizenship

• 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) Code: Filter applications by specific program code

• Decision Reason: Filter applicants who have been admitted, accepted, declined, denied, deferred, etc.

• 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!