Doctoral Minors and Graduate/Professional Certificates Awarded

Last Updated
08/12/2022
Description

This Institutional Data Exporter provides two tabs of data output. The first is for doctoral minors conferred to students and the second is for any graduate/professional certificates conferred to students. Supplemental degree and primary academic program data is also included to provide additional context. Filtering can be done by a list of Campus IDs, Award Completion Terms, Award Academic Structure, and/or Primary Academic Program Academic Structure.

Report URL
https://tableau.wisconsin.edu/#/views/DoctoralMinorsandGradorProfCertsIDE_16286187373840/DoctoralMinorsandGradProfCertsAwardedIDE
Data Cookbook URL (requires authorization)
https://uwmadison.datacookbook.com/institution/reports/44531/versions/60249
Data Domain(s)
Student Record
Access Restrictions
Student Record Data Restricted
Data Source Information
InfoAccess
Data View Information
RETENTION_AWARDS_MAIN, RETENTION_AWARDS_PLAN, RETENTION_AWARDS_SUBPLAN, RETENTION_SEMESTER_HISTORY, STDNT_ETHNIC_REPORTING, STDNT_TERM_CODES
Update Schedule
Data refreshes weekday mornings.
Responsible Office
Graduate School Office of Academic Analysis, Planning, & Assessment
Important Notes

The Academic Award Completion Terms filter is required, but all other filters are optional. Once a filter choice has been specified, other filters will automatically adjust to only display relevant selections. The data file produced by this query contains a separate row for each unique award conferred for a given unique student ID and award term combination.

Doctoral Minors are limited to those conferred alongside a doctoral-level degree. Graduate/Professional Certificates are limited to those with a designation of GCRT, LCRT, MCRT, PCRT, and VCRT. Excluded are Capstone Certificates, Personal & Professional Development Certificates, and other non-graduate certificates, including certain specialist and undergraduate certificates. More information on Doctoral Minors and Graduate/Professional Certificates can be found here in the Graduate Guide (https://guide.wisc.edu/graduate/).

Primary Academic Program information is based upon and limited to data that is listed on the student record for the term in which the award is conferred. If a student was not enrolled in a plan or did not have a primary academic program for that given term, their primary academic program information may be listed as null.

Definitions

Name Functional Definition Data Domains
Academic Award Completion Term

The academic term in which an academic award was granted.

Academic Planning, Student Record
Academic Award Formal Description

Credential that is awarded upon the completion of an academic plan.

Academic Planning, Student Record
Academic Award Level Academic degree level corresponding to an academic award, i.e. bachelor's, master's, professional, doctoral, and other. Academic Planning, Student Record
Academic Award Number

A number indicating the particular academic award in sequence of UW-Madison academic awards conferred on the student.

Academic Planning, Student Record
Academic Award Plan Academic plan corresponding to an academic award. Academic Planning, Student Record
Academic Award Plan Code Name of the plan code associated with the award. Academic Planning, Student Record
Academic Award Plan Type Academic plan type corresponding to an academic award. Academic Planning, Student Record
Academic Award Program Academic program associated to the academic award. Academic Planning, Student Record
Academic Award School/College

School or college of the academic award. In general, each academic award is associated with a unique academic plan, and each academic plan is part of a unique academic program, and every academic program is associated with a unique school or college. "MSN"/"UW-Madison" is used when an academic award has no school or college associated with it (such as an individualized major or special graduate committee award) or for an additional major.

Academic Planning, Student Record
Academic Award Type

Academic award type designates awards as degrees, additional majors, certificates, or teacher certification.

Academic Planning, Student Record
Academic Career Matriculation Term

The earliest academic term a student enrolled at UW-Madison in a given academic career. For some students with dual careers this field is not populated.

Academic Planning, Student Record
Academic Plan

An area of study--such as a major, minor, or certificate--that is within an academic career.

Academic Planning, Student Record
Career (Academic Structure)

A broad grouping of students related to their degree objectives and admitting office. Used for tuition charges, awarding financial aid, grading scales and other operational functions.

Academic Planning, Student Record
Cumulative Credits

The total credits earned by the student in a given academic career up to and including the selected academic term. It includes transfer, test, and other credits as well as UW-Madison credits.

Academic Planning, Student Record
Cumulative GPA

The grade point average for all courses completed for an A-F grade at UW-Madison within a career; cumulative grade points divided by cumulative credits taken for GPA.

Academic Planning, Student Record
Program (Academic Structure)

A group of academic plans that share characteristics within an academic group. Academic program code controls administrative functions such as min credits, max credits, tuition rates, academic standing, grading schemes, full-time/part-time standing, financial aid primacy number.

Academic Planning, Student Record
School/College of Academic Plan

Indicates the school/college that has ownership of the academic plan.

Academic Planning, Student Record
Student

Any person who is registered for study at UW-Madison for a specified academic period.

Student Record
Term

A period of instruction: Fall, Spring, or Summer.

University of Wisconsin - Madison
Campus ID

This is simply a unique student identifier (10 digits). It may occasionally change at the student's request. It is not the same as ID in the Student Information System (SIS) or ID in the Human Resources System (HRS).

Student Record
ID (SIS)

SIS personal identifier. It is also called a "student Empl ID." The ID will never be changed throughout the individual's relationship with the University. This is not the same as Campus ID. This is not the same as HR ID or the ID field from HRS or the Empl ID from HRS.

Student Record