FAB Grants Reports Overview

Query Name Description Report(s) Available
GRANTS Available Budget Balance This query provides Net Budget, Activity Fiscal YTD, Open Commitments, and the Available Budget Balance by GL Account or Budget Account within an Area, Department, or Project.
  1. Budget Account Summary by Department/Project
  2. Budget Account Summary by Area/Department
  3. Budget/GL Account Summary by Department/Project
  4. Budget Account Summary by Area
GRANTS Available Budget Balance Enhanced This query provides Net Budget, Activity Fiscal YTD, Open Commitments, and the Available Budget Balance by GL Account or Budget Account within an Area, Department, or Project.
  1. Budget Account Summary by Department/Project
  2. Budget Account Summary by Area/Department
  3. Budget/GL Account Summary by Department/Project
  4. Budget Account Summary by Area
Grants Inquiry This query provides sponsored project information previously available through the mainframe DPA and DPD screens. This query also provides contract information previously availble on the DFC report.A reference document is available in the report for code descriptions.
  1. Project Activity Summary
  2. Project Account Summary
  3. Project Detail
Project Run Rate This query provides information on financial performance of sponsored projects. It provides six and twelve month average spending by project. Projects can be selected either individually or by PI. This is particularly useful for PIs who manage multiple projects or for research centers with multiple funding sources. This query gives a historical perspective and is helpful in predicting future spending.
  1. Project Run Rate Report
Sponsored Award Financial Report Due This query lists the sponsored awards that currently have a financial report due date assigned.
  1. Report by Contract Number
  2. Report by PI
  3. Report by Department
Sponsored Contracts and Projects Summary This query provides a summary of the budget, expenditures, commitments and the available budget balance for Sponsored Contracts and Projects.
  1. Contracts with Sponsor Name by Contract
  2. Contracts with Director by Contract
  3. Projects with Sponsor Name by Project
  4. Projects with Director by Project
  5. Contracts with Sponsor by Department
  6. Contracts with Director by Department
  7. Projects with Sponsor by Department
  8. Projects with Director by Department
Sponsored Payroll Fringe Report This query provides sponsored project information for the payroll activity and related fringe and F&A costs from 7/1/05 through the current date.
  1. Fringe Benefit Detail Report by Project, by Name
  2. Fringe Benefit Detail Report by Project, by Name by Project
  3. Fringe Benefit Detail Report by Project, by Project by Name
  4. Fringe Benefit Detail Report by Project, by Name by Project For Project Corrections Only
Sponsored Project Chartstring Listing This query provides a listing of project chartstrings with the BudRef Start and End Dates for each project combination.Also listed are the Contract Number, Award Start and End Dates, Project Description and the PI Name.
  1. Listing by Project Id
  2. Listing by Contract Number
  3. Listing by Department
  4. Listing by PI Name.
Sponsored Project Expenditures by Fiscal Year This query provides summary and detail information of project to date expenditures by fiscal year.
  1. Transaction Detail by Department, Project, Account
  2. Budget Category Summary
  3. Account, Budget Category Summary
Sponsored Project Payroll Activity Detail This report will list Sponsored project payroll transactions for employees by:

  • Project
  • Activity
  • Budget Ref
  • Fund
  • Department
  • Program
  • Account
  • Journal Date

for the desired journal dates. Any report run today will include activity from the close of business of the previous day. This is the sponsored version of the Payroll Activity Detail Report.

You are limited to viewing information based on your PeopleSoft security.
  1. Employee Summary
  2. Payroll Activity Detail by Employee
  3. Payroll Activity Detail by Project
  4. Payroll Activity Detail by Department by Project
Sponsored Project Payroll FYTD Summary This report will list total labor charges and open commitments for each employee by Project / Account for the current fiscal year to date. Any report run today will include activity from the close of business of the previous day.You are limited to viewing information based on your PeopleSoft security.
  1. Payroll Fiscal Year to Date Summary
Sponsored Projects with Cost Sharing Required This query provides summary and detail information of the Cost Share required budget, expenditures, commitments and the Net Cost Share budget balance for Sponsored Projects.
  1. By Department
  2. By Sponsor
  3. By Department (with page break)
  4. By Sponsor (with page break)