International Graduate Students by School-College or Plan

The purpose of the document is to explain the features of the International Graduate Students by School-College or Plan query.


International Graduate Students by School-College or Plan
  • File folder path: MADISON/Student/Graduate/Enrolled Students
  • International graduate students carrying a major in a selected school/college. Reports include second and third majors, and certificates. The Home Address report highlights students with addresses within the US.

What answers can I find?

Reports available in this query:

  • Who are the international students in my program?
  • What countries do they come from?
  • What is their visa status (F-1 or J-1), contact info, demographic info, and contact info?
  • Which of these international students are dissertators?
report_list_14
The Export Data section allows you to create a customized data set for export to spreadsheet.

Query Parameter Page:

Query_Parameters_14

Sample Report:
Campus Address

sample_report_Campus_Address

Notes:

Returns all international grad students carrying a major in a selected academic group. Includes second, third majors, certificates, etc.

Returns seven reports:

Academic Info Sorted by GPA
Home Address
Campus Address
Demographic Information by Plan Description
Academic Information by Program Description
Demographic Information by Program Description
Email Address Pivot

Special Considerations:
If you want to see all students with Visas in a group, do not select the Visa Permit Type or Dissertator Indicator check boxes.

Selection Criteria Used:
Career (preset to exclude "UGRD"). You select Term, Primary Academic Group, Visa Permit Type (optional), and Dissertator Indicator (optional).

Data views used:

  • UW_STDNT_MULTITERM
  • UW_STDNT_DIRECTORY_MULTITERM
  • UW_STDNT_PROGRAM_MULTITERM
  • UW_STDNT_PLAN_MULTITERM
  • UW_STDNT_ADVISOR_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, enrolled, current student, international, visa, country, contact info, demographic info, dissertator Query Data Library   Doc ID:41679
Owner:Harriet A.Group:Query Library
Created:2014-07-07 15:57 CSTUpdated:2014-07-29 14:59 CST
Sites:Query Library
Feedback:  0   0