[ctcLinkfinaidsupport] {Disarmed} RE: ctcLink updates related to WSAC programs

Tue Aug 29 17:45:16 PDT 2023

Good Evening FA-

There are some updates to share about the items below:

WCG Connect: A query was developed and FAST representatives have tested the query. The query that can be used to identify a list of potential WCG-Connect students is: QCS_FA_WCG_C_ELIG_SSN_LIST

  *   This query looks for Car Term active students eligible to enroll, excludes CNED Career, Transitional & Non Award Seeking Programs, and student who have already been awarded WCG FA item types. Yes/No prompt for currently enrolled in the prompted term. In addition, criteria has been added to limit the results to those pursuing FA eligible programs (academic plans with a short description of '9'). Student accounts that have been marked as fraud have also been eliminated.  Please note that feedback received from FAST was that Residency should not be considered as a criteria in this query, rather, it should be checked in the system at the time of awarding.

  *   The WCG-Connect item type has also been added into the SQL that determines the CBS state aid award commitment.

WCG Interim: College UAT is underway. During testing a college encountered a non-overridable edit and we are working with Technical on addressing this.

Unit Record Report: The updated layout for 22-23 reporting was released in Production on 8/18.

CBS Eligibility Checker: WSAC informed us that the file layout for the CBS Eligibility Checker has been finalized. With the final layout comes a new field (2.0GPA) and the removal of a field (HS Requirements Met). WSAC will keep the CBS Cruncher available until our system is updated. While we work to modify our CEMLI to accommodate the changes, we recommend that colleges continue to use the CBS Cruncher file when running the CBS Import process. For those unclear on which CBS file has been downloaded from WSAC, the file generated from the CBS Cruncher will be labeled Export.csv whereas a file generated from the CBS Eligibility Checker will be labeled eligibility-data.csv

Thank you!

Stephanie

From: Stephanie Casino
Sent: Monday, August 7, 2023 9:18 AM
To: ctclinkfinaidsupport <ctclinkfinaidsupport at lists.ctc.edu>; Financial Aid Directors <dirfinaid at lists.ctc.edu>
Cc: FASupport <FASupport at sbctc.edu>; Dani Bundy <dbundy at sbctc.edu>; Roger Curry <rcurry at sbctc.edu>; Washington College Grant (WSAC) <wcg at wsac.wa.gov>; Unit Record (WSAC) <unitrecord at wsac.wa.gov>
Subject: ctcLink updates related to WSAC programs
Importance: High

Good Morning FA-

There have been a few questions that have come in regarding various state aid updates. We hope that the below helps to address some of those questions:

*        WCG-Connect: This new program has very broad criteria. We are working with representatives from FAST to develop a criteria that can be used to identify a list of potential WCG-Connect students to load to the WCG-Connect Checker

*        WCG Interim Report: In early spring, we were notified that the interim file contained $0 for CBS and PTC who did not receive an award. A workaround query was provided in order to meet WSAC reporting requirements. We have been working on correcting the Interim Report logic so that the workaround query is no longer needed. In addition to the logic update, we will be including the IsDelete field for 23-24 reporting. We are also analyzing the best approach to include the new WCG-Connect program. A timeline on this update will be shared out in the coming weeks.

*        Unit Record Report:  The URR co-presentation with WSAC is at 1:30PM tomorrow. Two new fields (WCG Bridge and WAVE) were added to the layout for 2022-2023 reporting. While the new layout is not yet available in Production, colleges can run the existing URR process to begin clean up. Please do not load the csv file into the WSAC Portal as it does not contain the two new headers. This will be discussed further tomorrow :)

*        CBS Eligibility Checker: The csv output file generated from the new CBS Eligibility Checker contains a new field (2.0 GPA). In order for ctcLink to accommodate this additional field, we will need to modify our CEMLI to read the additional field. As soon as we have a more concrete timeline for this update, we will share out with the colleges. In the meantime, WSAC will keep the CBS Cruncher available with the "old layout" so that you may continue with processing. Alternatively, if you are comfortable with modifying the csv file generated from the new CBS Eligibility Checker to remove the 2.0GPA column, the modified file can be loaded through the CBS Import process. If you do not remove the new 2.0GPA column prior to running the CBS Import process, the csv file will not be processed.

Happy Monday!

[Title: SBCTC logo - Description: Compass]Stephanie Casino
Senior Functional Analyst, Campus Solutions (Financial Aid)
Washington State Board for Community and Technical Colleges
scasino at sbctc.edu<mailto:scasino at sbctc.edu> * o: 360-704-1054 * SBCTC.edu/IT Division<https://www.sbctc.edu/colleges-staff/it-support/default.aspx>
[https://images.credly.com/images/260e36dc-d100-45c3-852f-9d8063fa71e6/pmp-600px.png]<https://www.credly.com/badges/dd237db6-6aed-4466-ae89-9a5fbf3f2910/public_url>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20230830/eb2a7048/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/20230830/eb2a7048/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 15690 bytes
Desc: image002.png
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20230830/eb2a7048/attachment-0003.png>