Search Tags: Budget, HR. Position Management
DM-21Report Purpose
This report provides a list of positions with salary and wages, fringes, account, fund, and other information by fiscal year and business unit. It excludes positions whose Base budget, Current budget, Base Fringe, and Current Fringe are all $0.
For FUND_CODE in ('00','03','10','12','22','23') only.
Since this report replaces one containing subtotals, the query will be flagged for replacement when a new BI tool is available. In the meantime, please use the subtotal function in Excel. Additional instructions for creating pivot tables is here.
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
- UMS_DTS_PM_BUDGET_RPT_MW_BUD (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
| FISCAL_YEAR | BUSINESS_UNIT | FUND | DEPTID_CF | DEPT_DESCR_CF | DEPTID_HR | DEPT_DESCR_HR | ACCOUNT | ACCT_DESCR | CLASS | OPER_UNIT | PROJECT | PROGRAM | ACCT_CD | POSITION_NBR | POSITION_TITLE | EMPLID | NAME | CLASS_INDC | BASE | BB_FRNG | CURRENT | CB_FRNG | POSN_STATUS | ACCT_CD_FRINGE |
|---|
2. UMS_DTS_PM_BUDGET_RPT_MW_BUD: ("TOTAL" is not on the query above. Everything else is the same.)
| FISCAL_YEAR | BUSINESS_UNIT | FUND | DEPARTMENT_CF | DEPTID_CF | ACCOUNT | ACCT_DESCR | POSITION_TITLE | NAME | BASE | BB_FRNG | TOTAL |
|---|
Tables Used
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.