Search Tags: MEIF, grant, YE, Year end, balance, deficits, UMSAccounting
DM-81Report Purpose
This report provides budget, revenue, expense, and balance (deficits) for MEIF (Maine Economic Improvement Fund) programs.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer
Report Name
UMS_DTS_YE_DEFICITS_MEIF
UMS_DTS_YE_DEFICITS_MEIF2 (NOT including DEPTID ending with 000010 - 000099)
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt.
Data Fields Generated
| PROGRAM | PROG_DESCR | DEPTID | FUND | PROG_MANAGER | OPER_UNIT | PROJECT | PROJ_DESCR | PROJ_START_DT | PROJ_END_DT | PTD_REV_BUDGET | BOY_FUND_EQUITY | YTD_REVENUE | YTD_EXP | DEFICIT_BALANCE | BUSINESS_UNIT |
|---|
Tables Used
Criteria Used
- FUND_CODE in ('23', '04')
- UM_PROG_CAT2 - Program Category 2 = 'ST_APPROP'
(For UMS_DTS_YE_DEFICITS_MEIF2 only)
- SUBSTR(DEPTID, 2,6) NOT BETWEEN 000010 AND 000099
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.