QBU_ISIR_FILE_E

This run control is used to assign and update the FAFAFS checklist during even aid years.

Context

A run control for Query Based Updater. It is used to select students who should have a FAFAFS checklist assigned. The FAFAFS checklist helps identify students who have not submitted a FAFSA. This run control will also select and update the FAFAFS checklist to completed.

Processing Options

Actions

This run control currently has 8 steps:

1. Run Query to select returning students using the query UDSFS1_QBU_E_CKL_FAFSA_A. The query looks for students with an AC program status, who are not in the continuing ed (CE) or gcnd programs. The students expected graduation should not be less than the current aid year, they are not a student with a certain visa status (e.g. asylumn), and they don't already have a FAFAFS checklist assigned.
2. Checklist - Add to assign the FAFAFS checklist
3. Checklist Item - Add to assign the even year specific FAFSAE item code
4. Run Query to select new/admitted students using the query UDSFS1_QBU_E_CKL_FAFSA_ADM_A. The query looks for UGRD students with AD or PM program statuses. The query will exclude those who already have a FAFAFS checklist assigned.
5. Checklist - Add to assign the FAFAFS checklist
6. Checklist Item - Add to assign the even year specific FAFSAE item code
7. Run Query to select students who had a checklist assigned and have submitted their FAFSA using the query UDSFS1_QBU_E_CKL_FAFS_FAFE_CCI. The query looks for students who have FAFAFS checklist in initiated status and we have received their ISIR.
8. Checklist Item - Update to mark the checklist status as completed for selected students.

Screenshots