Advisor Student Grades IDE

Last Updated
08/12/2022
Description

This IDE provides a list of advisees, courses, grades any academic actions for the current and one past term based on user-set filters. Accessible data span the current and previous term for students who were active/enrolled in the defined terms.

Report URL
https://tableau.wisconsin.edu/#/views/Covid-19AdvisorGradeDashboard/AdvisorStudentGradesIDE
Data Cookbook URL (requires authorization)
https://uwmadison.datacookbook.com/institution/reports/35604/versions/58500
Data Domain(s)
Student Record
Access Restrictions
Specific / Limited Audience
Data Source Information
InfoAccess
Data View Information
UW.STDNT_MULTITERM, UW.STDNT_DIRECTORY_MULTITERM, UW.STDNT_PROGRAM_MULTITERM, UW.STDNT_PLAN_MULTITERM, UW.STDNT_FINAL_GRADE_ROSTER, UW.STDNT_ACTIONS_MULTITERM, UW.STDNT_ADVISOR_MULTITERM
Update Schedule
Weekdays at 6:00 AM
Responsible Office
Office of the Registrar

Definitions

Name Functional Definition Data Domains
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 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 Plan

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

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

A student who has an advisor assignment in SIS.

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

A 5-digit number used for student enrollment in a specific course section.

Academic Planning
Course Title

The official name of the course.

Academic Planning
Course ID

A 6-digit unique ID assigned to a specific course. All course members of a crosslisted course will have the same Course ID.

Academic Planning
Grade The grade the student received in the course. Academic Planning, Student Record
Catalog Number

A code associated with a course in the course catalog.

University of Wisconsin - Madison
Subject

A grouping of courses, approved by faculty governance, within related academic areas.

University of Wisconsin - Madison
Component Type

Signifies the type of instruction for a particular course section.

Academic Planning
Section Number

This denotes a specific component of a given course in a given term. For example, a course with five sections - one lecture section, two lab sections, and two discussion sections - will have each section identified by a different section number in a given term.

University of Wisconsin - Madison
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
Term GPA The grade point average for all courses completed for a grade at UW-Madison in the term; term grade points divided by term credits taken for GPA. Academic Planning, Student Record