JIRA Reference:
DM-378
-
YE - Expense Analysis
Closed
Report Purpose
This report compares current year and prior year actuals and budget amounts.
It is by Functional Expense Category Code, Project ID, Program Code, and department.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer
Report Name
UMS_DTS_YE_EXPENSE_ANALYSIS
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt.
- Current Fiscal Year
- Prior Fiscal Year
- Accounting Period
- UM_DEPT_EXP2 - 2-Digit Department Expense Cd
Data Fields Generated
| Dept Exp 2 | Business Unit | Funding Source | Project ID | Proj Descr | Program Code | Prog Descr | Prog Restr 1 | Prog Restr 1 D | DEPTID | Dept Desc | Fund | NatExp | Natexp2 | Current Year Actuals | Prior Year Actuals | $ Var Actuals | CY Current Budget | PY Current Budget | Budget Incr (Decr) |
|---|
Tables Used (For DARTS users only)
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 adjustments. Please see Security Questions (PS Query/Discoverer).
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.