Instructor Course History IDE
| Last Updated |
|---|
| 03/12/2025 |
| 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 |
|---|---|---|
| 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 |
| Course Enrollment | The number of students enrolled in a course section. |
Academic Planning, Student Record |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| Term | A period of instruction: Fall, Spring, or Summer. |
University of Wisconsin - Madison |