Department Planning Profiles: Summary Profile

Last Updated
08/12/2022
Description

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

Report URL
https://apir.wisc.edu/institution/department-planning-profiles/
Data Cookbook URL (requires authorization)
https://uwmadison.datacookbook.com/institution/reports/27711/versions/43679
Data Domain(s)
Academic Planning, Employee Record, Finance, Research Administration, Student Record
Access Restrictions
UW-Madison Employees (NetID Required)
Data Source Information
InfoAccess
Data View Information
DPP_SUMMARY
Update Schedule
Weekly
Responsible Office
Academic Planning and Institutional Research
Important Notes

Data Source by Category
Credit Allocation: InfoAccess tables CFI_CREDIT_ALLOCATION, FROZEN_SUBJECT_CODES
Enrollments: InfoAccess tables FROZEN_ENROLLMENT_DEMO, FROZEN_ENROLLMENT_PLAN, FROZEN_ENROLLMENT_SUBPLAN,FROZEN_ACAD_PLAN_ATTRIBUTES, FROZEN_ACAD_SUBPLAN_ATTRIBUTES
Degrees and Certificates: InfoAccess tables RETENTION_AWARDS_MAN, RETENTION_AWARDS_PLAN, RETENTION_AWARDS_SUBPLAN,FROZEN_ACAD_PLAN_ATTRIBUTES, FROZEN_SUBPLAN_ATTRIBUTES
Faculty Roster: EPM table PS_UW_HR_OCTJOB_VW
Payroll: InfoAccess table UA_OCTOBER_PAYROLL
Budget: InfoAccess table UA_BDGTSUM_HIST
Expenditures: SUMMARIZED_ACCOUNTING
Research Awards: Wisconsin Data Mart, Award Funding Actions

InfoAccess table UA_UDDS_NAME

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

Definitions

Name Functional Definition Data Domains
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
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
Division (Academic)

An academic group of the University, defined in Faculty Policies & Procedures Chapter 3 and led by a dean or director who reports to the provost, that serves as a school, college or like unit. Each academic program code has an academic division assigned.

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
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
Expenditures (DPP)

Refers to summary expenditures by expenditure category and program. For more information please visit:

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

Finance
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