JIRA Reference:
DM-560
-
Applicant Listing Admitted but Not Enrolled
Closed
Report Purpose
This query pulls in data for degree-seeking first-year students who were admitted to the UMS but did not subsequently enroll. Data from this query are used to send a submission file to the Clearinghouse to determine if/where the student ended up enrolling. This query is a data source for the UMS Unrequited Love analysis.
Note: This query would require adjustment to accurately return UM, UMA, and UMF data.
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_IR_ADMIT_NOT_ENROLLED_FYR
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt.
Data Fields Generated
| Institution (code) | Institution (short) | Term | ID | Last | First Name | Middle | Suffix | Birthdate | Admit Date | Enroll Date | Career | Admit Type | Action Date | Prog Actn | Action Rsn | Status | Acad Plan | Plan Type | Sub-Plan | Acad Plan Appl | Acad Plan CIP Code | Acad Plan Appl CIP Code | Tuition Resid | Postal | Sex | case when F.UM_MULTIPLE_ETHNIC |
|---|
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.