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