JIRA Reference:   REPORT-475 - Current Budgets for OFBRI Closed

Report Purpose

This query provides budget variance (base vs budgeted), for OFBRI (Forest Bioproducts Research Institute). This information is available in the GL Inquiry tool, however only by a single employee at a time. This report returns all employees for the selected department, and can be edited to suit the needs of any department. See also Faculty Wages Variance.

Report Location

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

Report Name

UMS_DTS_CURRENT_BUDGET_OFBRI

Report Type

Query

Prompts Required

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

FISCAL_YEAR

ACCOUNTING_PERIOD

Data Fields Generated

FISCAL_YEARACCOUNTING_PERIODBUSINESS_UNITDEPTIDDEPT_DESCRFUND_CODEFUND_DESCRACCOUNTACCOUNT_DESCRPROGRAM_CODEPROG_DESCRPROJECT_IDPROJ_DESCROPER_UNITOPUN_DESCRCLASS_FLDCLASS_DCURR_BUDGETACTUALS_CURR_MONACTUALS_YTD

Tables Used


UM_GLQ_REPRTING - Ledger Data

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 adjustments. Please see Security Questions (PS Query/Discoverer).

HELP IS AT HAND!

Link to compose email for help with website.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.