Link to University of Wisconsin-Madison home page


Repository for Administrative Data and Reports

Restricted Student Directory IDE

Last Updated

This Tableau workbook exports an Excel file containing results of a query of the student directory. It has contact information for students registered in the last two terms, the current term, and up to two future terms. Students with FERPA holds are not omitted from this workbook. The Ferpa Flag field indicates which students have withheld their information from public release.

Report URL
Data Cookbook URL (requires authorization)
Data Domain(s)
Student Record
Access Restrictions
Student Record Data Restricted
Data Source Information
Data View Information
Update Schedule
The data extract is refreshed nightly.
Responsible Office
Office of the Registrar


Name Functional Definition Data Domains
Academic Career Matriculation Term

The earliest academic term a student enrolled at UW-Madison in a given academic career. For some students with dual careers this field is not populated.

Academic Planning, Student 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
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
Cumulative Credits

The total credits earned by the student in a given academic career up to and including the selected academic term. It includes transfer, test, and other credits as well as UW-Madison credits.

Academic Planning, Student Record

Indicates if a student has exercised the right to restrict the release of their public directory information by placing a FERPA restriction on that data , as permitted under the Family Educational Rights and Privacy Act of 1974 (FERPA).

Student Record
Full-Time/Part-Time Student Status

Full-time/part-time student status is based on credit load and varies by course of study. Undergraduate and special students are full-time if they are enrolled in 12 or more credits; part-time if they are enrolled in fewer than 12 credits. Most master's and research doctorate students are full-time if they are enrolled in 8 or more credits; part-time if they are enrolled in fewer than 8 credits.

University of Wisconsin - Madison

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
Student Home Address

An address self-reported by a student with an address type of "Home."

Student Record
Student Mail Address

An address self-reported by a student with an address type of "Mailing."

Student Record
Student Name

Student's preferred name (Last, First, Middle). Prior to the fall of 2014 it shows the primary/legal name.

Academic Planning, Student Record
Term Credits Total number of credits a student is enrolled in for the term. Academic Planning, Student Record