Employee Job Detail
Last Updated |
---|
10/03/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 |