Search Tags: active, student, faculty, staff, cs
JIRA Reference:
Report Purpose
These reports return all students (1) and all faculty and staff (2) currently enrolled or employed in the University of Maine System. As these are large datasets, they must be run in the scheduler to return all rows.
These reports can be used any time all EMPLIDs, Names and User IDs are needed for all active students, faculty and staff.
Report Location
MyCampus > MaineStreet > Enterprise Applications > Campus Solutions-92-Reporting > PS Query tile > Query Manager or Query Viewer
Note - If your CSRPT Reporting Homepage dashboard does not have a PS Query tile, contact the UMS - Campus Solutions Security Liaisons for your institution.
Report Name
- UMS_DTS_ALL_ACTIVE_STAFF
- UMS_DTS_ALL_ACTIVE_STUDENT
Report Type
Query - Run in Scheduler
Prompts Required
For information on field values to enter, click the name of the prompt.
1. STRM is Greater Than:
Data Fields Generated
1.
| INSTITUTION | CAMPUS | EMPLID | NAME | USERID | EMAIL_BUSINESS | EMPL_CLASS | UNION |
2.
| INSTITUTION | RELATIONSHIP | EMPLID | NAME | USERID | EMAIL_BUSINESS | |
Tables Used
1.
2.
- UM_STUD_EXT_VW - Student Reporting Extract
- SCC_EMAIL_QVW - Email Address Query View & EMAIL_ADDRESSES - Email Addresses
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.