Ratio SAP1 - Cost Pool (Research)

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