Search Tags: Budget, HR. Position Management
DM-18Report Purpose
This report provides a list of positions with FTE, salary and wages, fringes, account, fund, and other information by fiscal year and DEPTID. It returns positions with POS_BASE_BUDGET>$0 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_FTE
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt.
- Fiscal Year
- DEPTID
Data Fields Generated
| FISCAL_YEAR | BUSINESS_UNIT | FUND_CODE | DEPT_DESCR | DEPTID | ACCOUNT | ACCT_DESCR | UNION_DESCR | CLASS_FLD | OPERATING_UNIT | PROGRAM_CODE | PROJECT_ID | ACCT_CD | TITLE | EMPLID | NAME | POSITION_NBR | DEPTID_HR | REG_TEMP | POS_BASE_BUDGET | POS_BASE_FRINGE | CURRENT_BUDGET | CB_FRINGE | FTE_EQUIV_SUM | EFF_STATUS | POSN_STATUS | FTE_SUM | EMPL_RCD_SUM | ANNUAL_RT_SUM |
|---|
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.