DARTS : MEIF - R&D Transfers

Search Tags: MEIF, grant, transfer, UMSAccounting

JIRA Reference: DM-97 - MEIF-ALL4-All Rpt R and D Transfers Closed BI-4 - Finance Reports for BI tool Open

Report Purpose

This report provides base budget and YTD actuals for each MEIF (Maine Economic Improvement Fund) Research and Development (R&D) program.

Report Location

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

Report Name

UMS_DTS_MEIF_ALL_R_AND_D_TRANS

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	FUND_CODE	DEPTID	DEPT_DESCR	BASE_BUDGET_SUM	YTD_ACTUALS	ACCOUNTING_PERIOD	FISCAL_YEAR	ACCOUNT

Tables Used

UM_GLQ_REPRTING - Ledger Data

Criteria Used

ACCOUNTING_PERIOD =12
DEPTID NOT in ('5000010','5000030')
PROGRAM_CODE <> 69124
ACCOUNT (BETWEEN 70000 AND 72300) OR (BETWEEN 80000 AND 82300)
FUND_CODE = 23

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.