Report Purpose
Report returns student headcount, credit hours and FTE for all campuses, aggregated by term. This query, recreated from Discoverer, joins Academic Plans for each Campus with IPEDS CIP Code Definitions where Registrars have assigned CIP Codes (note: not all plans have CIP codes assigned to them)
Important Considerations
This report should be run in Scheduler because it uses student extract (UM_STUD_EXT_ARC - Student Reporting Extract Arch), which is extremely large.
Additionally, it will never match values for institutions engaging in cross-listing if they have any cross-listed enrollments for that semester.
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_STUD_EXT_ARC_WATCH
Prompts Required
For information on field values to enter, click the name of the prompt.
Data Fields Generated
| Institution | IN_OUT | STUDENT_LEVEL_SUM_UG_GRAD | HEADCOUNT | UM_UNT_TAK_PRG_RC | FTE |
|---|
Tables Used
DM-200
-
Stud Ext Archive Date Subquery Enrollment Watch
Closed
Discoverer Migration
New to PeopleSoft Query?
Click on Getting Started and begin with the Query Basics video
Need help running a query?
Click on Running Reports with Query Viewer & Query Manager for a quick how-to guide for navigating to PS Query and running a report.
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.