Bootstrap Navbar Example

Notes in Advising Gateway IDE

Last Updated
05/16/2025
Description

This workbook exports an Excel file containing the results of a query of the Advisor Notes System (ANS). Users can set filters/limits to obtain the meta-data around documented contacts entered into the ANS for a desired population of students or for an individual student based on the filters selected.

Report URL
https://tableau.wisconsin.edu/#/views/AdvisorNotesSystemIDE_0/AdvisorNotesSystem
Data Cookbook URL (requires authorization)
https://uwmadison.datacookbook.com/institution/reports/31010/versions/79461
Data Domain(s)
Advising, Student Record
Access Restrictions
Student Record Data Restricted
Data Source Information
InfoAccess
Data View Information
STDNT_ADVISOR_NOTES, STDNT_DIRECTORY_MULTITERM, STDNT_TERM_CODES, RETENTION_SEMESTER_HISTORY/STDNT_MULTITERM for enrolled student data, ACADEMIC_PLAN and associated for plan and subplan information, UGRD_RECRUITMENT_CATEGORY, STDNT_ETHNIC_REPORTING
Update Schedule
Daily at 1:00 am
Responsible Office
Data, Academic Planning & Institutional Research
Important Notes

This IDE does NOT provide users access to the text of the advising notes - only to the meta data around each documented contact.

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 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
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
Academic Year (Su,Fa,Sp)

An academic year consists of sequential summer, fall, and spring terms. For example, the 2021-22 academic years includes summer 2021, fall 2021, and spring 2022.

Academic Planning
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
Athletic Participation

This field specifies the sport a student actively participates in or their non-participatory association with Athletics, such as receiving services or medical hardship.

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
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
First Generation Status (Undergraduate)

An undergraduate is considered a first generation student if they reported on their application for admission that neither of their parents had earned a four-year college degree. All others, including those who did not respond to the question are considered non-first generation.

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
Matriculation Admit Type

The admissions status of the student in the academic career matriculation term. For example, FYR/First Year Student (applies to UGRD careers only), NEW/New to career (does not apply to UGRD careers), RAD/Readmitted to career, RET/Re-admitted with transfer work (applies to UGRD careers only), TRF/Transfer (does not apply to Grad and Special students).

Academic Planning, Student Record
Named Option

A named option is a formally documented sub-major within an academic major program.

Academic Planning, Student Record
Race/Ethnicity (Federal)

The methodology specified by the federal government for classifying individuals' self-reported race/ethnicity into a single race/ethnicity category. An individual who self-reports as Hispanic ethnicity is classified as Hispanic even if other racial identities are provided. Individuals who do not self-report as Hispanic are classified in their single race category if only one race was provided, or in a "2 or more races" category if more than one race is provided. Student race/ethnicity only applies to domestic (non-international) students.

Employee Record, Student Record
School/College of Student

The student's primary school/college. Some students have a second major or pursue a certificate in another school/college.

University of Wisconsin - Madison
Term

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

University of Wisconsin - Madison