JIRA Reference:
REPORT-476
-
Student Employees - Department Funds with Hours
Closed
Report Purpose
These reports student employee income, hours, and which department they work for. The first returns students paid with department funds, and the second shows those funded by Federal Work Study.
Although these do not work for all institutions, they can be easily duplicated upon request. Use our Data Request/Change Form to request report changes.
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
- USM_STUDENT_EARNINGS_DEPT - Department Funds
- USM_STUDENT_EARNINGS_FWS - FWS Funds Only
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt.
- Pay Period End greater than or equal to:
- Pay Period End less than or equal to:
- DEPTID_HR (This is used to refer to the DEPTID field in the Human Resources database, represented by an alpha code of up to 10 characters
Data Fields Generated
| FISCAL_YEAR | EMPLID | EMPL_RCD | NAME | DEPTID | DEPARTMENT | HOURLY_RT | TOTAL_EARNINGS | ACCT_CD | DEPTID_FIN | DEPARTMENT_FIN | FUND | ACCOUNT | PROGRAM | PROG_DESCR |
|---|
Tables Used
- UM_PAYEARNS_VW
- JOB - EE Job History
- DEPT_TBL - Departments
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.