Employee Lump Sums
| Last Updated |
|---|
| 11/21/2024 |
| 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/77982 |
| Data Domain(s) |
| Employee Record |
| Access Restrictions |
| Employee Record Data Internal |
| Data Source Information |
| HRS/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 |