Bootstrap Navbar Example

Department Planning Profiles: Summary Profile

This Page Last Updated
12/23/2025
Description

This interactive data visualization provides data trends for each division and department across 7 topic areas, including: Credit Allocation, Student Enrollments, Degrees/Certificates, Faculty Roster, Payroll, Budget, and Research Awards.

Report URL
https://data.wisc.edu/department-planning-profiles/
Data Cookbook URL (requires authorization)
https://uwmadison.datacookbook.com/institution/reports/27711/versions/80729
Data Domain(s)
Academic Planning, Employee Record, Research Administration, Student Record
Access Restrictions
All Uw Madison Employees
Data Source Information
InfoAccess
Update Schedule
Periodically, as new data become available
Responsible Office
Data, Academic Planning & Institutional Research
Important Notes

Data Sources and Notes

Academic Departments/Divisions

If a department appears in Badger Data & Analytics Platform table ACADEMIC_DEPARTMENT and the DEPARTMENT_STATUS = 'A', the department is considered academic. A division that contains an academic department is considered academic.

Department and Division Names

For academic departments and divisions: Badger Data & Analytics Platform table ACADEMIC_DEPARTMENT for the most recent fall term when the data were pulled.

For non-academic departments and divisions: InfoAccess table UA_UDDS_NAME as of when the data were pulled.

By Category
 

Budget

Source: InfoAccess table UA_BDGTSUM_HIST, where DATA_LEVEL = '3'
 

Credit Allocation

Sources: InfoAccess tables CFI_CREDIT_ALLOCATION and ACADEMIC_SUBJECT
 

Degrees/Awards

Sources: InfoAccess tables RETENTION_AWARDS_MAIN, RETENTION_AWARDS_PLAN, RETENTION_AWARDS_SUBPLAN, ACAD_STRUCTURE_PLAN star, FROZEN_ACAD_PLAN_ATTRIBUTES, FROZEN_SUBPLAN_ATTRIBUTES

Notes about specific metrics:

Degrees: [Total/Award Level] HC are counts of majors associated with awarded degrees. A student who received a degree for study in more than one major is counted once for each major. Also, a student who received more than one degree is counted once for each degree. Accordingly, counts at the department level should not be rolled up to the division level.

Degrees: Undergraduate FTE for a department or division is equal to the sum of, for each degree awarded by the department or division, 1 / [the number of majors associated with the degree]. At the institution level, this equals the number of undergraduate degrees awarded.

If any of the student's awarded subplans for the term/student/plan are service-based, the student is counted in the service-based metric and not in the not service-based metric.
 

Enrollments

Sources: InfoAccess tables FROZEN_ENROLLMENT_DEMO, FROZEN_ENROLLMENT_PLAN, FROZEN_ENROLLMENT_SUBPLAN, FROZEN_ACAD_PLAN_ATTRIBUTES, FROZEN_ACAD_SUBPLAN_ATTRIBUTES
 

Counts are as of the tenth day of class for each fall term.

Faculty Roster

Source: EPM table PS_UW_HR_OCTJOB_VW

Faculty tenure FTE: FTE of tenured/tenure-track faculty commitments within a department. Takes into consideration both a faculty member's employment FTE and the number of departments where tenure is held.

Faculty with tenure appointments in multiple departments have tenure FTE split among those departments. For example, if a faculty member is full-time (1.0 FTE) and holds equal tenured/tenure-track commitment in Chemistry and Biochemistry, their tenure FTE would be represented as 0.5 FTE in Chemistry and 0.5 FTE in Biochemistry.

Age calculations consider age as of July 1 in a given year.

Payroll

Source: InfoAccess table UA_OCTOBER_PAYROLL
 

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/

State Funds include funds: 101, 104, 105, 107, 108, 115, 116, 117, 118, 119, 126, 176, 177, 178, 402, 403, 406, 601.

Other Funds include all other funds.

Excludes student hourlies and unclassified hourly workers.

Research Awards

Wisconsin Data Mart (WISDM), Award Funding Actions

Related information and interactive data visualizations:
Credit Allocation - https://data.wisc.edu/credit-analysis/
Enrollment - https://data.wisc.edu/enrollment/
Degrees and Certificates - https://data.wisc.edu/degrees/
Faculty Roster - https://data.wisc.edu/department-planning-profiles/
Payroll - https://data.wisc.edu/department-planning-profiles/
Budget - https://data.wisc.edu/department-planning-profiles/
Research Awards - https://data.wisc.edu/department-planning-profiles/

Definitions

Name Functional Definition Data Domains
Academic Year (Su,Fa,Sp)

An academic year consists of sequential summer, fall, and spring terms. For example, the 2021-22 academic years includes summer 2021, fall 2021, and spring 2022.

Academic Planning
Budget (DPP)

Refers to summary budget allocations by category and program. For more information please visit:

https://apir.wisc.edu/institution/department-planning-profiles/

Finance
Credit Allocation (DPP)

Refers to metrics in Credits Follow the Department (CFD) and Credits Follow the Instructor (CFI) formats. For more information please visit the following link:

https://apir.wisc.edu/instruction/credit-analysis

Academic Planning, Student Record
Degrees and Certificates (DPP)

Refers to metrics on degree and other award trends; awards are assigned to the department that is the academic owner of the program. For more information please visit:

https://apir.wisc.edu/students/degrees

Academic Planning, Student Record
Department (Academic Structure)

An entity approved by academic governance to serve at least one of three academic purposes: serve as the academic home for a plan, serve as the academic home of a subject, or serve as a faculty tenure home. The status of an academic organization as academic owner is established through faculty/shared governance approval process; each plan and subject has one academic organization designated as an academic owner. Academic organizations are tied to the budgetary UDD (A####).

Academic Planning, Employee Record
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
Enrollment (DPP)

Refers to major enrollment trends. For more information please visit the following link:

https://apir.wisc.edu/students/enrollment

Academic Planning, Student Record
Faculty Roster (DPP)

Refers to tenure FTE by rank and age group. For more information please visit:

https://apir.wisc.edu/institution/department-planning-profiles/

Employee Record
Payroll (DPP)

Refers to budgeted FTE and payroll dollar totals by employee category. For more information please visit:

https://apir.wisc.edu/institution/department-planning-profiles/

Employee Record, Finance
Research Awards (DPP)

Refers to total research awards, with federal and non-federal disaggregation. For more information please visit: 

https://apir.wisc.edu/institution/department-planning-profiles/

Finance, Research Administration