Ratio SAP1 - State Appropriation (Sponsored Activity)

Last Updated: 12/02/20

Principle

Principle/Use: Distribute State Appropriations (40%) of sponsored activity incentive. 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

Q&A

  1. Why is University Press excluded? Auxiliary units are not funded from State Appropriations