Link to University of Wisconsin-Madison home page

RADAR

Repository for Administrative Data and Reports

Employee Job Detail

Last Updated
04/23/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