JIRA Reference:   DM-575 - List of UMPI GC Closed

Report Purpose

This report shows the list of grants and contract with PTD Expense, PTD Revenue, and YTD Expense.

Report Location

MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer

Report Name

UMS_DTS_GC_LIST

Report Type

Query

Prompts Required

For information on field values to enter, click the name of the prompt.

Data Fields Generated

BUSINESS_UNITProj CategoryFUNDProject IDDEPTIDProj DescrPTD ExpensesPTD RevenuesFiscal YTD ExpenseProj End Dt

Tables Used (For DARTS users only)

UM_GLQ_REPRTING - Ledger Data

Criteria Used

  • UM_PROJ_CATEGORY in ('GRANTS_CONTRACTS','SFA_GRANTS')
  • FUND_CODE =20
  • UM_PROJ_EFF_STATUS = A
  • DEPTID NOT BETWEEN 6999999 AND 7000091

New to PeopleSoft Query?

Click on Getting Started and begin with the Query Basics video

Need help running a report?

Click on Running Reports with Query Viewer & Query Manager or How to Run an SQR for simple how-to guides for running reports. If you've followed the path to an SQR location and cannot see the report, your PeopleSoft settings may need adjustments. Please see Security Questions (PS Query/Discoverer).

HELP IS AT HAND!

Link to compose email for help with website.Question, comment, critique? We are here to help and we strive to make our site a comprehensive, user friendly experience. Contact us at DARTS@maine.edu.