Search Tags: facilities, budget , revenue, expense
JIRA Reference:
DM-112
-
Kay Integrated Work Management System (IWMS) Project 8150024
Closed
Report Purpose
This report provides revenue and expense data for a specific project (PROJECT_ID = 8250145).
Report Location
MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer
Report Name
UMS_DTS_INTEG_WORK_MNGMT_SYS
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 | ACCT_GRP | BUDGET_ALLOCATION | SUBCATEGORY | ACCT | ACCOUNT_DESCR | DEPTID | FUND | OPER_UNIT | CLASS | CLASS_DESC | BASE_BUDGET | CURR_BUDGET | CURR_MONTH | YTD_ACTUAL | PTD_ACTUAL | EMCUMBER | TOT_PTD_ACTUAL_ENCUM | BUDGET_VARIANCE |
|---|
Tables Used
Criteria Used
- PROJECT_ID = 8250145
- ACCOUNT BETWEEN 30000 AND 89999
- FUND_CODE ='13'
- BASE_BUDGET <> $0 or CURR_BUDGET<> $0 or CURR_MONTH <> $0 or YTD_ACTUAL <> $0 or PTD_ACTUAL <> $0 or TOT_ENCUMBRANCE <> $0
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.