Graduate Applicant Reports

The purpose of the document is to explain the features of the Graduate Applicant Reports query.

Graduate Applicant Reports
  • File folder path: MADISON/Student/Graduate/Applicants
  • Provides data about applicants to graduate programs including GRE and TOEFL scores.

What answers can I find?

Reports available in this query:

  • Who are the students who have applied to my program in a given term?
  • What are all the GWIS codes that were entered for applicants to my program?
  • What is the most recent GWIS code entered for applicants to my program?
  • What previous institutions did applicants to my program attend?
  • What was the self-reported GPA for applicants to my program?
  • What are the demographics of individual applicants to my program?
  • What are the test scores of individuals applying to my program?
The Export Data section allows you to create a customized data set for export to spreadsheet.

Query Parameter Page:


Sample Report:
Program Reason Report



The Pivot of Max Scores for Verb, Quan, and ANLYW is designed for application review committees who want to use only the maximum GRE test scores in their review process. This pivot gives the maximum test percentiles and correlating scores for the three sections of the general GRE (Quantitative, Analytical, and Writing) and the maximum TOEFL scores along with the dates those scores were earned. (Due to the changes in the way the GRE is scored, we are unable to give simply maximum test values). In the "Export Data" section, you can find the additional parts of the maximum score tests. For example, these seven fields are all from the GRE test on which the student earned his/her highest quantitative percentile and can be used by committees who only use scores from one test date:

Max QUAN Test Date
QUAN Score with Max Percentile
Max QUAN Percentile
Verb Score from max QUAN test date
Verb Percentile from max QUAN test date
Analytical Score from max QUAN test date
Analytical Percentile from max QUAN test date
For all test scores, you can look at "Test Scores - One record per test."

Data views used:

  • Stdnt_Grad_Applicants
  • Stdnt_Grad_Previous_Inst_Prog
  • Stdnt_Grad_Decisions
  • Stdnt_Test
  • Stdnt_Group_Multiterm

Search either the InfoAccess Data View page or the Enterprise Performance Management (EPM) Data Warehouse page for data definitions to the data views used in the Query Library.

Keywords:graduate, applicant, admissions, GRE, TOEFL, test scores, applied, GWIS code, previous institutions, demographics Query Data Library   Doc ID:41628
Owner:Harriet A.Group:Query Library
Created:2014-07-07 13:05 CDTUpdated:2014-07-29 15:59 CDT
Sites:Query Library
Feedback:  0   0