FVT/GE: Implement Financial Value Transparency (FVT) and Gainful Employment (GE)
Banner Pages for gainful employment processing:
Gainful Employment Program Rules (SFAGECR) page
Gainful Employment File Maintenance (SFAGEFM) page
Gainful Employment Program File Maintenance (SFAGEPM) page (SFAGEFM name is same for for Student file records)
Setup Steps:
Make sure all majors to be processed for reporting must have CIP codes on STVMAJR.
Setup curriculum rules for gainful employment in the Curricula tab of the SFAGECR(PL/SQL script). Selected only the ones who are Fin Aid eligible.
Setup detail code rules for gainful employment in the Detail Codes window of SFAGEDR(PL/SQL script)..??indicator to be switch off??
Component code setup in the Books/Supplies/Equipment Allowance window on SFAGECR for Fin Aid, done
Build OPEID rules for gainful employment in the OPEID window on SFAGECR
Tuition status for residency codes setup in the Residency Tuition Status window of SFAGECR
Component code setup in the Housing/Food Allowance window on SFAGECR for Fin Aid
Run the Gainful Employment Student Creation (SFPGESC) report with ‘T' mode (Attached screenshot of parameters and output) Notes: if not using popsel, it will run against both campus Banner data and need to separate data later in report output file. If using popsel, each campus need to download the file from NSC. Make sure no duplicates in the file. The file has only SSN and would need to retrieve CWID for them to create popsel. Preferred method to use popsel. When the Run Mode parameter is set to 'T’, Banner automatically generates a new Batch ID, and does not use the Batch ID parameter. Links to Ellucian documentation at the end of this doc
Output is in table SFRGEFM table and make adjustments as needed SFAGEFM page …user can not access SFAGEFM once the confidential flags comes up. To verify data, check few CWIDs with having values in amt fields and see if there is mismatch. A&R and Fin Aid to coordinate on this task.
Once reviewed and fixed errors, run the SFPGESC report for your aid year, optional batch id with a Run mode = F(file). When running SFPGESC in ‘F' mode, Use the last Batch ID used to run for 'T’
NOTE: DO NOT OPEN FILE IN EXCEL. Instead open the file in Notepad++. View->Show Symbols. If you see symbol ‘Cr’(carriage return), then Edit->EOL Conversion and select UNIX format.
Submit the output .csv file to the NSC
Run the Gainful Employment Program Creation (SFPGEPC) report (Attached screenshot of parameter) Note: no need to have specific popsel, run against Banner data
Output can be reviewed on SFAGEPM page and make adjustments as needed. A&R and Fin Aid to coordinate on this task.
Once reviewed and fixed errors, run the SFPGEPC report for your aid year, optional batch id with a Run mode = F(file).
Submit the output .csv file to the NSC. If NSC rejects few records, one possible error might be coenrolled.
Complete the setup with the NSC before the report is submitted.
Once submitted to NSLDS, Fin Aid and A&R can work of fixing the errors that gets reported on NSLDS.
https://resources.elluciancloud.com/bundle/banner_student_acn_use/page/t_gain_emp_setup.html
Gainful Employment Student Creation (SFPGESC) report:https://resources.elluciancloud.com/bundle/banner_student_acn_use/page/c_gainful_employment_student_creation_report_sfpgesc.html
Gainful Employment Program Creation (SFPGEPC) report: https://resources.elluciancloud.com/bundle/banner_student_acn_use/page/c_gainful_employment_program_creation_sfpgepc_report.html
Common Questions about SFPGESC and SFAGEFM: https://elluciansupport.service-now.com/customer_center?sys_kb_id=2856c856476c9a1824ade731e36d43cc&id=kb_article_view
Resource link: https://elluciansupport.service-now.com/customer_center?id=community_blog&sys_id=9e3ea8d983ab661000ff9840ceaad323
Screenshots of each tab on page SFAGECR:
SFPGESC in 'T' mode(not using popsel)
SFPGESC in ‘F' mode