Link to University of Wisconsin-Madison home page


Repository for Administrative Data and Reports

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
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 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 Plan

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

Academic Planning, Student Record

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

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.

Advisor ID

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

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.

Advisor Role Description

The description of the academic advisor role.

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

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
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.

Plan Award Category

See definition for Academic Award Category

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