Department Planning Profiles: Payroll
| Last Updated |
|---|
| 08/12/2022 |
| Description |
|
This interactive visualization provides October and March payroll data going back to 1993. It includes FTE and Annual Payroll Amounts at the institution, division, department and subdepartment levels. |
| Report URL |
| https://apir.wisc.edu/institution/department-planning-profiles/ |
| Data Cookbook URL (requires authorization) |
| https://uwmadison.datacookbook.com/institution/reports/27635/versions/63216 |
| Data Domain(s) |
| Budget |
| Access Restrictions |
| UW-Madison Employees (NetID Required) |
| Data Source Information |
| InfoAccess |
| Data View Information |
| UA_OCTOBER_PAYROLL, UA_MARCH_PAYROLL |
| Update Schedule |
| Twice per year, when October and March Payrolls are run. |
| Responsible Office |
| Academic Planning and Institutional Research |
| Important Notes |
|
Limited Term Employees (LTEs), Student Hourlies and Unclassified hourly workers are excluded. Information on funds and program codes are available through the UW System Chart of Accounts, https://www.wisconsin.edu/financial-administration/accounting-and-budget-control/chart-of-accounts/ Fund Groups 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 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 |
|---|---|---|
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |