Report Purpose
Custom report for the UM Office of Sponsored Programs that returns expenditures from specific accounts (other than payroll) for projects coded by project ID and fund code. Designed for Grants and Contracts.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer
Report Name
UMS_DTS_UM_JRNL_APPR_VW_CW
Prompts Required
None
Tables Used
Data Fields Generated
| BUSINESS_UNIT | BUSINESS_UNIT_IU | SOURCE | JOURNAL_ID | DESCR254 | JOURNAL_DATE | POSTED_DATE | JOURNAL_LINE | JRNL_LINE_SOURCE | LINE_DESCR | JRNL_LN_REF | NAME | OPRID | NAME50 | ACCOUNT | CLASS_FLD | DEPTID | FUND_CODE | PROGRAM_CODE | PROJECT_ID | Sum Amount |
|---|
Tables Used
DM-203
-
Jrnl for Non-Comp Expenditures by Project ID & Fund Code
Closed
Discoverer Migration
New to PeopleSoft Query?
Click on Getting Started and begin with the Query Basics video
Need help running a query?
Click on Running Reports with Query Viewer & Query Manager for a quick how-to guide for navigating to PS Query and running a report.
HELP IS AT HAND!
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.