earch Tags: UMS05, facilities 

JIRA Reference:   DM-178 - FM YTD Transactions- All Dept's-Nancy Closed

Report Purpose

This query provides base budget, current budget, encumbrance, actual current, and actual YTD amounts by account class for the UM Facilities Office.

Report Location

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

Report Name

UMS_DTS_FM_YTD_TRANS 

Report Type

Query

Prompts Required

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

Data Fields Generated

ACCT_CLASSACCT_DESCRBASE_BUDGETCURR_BUDGETENCUMBRANCEACTUALS_CURRACTUALS_YTD

Tables Used

Criteria Used

  • FUND_CODE = '00'
  • ACCOUNT between 40000 AND 89999
  • DEPTID in ('5750100', '5750104', '5751100', '5751101', '5751102', '5751103', '5752102', '5753100', '5753101', '5753102', '5753103', '5753104', '5753105', '5753106', '5753107', '5750101', '5750102', '5750106', '5750105', '5750103', '5751104', '5751105', '5751106', '5752100', '5752101', '5752103')


Calculation Used

/*-ACCT_CLASS*/
CASE WHEN A.CLASS_FLD < '01' THEN A.ACCOUNT || '-xx' ELSE A.ACCOUNT || '-' || A.CLASS_FLD END

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!

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.