Research Administration Compass Queries and Reporting

A list of useful research compass queries and reports are provided below.  


Query Name

Description

EU_GM_ACTIVE_AWARDS Lists all awards not closed or terminated
EU_GM_ACTUALS_BY_FUND GL Posted Amount Summary by Fund Code
EU_GM_PANS List of projects for existing PANS
EU_GM_PROPOSED_EFFORT_BY_EMPLI Pending Proposals in V101 status - select PI number
EU_GM_PROPOSED_EFFORT_BY_DEPT Pending Proposals in V101 status - select from/to Department
EU_GM_AWARD_SEARCH_SPONSOR Search Active Awards by Sponsor Name (may use partial name)
EU_GM_AWARDED_EFFORT_BY_EMPLI Award proposals in V102 status for selected PI. For active awards enter today's date in the Project End Date field.
EU_GM_AWARDED_EFFORT_BY_DEPT Award proposals in V102 status for selected Department. For active awards enter today's date in the Project End Date field.
EU_GM_PI_AWARD_SEARCH Search awards by PI. This query is case sensitive.
EU_GM_PROJ_LIST_BY_PROJ_DEPTID Project listing for a specific department.
EU_GM_PROJ_LIST_BY_CONT_DEPTID Listing of all projects based on Contract Department ID. Useful to determine all projects within a contract, including projects housed in a department other than the overall contract.
EU_GM_PROJ_TRANS_BY_CONTRACT Sponsored Program project transactions with prompt by Contract and transaction date. Source table Project Resource. Primarily used by OGCA finance office. Source of Sponsor, Expenses invoiced.
EU_GM_PROJ_TRANS_BY_PROJECT Sponsored Program project transactions with prompt by Project and transaction date. Source table Project Resource. Primarily used by OGCA finance office. Source of Sponsor, Expenses invoiced.
EU_GM_JRNLS Journals by department.
EU_GM_AR_FOR_A_CONTRACT List of invoices for a selected contract