<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Aptos;}
@font-face
{font-family:"Franklin Gothic Medium";
panose-1:2 11 6 3 2 1 2 2 2 4;}
@font-face
{font-family:"Franklin Gothic Book";
panose-1:2 11 5 3 2 1 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Aptos",sans-serif;
mso-ligatures:standardcontextual;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#467886;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Aptos",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:11.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1027" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#467886" vlink="#96607D" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Good Morning FA-<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">We would like to share an update ahead of Fall interim.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">For 2023-2024 Interim reporting, the <i>IsDelete</i> field was added to the file layout to allow colleges the option of using the incremental file layout.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">We were under the impression that when the<i> IsDelete</i> column was left blank, the file layout would be treated as the typical full file upload where each upload is a fresh start. The full file upload allows for awards that had been
previously reported in CSAW but have since been cancelled in PS (therefore no longer present in the PS Interim csv) to be cancelled in CSAW.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Last week a college notified us that 2023-2024 award cancellations in PS were not properly communicated to CSAW through the 2023-2024 Interim. Having the
<i>IsDelete</i> column in the file layout made the file an incremental file upload so awards that were previously reported in CSAW but have since been cancelled in PS (therefore no longer present in the PS Interim csv) did not get cancelled in CSAW. <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">To avoid this issue for fall, we recommend that colleges remove the<i> IsDelete</i> field from their WA College Grant csv file prior to loading the csv file to CSAW. The absence of the
<i>IsDelete</i> column is how the WSAC Portal determines the file is a full file upload. Instructions are attached and can also be found in the
<a href="https://ctclinkreferencecenter.ctclink.us/m/92436/l/848386-wcg-interim-reporting-business-process-guide">
WCG Interim Guide</a> in the Reference.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thank you!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
<v:stroke joinstyle="miter" />
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0" />
<v:f eqn="sum @0 1 0" />
<v:f eqn="sum 0 0 @1" />
<v:f eqn="prod @2 1 2" />
<v:f eqn="prod @3 21600 pixelWidth" />
<v:f eqn="prod @3 21600 pixelHeight" />
<v:f eqn="sum @0 0 1" />
<v:f eqn="prod @6 1 2" />
<v:f eqn="prod @7 21600 pixelWidth" />
<v:f eqn="sum @8 21600 0" />
<v:f eqn="prod @7 21600 pixelHeight" />
<v:f eqn="sum @10 21600 0" />
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect" />
<o:lock v:ext="edit" aspectratio="t" />
</v:shapetype><v:shape id="Picture_x0020_3" o:spid="_x0000_s1026" type="#_x0000_t75" alt="Title: SBCTC logo - Description: Compass" style='position:absolute;margin-left:0;margin-top:0;width:45.1pt;height:84.5pt;z-index:251659264;visibility:visible;mso-wrap-style:square;mso-width-percent:0;mso-height-percent:0;mso-wrap-distance-left:9pt;mso-wrap-distance-top:0;mso-wrap-distance-right:9pt;mso-wrap-distance-bottom:0;mso-position-horizontal:absolute;mso-position-horizontal-relative:text;mso-position-vertical:absolute;mso-position-vertical-relative:text;mso-width-percent:0;mso-height-percent:0;mso-width-relative:page;mso-height-relative:page'>
<v:imagedata src="cid:image001.png@01DB1EDA.B6EADA30" o:title=" Compass" />
<w:wrap type="square"/>
</v:shape><![endif]--><![if !vml]><img width="60" height="113" style="width:.625in;height:1.1736in" src="cid:image004.png@01DB1EDE.68EF5550" align="left" hspace="12" alt="Title: SBCTC logo - Description: Compass" v:shapes="Picture_x0020_3"><![endif]><span style="font-size:12.0pt;font-family:"Franklin Gothic Medium",sans-serif;color:#003764">Stephanie
Casino<o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:10.55pt;text-autospace:none"><span style="font-size:10.0pt;font-family:"Franklin Gothic Medium",sans-serif;color:#003764">Senior Functional Analyst, Campus Solutions (Financial Aid)<o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:10.55pt;text-autospace:none"><span style="font-size:10.0pt;font-family:"Franklin Gothic Book",sans-serif;color:#003764">Washington State Board for Community and Technical Colleges<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><a href="mailto:scasino@sbctc.edu"><span style="font-size:10.0pt;font-family:"Franklin Gothic Book",sans-serif;color:blue">scasino@sbctc.edu</span></a></span><span style="font-size:10.0pt;font-family:"Franklin Gothic Book",sans-serif;color:#003561">
</span><span style="font-size:10.0pt;font-family:"Franklin Gothic Book",sans-serif;color:#003764">• o:
</span><span style="font-size:10.0pt;font-family:"Franklin Gothic Book",sans-serif;color:#1F3864">360-704-1054 •</span><span style="font-size:10.0pt;font-family:"Franklin Gothic Book",sans-serif;color:#3333FF"><a href="https://www.sbctc.edu/colleges-staff/it-support/default.aspx"><span style="color:#3333FF">
SBCTC.edu/IT Division</span></a></span><span style="font-family:"Calibri",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal"><a href="https://www.credly.com/badges/dd237db6-6aed-4466-ae89-9a5fbf3f2910/public_url"><span style="color:windowtext;text-decoration:none"><img border="0" width="109" height="109" style="width:1.1319in;height:1.1319in" id="Picture_x0020_2" src="cid:image003.png@01DB1EDA.B6EADA30" alt="A logo with a purple circle
Description automatically generated"></span></a><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>