DARTS : MEIF - Revenue & Expense

Search Tags: MEIF, grant, AM061, Expense, Revenue

JIRA Reference: DM-84 - AM061 - Revenue & Expense - MEIF1 BI Tool BI-4 - Finance Reports for BI tool Open

Report Purpose

This report provides base budget, current budget, YTD actuals, PTD actuals, encumbrance, and balances for MEIF (Maine Economic Improvement Fund) projects.

Report Location

MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer

Report Name

UMS_DTS_AM061_REV_EXP_MEIF

Report Type

Query

Prompts Required

For information on field values to enter, click the name of the prompt.

Data Fields Generated

BUSINESS_UNIT	FUND	DEPTID	DEPARTMENT	DEPT_MANAGER	OPER_UNIT	Oper Unit Desc	PROGRAM	PROG_DESCR	PROG_MANAGER	PROJECT	PROJ_DESCR	PROJ_MGR_NAME	ACCT_GRP_DESCR	BASE_BUDGET	CURRENT_BUDGET	CURRENT_MON	YTD_ACTUAL	PTD_ACTUAL	ENCUMBRANCE	BUDGET_BALANCE

Tables Used

UM_GLQ_REPRTING - Ledger Data

UM_GLQ_ACCTA - GL reporting account attribute

Criteria Used

(From UM_GLQ_REPRTING - Ledger Data)

FUND_CODE = 23
ACCOUNT (BETWEEN 30000 AND 89999) AND (NOT IN ('80099','80399','81599','81699','81299','82299','84899','70099','70399','71299','71599','71699','72299','46999','66999'))
STATISTICS_CODE = ' '

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!

Round, red help button. Click to email DARTS.

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.