Search Tags: salary and wages, student, faculty
DM-313Report Purpose
These queries provide summary tables for faculty salary and students wages for all business unit by fiscal year, accounting period, and fund code.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer
Report Name
UMS_DTS_DJ_SAL_WAGES_FACULTY (For faculty)
UMS_DTS_DJ_STUDENT_WAGES (For students)
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt.
UMS_DTS_DJ_SAL_WAGES_FACULTY:
- Fiscal Year
- Accounting Period
- Fund Code (Leave blank to get all of the fund codes)
UMS_DTS_DJ_STUDENT_WAGES:
Data Fields Generated
(The images below are blurred to protect privacy.)
UMS_DTS_DJ_SAL_WAGES_FACULTY:
UMS_DTS_DJ_STUDENT_WAGES:
Tables Used
Criteria Used
UMS_DTS_DJ_SAL_WAGES_FACULTY:
- ACCOUNT between 50000 AND 50101
- SUM(A.UM_ACTUALS_YTD) <> 0
UMS_DTS_DJ_STUDENT_WAGES:
- ACCOUNT between 53000 AND 53899
- STATISTICS_CODE = ' '
- DEPTID in list ('5165100', '5166103', '5166104', '5166106', '5166107', '5173100', '5174100', '1152005', '1152550', '1705000', '2220200', '3310000', '3350000', '4140000', '7407102', '7407103', '7401600', '6152004', '6152006', '6152007', '6152010', '6152011', '6153013', '6705000', '6706000')
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.