Department Planning Profiles: Summary Profile

Last Updated
12/01/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
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 (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
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
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