Understanding the GM096 Grants Transaction History Queries in Cognos Analytics

The GM096 displays expense and budget transactions on sponsored (grant) chart strings. This report, when downloaded to Excel, can be used in conjunction ASRSP’s Expense Review Workbook template. The report contains two sections, “Expense Transaction Query” and “Budget Query”. When exported to Excel, the data will appear on separate tabs.

 

This report is used by Principal Investigators, Department Administrators, and ASRSP to review detailed transaction history by contract or project id. It can reduce compliance risk by providing departments with easier access to and greater detail regarding expenses posted to grants.

Step 1 Navigate to the report

Step 2 Respond to prompts and run the report

Prompt Descriptions

Report Results: Expense Transaction Query

Report Results: Budget Query

Column Definitions

 


Keywords: "grants management" grants understanding the gm096 transaction history queries cognos analytics
Created: 2017-10-31 13:59:18
Updated: 2021-05-24 14:10:46

Was this helpful?
0 reviews
Print Article

Details

Article ID: 1661
Created
Thu 5/12/22 12:39 PM
Modified
Fri 9/22/23 12:29 PM