JIRA Reference:
REPORT-390
-
Admissions Funnel Data for Ruffalo Noel Levitz
Closed
Report Purpose
Data from this report was supplied to an outside marketing vendor in order to determine how Academic Programs and Program Admission Funnels align with the current labor market.
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_APP_ADM_ENR_FUNNEL_RNL
Report Type
Query
Prompts Required
Data Fields Generated
| ID | Term | Case When A.INSTITUTION = 'UMS | Institution | Admit Type | Funnel Stage | Zip Code | State | Major 1 | Major 2 | Online |
|---|
- ID is derived from a standard calculation on the student's EMPLID.
- Major 1 is the major which the student applied for.
- Major 2 is the major to which the student was admitted.
Tables Used (For DARTS users only)
- UM_APPL_EXT_VW - Applicant Reporting Extract
- STDNT_GRPS - Student Groups
- ACAD_PLAN_TBL - Academic Plan Table
- UM_STUD_CENSUS - Student Reporting Extract Arch
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.