Ratio SAP2 - Cost Pool (General Admission)

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