[ctcLinkfinaidsupport] Guidance for 24-25 Interim Incremental File Issue

[Stephanie Casino]

Good Morning FA-

We would like to share an update ahead of Fall interim.

For 2023-2024 Interim reporting, the IsDelete field was added to the file layout to allow colleges the option of using the incremental file layout.

We were under the impression that when the IsDelete 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.

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 IsDelete 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.

To avoid this issue for fall, we recommend that colleges remove the IsDelete field from their WA College Grant csv file prior to loading the csv file to CSAW. The absence of the IsDelete column is how the WSAC Portal determines the file is a full file upload. Instructions are attached and can also be found in the WCG Interim Guide<https://ctclinkreferencecenter.ctclink.us/m/92436/l/848386-wcg-interim-reporting-business-process-guide> in the Reference.


Thank you!

[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>
[A logo with a purple circle  Description automatically generated]<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/20241015/a30dada7/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/20241015/a30dada7/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 11317 bytes
Desc: image003.png
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20241015/a30dada7/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 15661 bytes
Desc: image004.png
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20241015/a30dada7/attachment-0005.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Removing IsDelete from WCG Interim csv file.docx
Type: application/vnd.openxmlformats-officedocument.wordprocessingml.document
Size: 142011 bytes
Desc: Removing IsDelete from WCG Interim csv file.docx
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20241015/a30dada7/attachment-0001.docx>