Last Updated: 12/02/20
Principle
Distribute Academic Support Cost pool net balance. This is based on two counts added together: Student
Headcounts and Faculty FTE.
Source
Student headcount data generated by IEA and Faculty FTE generated by Budget
(dbo_budget_model_ratio_student_headcount & dbo_budget_model_ratio_employee_detail)
View
1) dbo_Budget_model_ratio_student_headcount
Student_nuid: count
Model_unit: not like “Academic Support”
2) dbo_budget_model_ratio_employee_detail
Employee NUID: count
Model_unit: Not Like "Academic support" And Not Like "Athletics" And Not Like "Research" And Not Like
"Extension"
Employee_position_function: Faculty
Budget_model_employee_grouping_inclusion: Include
The faculty FTE comes from SAP primary job assignment in employee subgroups of J1, K1, F1, F2, L1, or
L2.
Reporting
Tableau
Views : dbo_budget_model_ratio_student_headcount & dbo_budget_model_ratio_employee_detail
Q&A
- Are the extension faculty included? No