Search Tags: MEIF, grant, match, UMSAccounting
DM-96Report Purpose
This report provides base budget and YTD actuals for MEIF (Maine Economic Improvement Fund) programs with account numbers of either 72400 or 72800 or 82400.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer
Report Name
UMS_DTS_MEIF_ALL_MATCH
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt.
Data Fields Generated
| BUSINESS_UNIT | PROGRAM_CODE | PROG_DESCR | GROUP | PROJECT_ID | FUND_CODE | DEPTID | DEPT_DESCR | BASE_BUDGET_SUM | YTD_ACTUALS | ACCOUNTING_PERIOD | FISCAL_YEAR | ACCOUNT |
|---|
Tables Used
Criteria Used
- ACCOUNTING_PERIOD =12
- DEPTID NOT in ('6380011','5400983','5501105','5000010','5000030')
- PROJECT_ID NOT in ('5250124','6250014')
- FUND_CODE = 23
ACCOUNT in ('72400','72800','82400')
- SUM (YTD_ACTUALS) <> 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.