All Active Plans for Graduate Students (Includes Dual Career)

The purpose of the document is to explain the features of the All Active Plans for Graduate Students (Includes Dual Career) query.


All Active Plans for Graduate Students (Includes Dual Career)
  • File folder path: MADISON/Student/Graduate/Enrolled Students
  • This query provides a list of all of the students in a selected plan(s) for the selected term(s) and shows all the plans in which they are active for those terms.

What answers can I find?

Reports available in this query:

  • Who are the students currently enrolled in my program/plan?
  • What are all the active plans of the students currently enrolled in my program?
  • Who are the dual career students in my program?
  • What are the email addresses of the students currently enrolled in my program?
report_list_05
The Export Data section allows you to create a customized data set for export to spreadsheet.

Query Parameter Page:

Query_Parameters_05

Sample Report:
All Active Plans Pivot

sample_report_All_Active_Plans_Pivot

Notes:

This query provides a list of all of the students in the selected plan(s) for the selected term(s) and shows all of the plans in which they are active for those terms. For most students, you will only see the selected plan listed because it is the only plan in which they are enrolled. If any dual career students are in the list, their non-Graduate career will be in red.

Data views used:

  • Stdnt Plan 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, plan, term, active, dual career, email address Query Data Library   Doc ID:41649
Owner:Harriet A.Group:Query Library
Created:2014-07-07 13:17 CSTUpdated:2014-07-29 14:59 CST
Sites:Query Library
Feedback:  0   0