veteran
Report Purpose
USM Veterans Services Coordinator requested that "term credits" be added to an existing admissions query (USM_AD_APPS_VETERANS) in order to identify veterans who had not yet registered for classes for the upcoming semester. JY reconstructed this query, joining the Student Career Term table (STDNT_CAR_TERM) with the Admission Applicant Program (UM_D_APPL_PG_VW) and adding the field "Units Taken for Progress" (UNITS_TAKEN_PRGRSS). JY also added an expression named "Registered?" where a zero indicates a student is not registered for any credits for the Enroll Term selected.
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_VETERANS_TERM_CREDITS
Prompts Required
For information on field values to enter, click the name of the prompt.
:1 = INSTITUTION - Institution |
:2 = ACAD_CAREER - Career |
:3 = ADMIT_TERM - Start Admit Term |
:4 = ADMIT_TERM - End Admit Term |
:5 = STRM - Enroll Term |
Data Fields Generated
| ID | Last | First Name | Admit Term | Term | Mil Status Code | Military Status | Address 1 | Address 2 | City | State | Postal | Phone | Acad Prog | Acad Plan | Sub-Plan | Application Status | Program Status | Take Prgrs | Registered for coursework? |
|---|
Tables Used
A. UM_D_APPL_PG_VW - Admission Applicant Program
B. SCC_PERDATA_QVW - PERSONAL_DATA Query View
C. UM_APPL_EXTRACT - Applicant Reporting Extract
D. STDNT_CAR_TERM - Student Career Term Table
Data Governance
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.