Search Tags: UMA, Budget, Part-time, overload
DM-268Report Purpose
These queries provide budget detail for part-time and overload positions.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer
Report Names
UMS_DTS_PART_TIME_OVERLOAD
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt.
Data Fields Generated
| ACCOUNTING_ID | POSITION_NBR | LINE_DESCR | DEPTID | FUND_CODE | ACCOUNT | POSITION_DESC | DEPTID_DESCR | PROGRAM_CODE | ACCT_DESCR | BASE_BUDGET | CURRENT_BUDGET | ACTUALS_CURR_SUM | YTD_ACTUAL | FISCAL_YEAR | ACCOUNTING_PERIOD |
|---|
Tables Used
Criteria Used
- A.DEPTID <> 1150503
- A.ACCOUNT in ('50001','50003','50004','50007','50008','50009','50012','50013','50014','50015','50016','50017','50018','50019','50300','50400','50401','50402','50403','50404','51001','51002','52001')
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!
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.