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 |