Search Tags: Budget, HR, Position Management
DM-23Report Purpose
These reports provide a list of positions with salary and wages, fringes, account, fund, and other information by fiscal year and business unit. This query excludes positions where POS_BASE_BUDGET, POS_BASE_FRINGE, CURRENT_BUDGET, and CURR_FRINGE are all $0.
UMS_DTS_PM_BUDGET_RPT_NO_TOTAL is part of UMS_DTS_PM_BUDGET_RPT_LIST and has fewer fields.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Human Resources - Production > NavBar (compass icon, top right) > Navigator > Reporting Tools > Query > Query Manager or Query Viewer
Report Name
- UMS_DTS_PM_BUDGET_RPT_LIST
- UMS_DTS_PM_BUDGET_RPT_NO_TOTAL (has fewer fields)
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt.
Data Fields Generated
1. UMS_DTS_PM_BUDGET_RPT_LIST
| FISCAL_YEAR | BUSINESS_UNIT | FUND | OPERATING_UNIT | DEPT_DESCR | DEPTID | ACCOUNT | ACCT_DESCR | CLASS | PROGRAM_CODE | PROJECT_ID | ACCT_CD | TITLE | EMPLID | NAME | POSITION_NBR | DEPTID_HR | POS_BASE_BUDGET | POS_BASE_FRINGE | CURRENT_BUDGET | CURR_FRINGE | ANNUAL_RATE_SUM |
|---|
2. UMS_DTS_PM_BUDGET_RPT_NO_TOTAL
| FISCAL_YEAR | BUSINESS_UNIT | NAME | TITLE | POSITION_NBR | COMBO_CODE | DEPTID | FUND_CODE | ACCOUNT | CLASS_FLD | OPERATING_UNIT | FR_CURR | FR_BASE | S&W_CURR | S&W_BASE |
|---|
*POS_BASE_BUDGET and S&W_BASE are the same.
*POS_BASE_FRINGE and FR_BASE are the same.*CURRENT_BUDGET and S&W_CURR are the same.*CURR_FRINGE and FR_CURR are the same.
Table Used
UM_F_POS_BUD_VW - view of Posi & Budget extract
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.