JIRA Reference:
REPORT-576
-
Make a Query public
Closed
Report Purpose
The UMaine Admissions and Enrollment Offices use this query to pull information on Admitted/Matriculated students in the current funnel. It's used to report to the various colleges on campus each week. Additionally, it's used for Early Financial Aid reports along with various other reports that pertain to currently accepted students (who are active and have not been cancelled) and contains pertinent Transfer and First-year student info.
Fun Fact: The query also contains a subquery that determines the best address to which communications should be mailed. This could be useful to anyone who sends physical mailings to accepted students.
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
UMS05_ACCEPTED_STDNTS_ALL
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt.
Data Fields Generated
| Student_ID | Application_Number | Start_Term | Admit_Type | ADM_RES_FIXED | Program_Status | Academic_Program | Academic_Plan | Academic_Sup-plan | Program_Action | Program_Action_Reason | Program_Action_Date | First_Name | Middle_Name | Last_Name | Address_Line_1 | Address_Line_2 | City | State | Zip_Code | Country | Preferred_Phone_Number | Email_Address | Gender | High_School_GPA | Class Rank | Class Size | SAT_Math | SAT_Reading | SAT_Writing | SAT_Comp | ACT_Comp | Max SAT ERWS | Max SAT MSS | Merit_Category1 | Merit_Amount1 | Merit_Category2 | Merit_Amount2 | Merit_Category3 | Merit_Amount3 | Last_School_Attended | Transfer Credits | Admit Date | Net Confirm Date | Appl Ctr | PreferredName | SalutName | C-Index (ACT) | C-Index (Old to New SAT) | C-Index (RSAT) | Birthdate |
|---|
Tables Used
ADM_APPL_DT_VW1 - Adm Appl Data view used by CC
ADM_APPL_PROGVW - Admission Applicant Program
ADM_APPL_PLAN - Admission Applicant Plan
ACAD_PROG - Student Academic Program
ACAD_PLAN_ - Student Academic Plan Table
UM_APPL_EXTRACT - Applicant Reporting Extract
ADM_COMMENTS - Admission Comments Setup Table
EARLY_FA_OFFER - Early Financial Aid Offer
EARLY_FA_CATGS - Early Financial Aid Categories
ADM_APPL_CMP - Adm Application Componet
UM_EXT_ORG_VW2
ADM_APPL_SBPLAN - Admission Applicant Subplan
ACAD_SUBPLAN - Student Academic Subplan Table
SCC_PERS_PH_QVW- Phone Numbers Query View
RESIDENCY_OFF - Official Residency Data
STDNT_EQUTN_VAR - Student Equation Variables
UM_NAMES_PRF_VW
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.