Specific Advisor's List of Advisees

The purpose of the document is to explain the features of the Specific Advisor's List of Advisees query.


Specific Advisor's List of Advisees
  • File folder path: MADISON/Student/Graduate/Programs and Degrees
  • This query pulls all advisees listed in ISIS for a particular advisor.

What answers can I find?

Reports available in this query:

  • Who are the advisees for a particular advisor?
  • Of the advisor's advisees, which ones have earned a degree and what type?
  • Of the advisor's advisees, which ones are currently enrolled?
  • Of the advisor's advisees, what was the last term in which they enrolled?
report_list_30
The Export Data section allows you to create a customized data set for export to spreadsheet.

Query Parameter Page:

Query_Parameters_30

Sample Report:
Count of Advisee's Awards by Level

sample_report_Count_of_Advisees_Awards_by_Level

Notes:

This query pulls all advisees listed in ISIS for a particular advisor, regardless if the student is currently enrolled. If it looks like an advisee is missing, that person probably doesn't have his/her advisor set up correctly in ISIS.

Data views used:

  • Stdnt Advisor Assignments
  • Retention Awards Main

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,program,degree,ISIS,advisor,degress,type,term,enrolled Query Data Library   Doc ID:41811
Owner:Ali K.Group:Query Library
Created:2014-07-14 09:54 CSTUpdated:2014-07-29 14:59 CST
Sites:Query Library
Feedback:  0   0