Search Tags: first gen, UMS_FIRST_GEN, FGen
JIRA Reference:
Report Purpose
This audit report generates a list of people who have had the FGEN Student Group added by the BATCH user, perhaps in error. It looks for any person who has a relationship with the student and has a bachelor's degree or higher. It is finding people who have a relative other than a parent or step-parent who meets this criterion. In these cases, the FGEN Student Group is correct.
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_FIX
Report Type
Query
Prompts Required
None
Data Fields Generated
| ID | Admit Term | Name | Fa Grd/Lvl | Mo Grd/Lvl | Group Name | Eff Date | Hi Educ Lv | Hi Educ Lv | by | Last Upd DtTm | Complete |
|---|
Tables Used
- DM_APPL_DATA - Admission Application Data
- ADM_APPL_PROG - Admission Applicant Program
- SCC_NAMES_QVW - Person Names Query View
- RELATION_VW - Relationships View
- ISIR_PARENT - Fed Parent Application Data
- STDNT_GRPS_HIST - Student Groups History
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.