Employee Job Detail
| Last Updated |
|---|
| 04/16/2024 |
| Description |
|
Detailed employee and job data searchable by division, department, and employee name. |
| Report URL |
| https://tableau.wisconsin.edu/#/views/EmployeeJobDetail_0/EmployeeContact |
| Data Cookbook URL (requires authorization) |
| https://uwmadison.datacookbook.com/institution/reports/31743/versions/71524 |
| Data Domain(s) |
| Employee Record |
| Access Restrictions |
| Employee Record Data Internal, Student Record Data Internal |
| Data Source Information |
| HRS/EPM, InfoAccess, Other |
| Data View Information |
| EPM.SYSADM.PS_UW_HR_ALLJOB_VW, EPM.SYSADM.PS_UW_HR_ADRBUS_VW, INFOACCESS.UW.ID_CROSSWALK_UWMSN, INFOACCESS.UW.UDDS, JEMS.UDS_ADDR_PHONE |
| Update Schedule |
| Data are refreshed daily. |
| Responsible Office |
| Office of Human Resources |
| Important Notes |
|
Release History: January 2023 - Version 2.0 - Employee Contact information including NetID and Name in Use; Sources: EPM.SYSADM.PS_UW_HR_ALLJOB_VW (for employee/job data), EPM.SYSDM.PS_UW_HR_ADRBUS_VW (for employee contact data), InfoAccess.UW.ID_Crosswalk_UWMSN (for NetID), InfoAccess.UW.UDDS (for division/department descriptions); JEMS.UDS_ADDR_PHONE (for Name in Use) Additional Info: This workbook includes information on UW employees with at least one UW-Madison appointment. All employment classes and pay bases are included. |
Definitions
| Name | Functional Definition | Data Domains |
|---|---|---|
| Business Email Address (HRS) | The email address designated by an employee in HRS and used by HRS for business purposes. At UW-Madison, this email address is synchronized with the DoIT primary email address. See Email Address (DoIT), Bus Email (HRS). |
Employee Record |
| 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 |
| 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 |
| Employee ID Number (HRS) | Employee ID Number (HRS) - A unique 8-digit number assigned to each individual in HRS; used for tracking all HRS information related to an individual. These numbers are assigned to both employees as well as Persons of Interest. |
Employee Record |
| Employee Name (HRS) | The English format name for an employee entered in HRS. The name consists of Last Name, First Name and an optional Middle Initial. |
Employee Record |
| Employee Name (In Use) | The first and/or middle name and in limited cases last name provided by an employee that differs from the employee’s legal name. |
Employee Record |
| NetID (IT) | The identifier portion of the NetID username and password credential. |
Employee Record, Student Record |