[ctcLinkfinaidsupport] WCG Interim Reporting and $0 Awards in CSAW Portal

[Stephanie Casino]

Good Afternoon FA-



Last week WSAC notified us of the issue below:



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 10th



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 April 7th.



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.

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>
[https://images.credly.com/images/260e36dc-d100-45c3-852f-9d8063fa71e6/pmp-600px.png]<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/20230330/261ae8ee/attachment-0001.html>
-------------- 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/20230330/261ae8ee/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 8117 bytes
Desc: image003.png
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20230330/261ae8ee/attachment-0003.png>