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
State Funds include funds: 101,104,105,107,108,115,116,117,118,119,126,176,177,178,402,403,406,601
Auxiliaries include funds: 120,127,128,129,130,131,136,139,183,501,526,528,529,530
Gifts and Grants include funds: 133,135,137,154,159,161,165,166,167,169,172,182,185,187,190,233,533
Federal Funds include funds: 141,142,143,144,145,146,147,150,199

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