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_SEM35

Prompts Required

Click on prompt for input information.


Data Fields Generated

TermInstitutionIDNID USAStudentAdmit TermCareerAcad ProgProgramAcad Plan DescrAcad GroupAcademic GroupTuition ResidStud LevelĀ  SumStudent LevelAcademic YearTake PrgrsTake PrgrsComponentSubjectCatalogDescrClass NbrComb Sects IDCourse IDSectionOffer NbrProgressInstructorCampusLocationModeDescriptionStatusGrade BaseField not activGrd Pt/UntCareerAcad GroupAcad OrgAcad Org DsecrAcad ProgCourse CarCrse CountInstructor NameSexAcad PlanEmailCap EnrlGrade InGradeGPAGPAEthnic GrpAdvisorAdvisr Lst NameAdvisr Fst NameAdmit TypeEthnic Grp DescDrop Dt

Tables Used

  1. UM_D_STD_ENR_VW - Student Enrollment Table
  2. UM_STUD_EXT_VW - Student Reporting Extract

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!

Round, red help button. Click to email DARTS.

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.