JIRA Reference:
Report Purpose
This comprehensive report is used by Admissions, Enrollment Management, and Institutional Research. It returns the most complete and accurate data on UMaine's Application Funnel.
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
UM_EM_ADM_FUNNEL_W_SCORES_MJK2
Report Type
Query
Prompts Required
For information on field values to enter, click the name of the prompt.
Data Fields Generated
| ID | ADM_APPL_NBR | APPL_CENTER | ADMIT_TYPE | APPLICATION_TYPE | FIRST_NAME | MIDDLE_NAME | LAST_NAME | ADDRESS_1 | ADDRESS_2 | CITY | STATE | ZIP_CODE | COUNTY | COUNTRY | PHONE | GENDER | BIRTHDATE | ETHNICITY | ADM_RESIDENCY | Max SAT ERWS | Max SAT MSS | SAT COMP | SAT_MATH | SAT_VERBAL | SAT_WRITE | SAT_COMP | ACT_MATH | ACT_ENGLISH | ACT_COMP | ACT_READ | HS_GPA | COLLEGE_GPA | EXTERNAL_GPA | LAST_SCHOOL_ID | LAST_SCHOOL_CEEB | LAST_SCHOOL_DESC | LAST_SCHOOL_CITY | LAST_SCHOOL_STATE | CLASS_RANK | CLASS_SIZE | Grad Dt | APPL_COMPLETE | APPLY_DATE | APPLY_PROG | APPLY_PLAN | ADMIT_DATE | ADMIT_PROG | ADMIT_PLAN | CONFIRM_DATE | CONFIRM_PROG | CONFIRM_PLAN | CANCEL_DATE | CANCEL_PROG | CANCEL_PLAN | APPLY | ADMIT | CONFIRM | CANCEL | DENY | DEFER | DEFER_TERM | ENROLL | OFFERED_HONORS | MAX_ACAD_PROG | MAX_ACAD_PLAN | Date | Created | Updated | Status | Prog Actn | Action R |
|---|
Tables Used
- ADM_APPL_DT_VW1 - Adm Appl Data view
- 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_APPL_CMP - Adm Application Componet
- STDNT_CAR_TERM - Student Career Term Table
- ADM_COMMENTS - Admission Comments Setup Table
- EXT_ORG_TBL_ADM - External Org Admissions
- SCC_EMAIL_QVW - Email Address Query View
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.