QBU_MISC_WEEKLY_COMM

Tags SFS QBU FinAid

Context

A run control for Query Based Updater to assign weekly award change and exit counseling communications. 

Processing Options

Actions

This run control currently has 8 steps:

  1. Run Query to select students using the query UDSFS1_QBU_COM_A_AWRD_ACTV. The query looks at the fields ACTION_DTTM & ADJUST_AMOUNT in the STDNT_AWRD_ACTV table. The query looks for any award adjustments above $0 within the past 7 days. The aid years to be reviewed are determined by tree nodes in the UD_FA_AID_YEAR tree.
  2. Adds the FACE communication speed key for selected students. This communication is used to notify students of award changes.
  3. Run Query to select students using the query UDSFS1_QBU_COM_A_LOAN_EXIT. The query looks for expected graduates that had a Fed loan while at UD or their ISIR record shows previous borrowing history. It will exclude students who have already received an FLE communication. It will also not begin sending communications until 30 days before the end of the loan period.
  4. Adds the FLEE communication speed key for selected students. Used for loan exit counseling communication.
  5. Run Query to select students using the query UDSFS1_QBU_COM_A_LOAN_EXIT_GEN. The query looks for students who have received Fed loans while at UD or their ISIR record shows previous borrowing history. It uses the ACAD_PROG table and searches for 'CN','DC','DM','LA','SP' statuses. The status change must have happened in the past 30 days. It will not send a communication to deceased students or students who have already received any exit counseling communication that aid year.
  6. Adds the FLIE communication speed key for selected students. This communication is used to send exit counseling communication for terminated students.
  7. Run Query to select students using the query UDSFS1_QBU_COM_A_LOAN_EXIT_ATT. The query looks at enrollment in the current/prior term (determined by tree nodes on the term tree). UGRDs must have 6 or more credits, Grads must have 5 or more credits. 
  8. Adds the FLFE communication speed key for selected students. Used to send exit counseling information for students based on part-time enrollment.

Screenshots

Step 1:

Step 2:

Step 3:

Step 4:

Step 5:

Step 6:

Step 7:

Step 8:
Print Article