Workforce Dynamics

Last Updated
08/12/2022
Description

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.

Report URL
https://tableau.wisconsin.edu/#/views/WorkforceDynamics/HomePage
Data Cookbook URL (requires authorization)
https://uwmadison.datacookbook.com/institution/reports/37024/versions/58567
Data Domain(s)
Employee Record
Access Restrictions
Employee Record Data Internal
Data Source Information
EPM, InfoAccess
Data View Information
EPM.PS_UW_HR_ALLJOB_VW, InfoAccess.UDDS
Update Schedule
Weekly, Monday morning
Responsible Office
Office of Human Resources

Definitions

Name Functional Definition Data Domains
Division (UDDS)

A two-character numeric designation for each school/college or non-academic division within a Unit (UDDS). Division is the second and third characters of a UDDS.

University of Wisconsin - Madison
Department (UDDS)

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.

University of Wisconsin - Madison
Employment Class

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

Employee Record
Departure (Employee)

An employee who has ended all employment at UW-Madison within a particular time period.

Employee Record
Transition (Employee)

An employee who has ended at least one appointment but remains employed at UW-Madison within a particular time period.

Employee Record
Turnover, External (Employee)

The percentage of all employees in a specified population who left all appointments at the university, calculated as the ratio of the count of Departures (Employee) to average Headcount of employees over a specified time period.

Employee Record
Turnover, Internal (Employee)

The percentage of all employees in a specified population who left at least one appointment but remained employed at the university, calculated as the ratio of a count of Transitions (Employee) to the average Headcount of employees over a specified time period.

Employee Record
Turnover Reason (HRS)

The HRS reason code description associated with a job termination action.

Employee Record
Turnover Reason Type

A grouping of Turnover Reason (HRS). The levels are Voluntary, Involuntary, and Unspecified. Voluntary turnover is initiated by the employee. Examples include retirement and resignation. Involuntary turnover is initiated by UW-Madison. Examples include the end of a fixed terminal appointment, layoff, and non-renewal.

Employee Record
Headcount

A distinct count of individual persons.

University of Wisconsin - Madison