Last Updated: 12/02/20
Principle
Principle/Use: Distribute Research Cost pool net balance. Based on grants and contracts revenue distribution from SAP postings
Source
SAP totals and IDC totals generated by Budget (dbo_budget_model_sap_summary)
View
dbo_Budget_model_sap_summary
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”
budget_model_line: “Grants and Contracts”
Reporting
Tableau
View: dbo_budget_model_ratio_sap_summary