Link to University of Wisconsin-Madison home page

RADAR

Repository for Administrative Data and Reports

Department Planning Profiles: Summary Profile

Last Updated
04/11/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/71883
Data Domain(s)
Academic Planning, Employee Record, Research Administration, Student Record
Access Restrictions
UW-Madison Employees (NetID Required)
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