JIRA Reference:
DG-77
-
Pull campus mailing addresses
Closed
Report Purpose
This report can be used to pull all employee addresses with their supervisors.
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_SUPERVISOR_CONTACT
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt.
Data Fields Generated
| BUSINESS_UNIT | EMPLID | NAME_SORT | FIRST_NAME | LAST_NAME | POSITION_TITLE | CAMPUS_ADDRESS | CAMPUS | WORK_PHONE | LAST_PAY_END_DT | SUPERVISOR_NAME_SORT | SUPERVISOR_FIRST_NAME | SUPERVISOR_LAST_NAME | SUPERVISOR_POSITION | SUPERVISOR_EMAIL | SUPERVISOR_CAMPUS_ADDR | SUPERVISOR_CAMPUS |
|---|
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.