Search Tags: UMA, budget, travel fund
JIRA Reference:
DM-269
-
Instate academic travel Fund 00 by Department by Account UMA no totals RT
Closed
Report Purpose
This query provides base budget, current budget, current actual, YTD actual, encumbrance, and budget balance for in-state academic travel fund 00 by department and account for UM Augusta.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer
Report Name
UMS_DTS_UMA_TRAVEL_FUND00
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt.
Data Fields Generated
| DEPTID | DEPT_DESCR | ACCOUNT | ACCT_DESCR | CLASS_FLD | BASE_BUDGET | CURR_BUDGET | ACTUALS_CURR | ACTUALS_YTD | ENCUMBRANCE | BUDGET_BALANCE |
|---|
Tables Used
Criteria Used
- BUSINESS_UNIT = UMS01
- FUND_CODE = 00
- SUBSTR(A.ACCOUNT,1,3) <> 659
- ACCOUNT between 61400 and 61401
- DEPTID (BETWEEN 1200004 AND 1262000) OR (BETWEEN 1465500 AND 1485599) OR (BETWEEN 1815501 AND 1815503)
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!
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.