Link to University of Wisconsin-Madison home page

Glossary of Terms In Administrative Data and Reports

Data, Academic Planning & Institutional Research

Department (UDDS)

Definition

A two-character numeric designation for each department (academic or budgetary) within a Division (UDDS). Department is the fourth and fifth characters of a UDDS.

Data Cookbook URL (requires authorization)
https://uwmadison.datacookbook.com/institution/terms/176397/versions/323809
Data Domain(s)
University of Wisconsin - Madison
Data Systems
INSITE

Related Dashboards

Name Type Description Data Domain Responsible Office Access Restrictions Last Updated
Department Planning Profiles: Budget
Interactive Data Visualization

This interactive visualization provides budget summary data for UW-Madison going back to 1995. New data is added once per year after the budget cycle is completed and the budget is locked.

Additional Info
Budget Academic Planning and Institutional Research UW-Madison Employees (NetID Required) 11/01/2019
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
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
TA Remote Teaching Training Audit
viz thumbnail for TA Remote Teaching Training Audit
Interactive Data Visualization

This workbook identifies individuals who are required to complete the TA Remote Teaching Training course(s) and reports their training completion status. The data presented in this workbook is used by the College of Letters and Science to ensure their TAs have completed the required training.

Additional Info
Employee Record, Student Record College of Letters and Science Employee Record Data Internal, Student Record Data Internal
Request Access
12/15/2021
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
Title & Total Compensation Project Training Tracker
viz thumbnail for Title & Total Compensation Project Training Tracker
Interactive Data Visualization

A list and summary of UW-Madison employees who completed the Title & Total Compensation (TTC) Project training used for division tracking and enforcement of training.

Additional Info
Employee Record Office of Human Resources Employee Record Data Internal
Request Access
12/15/2021
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
Learning and Talent Development Training Audit
viz thumbnail for Learning and Talent Development Training Audit
Interactive Data Visualization

This workbook identifies individuals that have attended training in the OHR Registration System for help in reporting training for Learning and Talent Development courses

Additional Info
Employee Record Learning and Talent Development Specific / Limited Audience
Request Access
07/07/2022
Civil Rights Training Tracker
viz thumbnail for Civil Rights Training Tracker
Interactive Data Visualization

The two tabs of this workbook display overall completion status as well the list of completions for each individual.

Additional Info
Employee Record OAIC - Office of Access, Inclusion and Compliance Employee Record Data Internal
Request Access
09/09/2022
Expenses and Awards by Funding Unit & PI Unit
viz thumbnail for Expenses and Awards by Funding Unit & PI Unit
Interactive Data Visualization

Visualizations break down a unit's PIs' extramural expenditures and awards by the unit in which the funding resides, show PIs' appointment locations for expenditures/awards for which the funding resides in a given unit, and help compare a unit's impact in terms of expenditures/awards within that unit to its impact in terms of the expenditures/awards of its PIs regardless of where the funding resides.

Additional Info
Finance, Research Administration Research & Sponsored Programs Specific / Limited Audience
Request Access
02/24/2023
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
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) 02/07/2023
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
07/11/2023
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
04/24/2023
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
04/24/2023
Department Planning Profiles: Summary Profile
Interactive Data Visualization

This interactive data visualization provides data trends for each division and department across 7 topic areas, including: Credit Allocation, Student Enrollments, Degrees/Certificates, Faculty Roster, Payroll, Budget, and Research Awards.

Additional Info
Academic Planning, Employee Record, Research Administration, Student Record Data, Academic Planning & Institutional Research UW-Madison Employees (NetID Required) 05/03/2023
Academic Structure
viz thumbnail for Academic Structure
Interactive Data Visualization

This workbook provides information about academic divisions (schools/colleges), departments, plans, subplans, and curricular subjects as well as a visual overview of UW-Madison's academic structure.

Additional Info
Academic Planning Data, Academic Planning & Institutional Research Publicly Available 06/19/2023
Compliance Trainings for Youth Activities
viz thumbnail for Compliance Trainings for Youth Activities
Interactive Data Visualization

UW–Madison youth programs and activities require all staff, including employees, volunteers, and contractors, to complete specific trainings before working with youth. This workbook tracks the completion of required trainings by these individuals.

Additional Info
Employee Record Office of Youth Protection (OYP) Employee Record Data Internal
Request Access
08/28/2023
Postdocs at UW-Madison
Interactive Data Visualization

This data visualization provides information on the background characteristics of postdocs at UW-Madison, their average time spent in postdoctoral training, and their employment outcomes after leaving their postdoc appointment at UW-Madison. It was developed as part of the Coalition for Next Generation Life Science initiative (CNGLS). UW-Madison is a founding member of the Coalition for Next Generation Life Science, which includes 55 national research universities and schools of medicine. The Coalition seeks to improve transparency related to career prospects and opportunities for life sciences trainees, including both graduate students and postdocs.

Additional Info
Employee Record Graduate School Office of Academic Analysis, Planning, & Assessment Publicly Available 09/19/2023
Department Planning Profiles: Payroll
Interactive Data Visualization

This interactive visualization provides October and March payroll data going back to 1993 and monthly payroll data for recent years. It includes FTE and annual payroll amounts at the institution, division, department and subdepartment levels.

Additional Info
Budget Data, Academic Planning & Institutional Research UW-Madison Employees (NetID Required) 11/01/2023
FP&M Training Tracking Tool
viz thumbnail for FP&M Training Tracking Tool
Interactive Data Visualization

A list and summary of Facilities, Planning & Management (FP&M) employees who completed select required & preferred trainings for division tracking and forecasting.

Additional Info
Employee Record Facilities Planning and Management Employee Record Data Internal
Request Access
11/10/2023
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/22/2023
Responsible Employee Training Audit
viz thumbnail for Responsible Employee Training Audit
Interactive Data Visualization

A list of individuals required to complete the Responsible Employee Training (formerly Title IX Responsible Employee Training)  and the completion status of each.

Additional Info
Employee Record Office of Compliance Employee Record Data Internal
Request Access
12/05/2023
Employee Job Detail
viz thumbnail for Employee Job Detail
Interactive Data Visualization

Detailed employee and job data searchable by division, department, and employee name.

Additional Info
Employee Record Office of Human Resources Employee Record Data Internal, Student Record Data Internal
Request Access
01/16/2024
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 Data, Academic Planning & Institutional Research Employee Record Data Internal
Request Access
02/01/2024
Campus Security Authorities Training Audit
viz thumbnail for Campus Security Authorities Training Audit
Interactive Data Visualization

This workbook identifies individuals who are required to complete the Campus Security Authorities Training and reports their training completion status. The data presented in this workbook is used by the UW Police Department to ensure they meet regulatory standards.

Additional Info
Employee Record, Student Record UW Police Department Employee Record Data Internal, Student Record Data Internal
Request Access
04/05/2024
Student Credit Hours by School, College and Department
viz thumbnail for Student Credit Hours by School, College and Department
Interactive Data Visualization

This is a visualization of student credit hours using the Credits Follow the Instructor (CFI) data system which apportions course credits to the section level and then attributes course section credits to the academic unit funding the instructor. This attribution is often different than the academic unit that coordinates the course subject listing(s). The number of student credits hours, the change from previous like semesters, and the relationship between funding department and subject listing(s) are all provided. Student credit hours for fall and spring semesters between fall 2014 and fall 2023 are included.

Additional Info
Academic Planning, Employee Record Academic Planning and Institutional Research UW-Madison Employees (NetID Required) 04/17/2024