Do you need to know what effort was proposed or awarded and don’t know where to look? Below are a few queries that can be used to assist in finding proposed and awarded effort in Compass.
Proposed Effort:
EU_GM_PROPOSED_EFFORT_BY_EMPLI
EU_GM_PROPOSED_EFFORT_BY_DELI
These queries swill show a person’s role on a proposal, the proposal title, and the proposed effort for pending proposals as of 9/1/09.
Awarded Effort:
EU_GM_AWARDED_EFFORT_BY_EMPLID
EU_GM_AWARDED_EFFORT_BY_DEPT
These queries will show a person’s role on an award, the proposal title, the awarded effort, and the awarded Directs/Indirects for awards. To find active rewards, enter today’s date in the Project End Date field.
Need help on running queries? The Division of Finance offers a Reporting Basics class that teaches the fundamentals of running queries as well as other reports. Class dates and times can be obtained by searching the course listings in Emory Self Service.