Advisor Assignments IDE

Last Updated
08/12/2022
Description

This IDE provides a list of advisors and their assigned advisees based on user-set filters. Accessible data span the current term, the previous two terms, and one future term for students who were active/enrolled in the term(s) selected.

Report URL
https://tableau.wisconsin.edu/#/views/AdvisorAssignmentsIDE/AdvisorAssignmentsIDE
Data Cookbook URL (requires authorization)
https://uwmadison.datacookbook.com/institution/reports/31024/versions/59296
Data Domain(s)
Advising, Student Record
Access Restrictions
Student Record Data Restricted
Data Source Information
InfoAccess
Data View Information
STDNT_MULTITERM, STDNT_DIRECTORY_MULTITERM, STDNT_PLAN_MULTITERM, STDNT_ADVISOR_MULTITERM, STDNT_SUBPLAN_MULTITERM
Update Schedule
Daily at 7:45am
Responsible Office
Office of Data Management and Analytics Services

Definitions

Name Functional Definition Data Domains
Academic Advisor

A university staff member assigned to students for the purpose of advising them on academic matters, such as the requirements for progression through a degree program.

Academic Planning, Employee Record
Term

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

University of Wisconsin - Madison
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
Academic Plan

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

Academic Planning, Student Record
Plan Type (Academic Structure)

A code indicating the type of academic plan, related to to the degree or credential awarded to students who complete it.
CAP = Capstone
CRT = Certificate
MAJ = Major
MIN = Minor (Graduate School or Education)
TCH = Educator Certification
NON = Non-degree
HON = Honors
SP = Specialization
PRP = Pre College Program

Academic Planning, Student Record
Subplan Type (Academic Structure)

A code indicating the type of subplan, related to the degree or credential awarded to students who complete it. OPT = named option, HON = Honors, TRK = Track.

Academic Planning, Student Record
Academic Level

Indicates whether a student is an undergraduate, graduate or professional, or special student. For undergraduates, students are freshman, sophomore, junior, or senior based on accumulated credits, not the duration of time at the University.

University of Wisconsin - Madison
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
Advisor Role

The role under which the advisor is assigned.

Academic Planning, Employee Record
Advisor Role Code

The code for the role of the academic advisor.

Advising
Advisor Role Description

The description of the academic advisor role.

Advising
Term Admit Type

Indicates whether a student is a continuing, readmitted, reentry/transfer, new freshman, new transfer, or other new student in that term, except students who start as new freshmen in summer are shown as new freshmen in the following fall too, if enrolled.

University of Wisconsin - Madison
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
Term Credits Total number of credits a student is enrolled in for the term. Academic Planning, Student Record
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
Academic Plan Group

A code assigned by UW-Madison for a major. The major may be offered across multiple degree levels and/or by multiple school or colleges.

Academic Planning, Student Record
Advisee Name

Assigned student's preferred name (Last, First, Middle). Prior to the fall of 2014 it shows the primary/legal name.

Advising
Advisee Program Code

The code for the student’s academic program on the academic advisor record.

Advising
Advisee Program Description

The name of the student’s academic program matching the advisor record.

Advising