DARTS : UMS08 Facilities by Month

Report Purpose

Provide base budget, current budget, total expense, encumbrance, projection, and available amount by department and account for each month.

Report Location

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

Report Name

UMS_DTS_FACILITIES_BY_MONTH
UMS_DTS_CONDO_ASSO_OP_BUDGET (For Condo Association , DEPTID =8150110 only & PROGRAM_CODE = 89844)

Report Type

Query

Prompts Required

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

UMS_DTS_FACILITIES_BY_MONTH:

UMS_DTS_CONDO_ASSO_OP_BUDGET:

Fiscal Year

Data Fields Generated

UMS_DTS_FACILITIES_BY_MONTH:

DEPTID	DEPT_DESCR	ACCOUNT	ACCT_DESCR	CLASS_FLD	CLASS_DESC	BASE_BUDGET	CURR_BUDGET	JUL	AUG	SEP	OCT	NOV	DEC	JAN	MAR	APR	MAY	JUN	TOTAL_EXPENSES	ENCUMBRANCE	PROJECTION	AVAILABLE

UMS_DTS_CONDO_ASSO_OP_BUDGET:

ACCT_CAT_D	ACCT_SUBCAT_D	ACCOUNT	ACCT_DESCR	CLASS	JULY_ACTUAL	AUG_ACTUAL	SEP_ACTUAL	OCT_ACTUAL	NOV_ACTUAL	DEC_ACTUAL	JAN_ACTUAL	FEB_ACTUAL	MAR_ACTUAL	APR_ACTUAL	MAY_ACTUAL	JUN_ACTUAL	YTD_TOTAL	ENCUMBRANCE	FISCAL_YEAR

Tables Used

UM_GLQ_REPRTING - Ledger Data

Criteria Used

UMS_DTS_FACILITIES_BY_MONTH:

ACCOUNT BETWEEN 50000 AND 89999
FUND_CODE = '00'
DEPTID in list ('8350100', '8350101', '8350103', '8350104', '8350105', '8350106', '8350107', '8350108', '8350109', '8350110')

UMS_DTS_CONDO_ASSO_OP_BUDGET:

ACCOUNT BETWEEN 40000 AND 89999
FUND_CODE = '50'
DEPTID = 8150110
OPERATING_UNIT = 830
PROGRAM_CODE = 89844
BUSINESS_UNIT = UMS08

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.