Recent Enhancements to the RAS Awards Report by Department

Contracts and Grants Accounting (CGA) updated the existing Awards Report by Department in the PeopleSoft Research Administration System (RAS) to further aid research administrators and departments in researching awards assigned by Department ID. The report lists and summarizes awards by total direct cost, total indirect cost, and total funding amounts. It can be run using multiple search parameters, such as Department ID, Sponsor ID, Award PI, Agreement Type, Purpose, Award End Date Status, and ARRA Type.

For this enhancement, we added the following new search filters and additional data in the report output to further assist in identifying and verifying awards without navigating various pages within PeopleSoft. Data results are grouped on the award-level information to eliminate duplicate lines when the search filters include Project Dept ID, Project RSA, and Project PI.

New Search Filters in the Awards Report by Department:

  1. Award Dept ID: Filter to search for Dept ID on the award level.
  2. Award RSA EID: Filter to search by RSA name or employee ID on the award level.
  3. Project Dept ID: Filter to search for awards with the project-level Dept ID.
  4. Project RSA EID: Filter to search for awards by RSA name or employee ID with the project-level RSA.
  5. Project PI: Filter to search for awards by PI name or employee ID with the project-level PI.
  6. Award Start Date From and Award Start Date To
  7. Award End Date From and Award End Date To
  8. Award Status: Filter to search for awards with the following status: Accepted, Advance, Cancelled, and Closed.

New Data Columns in the Awards Report by Department:

  1. Fed Flow Through: Displays the following Fed Flow Through information on the award (blank, if none):
    • 1-Funded 100%State/PrivateSrce
    • 2-Funded:Fed & State/Priv.Srce
    • 3-Funded100%Fed.allocSt/Pr.Agy
    • 4-Campus fndn endw income
    • 5-Campus fndn not endw income
    • 6-FundedPartFedARRASt/Priv.Src
    • 7-Funded100%FedARRASt/Priv.Src
  2. Fed Flow Through Type: Displays the following Fed Flow Through Type information on the award (blank, if none):
    • Non Fed Award
    • Fed Contract
    • Fed Grant/Other

Additional Updates or Features:

  1. Removed the ARRA Type filter and data column in the results.
  2. Removed the End Dt Status filter.
  3. Added a Personalize option in the Grid Action Menu icon.
  4. Added a Clear button to clear the search filters.
  5. Required Field -Error Message is displayed when no search filter is entered.
  6. Warning Limit Message is displayed when the number of rows returned exceeds 300 rows up to 19,999 rows.
  7. Error Limit Message is displayed when the number of rows returned is at or exceeds 20,000 rows, which should not allow the user to proceed.
  8. Note corresponding to asterisks (**) on search filter labels:

** Only awards with the Project Dept ID, Project PI, and Project RSA in the search filter will be displayed in the results.

If you need help researching a payment or have other questions about our collection and payment processes, email [email protected].