<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div class="elementToProof"><span class="x_x_elementToProof x_ContentPasted0" style="font-size: 12pt; background-color: rgb(255, 255, 255);">Good morning FA!</span></div>
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div class="x_x_elementToProof" style="font-size: 12pt; background-color: rgb(255, 255, 255);">
<br class="x_ContentPasted0">
</div>
<div class="x_x_elementToProof x_ContentPasted0" style="font-size: 12pt; background-color: rgb(255, 255, 255);">
We had done much testing and data validation before we released <span class="x_x_x_contentpasted1">
<b><span class="x_x_ContentPasted0 x_ContentPasted0" style="font-family: "Arial", sans-serif; background: white; color: black;">QCS_FA_WCG_INTERIM_CSV</span></b></span> into production as a solution to the misreporting of zeroes for CBS and PTC in the Interim
Report. <br class="x_ContentPasted0">
</div>
<div class="x_x_elementToProof" style="font-size: 12pt; background-color: rgb(255, 255, 255);">
<br class="x_ContentPasted0">
</div>
<div class="x_x_elementToProof x_ContentPasted3" style="font-size: 12pt; background-color: rgb(255, 255, 255);">
We were trying to get a solution out to the colleges as quick as possible to remove two burdens: 1) manually removing the hundreds of erroneous zeroes from the <b><i><span class="x_ContentPasted6 x_ContentPasted11" style="font-size: 11pt; line-height: 107%; font-family: "Segoe UI", "Segoe UI Web (West European)", "Helvetica Neue", sans-serif;">WA
College Grant.csv</span></i></b> and 2) look for the students who should actually be reported as zeroes.</div>
<div class="x_x_elementToProof x_ContentPasted3 x_ContentPasted10" style="font-size: 12pt; background-color: rgb(255, 255, 255);">
<br>
</div>
<div class="x_x_elementToProof x_ContentPasted3 x_elementToProof" style="font-size: 12pt; background-color: rgb(255, 255, 255);">
Colleges have started to run the <span class="x_x_x_contentpasted1"><b><span class="x_x_ContentPasted0 x_ContentPasted0 x_ContentPasted1 x_ContentPasted2 x_ContentPasted4 x_ContentPasted5 x_ContentPasted12" style="font-family: "Arial", sans-serif; background: white; color: black;">QCS_FA_WCG_INTERIM_CSV</span></b></span>
and we've received feedback. The zeroes are looking good but some CBS awards are not populating on the query for colleges due to unpredictable live data we did not see during testing.
<b>With this new information, we believe it's safer to use the query only to <u>find</u> the zeroes that should be reported to WSAC.</b>
<br>
</div>
<div class="x_x_elementToProof x_ContentPasted3 x_elementToProof" style="font-size: 12pt; background-color: rgb(255, 255, 255);">
<br>
</div>
<div class="x_x_elementToProof x_ContentPasted3 x_elementToProof" style="font-size: 12pt; background-color: rgb(255, 255, 255);">
The students who have zeroes in the CBS columns on the <span class="x_x_x_contentpasted1">
<b><span class="x_x_ContentPasted0 x_ContentPasted0 x_ContentPasted1 x_ContentPasted2 x_ContentPasted4 x_ContentPasted5" style="font-family: "Arial", sans-serif; background: white; color: black;">QCS_FA_WCG_INTERIM_CSV
</span></b></span>results are students who are enrolled for the term and eligible for CBS but unmet need was met with other aid. That is the population WSAC reported not all colleges have been reporting accurately.<br>
</div>
<div class="x_x_elementToProof x_ContentPasted3" style="font-size: 12pt; background-color: rgb(255, 255, 255);">
<br>
</div>
<div class="x_x_elementToProof x_ContentPasted0" style="font-size: 12pt; background-color: rgb(255, 255, 255);">
Attached are steps on how to remove the zeroes off of the<b><i> <span class="x_ContentPasted6" style="font-size: 11pt; line-height: 107%; font-family: "Segoe UI", "Segoe UI Web (West European)", "Helvetica Neue", sans-serif;">
WA College Grant.csv</span> </i></b>before uploading it into WSAC. Afterwards, you can use the results from
<b>QCS</b><span class="x_x_x_contentpasted1"><b><span class="x_x_ContentPasted0 x_ContentPasted0 x_ContentPasted1 x_ContentPasted2 x_ContentPasted4 x_ContentPasted5 x_ContentPasted7" style="font-family: "Arial", sans-serif; background: white; color: black;">_FA_WCG_INTERIM_CSV</span></b></span>
to report the zeroes manually in the WSAC Portal.<br>
</div>
<div class="x_x_elementToProof x_ContentPasted0" style="font-size: 12pt; background-color: rgb(255, 255, 255);">
<br>
</div>
<div class="x_x_elementToProof x_ContentPasted0" style="font-size: 12pt; background-color: rgb(255, 255, 255);">
Thank you for your understanding,<br class="x_ContentPasted0">
</div>
</div>
<div dir="ltr" class="elementToProof"><span class="x_x_elementToProof x_ContentPasted0" style="font-size: 12pt; background-color: rgb(255, 255, 255);">Debbie</span><br>
</div>
<div dir="ltr">
<div class="x_x_elementToProof" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<p style="text-align: start; font-size: 11pt; font-family: Calibri, sans-serif; margin: 0px; background-color: rgb(255, 255, 255);">
<img alt="Compass" style="margin:0px; width:45pt; height:84.49pt" align="left" data-outlook-trace="F:1|T:1" src="cid:ccf6a1ae-31e4-4c00-a080-05ca8a65d812"><b><span style="margin: 0px; font-size: 14pt; font-family: Candara, sans-serif, serif, EmojiFont; color: rgb(31, 73, 125);">Deborah
Englehardt</span></b><b><span style="margin: 0px; font-size: 14pt; font-family: Candara, sans-serif, serif, EmojiFont; color: rgb(0, 55, 100);"></span></b></p>
<p style="text-align: start; font-size: 11pt; font-family: Calibri, sans-serif; margin: 0px; line-height: 10.55pt; background-color: rgb(255, 255, 255);">
<b><span style="margin: 0px; font-size: 10pt; font-family: Candara, sans-serif, serif, EmojiFont; color: rgb(31, 73, 125);">Functional Analyst, Campus Solutions (Financial Aid)</span></b></p>
<p style="text-align: start; font-size: 11pt; font-family: Calibri, sans-serif; margin: 0px; line-height: 10.55pt; background-color: rgb(255, 255, 255);">
<span style="margin: 0px; font-size: 10pt; font-family: Candara, sans-serif, serif, EmojiFont; color: rgb(31, 73, 125);">Washington State Board for Community and Technical Colleges</span></p>
<p style="text-align: start; font-size: 11pt; font-family: Calibri, sans-serif; margin: 0px; line-height: 10.55pt; background-color: rgb(255, 255, 255);">
<span style="margin:0px; font-size:10pt; font-family:Candara,sans-serif,serif,EmojiFont">1300 Quince Street SE</span></p>
<p style="text-align: start; font-size: 11pt; font-family: Calibri, sans-serif; margin: 0px; line-height: 10.55pt; background-color: rgb(255, 255, 255);">
<span style="margin:0px; font-size:10pt; font-family:Candara,sans-serif,serif,EmojiFont">Olympia, WA 98504-2495</span></p>
<p style="text-align: start; font-size: 11pt; font-family: Calibri, sans-serif; margin: 0px; line-height: 10.55pt; background-color: rgb(255, 255, 255);">
<span style="margin: 0px; font-size: 10pt; font-family: Candara, sans-serif, serif, EmojiFont; color: rgb(31, 73, 125);"><a href="mailto:denglehardt@sbctc.edu" target="_blank" rel="noopener noreferrer" style="margin:0px" data-loopstyle="link">denglehardt@sbctc.edu</a><span> </span>•
O: 360-704-3979</span><span style="margin: 0px; font-size: 12pt; font-family: Candara, sans-serif, serif, EmojiFont; color: rgb(31, 73, 125);"></span></p>
<p style="text-align: start; font-size: 11pt; font-family: Calibri, sans-serif; margin: 0px; background-color: rgb(255, 255, 255);">
<span style="margin: 0px; font-family: Candara, sans-serif, serif, EmojiFont; color: rgb(31, 73, 125);"><a href="https://www.sbctc.edu/" target="_blank" rel="noopener noreferrer" style="margin:0px" data-loopstyle="link"><span style="margin:0px; font-size:10pt">sbctc.edu</span></a></span><span style="margin: 0px; font-size: 10pt; font-family: Candara, sans-serif, serif, EmojiFont; color: rgb(0, 53, 97);"><span> </span></span><span style="margin: 0px; font-size: 10pt; font-family: Candara, sans-serif, serif, EmojiFont; color: rgb(31, 73, 125);">•
Twitter:</span><span style="margin: 0px; font-size: 10pt; font-family: Candara, sans-serif, serif, EmojiFont; color: rgb(0, 55, 100);"><span> </span></span><span style="margin: 0px; font-family: Candara, sans-serif, serif, EmojiFont; color: rgb(31, 73, 125);"><a href="https://twitter.com/SBCTCWashington" target="_blank" rel="noopener noreferrer" style="margin:0px" data-loopstyle="link"><span style="margin:0px; font-size:10pt">@SBCTCWashington</span></a></span><span style="margin: 0px; font-size: 10pt; font-family: Candara, sans-serif, serif, EmojiFont; color: rgb(0, 55, 100);"><span> </span></span><span style="margin: 0px; font-size: 10pt; font-family: Candara, sans-serif, serif, EmojiFont; color: rgb(31, 73, 125);">•
Facebook:<span> </span></span><span style="margin: 0px; font-family: Candara, sans-serif, serif, EmojiFont; color: rgb(31, 73, 125);"><span style="margin:0px; font-size:10pt"><a href="https://www.facebook.com/wasbctc/" target="_blank" rel="noopener noreferrer" style="margin:0px" data-loopstyle="link">@WASBCTC</a></span></span></p>
</div>
</div>
</div>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="x_x_divRplyFwdMsg" dir="ltr"><font class="x_x_elementToProof" style="font-size: 11pt; color: rgb(0, 0, 0);" face="Calibri, sans-serif"><b>From:</b> Deborah Englehardt <denglehardt@sbctc.edu><br>
<b>Sent:</b> Thursday, April 6, 2023 12:52 PM<br>
<b>To:</b> dirfinaid@lists.ctc.edu <dirfinaid@lists.ctc.edu>; ctclinkfinaidsupport@lists.ctc.edu <ctclinkfinaidsupport@lists.ctc.edu><br>
<b>Cc:</b> FASupport <FASupport@sbctc.edu>; Dani Bundy <dbundy@sbctc.edu>; Roger Curry <rcurry@sbctc.edu>; wcg@wsac.wa.gov <wcg@wsac.wa.gov><br>
<b>Subject:</b> [Update] WCG Interim Reporting and $0 Awards in CSAW Portal</font>
<div> </div>
</div>
<div lang="EN-US">
<div class="x_x_x_WordSection1">
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; background: white;">
<span class="x_x_x_contentpasted1"><span style="font-family: "Arial", sans-serif; background: white;">Good afternoon FA!</span></span></p>
<div>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; background: white;">
<span class="x_x_x_contentpasted1"><span style="font-family: "Arial", sans-serif; background: white;"> </span></span></p>
</div>
<div>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; background: white;">
<span class="x_x_x_contentpasted1"><span style="font-family: "Arial", sans-serif; background: white;">The workaround query that removes the erroneous $0 for CBS and PTC is now in production!
</span></span><span class="x_x_x_contentpasted1"><span style="font-family: "Segoe UI Emoji", sans-serif; background: white;">😊</span></span><span class="x_x_x_contentpasted1"><span style="font-family: "Arial", sans-serif; background: white;"></span></span></p>
</div>
<div>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; background: white;">
<span class="x_x_x_contentpasted1"><span style="font-family: "Arial", sans-serif; background: white;"> </span></span></p>
</div>
<div>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; background: white;">
<span class="x_x_x_contentpasted1"><span style="font-family: "Arial", sans-serif; background: white;">The query is
</span></span><span class="x_x_x_contentpasted1"><b><span style="font-family: "Arial", sans-serif; background: white; color: black;">QCS_FA_WCG_INTERIM_CSV</span></b></span><span class="x_x_x_contentpasted1"><b><span style="font-family: "Arial", sans-serif; background: white;"></span></b></span></p>
</div>
<div>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; background: white;">
<span style="font-size: 12pt; color: black;"> </span></p>
</div>
<div>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; background: white;">
<span class="x_x_x_contentpasted1"><span style="font-family: "Arial", sans-serif; background: white; color: black;">Before running this query, it would be business as usual running the PS Interim Report CEMLI, working the error report and re-running as necessary<b>
</b>to clean up the Interim Report.</span></span><span style="font-size: 12pt; font-family: "Arial", sans-serif; color: black;"></span></p>
</div>
<div>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; text-indent: 0.5in; background: white;">
<span style="font-size: 12pt; font-family: "Arial", sans-serif; color: black;"> </span></p>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; text-indent: 0.5in; background: white;">
<span style="font-size: 12pt; font-family: "Arial", sans-serif; color: black;">Reference:
<a href="https://ctclinkreferencecenter.ctclink.us/m/92436/l/848386-wcg-interim-reporting-business-process-guide" data-auth="NotApplicable" data-loopstyle="link">
WCG Interim Reporting Business Process Guide | 9.2 FA - Financial Aid Business Process Guides | ctcLink Reference Center</a></span></p>
</div>
<div>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; background: white;">
<span style="font-size: 12pt; font-family: "Arial", sans-serif; color: black;"> </span></p>
</div>
<div>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; background: white;">
<span style="font-family: "Arial", sans-serif; background: white; color: black;">Once you are ready to upload a CSV into CSAW, you can run
<span class="x_x_x_contentpasted2"><b>QCS_FA_WCG_INTERIM_CSV</b> (the query grabs data that is in your PS Interim Report and removes the inaccurate $0 for CBS and PTC)</span></span><span class="x_x_x_contentpasted2"><span style="background: white;"></span></span></p>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; background: white;">
<span class="x_x_x_contentpasted2"><span style="font-family: "Arial", sans-serif; background: white; color: black;"> </span></span></p>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; background: white;">
<span class="x_x_x_contentpasted2"><b><span style="font-family: "Arial", sans-serif; background: yellow; color: black;">Steps for running QCS_FA_WCG_INTERIM_CSV</span></b></span><span class="x_x_x_contentpasted2"><b><span style="font-family: "Arial", sans-serif; background: white; color: black;"></span></b></span></p>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; background: white;">
<span style="font-size:12.0pt"> </span></p>
<ol style="margin-bottom:0in; margin-top:0in" type="1">
<li class="x_x_x_MsoListParagraph" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; background: white; color: black;">
<span style="font-size:12.0pt; font-family:"Arial",sans-serif">Go to <b>Query Viewer</b>, find the query, and select to run to
<b>HTML</b></span></li></ol>
</div>
<div>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; background: white;">
<span style="font-size: 12pt; font-family: "Arial", sans-serif; color: black;"> </span></p>
</div>
<div>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; text-indent: 0.5in; background: white;">
<span style="font-size: 12pt; font-family: "Arial", sans-serif; color: black;"></span></p>
<div><image001.png></div>
<span style="font-size: 12pt; font-family: "Arial", sans-serif; color: black;"></span>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; text-indent: 0.25in; background: white;">
<span style="font-size: 12pt; font-family: "Arial", sans-serif; color: black;"> </span></p>
<ol style="margin-bottom:0in; margin-top:0in" type="1" start="2">
<li class="x_x_x_MsoListParagraph" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; background: white; color: black;">
<span style="font-size:12.0pt; font-family:"Arial",sans-serif">Enter your parameters, select
<b>View Results</b> then select<b> </b></span><b><span style="font-size: 12pt; font-family: "Arial", sans-serif; color: rgb(112, 48, 160);">CSV Text File</span></b><span style="font-size:12.0pt; font-family:"Arial",sans-serif"></span></li></ol>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; background: white;">
<span style="font-size: 12pt; font-family: "Arial", sans-serif; color: black;"> </span></p>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; text-indent: 0.5in; background: white;">
<span style="font-family:"Arial",sans-serif"></span></p>
<div><image004.jpg></div>
<span style="font-size: 12pt; font-family: "Arial", sans-serif; color: black;"></span>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; text-indent: 0.25in; background: white;">
<span style="font-size: 12pt; font-family: "Arial", sans-serif; color: black;"> </span></p>
<ol style="margin-bottom:0in; margin-top:0in" type="1" start="3">
<li class="x_x_x_MsoListParagraph" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Arial", sans-serif; background: white; color: black;">
<span style="font-size: 12pt; font-family: "Arial", sans-serif; color: black;">Open up
</span><span class="x_x_x_contentpasted2"><span style="font-family: "Arial", sans-serif; background: white; color: black;">QCS_FA_WCG_INTERIM_CSV.csv to confirm it has the same number of rows as the View Log/Trace’s WA College Grant.csv.
</span></span></li></ol>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; background: white;">
<span style="font-size: 12pt; font-family: "Arial", sans-serif; color: black;">
</span></p>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; background: white;">
<span style="font-size: 12pt; font-family: "Arial", sans-serif; color: black;"> Example location of WA College Grant.csv</span></p>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; text-indent: 0.5in; background: white;">
<span style="font-family:"Arial",sans-serif"></span></p>
<div><image009.jpg></div>
<span style="font-size: 12pt; font-family: "Arial", sans-serif; color: black;"></span>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; background: white;">
<span style="font-size: 12pt; font-family: "Arial", sans-serif; color: black;"> </span></p>
<ol style="margin-bottom:0in; margin-top:0in" type="1" start="4">
<li class="x_x_x_MsoListParagraph" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Arial", sans-serif; background: white; color: black;">
<span class="x_x_x_contentpasted2"><span style="font-family: "Arial", sans-serif; background: white; color: black;">After confirming the numbers match, close both CSVs without saving so that you do not end up removing the leading zeroes on SSNs.
</span></span></li></ol>
<p class="x_x_x_MsoListParagraph" style="margin: 0in 0in 0.0001pt 0.5in; font-size: 11pt; font-family: "Calibri", sans-serif; background: white;">
<span class="x_x_x_contentpasted2"><span style="font-family: "Arial", sans-serif; background: white; color: black;"> </span></span></p>
<p class="x_x_x_MsoListParagraph" style="margin: 0in 0in 0.0001pt 0.5in; font-size: 11pt; font-family: "Calibri", sans-serif; background: white;">
<span class="x_x_x_contentpasted2"><span style="font-family: "Arial", sans-serif; background: white; color: rgb(0, 112, 192);">Note: If the number of rows on the two CSVs do not match, please submit a ticket to FA ERP Support because that means you have some
bad data that needs to be cleaned up before loading the CSV into CSAW.</span></span></p>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; background: white;">
<span style="color: black;"> </span></p>
<ol style="margin-bottom:0in; margin-top:0in" type="1" start="5">
<li class="x_x_x_MsoListParagraph" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; background: white;">
<span style="font-family: "Arial", sans-serif; color: black;">Upload the <span class="x_x_x_contentpasted2">
<span style="background: white;">QCS_FA_WCG_INTERIM_CSV into CSAW</span></span></span><span class="x_x_x_contentpasted2"></span></li></ol>
</div>
<div>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; background: white;">
</p>
</div>
<div>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; background: white;">
<span style="font-family: "Arial", sans-serif; color: black;"> </span></p>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; background: white;">
<span style="font-family: "Arial", sans-serif; color: black;">Wishing you good luck with Spring Interim!
</span></p>
</div>
<p class="x_x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px; margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
<span style="font-size: 12pt; font-family: "Times New Roman", serif; color: black;"> </span></p>
<div><image011.jpg></div>
<b><span style="font-size: 14pt; font-family: "Candara", sans-serif; color: rgb(31, 73, 125);">Deborah Englehardt</span></b><b><span style="font-size: 14pt; font-family: "Candara", sans-serif; color: rgb(0, 55, 100);"></span></b>
<p class="x_x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px; margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif; line-height:10.55pt; text-autospace:none">
<b><span style="font-size: 10pt; font-family: "Candara", sans-serif; color: rgb(31, 73, 125);">Functional Analyst, Campus Solutions (Financial Aid)</span></b></p>
<p class="x_x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px; margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif; line-height:10.55pt; text-autospace:none">
<span style="font-size: 10pt; font-family: "Candara", sans-serif; color: rgb(31, 73, 125);">Washington State Board for Community and Technical Colleges</span></p>
<p class="x_x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px; margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif; line-height:10.55pt; text-autospace:none">
<span style="font-size: 10pt; font-family: "Candara", sans-serif; color: black;">1300 Quince Street SE</span></p>
<p class="x_x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px; margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif; line-height:10.55pt; text-autospace:none">
<span style="font-size: 10pt; font-family: "Candara", sans-serif; color: black;">Olympia, WA 98504-2495</span></p>
<p class="x_x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px; margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif; line-height:10.55pt; text-autospace:none">
<span style="font-size: 10pt; font-family: "Candara", sans-serif; color: rgb(31, 73, 125);"><a href="mailto:denglehardt@sbctc.edu" data-auth="NotApplicable" data-loopstyle="link"><span style="color: rgb(5, 99, 193);">denglehardt@sbctc.edu</span></a> • O: 360-704-3979
</span><span style="font-size: 12pt; font-family: "Candara", sans-serif; color: rgb(31, 73, 125);"></span></p>
<p class="x_x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px; margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
<span style="font-family: "Candara", sans-serif; color: rgb(31, 73, 125);"><a href="https://www.sbctc.edu/" data-auth="NotApplicable" data-loopstyle="link"><span style="font-size: 10pt; color: rgb(5, 99, 193);">sbctc.edu</span></a></span><span style="font-size: 10pt; font-family: "Candara", sans-serif; color: rgb(0, 53, 97);">
</span><span style="font-size: 10pt; font-family: "Candara", sans-serif; color: rgb(31, 73, 125);">• Twitter:</span><span style="font-size: 10pt; font-family: "Candara", sans-serif; color: rgb(0, 55, 100);">
</span><span style="font-family: "Candara", sans-serif; color: rgb(31, 73, 125);"><a href="https://twitter.com/SBCTCWashington" data-auth="NotApplicable" data-loopstyle="link"><span style="font-size: 10pt; color: rgb(5, 99, 193);">@SBCTCWashington</span></a></span><span style="font-size: 10pt; font-family: "Candara", sans-serif; color: rgb(0, 55, 100);">
</span><span style="font-size: 10pt; font-family: "Candara", sans-serif; color: rgb(31, 73, 125);">• Facebook:
</span><span style="font-family: "Candara", sans-serif; color: rgb(31, 73, 125);"><a href="https://www.facebook.com/wasbctc/" data-auth="NotApplicable" data-loopstyle="link"><span style="font-size: 10pt; color: rgb(5, 99, 193);">@WASBCTC</span></a></span><span style="font-size: 10pt; font-family: "Candara", sans-serif; color: rgb(31, 73, 125);"></span></p>
<p class="x_x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px; margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
<span style="font-size: 12pt; font-family: "Times New Roman", serif; color: black;"> </span></p>
<div>
<p class="x_x_x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: "Calibri", sans-serif; background: white;">
<span style="font-family: "Arial", sans-serif; color: black;"> </span></p>
</div>
<div class="x_x_x_MsoNormal" style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif; text-align:center" align="center">
<hr width="98%" size="3" align="center">
</div>
<div id="x_x_x_divRplyFwdMsg">
<p class="x_x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px; margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
<b><span style="color: black;">From:</span></b><span style="color: black;"> Stephanie Casino <scasino@sbctc.edu><br>
<b>Sent:</b> Wednesday, March 29, 2023 5:13 PM<br>
<b>To:</b> dirfinaid@lists.ctc.edu <dirfinaid@lists.ctc.edu>; ctclinkfinaidsupport@lists.ctc.edu <ctclinkfinaidsupport@lists.ctc.edu><br>
<b>Cc:</b> FASupport <FASupport@sbctc.edu>; Dani Bundy <dbundy@sbctc.edu>; Roger Curry <rcurry@sbctc.edu>; wcg@wsac.wa.gov <wcg@wsac.wa.gov><br>
<b>Subject:</b> WCG Interim Reporting and $0 Awards in CSAW Portal</span> </p>
<div>
<p class="x_x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px; margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
</p>
</div>
</div>
<div>
<div>
<p style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px">
Good Afternoon FA-<span style="font-size:12.0pt; font-family:"Times New Roman",serif"></span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px">
<span style="font-size:12.0pt; font-family:"Times New Roman",serif"></span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px">
Last week WSAC notified us of the issue below:<span style="font-size:12.0pt; font-family:"Times New Roman",serif"></span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px">
<span style="font-size:12.0pt; font-family:"Times New Roman",serif"></span></p>
<p class="x_x_x_elementtoproof" style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px; margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
<i>It has been brought to our attention by our IT team that your institution’s interim file loads have been including $0 for students who did not receive an award – especially for CBS and PTC. If a student is not eligible to receive an award, they should either
not be reported or reported with a blank in the award field. The $0 award is to be used for when a student is eligible for an award but has not been awarded because of having their need met with other aid. Please work with whomever prepares your file to ensure
that it is correct for the Spring interim report opening on April 10<sup>th</sup></i><span style="font-size:12.0pt; font-family:"Times New Roman",serif"></span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px">
<span style="font-size:12.0pt; font-family:"Times New Roman",serif"></span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px">
Currently, the delivered interim report will populate $0 when a student does not have a CBS or PTC award, regardless of eligibility. We met with WSAC to discuss their findings. While the delivered report populates $0, we learned that a handful of colleges may
have edited their file before submitting their interim report in CSAW. While that is an option available to colleges, we understand that manual intervention can be time consuming and potentially cause layout errors. In an effort to provide a solution as quickly
as possible, Debbie has developed a query that can be run after generating the WCG Interim file. This query pulls the WCG Interim file data that was generated, while omitting the erroneous $0 for CBS and PTC and can be downloaded in a .csv format to load to
the CSAW portal. For the remainder of 22-23 reporting, we recommend using the query to generate a file that aligns with WSAC reporting requirements. Instructions will be provided once we have confirmed the query is available in Production and we expect this
will be delivered <b>April 7th</b>.<span style="font-size:12.0pt; font-family:"Times New Roman",serif"></span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px">
<span style="font-size:12.0pt; font-family:"Times New Roman",serif"></span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px">
The logic to the delivered interim report will be corrected in time for 23-24 reporting. We will also include any additional file layout changes required.<span style="font-size:12.0pt; font-family:"Times New Roman",serif"></span></p>
<p class="x_x_x_xmsonormal" style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px; margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
<span style="font-size:12.0pt; font-family:"Times New Roman",serif"> </span></p>
<p class="x_x_x_xmsonormal" style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px; margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
<span style="font-size:12.0pt; font-family:"Times New Roman",serif">Thank you!</span></p>
<p class="x_x_x_xmsonormal" style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px; margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
<span style="font-size:12.0pt; font-family:"Times New Roman",serif"> </span></p>
<div><image003.png></div>
<span style="font-size: 12pt; font-family: "Franklin Gothic Medium", sans-serif; color: rgb(0, 55, 100);">Stephanie Casino</span><span style="font-size:12.0pt; font-family:"Times New Roman",serif"></span>
<p class="x_x_x_xmsonormal" style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px; margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif; line-height:10.55pt; text-autospace:none">
<span style="font-size: 10pt; font-family: "Franklin Gothic Medium", sans-serif; color: rgb(0, 55, 100);">Senior Functional Analyst, Campus Solutions (Financial Aid)</span><span style="font-size:12.0pt; font-family:"Times New Roman",serif"></span></p>
<p class="x_x_x_xmsonormal" style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px; margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif; line-height:10.55pt; text-autospace:none">
<span style="font-size: 10pt; font-family: "Franklin Gothic Book", sans-serif; color: rgb(0, 55, 100);">Washington State Board for Community and Technical Colleges</span><span style="font-size:12.0pt; font-family:"Times New Roman",serif"></span></p>
<p class="x_x_x_xmsonormal" style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px; margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
<span style="font-size: 12pt; font-family: "Times New Roman", serif; color: rgb(31, 73, 125);"><a href="mailto:scasino@sbctc.edu" data-auth="NotApplicable" data-loopstyle="link"><span style="font-size:10.0pt; font-family:"Franklin Gothic Book",sans-serif">scasino@sbctc.edu</span></a></span><span style="font-size: 10pt; font-family: "Franklin Gothic Book", sans-serif; color: rgb(0, 53, 97);">
</span><span style="font-size: 10pt; font-family: "Franklin Gothic Book", sans-serif; color: rgb(0, 55, 100);">• o:
</span><span style="font-size: 10pt; font-family: "Franklin Gothic Book", sans-serif; color: rgb(31, 56, 100);">360-704-1054 •</span><span style="font-size: 10pt; font-family: "Franklin Gothic Book", sans-serif; color: rgb(51, 51, 255);"><a href="https://www.sbctc.edu/colleges-staff/it-support/default.aspx" data-auth="NotApplicable" data-loopstyle="link"><span style="color: rgb(51, 51, 255);">
SBCTC.edu/IT Division</span></a></span><span style="font-size:12.0pt; font-family:"Times New Roman",serif"></span></p>
<p class="x_x_x_xmsonormal" style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px; margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
<a href="https://www.credly.com/badges/dd237db6-6aed-4466-ae89-9a5fbf3f2910/public_url" data-auth="NotApplicable"><span style="font-size: 12pt; font-family: "Times New Roman", serif; text-decoration: none; color: windowtext;"><img id="x_x_x__x0000_i1031" alt="https://images.credly.com/images/260e36dc-d100-45c3-852f-9d8063fa71e6/pmp-600px.png" data-unique-identifier="" style="width:1.1458in; height:1.1458in" width="110" height="110" border="0" src="https://images.credly.com/images/260e36dc-d100-45c3-852f-9d8063fa71e6/pmp-600px.png"></span></a><span style="font-size:12.0pt; font-family:"Times New Roman",serif"></span></p>
<p class="x_x_x_xmsonormal" style="margin-top: 0px; margin-bottom: 0px;margin-top:0px; margin-bottom:0px; margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
<span style="font-size:12.0pt; font-family:"Times New Roman",serif"> </span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>