Search Tags: first gen, UMS_FIRST_GEN, FGen

JIRA Reference:   DM-209 - SR - First Gen Enrollment Summary by Campus Closed DM-213 - SR - Enrollment Summary with First Gen Closed IR-6 - First Generation 2017 Report Done

Report Purpose

This query returns student's first generation data with other demographic data by admitted term, enrolled term and institution. Enrollment data is as of census date, however, the first generation data has not been archived by term yet.

Important!

Before First Generation information is accessed for reporting, the use case must be reviewed and approved. This process change is in recognition of the stringent requirements dictating the utilization of federal FAFSA data. A review of each use case for First Generation data ensures the highest standards of data protection for this restricted information. You may apply for approval by submitting your request using the First Generation Data Usage Request Form. For more information, please refer to the First Generation Coding Data Issue Documentation web page.


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_FIRST_GEN

Report Type

Query

Prompts Required

For information on field values to enter, click the name of the prompt.

Data Fields Generated

Admit TermEnrolled TermInstitutionAdmit Type DescCareerStudent LevelDegree NonDegAcad Plan DescrPlan TypeAcad PlanFull PartEMPLIDFirst GenFirst Gen CountBirthdateFirst NameMiddle NameLast name

Tables Used

UM_STUD_CENS_VW - Student Reporting Extract

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!

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.