Search Tags: UMS05, UM, NSFA, ONF, Budget, HR. Position Management
JIRA Reference:
DM-34
-
pm budget rprt NSFA All Funds salary Rev
Closed
Report Purpose
This report provides list of positions with salary and wages, fringes, account, fund, and other information by fiscal year. It excludes positions whose BASE_BUDGET and BASE_FRINGE are both $0.
Results are for UMS05 , College of Natual Sciences, Forestry, and Agriculture (NSFA) only.
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_NSFA_PM_BUDGET_RPT
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt.
Data Fields Generated
| FISCAL_YEAR | FUND | DEPT_DESCR | DEPTID | ACCOUNT | ACCT_DESCR | CLASS | PROJECT_ID | PROGRAM_CODE | ACCT_CD | TITLE | NAME | EMPLID | POSITION_NBR | DEPTID_HR | BASE_BUDGET | BB_FRNG | ANNUAL_RT_SUM |
|---|
Tables Used
Criteria Used
(From UM_F_POS_BUD_VW )
- POSITION_NBR is not null
- DEPTID in ('5260100','5304100','5133100','5352100','5303100','5216100','5202982','5202922','5260921','5216982')
or BETWEEN 5200100 AND 5202101
or BETWEEN 5204100 AND 5214921
or BETWEEN 5364101 AND 5364102
or BETWEEN 5217100 AND 5217982 - SUM(UM_POS_BUD_BAS_AMT - UM_POS_BUD_PER_AMT) <> 0
or SUM(A.UM_POS_BUD_FRB_AMT - A.UM_POS_BUD_FRP_AMT) <>0
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.