earch Tags: UMS05, UM, NSFA, Budget 

JIRA Reference:   DM-264 - NSFA Balance All Funds Closed

Report Purpose

This query provides revenue and expense balances by department, program, and project for the University of Maine, College of Natural Sciences, Forestry, and Agriculture (NSFA).

Report Location

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

Report Name

UMS_NSFA_BALANCE_ALL_FUNDS

Report Type

Query

Prompts Required

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

Data Fields Generated

DEPT_CR_3DEPTIDFUND_CODEPROGRAM_CODEPROJECT_IDFUND_DESCRDESCRPROJ_MGR_NAMEPROG_MGR_NAMEPROG_STATUSPROJECT_STATUSFISCAL_YEARACCOUNTING_PERIODBEG_NABASE_REVENUECURR_BUD_REVPTD_REVREV_BALANCEBASE_EXPENSECURR_BUD_EXPPTD_ACTUAL_EXPENCUMBRANCEEXPENSE_BALANCENET_BALANCE


Tables Used

UM_GLQ_REPRTING - Ledger Data

Criteria Used

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 adjustment. Please contact the Change Management /Systems Security Analyst at 581-5420.

HELP IS AT HAND!

Round, red help button. Click to email DARTS.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.