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

Fri Dec 20 15:06:07 PST 2024

Hi there all. Clarifying question – step 1 says to run the Recalculating Eligibility process as outlined in the WCG/CBS Processing Guide. The guide says to run the Populate WCG Eligibility Fields (Calculate WCG Eligibility) process after Recalculating Eligibility, but there’s no mention of that below. Should we do that process as well? If so, do we need to create a new run control ID for it, like we did for Recalculating Eligibility?

Sorry, real big Friday-afternoon-before-Christmas brain over here.
Beth Hawes (she, her pronouns)
Director of Financial Aid
Financial Aid - Green River College<https://www.greenriver.edu/students/pay-for-college/financial-aid/>
P: 253-333-4978 | SA243

From: ctcLinkfinaidsupport <ctclinkfinaidsupport-bounces at lists.ctc.edu> On Behalf Of Deborah Englehardt via ctcLinkfinaidsupport
Sent: Thursday, December 19, 2024 2:51 PM
To: Financial Aid Directors <dirfinaid at lists.ctc.edu>; ctclinkfinaidsupport at lists.ctc.edu
Subject: [ctcLinkfinaidsupport] Action Needed: WCG CEMLI Updates are in Production!
Importance: High

CAUTION: This email originated from outside of Green River College. Please do not click any links or open attachments unless you know the sender and know the information is safe. Even if you know the sender, if the request or information seems unusual please check with the sender first before clicking a link or opening the attachment. If you are unsure, contact the IT Help Desk at x6050 or email ithelpdesk at greenriver.edu<mailto:ithelpdesk at greenriver.edu>.

Please do not give out or enter your Green River email, network login, password information on non-Green River websites.
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:image001.jpg at 01DB52F0.B1541D30]

After (Note: FTI info on screenshot has been blurred)
[cid:image002.jpg at 01DB52F0.B1541D30]

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/20241220/ad89c0b4/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 33211 bytes
Desc: image001.jpg
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20241220/ad89c0b4/attachment-0002.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 35487 bytes
Desc: image002.jpg
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20241220/ad89c0b4/attachment-0003.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 20405 bytes
Desc: image003.png
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20241220/ad89c0b4/attachment-0001.png>