Advisor Audit

The purpose of the document is to explain the features of the Advisor Audit query.


Advisor Audit
  • File folder path: MADISON/Student/Graduate/Enrolled Students
  • Advisor audit reports including a pivot chart displaying only students without advisors.

What answers can I find?

Reports available in this query:

  • Who are my students' advisors (with email addresses)?
  • Which students are missing advisors?
  • Who is assigned to faculty in my program as advisees?
report_list_04
The Export Data section allows you to create a customized data set for export to spreadsheet.

Query Parameter Page:

Query_Parameters_04

Sample Report:
Advisors and Their Students

sample_report_Advisors_and_Their_Students

Notes:

Three reports will be displayed with this Query.

If an Advisor is selected before processing, the reports displayed are
Students Assigned to Selected Advisor,
Students NOT Assigned to Selected Advisor,
Export Data,
Export Data - Selected Advisor

If an Advisor is NOT selected before processing, the reports displayed are
Students and their Advisors,
Advisor and Student Names,
Student with no academic advisor assigned
and
Export Data.

All are easy to export.

Data views used:

  • STDNT MULTITERM
  • STDNT ADVISOR MULTITERM
  • STDNT PLAN MULTITERM
  • STDNT SUBPLAN MULTITERM
  • STDNT DIRECTORY MULTITERM
  • STDNT TERM CODES

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, advisor, audit, missing, advisee Query Data Library   Doc ID:41632
Owner:Harriet A.Group:Query Library
Created:2014-07-07 12:26 CSTUpdated:2014-07-29 14:59 CST
Sites:Query Library
Feedback:  0   0