Link to University of Wisconsin-Madison home page

Glossary of Terms In Administrative Dashboards and Reports

Office of Data Management and Analytics Services

Employee Record Number

Definition

Identifies each job at a particular point in time. For most employees, the number will be zero. Employees with multiple concurrent jobs will have a unique record number for each job, assigned sequentially based on date of hire for each job. For most employees, the number will be zero. Per UW policy,after a job ends, the employee record number will be reused for future jobs.

Data Cookbook URL (requires authorization)
https://uwmadison.datacookbook.com/institution/terms/194148/versions/229387
Data Domain(s)
Employee Record

Related Dashboards

Name Type Description Data Domain Responsible Office Access Restrictions Last Updated
Current Funding for Graduate and Professional Students IDE
viz thumbnail for Current Funding for Graduate and Professional Students IDE
Institutional Data Exporter (IDE)

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

Additional Info
Employee Record, Student Record Graduate School Office of Academic Analysis, Planning, & Assessment Employee Record Data Internal, Student Record Data Restricted
Request Access
09/23/2022
Employee Supervisor Detail
viz thumbnail for Employee Supervisor Detail
Interactive Data Visualization

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.

Additional Info
Employee Record Office of Human Resources Employee Record Data Internal
Request Access
10/24/2022
Student Assistant Enrollment Status IDE
viz thumbnail for Student Assistant Enrollment Status IDE
Institutional Data Exporter (IDE)

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.

Additional Info
Employee Record, Student Record Graduate School Office of Academic Analysis, Planning, & Assessment Employee Record Data Internal, Student Record Data Restricted
Request Access
10/04/2022
Employee Lump Sums
viz thumbnail for Employee Lump Sums
Interactive Data Visualization

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.

Additional Info
Employee Record OHR Employee Record Data Internal
Request Access
12/02/2020
Student Assistant Tuition Remission IDE
viz thumbnail for Student Assistant Tuition Remission IDE
Institutional Data Exporter (IDE)

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.

Additional Info
Employee Record, Student Record Graduate School Office of Academic Analysis, Planning, & Assessment Employee Record Data Internal, Student Record Data Restricted
Request Access
09/23/2022
Historical Graduate Student Funding IDE
viz thumbnail for Historical Graduate Student Funding IDE
Institutional Data Exporter (IDE)

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.

Additional Info
Employee Record, Student Record Graduate School Office of Academic Analysis, Planning, & Assessment Employee Record Data Internal, Student Record Data Restricted
Request Access
11/09/2022