EU_GM_AWARD_END_DATES
This query allows you to choose a department or range of department ID’s and a date range to see all awards that are ending in that date range.
• EU_GM_PROJ_LIST_BY_PROJ_DEPTID
This query allows you to choose a department or range of department ID’s and a date range to see all projects in the chosen department that are ending.
• EU_EM_PROJ_LIST_BY_CONT_DEPTID
This query allows you to choose a department or range of department ID’s and a date range to see all awards in the chosen department that are ending along with the associated project numbers.
Once it is determined which grants are ending, the following reports/queries can help determine the financial status:
• SPP2242 (nVision)
• SPP (FORS)
• EUOGC014 – GM Project Summary (Custom Report)
Another way to quickly see the financial status of grants that are ending is to review the Grant Quick View page in Compass.
• Grants
– Grants Quick View
-PI Awards/Proposals
-Award Summary
-Project Summary
More information regarding managing sponsored programs is available at:
http://www.osp.emory.edu/communication/handbook/index.cfm?intro
More information regarding managing sponsored programs can be obtained at the link above or: http://www.ogca.emory.edu/OGCA_documents/FinancialManagementCompassGrants.pdf More information regarding reports and queries to manage sponsored programs is available at: http://www.ogca.emory.edu/OGCA_documents/GrantsReportingGuide.pdf
If you have any questions regarding running the queries or reports above, please contact James Goff at james.goff@emory.edu or (404) 727-3419.