Advisors and Assigned Advisees
| Last Updated |
|---|
| 04/26/2024 |
| Description |
|
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 |
| https://tableau.wisconsin.edu/#/views/AdvisorsandAssignedAdvisees/HomePage |
| Data Cookbook URL (requires authorization) |
| https://uwmadison.datacookbook.com/institution/reports/34308/versions/64860 |
| Data Domain(s) |
| Advising, Student Record |
| Access Restrictions |
| Student Record Data Restricted |
| Data Source Information |
| InfoAccess |
| Data View Information |
| UW.STDNT_ADVISOR_ASSIGNMENTS, UW.ACADEMIC_PLAN |
| 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. |
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 |
| 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 |
| Advisee | A student who has an advisor assignment in SIS. |
Advising |
| Advisee Name | Assigned student's preferred name (Last, First, Middle). Prior to the fall of 2014 it shows the primary/legal name. |
Advising |
| Advisee Plan Code | See definition for Plan Code (Academic) |
Advising |
| Advisee Plan Description | See definition for Academic Plan |
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 |
| Advisor ID | Ten-digit SIS personal identifier of the advisor. This will be the committee ID if advising is done by a committee. |
Advising |
| 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 |
| 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 |
| 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 |
| 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. |
Advising |
| Plan Award Category | See definition for Academic Award Category |
Advising |
| 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 |