JIRA Reference:  

Report Purpose

This audit report is looking for applicants who may need the FGEN Student Group added. 

  • The first set of people it looks for are those who, on the FAFSA, say their parents attended college, but on the application, they have a highest degree of Associates or lower. If employment information is provided and it supports less than a bachelor's degree, the Student Group for FGEN should be added manually.  
  • The second set of people it looks for are those where the FAFSA data is not equal to the attending college data, and where the parent's highest degree is less than a bachelor's degree or is blank.


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-9.2 > PS Query tile > Query Manager or Query Viewer

Report Name

UMC_FGEN_MISSING_STUDENT_GROUP

Report Type

Query

Prompts Required

None

Data Fields Generated

IDAdmit TermCreated OnNameFa Grd/LvlMo Grd/LvlHi Educ LvHi Educ LvCompleteInstitutionCompleted_Date

Tables Used

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.