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: |
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: |
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: |
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: |
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 |