[ctcLinkfinaidsupport] Action Needed: WCG CEMLI Updates are in Production!

[Deborah Englehardt]

Good afternoon, FA!



We have several updates to provide!


As of last Friday, the WCG CEMLI Family SQL has been updated to populate FTI data when appropriate, so the ISIR Family Size and WCG Family Size fields have been moved to display between the FTI start and end labels.


Before (Note: FTI info on screenshot has been blurred)

[cid:image005.jpg at 01DB5225.5AE2EB50]



After (Note: FTI info on screenshot has been blurred)
[cid:image006.jpg at 01DB5225.5AE2EB50]

The update to the WCG CEMLI is complicated and massive so we have created an overview document to explain all the changes. Please see attached document that shows our hierarchy as well as our test data. The document also includes areas that were out of scope.


Updating the WCG Eligibility page for your 2025 aid year students



Step 1 Update WCG Eligibility on Students Who Don’t Have Override Checkbox Selected

Having a before and after may be helpful so we recommend running CTC_FA_SNG_ALL_RECORDS and downloading the results so you can refer back to it. Then, run the Recalculating Eligibility process p.9 of WCG and CBS Processing Business Process Guide | 9.2 FA - Financial Aid Business Process Guides | ctcLink Reference Center<https://ctclinkreferencecenter.ctclink.us/m/92436/l/798586-wcg-and-cbs-processing-business-process-guide> When running the Recalc process, please make sure not to use the same Run Control ID that is used in your college’s ISIR Jobset.



Step 2 Update WCG Eligibility on Students Who Have Override Checkbox Selected

Any student where you locked the WCG Eligibility page will not be re-calculated. There are two options that you can take to clean up those students.



Option 1

Run CTC_FA_SNG_ALL_RECORDS query and download the results. Filter by Lock Eligibility field equal to Y to find all those you’ve overridden.

Run the WCG Override process p.7 of WCG and CBS Processing Business Process Guide | 9.2 FA - Financial Aid Business Process Guides | ctcLink Reference Center<https://ctclinkreferencecenter.ctclink.us/m/92436/l/798586-wcg-and-cbs-processing-business-process-guide> with ‘Lock Eligibility’ box not selected



You have two options for population selection



QCS_FA_WCG_OVERRIDE - Selects students who have the prompted Eligible? field status



QCS_FA_WCG_OVERRIDE_AWARDED - Selects students who have prompted item-type offered and Eligible? field status. This query is the same as the one existing in the guide: CTC_FA_SNG_OVERRIDE. No criteria change, just renaming for clarity, and SNG has been WCG for several years now.

  

Once you've unlocked the students that were overridden, run Recalculating Eligibility process p.9 of WCG and CBS Processing Business Process Guide | 9.2 FA - Financial Aid Business Process Guides | ctcLink Reference Center<https://ctclinkreferencecenter.ctclink.us/m/92436/l/798586-wcg-and-cbs-processing-business-process-guide>. When running the Recalc process, please make sure not to use the same Run Control ID that is used in your college’s ISIR Jobset.





Option 2

Run CTC_FA_SNG_ALL_RECORDS query and download the results. Filter by Lock Eligibility field equal to Y to find all those you’ve overridden and manually review each one. For any student you need to populate the FTI data, use the CTC_FA_SNG_POPULATE_ONE_ID query for the WCG Pop Update Process. Once you confirm the WCG Eligibility page updated, manually select Calculate for the student.



Thank you!!!
FA Support

[Compass]Deborah Englehardt
Senior Functional Analyst, Campus Solutions (Financial Aid)
Washington State Board for Community and Technical Colleges
1500 Jefferson Street SE
Olympia, WA 98501
denglehardt at sbctc.edu<mailto:denglehardt at sbctc.edu> • O: 360-704-3979
sbctc.edu<https://www.sbctc.edu/> • Twitter: @SBCTCWashington<https://twitter.com/SBCTCWashington> • Facebook: @WASBCTC<https://www.facebook.com/wasbctc/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20241219/06eb2a11/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image008.jpg
Type: image/jpeg
Size: 25101 bytes
Desc: image008.jpg
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20241219/06eb2a11/attachment-0004.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image009.jpg
Type: image/jpeg
Size: 40598 bytes
Desc: image009.jpg
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20241219/06eb2a11/attachment-0005.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image007.png
Type: image/png
Size: 20405 bytes
Desc: image007.png
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20241219/06eb2a11/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.jpg
Type: image/jpeg
Size: 33211 bytes
Desc: image005.jpg
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20241219/06eb2a11/attachment-0006.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.jpg
Type: image/jpeg
Size: 35487 bytes
Desc: image006.jpg
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20241219/06eb2a11/attachment-0007.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Overview of Updates WCG CEMLI - WCG Income and Family Size.docx
Type: application/vnd.openxmlformats-officedocument.wordprocessingml.document
Size: 7555453 bytes
Desc: Overview of Updates WCG CEMLI - WCG Income and Family Size.docx
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20241219/06eb2a11/attachment-0001.docx>