Dissertator Status Audit

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

Dissertator Status Audit
  • File folder path: MADISON/Student/Graduate/Enrolled Students
  • Lists milestones (dissertator, minors, etc) for current and past graduate students.

What answers can I find?

Reports available in this query:

  • Which students in my program have achieved dissertator status?
  • Who is advising dissertators?
  • What is the fifth year limit for these students?
  • Historically, when have my students achieved dissertator status and graduated?
  • What is their elapsed time to degree?
The Export Data section allows you to create a customized data set for export to spreadsheet.

Query Parameter Page:


Sample Report:
All Students History



This query is meant to be used when looking up all the names on students who have met a certain Milestone in their PhD candidate career.

The question being asked is,

Show me all the students since XXXX (Term code) that have attained the Milestone of (choose from
1.) Prelim,
2.) Major Requirements,
3.) Dissertator Status.

The query will report those students with that Milestone from that Term to the present.

Two reports are available.
Current Students With Milestones ( showing only those currently enrolled ).
All Students Milestone History (showing both those who have graduated and those who have not completed their final requirements).

Data views used:

  • Retention Awards Main
  • Retention Plan History
  • Retention Student
  • Retention Semester History
  • Stdnt Milestones
  • Stdnt Multiterm
  • Stdnt Plan Multiterm
  • Stdnt Advisor 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, dissertator, minor, advisor, five year limit, graduation, time to degree Query Data Library   Doc ID:41668
Owner:Harriet A.Group:Query Library
Created:2014-07-07 15:13 CDTUpdated:2014-07-29 15:59 CDT
Sites:Query Library
Feedback:  0   0