Glossary of Terms In Administrative Data and Reports

This workbook describes lump sum earnings paid to UW-Madison salaried and hourly employees. The employee population represented includes Faculty, Academic Staff, Limited Staff, and University Ongoing and Project Staff. The period covered includes the current fiscal year through the current fiscal month as well as the past four fiscal years.

This workbook describes UW-Madison employee reporting relationships based on the 'Reports To' field in HRS. Two lookup paths are provided: supervisor to employee and employee to supervisor. Filters enable reduction by division, department, sub-department and employee/supervisor name. An active/inactive/missing status filter enables identification of missing and inactive supervisor/employee relationships.

This Tableau workbook exports an Excel file listing currently active UW-Madison funding appointments held by graduate and professional students.

This Tableau workbook exports an Excel file listing currently active UW-Madison student assistantship appointments, as well information on each student's eligibility for their appointment(s) based on enrollment information from the current academic term.

This workbook exports a file listing student assistant appointments (PA, RA, TA, & LSA) that may qualify the graduate or professional student holding the appointment for tuition remission. Query output is limited to active A & C-basis appointments where the employed student has a minimum total FTE of 33% for all appointments in the term selected. Data reflect the most recent action and action effective date in HRS at the time the query is run.

This workbook exports an Excel file of student assistant appointments held by students enrolled in UW-Madison graduate programs over the past ten academic years. Data are derived from annual October and March payroll snapshots and therefore only represent student assistant appointments active in those months.