earch Tags: UMS05, UM, NSFA, Budget
JIRA Reference:
DM-116
-
CURRENT Budgets Detail
Closed
Report Purpose
This query provides current budget details for UMaine, 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_CURR_BUDGET
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt.
- JOURNAL_DATE From
- JOURNAL_DATE To
- FUND_CODE
- DEPT_CR_3
- Program Code
- Project ID
- Account FROM
- Account TO
- Deptid
Data Fields Generated
| Fiscal Year | Acct Period | Fund | Dept_Cr_2 | Dept_Cr_3 | Deptid | Deptid Descr | Program | Program Descr | Proj Id | Proj Descr | Proj Mgr Id | Proj Mgr | Proj Status | Proj Start Dt | Proj End Dt | Acct Grp | Acct Cat D | Acct Subcat D | Account | Class | Line Descr | Amount | Jrnl Date | Jrnl ID | Jrnl Ln Ref | Long Descr |
|---|
Table Used
Criteria Used
- A.DEPTID in tree (UMSYS,,UMS_DEPT_ORG,2018-07-01,5NSFA)
- A.BUSINESS_UNIT= UMS05
- A. ACCOUNTING_PERIOD between 1 and 12
- B.LEDGER_GROUP = 'BUDGET'
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.