Search Tags: facilities, UMS accounting
JIRA Reference:
DM-183
-
YE- Repairs and Maintenance GL Detail
Closed
Report Purpose
This report provides data for facilities maintenance and repair by campus, department and account.
It shows changes and the percent of change for prior year and current year as of end of each year.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer
Report Name
UMS_DTS_YE_REPAIR_MAINT_GL_DET
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt.
- Fiscal Year (pick two years)
- Business Unit (Leave it blank if you want to see data from all business unit)
Data Fields Generated
| BUSINESS_UNIT | DEPTID | FUND | ACCOUNT | CLASS | ACCOUNT_DESCR | PRIOR_YEAR | CURRENT_YEAR | NET_CHANGE | %_CHANGE |
|---|
Tables Used
Criteria Used
- ACCOUNT between 64700 and 64900
- Accounting Period = 12
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!
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.