Link to University of Wisconsin-Madison home page

Glossary of Terms In Administrative Dashboards and Reports

Office of Data Management and Analytics Services

Employment Class

Definition

A classification system used to group employees with common attributes; examples: FA = Faculty, SH = Student Hourly, CP = University Staff, etc.

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

Related Dashboards

Name Type Description Data Domain Responsible Office Access Restrictions Last Updated
Preventing Sexual Harassment Training Audit
viz thumbnail for Preventing Sexual Harassment Training Audit
Interactive Data Visualization

This workbook identifies individuals who are required to complete the Preventing Sexual Harassment/Sexual Violence (PSHSV) Training and reports their training completion status. The data presented in this workbook is used by the Office of Compliance to ensure they meet regulatory standards.

Additional Info
Employee Record Office of Compliance Employee Record Data Internal
Request Access
11/21/2022
Employee Demographics
viz thumbnail for Employee Demographics
Interactive Data Visualization

Non-duplicating headcount of UW-Madison employees by department with demographic characteristics.

Additional Info
Employee Record Academic Planning and Institutional Research Employee Record Data Internal
Request Access
11/10/2022
Salary Funding IDE
viz thumbnail for Salary Funding IDE
Institutional Data Exporter (IDE)

An export of salary data for both the past (payroll) and the future (projection). Data is displayed by job, project, pay period, HRS distribution percentage, funding source, etc.

Additional Info
Employee Record Office of Human Resources Employee Record Data Internal
Request Access
11/23/2022
International Faculty and Staff Profile
viz thumbnail for International Faculty and Staff Profile
Interactive Data Visualization

This visualization provides summary counts of UW-Madison international faculty and staff by division, employee class, country of record, and most current visa type. The underlying data set comprises anonymized data derived from HRS.

Additional Info
Employee Record Office of Human Resources UW-Madison Employees (NetID Required) 06/02/2021
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
Payroll Funding Edit & Placeholder IDE
viz thumbnail for Payroll Funding Edit & Placeholder IDE
Institutional Data Exporter (IDE)

An export of employee jobs and the respective upcoming payroll funding projections for a given Deptid(s) and Pay Period(s).

Additional Info
Employee Record Office of Human Resources Employee Record Data Internal
Request Access
03/11/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
Cybersecurity Awareness Training Audit
viz thumbnail for Cybersecurity Awareness Training Audit
Interactive Data Visualization

A list and summary of UW-Madison employees who completed the Cybersecurity Awareness training.

Additional Info
Employee Record, Student Record Office of Cybersecurity Employee Record Data Internal, Student Record Data Internal
Request Access
11/09/2022
COVID-19 Training Audit
viz thumbnail for COVID-19 Training Audit
Interactive Data Visualization

This workbook identifies individuals who are required to complete the COVID-19 Training and reports their training completion status. The data presented in this workbook is used by the Department of Health and Safety to ensure they meet regulatory standards.

Additional Info
Employee Record FP&M EHS Employee Record Data Internal
Request Access
12/15/2021
Workforce Dynamics
viz thumbnail for Workforce Dynamics
Interactive Data Visualization

This workbook characterizes changes in the UW-Madison workforce over time in terms of active employees (headcount), employees who have left the institution (external turnover), and employees who have left one but not all appointments within the institution (internal turnover). The employee population represented includes Faculty, Academic Staff, University Staff, Employees-in-Training, and Student Assistants. The period covered includes the current fiscal year through the current month and the past four fiscal years.

Additional Info
Employee Record Office of Human Resources Employee Record Data Internal
Request Access
06/02/2021
Employee Base Compensation Rate Adjustments
viz thumbnail for Employee Base Compensation Rate Adjustments
Interactive Data Visualization

This workbook describes adjustments to base compensation rates for UW-Madison employees. The employee population represented includes Faculty, Academic Staff, Limited, and University 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 Employee Record Data Internal
Request Access
11/08/2021
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
Space Analytics
viz thumbnail for Space Analytics
Interactive Data Visualization

This visualization provides high level overviews of space allocation, space use, and space function across campus and can be customized to view select organization(s), locations(s), use(s), and function types. It also includes a report on space productivity related to staff counts based on human resources data. The primary users of this dashboard will be Facilities Planning and Management and offices involved in campus planning and resource management at the institutional level. 

Additional Info
Space Facilities Planning & Management Facilities Data Internal
Request Access
02/08/2022
Staff Climate Survey Results (2022)
viz thumbnail for Staff Climate Survey Results (2022)
Interactive Data Visualization

Results of the staff climate survey are shown by the division and department level with filters for demographic categories self-reported by the surveyed staff members. Results are not shown when fewer than 10 staff members in a selected group responded to the survey.

Additional Info
Other Academic Planning and Institutional Research UW-Madison Employees (NetID Required) 12/13/2022