Department Planning Profiles: Payroll
| Last Updated |
|---|
| 09/25/2023 |
| Description |
|
This interactive visualization provides October and March payroll data going back to 1993 and monthly payroll data for recent years. It includes FTE and Annual Payroll Amounts at the institution, division, department and subdepartment levels. |
| Report URL |
| https://data.wisc.edu/institution/department-planning-profiles/ |
| Data Cookbook URL (requires authorization) |
| https://uwmadison.datacookbook.com/institution/reports/27635/versions/66425 |
| Data Domain(s) |
| Budget |
| Access Restrictions |
| UW-Madison Employees (NetID Required) |
| Data Source Information |
| Badger Analytics, EPM, InfoAccess |
| Data View Information |
| UA_OCTOBER_PAYROLL, UA_MARCH_PAYROLL, UA_MONTHLY_PAYROLL_ALL, UA_UDDS_NAME, BAGP.DM.ACAD_DIVISION_DIM, BAGP.DM.ACAD_DEPARTMENT_DIM |
| Update Schedule |
| Weekly on Saturday at 11 pm |
| Responsible Office |
| Data, Academic Planning, and Institutional Research |
| Important Notes |
|
Limited Term Employees (LTEs), Student Hourlies, and Unclassified hourly workers are excluded. Funds and Program Codes Information on funds and program codes is available through the UW System Chart of Accounts, https://www.wisconsin.edu/financial-administration/accounting-and-budget-control/chart-of-accounts/ Fund Groups State Funds include funds: 101, 104, 105, 107, 108, 115, 116, 117, 118, 119, 126, 176, 177, 178, 402, 403, 406, 601 Academic Staff Instructional and Instr - CHS/Clinical Categories These categories include the following job codes: Instructional Pre-TTC: D11NN, D12NN, D13NN, D14NN, D21NN, D22NN, D23NN, D41NN, D42NN, D43NN, D44NN, D61NN, D62NN, D63NN, D73NN, D80AN, D80BN, D80DN, D80FN, D81BN, D81DN, D81FN, D91BN, D91NN, D92AN, D92DN, D92FN, D92LN, D95AN, D95DN, D95FN, D95LN, T04BN, T04DN, T04FN Instructional TTC: IC001, IC002, IC003, IC004, IC005, IC006, IC007, IC018, IC019, IC020, IC021, IC022, IC023, IC024, IC025, IC026, IC027, IC028, IC029, IC030, IC031, IC032, IC036, TL001, TL020, TL022, TL024, TL025, TL026, TL027, TL031, TL053, TL055, TL056 Instr - CHS/Clinical Pre-TTC: D00AN, D01NN, D02NN, D03NN, D04NN, D50AN, D51NN, D52NN, D53NN, D54NN Instr - CHS/Clinical TTC: IC008, IC009, IC010, IC011, IC012, IC013, IC014, IC015, IC016, IC017 Graduate Assistant Categories These categories include the following job codes: Program or Project Assistant Pre-TTC: Y42NC, Y42NG, Y42NN, Y43NC, Y43ND, Y43NG, Y43NN Program or Project Assistant TTC: SA005, SA006, SA007, SA008, SA019, SA020, SA021, SA022 Research Assistant Pre-TTC: Y41NN Research Assistant TTC: SA009 Teaching Assistant Pre-TTC: Y30NN, Y33ND, Y33NN Teaching Assistant TTC: SA004, SA011, SA012 Job Families/Groups Beginning with the March 2022 payroll data, the “Select Job Family/Group” filter uses job groups created by the Title and Total Compensation project. For older data, the filter uses job families. There is not a one-to-one relationship between job groups and job families. |
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 |
| FTE (Payroll) | Employee full-time equivalent from payroll used in budget considerations and official reporting. Excludes LTEs, student and unclassified hourly employees, certain post-degree training staff and graduate assistantships. |
Budget |
| Fund (Accounting) | Also known as appropriation, this is a 3 digit number set up by the Legislature to define the funding source and transactions that can be attributed to it. |
Finance |
| Program (Accounting) | A code assigned to classify institutional activities in accordance with NACUBO. |
Finance |
| UDDS | A UW System-wide, seven-character organizational code used to identify the Unit, Division, Department, Sub-department associated with a particular personnel, research, financial, or other activity or transaction. |
University of Wisconsin - Madison |