Search Tags: facilities, budget, expense
JIRA Reference:
DM-150
-
Facilities Functional EX70
Parked
Report Purpose
This query provides base budget and actual YTD amounts for certain facilities expenses.
Uses FUND_CODE = '00' only.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer
Report Name
UMS_DTS_FAC_FUNC_EX70
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt.
Data Fields Generated
| FISCAL_YEAR | ACCNT_PERIOD | BUSINESS_UNIT | FUND_CODE | DEPTID | DEPT_DESCR | ACCOUNT | CLASS_FLD | ACCT_DESCR | BASE_BUDGET_SUM | ACTUALS_YTD_SUM | DEPT_EXP4 | DEPT_EXP4_D |
|---|
Tables Used
Criteria Used
- ACCOUNT BETWEEN 39999 AND 89999 and NOT in list ('84899','81500','71500')
- UM_DEPT_EXP2 - 2-Digit Department Expense Cd = 'EX70'
- FUND_CODE = 00
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.