PeopleSoft Grant’s Queries

Overview

·         Used to monitor and manage spending on sponsored funding

·         Must have Query Viewer access in PeopleSoft

o   May need to request access.  Have your Chair, Director or Dean send an email to Carol Mitton or Carol Lunn, and they will process your request with the UCC.

·         Three public queries:

o   U_GRNT_EXP_PROJ_CUM

o   U_GRNT_EXP_PROJ_DATES

o   U_GRNT_EXP_PROJ_FY

·         User prompts with each query

·         Instructions located on Research site of SharePoint

o   Link:  https://sharepoint.uno.edu/research/PS/Report%20Manual/Forms/AllItems.aspx

Query Results

·         Only includes items fully processed in financial system

o   May be delays for some items, especially payroll

·         If questions about results, contact Sponsored Programs Accounting

Responsibilities

Principal Investigator or Business Manager

·         Run queries for projects

The Office of Research and Sponsored Programs

·         If necessary, request changes to public queries

Sponsored Programs Accounting

·         Assist Principal Investigator or business manager if errors found in query results or unauthorized charges are found