Department Planning Profiles: Summary Profile

Last Updated
04/25/2024
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/68036
Data Domain(s)
Academic Planning, Employee Record, 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
Data, Academic Planning & 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://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
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