Advisors and Assigned Advisees

Last Updated

Lists UW-Madison advisors designated in SIS and the advisees assigned to them. Graduate and undergraduate advisees can be filtered by Plan, Career, Award Category, Advisee Program and Last Term Enrolled.

Report URL
Data Cookbook URL (requires authorization)
Data Domain(s)
Advising, Student Record
Access Restrictions
Student Record Data Restricted
Data Source Information
Data View Information
Update Schedule
Saturdays at 11pm
Responsible Office
Office of Data Management and Analytics Services
Important Notes

This workbook is intended to show all data for data clean up purposes. Therefore, null values are intentionally included.


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
Advisor Role

The role under which the advisor is assigned.

Academic Planning, Employee 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
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 Plan Code Name of the plan code associated with the award. 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
Advisor ID

Ten-digit SIS personal identifier of the advisor. This will be the committee ID if advising is done by a committee.

Last Term Enrolled

The SIS code for the most recent academic year and semester that the student was enrolled. Note that this can be in a future term if the enrollment period for that term is active.


A student who has an advisor assignment in SIS.

Advisee Name

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

Advisee Plan Code

See definition for Plan Code (Academic)

Advisee Plan Description

See definition for Academic Plan

Advisor Role Code

The code for the role of the academic advisor.

Advisor Role Description

The description of the academic advisor role.

Plan Award Category

See definition for Academic Award Category

Advisee Program Code

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

Advisee Program Description

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

Plan Code (Academic)

A code representing an approved academic offering such as a major, minor, or certificate within an academic career and program.

Academic Planning, Student Record
Academic Award Category

Indicates the level and type of award granted to a student who graduates in a given plan code. For example, Bachelor's, Master's, Research Doctorate, Clinical Doctorate, Undergraduate Certificate, Capstone Certificate.

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