[ctcLinkfinaidsupport] NEW R2T4 Query!

[Molly Groyer]

Good morning FA -

We have a new global Post-Withdrawal Disbursement query: QCS_FA_POST_WITHDRAWN!

The new query is similar to CTC_FA_POST_WITHDRAWN but with improvement in criteria and additional fields.

Criteria change: QCS_FA_POST_WITHDRAWN compared to CTC_FA_POST_WITHDRAWN is not eliminating students who 'had' aid for the prompted term. For colleges like SFCC, that award full year of aid up front, eliminating that population of students may result in missing students eligible for Post-Withdrawal disbursements.

New fields:
- FINA Requirement checklists still in Initiated status? 'Y' or 'N'
- Last Dt of Att - Stdnt Records from STDNT_CAR_TERM
- Withdraw Code, Withdraw Reason, Withdrawal Date
- FA Load, FA Taken Units, Enrollment Intensity & Enrollment Intensity Calculate
- Term

We also removed the middle name field from the query so we could reduce the amount of data returned & because it wasn't a necessary field.

CTC_FA_POST_WITHDRAWN query has been archived.

Please note: In order to ensure we did not miss any students in the available R2T4 queries & to accommodate business processes for 33 colleges, there may be some students that meet the criteria for multiple R2T4 queries.

Thank you,

[Title: SBCTC logo - Description: Compass] Molly Groyer
Functional Analyst, Campus Solutions (Financial Aid)
Washington State Board for Community and Technical Colleges
mgroyer at sbctc.edu<mailto:mgroyer at sbctc.edu> * o: 360-704-1058 * SBCTC.edu/IT Division<https://www.sbctc.edu/colleges-staff/it-support/default.aspx>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20241118/f8315010/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 18063 bytes
Desc: image001.png
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20241118/f8315010/attachment-0001.png>