Queries

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 FGC 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 FGC 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