These Help Guides describe reports developed for use by distributed users (department administrators) and central users, e.g., Office of Sponsored Program (OSP) administrators. The reports address pre-award activity.

There are some functional differences between the reports developed for central and distributed users, so be sure you use Guides appropriate to your role. Access to the reports is determined by an individual’s security permissions based on business roles.

Summary Table of Report Functionality
This table provides an overview of the Research and Sponsored Program reports. Use the table to identify which report to use to view particular kinds of data and/or to answer specific questions related to proposals and awards.

Report Guides

How to Run – Proposal Activity report
Execute this report to view details of all proposal submissions within a fiscal period or set of fiscal periods for an investigator, funds center, funds center group, school, campus, or sponsor. Proposals can also be searched by status and/or type.
Distributed report version / Central report version

How to Run – Award Activity – Grant Level report
Execute this report to view details of the award activity (new, renewal, continuation, incremental, or supplemental funding) that has taken place during a specified period by investigator, funds center, funds center group, school, campus, or sponsor. Grants can also be searched by award status and/or award type. This report displays data aggregated at the SAP Grant level. To see award activity broken out by individual sponsored programs, please use the Award Activity – Sponsored Program report.
Distributed report version / Central report version

How to Run – Award Activity – Sponsored Program Level report
Execute this report to view details of the award activity (new, renewal, continuation, incremental, or supplemental funding) that has taken place for all grants awarded during a specified period by investigator, funds center, funds center group, school, campus, or sponsor. Grants can also be searched by award status and/or award type. This report displays data broken out at the SAP Sponsored Program level. To see award activity aggregated at the SAP Grant level, please use the Award Activity – Grant report.
Distributed report version / Central report version

How to Run – Cumulative Award report
Execute this report to obtain a snapshot of a grant as of the date the report is run. Data displayed includes cumulative obligated amount to date and the amount of additional funding that is anticipated for each selected grant.  This report displays data aggregated at the SAP Grant level.
Distributed report version / Central report version

How to Run – Proposal and Award Summary report
Execute this report to obtain a summary of the number of proposals that were submitted and awards received within a given period. This report displays data aggregated at the SAP Grant level.
Version common to both distributed and central users

How to Run – Submitted Proposals and Funded Awards report
Execute this report to obtain proposal and award data points to show the relationship between a proposal and its associated award. This report displays data aggregated at the SAP Grant level.
Version common to both distributed and central users

How to Run – Multi-period Comparison report
Execute this report to compare the number and associated dollar amounts of proposals submitted and awards received during two fiscal periods. This report displays data aggregated at the SAP Grant level.
Version common to both distributed and central users

Quick Reference Guide – Funds Center Group Definitions

Funds Center Groups and Group Types are presented in a hierarchical format. Groups and group types are defined and maintained by individual schools and colleges. This Quick Reference Guide contains definitions of groups used by all schools currently using this feature.
BW QRG – GM Funds Center Group Definitions