A series of visualizations that are based upon the grant inventory within the COEUS grant management system, and the reconciliation of expenses incurred and captured within the FRS/URFinancials (Workday) accounting systems. These visualizations are meant to illustrate the dollar "burn rates" of a planned vs actual grant financial lifecycle, provide insight on proposed vs accepted awards for the principal investigators. 

Please note data caveats as of 1/13/2014:

The Scope of the visualizationis bound by following; 

• Grants are indicated as (FRS) Ledger 5 accounts or (URFinancials) GR FAO's
• Grant must be in COEUS
• Subcontracts are NOT included
• Activity Name "Conference" is excluded                   
• COEUS Award Effective Date >= 07/01/2005
• COEUS Final Expiration Date >= 07/01/2010
•  
• LLE is excluded except where the Primary Investigator is NOT in LLE. For example, a Grant for a PI in SMD may have a small award to LLE. Those LLE costs are included in Company - Medicine and Dentistry and Costcenter - LLE.
•  

The following conditions have been determined to exist and will affect the individual Company dollar totals for expenses against Grants. Overall the totals for the University remain unchanged.

·         Principal Investigator assignments have changed among company/divisions

·         URFinancial Conversion activity

·         Initial startup activity of URFinancials and COEUS reconciliations in progress

·         In some cases, Company is based on the Co-Investigator, not the Primary Investigator