Report Purpose
This query returns current data for students enrolled in classes for credit by institution and term. It was recreated from Discoverer for USM Institutional Research, then prompted for use by all institutions.
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_IR_USM_CRSE_INFO
Prompts Required
For information on field values to enter, click the name of the prompt.
Data Fields Generated
| Strm | Institution | EMPLID | NID USA | NAME_FORMATTED | Admit term | Acad career | Acad prog | Acad prog descr | Um acad plan descr | Acad group 2 | Um acad grp descr | Residency | STUDENT_LEVEL_SUM | STUDENT_LEVEL | ACADEMIC_YEAR | Unt taken prgrss SUM | Tot taken prgrss SUM | Ssr Component | Subject | Catalog Nbr | Descr | Class Nbr | Sctn Combined Id | Crse Id | Class Section | Crse Offer Nbr | Unt Prgrss SUM | Instructor Id | Campus | Location | Instruction Mode | Descr Location | Stdnt Enrl Status | Grading Basis Enrl | Grading Scheme Enr | Grd Pts Per Unit SUM | Acad career 2 | Acad group | Acad Org | Acad Org Descr | Acad prog 2 | Crse Career | Crse Count SUM | INSTRUCTOR_NAME_FORMATTED | Sex | Acad plan | Email addr | Enrl Cap | Crse Grade Input | Crse Grade Off | Cum gpa SUM | Cur gpa SUM | Ethnic grp cd | Advisor Id | Um advisr lst name | Um advisr fst name | Admit type | ETHNIC GROUP |
|---|
Tables Used
DM-10
-
1720 IR - USM Course Info Student Dump, 1720 IR - USM Course Info Student Dump SEM35, 1720 IR - USM Course Info Student Dump SEM35 ALL
Closed
Discoverer Migration, campus solutions, universal
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.