Workforce Dynamics
| Last Updated |
|---|
| 01/22/2025 |
| 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/77985 |
| Data Domain(s) |
| Employee Record |
| Access Restrictions |
| Employee Record Data Internal |
| Data Source Information |
| HRS/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 |
|---|---|---|
| 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 |
| Departure (Employee) | An employee who has ended all employment at UW-Madison within a particular time period. |
Employee Record |
| 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 |
| Employment Class | A classification system used to group employees with common attributes; examples: FA = Faculty, SH = Student Hourly, CP = University Staff, etc. |
Employee Record |
| Headcount | A distinct count of individual persons. |
University of Wisconsin - Madison |
| 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 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 |
| 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 |