Report Purpose
Data dump recreated from Discoverer for USM Institutional Research
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_1720_IR_USM_CRS_ALL
Prompts Required
Click on prompt for input information.
Data Fields Generated
| Strm | Institution | Emplid | Um nid usa | NAME_FORMATTED | Admit Term | Acad career | Acad prog | Acad prog descr | Um acad plan descr | Acad group | 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 | Acad Group | Acad Org | Acad Org Descr | Acad Prog | 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 Use
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
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.