Instructor Course History IDE

Last Updated
08/12/2022
Description

This workbook exports an Excel file containing results of a query of instructors who taught courses based on instructor ID, term, course ID, and other user-defined filters.

Report URL
https://tableau.wisconsin.edu/#/views/InstructorCourseHistoryIDE/InstructorCourseHistory
Data Cookbook URL (requires authorization)
https://uwmadison.datacookbook.com/institution/reports/29397/versions/58529
Data Domain(s)
Academic Planning
Access Restrictions
Student Record Data Internal
Data Source Information
InfoAccess
Data View Information
STDNT_TIMETABLE_MULTITERM, STDNT_INSTR_ADV_DIRECTORY
Update Schedule
Weekdays at 4:00 AM
Responsible Office
Office of the Registrar
Important Notes

This IDE filters based on Instructor ID to account for differences in instructor names over terms.

Definitions

Name Functional Definition Data Domains
Term

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

University of Wisconsin - Madison
Instructor ID

SIS personal identifier. It is also called an "instructor 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.

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
Subject

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

University of Wisconsin - Madison
Subject Code (Academic Structure)

For subjects used by courses offered for UW-Madison for-credit courses (not used for transfer equivalencies or placeholders for study abroad), a unique three digit code identifying each subject listing, used to organize groups of courses in related subject areas or topics.

Academic Planning
Session Code

A code which indicates the session within the term the course meets. See https://registrar.wisc.edu/sessiondates/ for more information.

Academic Planning
Catalog Number

A code associated with a course in the course catalog.

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

The number of students enrolled in a course section.

Academic Planning, Student Record
Instructor Name

The preferred name of the person(s) listed by the department as a course instructor and/or course supervisor.

Academic Planning, Employee Record