[ctcLinkfinaidsupport] **FirstLinks, DG2 & DG3 only** WORKAROUND for FSEOG totals (section 24, 25 & 26) on the FISAP

[Deborah Englehardt]

Hello!

We're not confident with the Oracle delivered queries:
FISAP_DISTRIBUTION_AUTO_0_EFC
FISAP_DISTRIBUTION_LTHT

Oracle says they have not maintained those delivered queries and there have been reported issues with those queries.

To get the totals that are missing on this year's FISAP shell, we suggest running last year's FISAP shell.

Every year, Oracle brings in the new year's FISAP shell and often times, there is no change in how the data is being pulled in the FISAP and just the change of aid year specific text.

The difference between last year's shell and this year's shell are:


  1.  The change in aid year specific text

[cid:3e126559-8a91-4dbb-820a-4bff81159c59]


  1.  The elimination of the "n/a" from the Grad/Professional FSEOG fields
  2.  The emptying of Section 24, 25 & 26 FSEOG fields


[cid:73d2ffd8-0954-4c79-bce2-8667c689f123]

As quoted earlier, Oracle explains Section 24, 25 & 26 FSEOG fields are left blank as a result of the change in Grad/Professional FSEOG field no longer being "n/a" globally.

Since no data is being pulled in for the Grad value, the sum could misrepresent what the actual total is if the school awarded any funds to Graduate/Professional students. Hence, the decision was made to not populate the totals to prevent the possibility of providing incorrect information.  The new fields for Graduate/Professional student FSEOG funds were intended as manual update fields, and it is recommended that fields and the FISAP instructions be reviewed.

If your college has not offered FSEOG to any Grad/Professional students, you can get the missing totals for Section 24, 25 & 26 FSEOG fields by running last year's FSEOG shell.

To do this, you would choose the FISAP Report 2021-2022 and choose the 2020-2021 aid year.
[cid:cac2707e-708e-4c28-910e-9d484e069116]

Confirm that all the numbers populated on the 2021-2022 FISAP shell matches the numbers populated on the new 2022-2023 FISAP shell so that you feel comfortable copying the numbers from Section 24, 25 & 26 FSEOG totals and putting it in for this year's FISAP.

If your college has offered FSEOG to any Grad/Professional students, this workaround will only work halfway because you'll need to manually add the Grad/Professional numbers.

Thank you,



[Compass]Deborah Englehardt

Functional Analyst, Campus Solutions (Financial Aid)

Washington State Board for Community and Technical Colleges

1300 Quince Street SE

Olympia, WA 98504-2495

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/>

________________________________
From: Deborah Englehardt <denglehardt at sbctc.edu>
Sent: Tuesday, September 21, 2021 10:20 AM
To: ctclinkfinaidsupport at lists.ctc.edu <ctclinkfinaidsupport at lists.ctc.edu>
Subject: **FirstLinks, DG2 & DG3 only** FSEOG totals (section 24, 25 & 26) on the FISAP are intentionally left blank this year on the generated file

​Good morning!

For the new FISAP, the FSEOG totals (24c, 24d, 25c, 25d, 26c, & 26d) do not populate like previous aid years because of the CARES Act which allowed emergency FSEOG to be awarded to eligible Grad/Prof students. Below is Oracle's explanation and reasoning behind this.


The lack of totals is by design. The totals are a sum of rows 1-23 in Part VI. There is not a query that pulls in the data for row 23 since there is variability for how a school might have awarded Graduate/Professional students SEOG funds, with the normal SEOG fund type only allowed to be awarded to undergraduate students, per regulations. All of this stems from the CARES Act, which allowed for FSEOG to be awarded to Grad/Prof students as emergency aid by the Department of Education, and as such is now required to be reported on the FISAP.

Since no data is being pulled in for the Grad value, the sum could misrepresent what the actual total is if the school awarded any funds to Graduate/Professional students. Hence, the decision was made to not populate the totals to prevent the possibility of providing incorrect information.  The new fields for Graduate/Professional student FSEOG funds were intended as manual update fields, and it is recommended that fields and the FISAP instructions be reviewed.

To help with getting the totals that are missing, there are delivered FISAP queries available in ctcLink.

FISAP_DISTRIBUTION_AUTO_0_EFC
FISAP_DISTRIBUTION_LTHT

We are currently validating that data on these two queries but wanted to send out an FYI so that you don't have to submit tickets about the fields being blank. 😊

Thank you,


[Compass]Deborah Englehardt

Functional Analyst, Campus Solutions (Financial Aid)

Washington State Board for Community and Technical Colleges

1300 Quince Street SE

Olympia, WA 98504-2495

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/>

________________________________
From: Deborah Englehardt <denglehardt at sbctc.edu>
Sent: Monday, September 20, 2021 4:05 PM
To: ctclinkfinaidsupport at lists.ctc.edu <ctclinkfinaidsupport at lists.ctc.edu>
Subject: **FirstLinks, DG2 & DG3 only** The FISAP is now in production!

Good afternoon!!

Image 22 with the FISAP is now in production. Attached is the updated guide. 😊

The first process of ctcLink FISAP process is to move the Federal Work Study awards into the disbursed column. For colleges that did not have Federal Work Study earnings for 2020-2021, you do not have to run through the External Awards process. You can skip straight to Running the FISAP Report process.

Thank you!


[Compass]Deborah Englehardt

Functional Analyst, Campus Solutions (Financial Aid)

Washington State Board for Community and Technical Colleges

1300 Quince Street SE

Olympia, WA 98504-2495

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/20210921/b5e8966a/attachment-0002.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-Compass.png
Type: image/png
Size: 20405 bytes
Desc: Outlook-Compass.png
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20210921/b5e8966a/attachment-0012.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-Compass.png
Type: image/png
Size: 20405 bytes
Desc: Outlook-Compass.png
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20210921/b5e8966a/attachment-0013.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 156979 bytes
Desc: image.png
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20210921/b5e8966a/attachment-0014.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 119661 bytes
Desc: image.png
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20210921/b5e8966a/attachment-0015.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 24237 bytes
Desc: image.png
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20210921/b5e8966a/attachment-0016.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-Compass.png
Type: image/png
Size: 20405 bytes
Desc: Outlook-Compass.png
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20210921/b5e8966a/attachment-0017.png>