Employee Job Detail

Last Updated
12/01/2022
Description

Detailed employee and job data searchable and grouped by division and department.

Report URL
https://tableau.wisconsin.edu/#/views/EmployeeJobDetail_0/EmployeeContact
Data Cookbook URL (requires authorization)
https://uwmadison.datacookbook.com/institution/reports/31743/versions/58522
Data Domain(s)
Employee Record
Access Restrictions
Employee Record Data Internal
Data Source Information
EPM, InfoAccess
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
Update Schedule
Data are refreshed daily.
Responsible Office
Office of Human Resources
Important Notes

Release History: March 2019 - Version 0.1 - Employee Contact information including NetID;

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);

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
NetID (IT)

The identifier portion of the NetID username and password credential.

Employee Record, Student Record