Link to University of Wisconsin-Madison home page


Repository for Administrative Data and Reports
Notice: As of June 20, 2023, you will need to be on the campus network or logged into the campus VPN to access non-publicly available Tableau reports. Additionally, public Tableau reports will be on Please be sure to update bookmarks for any public reports you access. Links in RADAR should always be up-to-date.

Employee Lump Sums

Last Updated

This workbook describes lump sum earnings paid to UW-Madison salaried and hourly employees. The employee population represented includes Faculty, Academic Staff, Limited Staff, and University Ongoing and Project Staff. The period covered includes the current fiscal year through the current fiscal month as well as the past four fiscal years.

Report URL
Data Cookbook URL (requires authorization)
Data Domain(s)
Employee Record
Access Restrictions
Employee Record Data Internal
Data Source Information
EPM, InfoAccess
Data View Information
Update Schedule
Responsible Office
Important Notes

This workbook captures lump sum earnings paid on appointments with employment class FA, AS, LI, CP, or CJ and pay basis A, C, or H.  The effective date of the payment is the end date of the pay period end in which the lump sum earnings are recorded in HRS. Lump sum earnings codes are limited to AEX, HCF, HCV, HDE, HDM, HEM, HMA, HPE, AXT, HFT, HCT, HET, HDT, HZT, HMT, HOT, UCV, UDE, UEM, UMA, UOL, UPE, UVS, UDS, UES, UMS, ULS, and UOS.


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
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 Record Number

Identifies each job at a particular point in time. For most employees, the number will be zero. Employees with multiple concurrent jobs will have a unique record number for each job, assigned sequentially based on date of hire for each job. For most employees, the number will be zero. Per UW policy,after a job ends, the employee record number will be reused for future jobs.

Employee Record
Employment Class

A classification system used to group employees with common attributes; examples: FA = Faculty, SH = Student Hourly, CP = University Staff, etc.

Employee Record
Job Code

A five-character code that identifies the employee's job classification/title. For University Staff and student hourly positions it's a numeric code. Unclassified positions have alpha-numeric codes.

Employee Record
Lump Sum Payment

A one-time payment to an employee that does not increase the employee's base compensation rate.

Employee Record