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.