Last Updated: 12/02/20
Principle
Distribute General Administration Cost pool net balance. Based on direct expenditures in SAP.
Source
SAP totals generated by Budget (dbo_budget_model_sap_summary)
View
dbo_Budget_model_sap_summary
Transaction_category: All Expense GL’s excluding the College training expense (GL’s 562xxx & 563xxx)
sap_amount_adjusted: sum
model_line_exclusion: " "
model_unit_level3: Not Like "Academic support" And Not Like "General Administration" And Not Like "Research" And Not Like "Student support" and not like “Facilities” and not like “University Press” and not like "Athletics"And Not Like "Breslow" And Not Like "University Services"
Reporting
Tableau
View: dbo_budget_model_ratio_sap_summary