Employee Lump Sums

Last Updated
12/01/2022
Description

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
https://tableau.wisconsin.edu/#/views/EmployeeLumpSums/HomePage
Data Cookbook URL (requires authorization)
https://uwmadison.datacookbook.com/institution/reports/37638/versions/51021
Data Domain(s)
Employee Record
Access Restrictions
Employee Record Data Internal
Data Source Information
EPM, InfoAccess
Data View Information
EPM.PS_UW_HR_ALLJOB_VW, EPM.PS_UW_PY_NS_PYI_VW,InfoAccess.UDDS
Update Schedule
Weekdays
Responsible Office
OHR
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.

Definitions

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