Search Tags: faculty salary, wages
JIRA Reference:
DM-157
-
Faculty Wages
Parked
Report Purpose
This query provides budget variance (base vs actual) for faculty salary by fiscal year, accounting period, business unit, department ID, and account. This information is available in the GL Inquiry tool, however only by a single employee at a time. This report returns all employees for the selected department, and can be edited to suit the needs of any department. See also OFBRI Wages Variance.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer
Report Name
UMS_DTS_FACULTY_WAGES_VAR
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt.
Data Fields Generated
| FISCAL_YEAR | ACCOUNTING_PERIOD | BUSINESS_UNIT | DEPTID | DEPT_DESCR | ACCOUNT | ACCT_DESCR | BASE_BUDGET | ACTUALS_YTD | BUDGET_VARIANCE |
|---|
Tables Used
Criteria Used
- ACCOUNT between 50000 and 50403
- FUND_CODE in list ('00','03','04','10')
- SUM(A.UM_ACTUALS_YTD) <> 0 OR SUM(A.UM_BASE_BUDGET) <> 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.