[ctcLinkfinaidsupport] [FINAL UPDATE] Queries Updated Due to Newly Identified FTI Fields
Britney Corbitt
bcorbitt at sbctc.edu
Fri May 2 10:21:52 PDT 2025
Greetings,
The following queries were updated again and are now accessible only to college users with security role ZD_DS_QRY_FA_FTI_HIGH_SENS:
* FISAP_DISTRIBUTION_AUTO_0_EFC
* FISAP_DISTRIBUTION_GRAD
* FISAP_DISTRIBUTION_LTHT
* FISAP_DISTRIBUTION_UGRD_DEPEND
* FISAP_DISTRIBUTION_UGRD_IND
* FISAP_ELIG_APP_GRAD_IND
* FISAP_ELIG_APP_UGRD_DEP_DEG
* FISAP_ELIG_APP_UGRD_DEP_NOT_FT
* FISAP_ELIG_APP_UGRD_DEP_NO_DEG
* FISAP_ELIG_APP_UGRD_IND_DEG
* FISAP_ELIG_APP_UGRD_IND_NO_DEG
* FISAP_NO_DISB_IN_GRAD_MAX_TERM
* FISAP_NO_DISB_NOT_FT_MAX_TERM
[Compass]
Britney Corbitt
Functional Analyst, Campus Solutions (Financial Aid)
Washington State Board for Community and Technical Colleges
bcorbitt at sbctc.edu<mailto:bcorbitt at sbctc.edu> • o: 360-704-1841
sbctc.edu<https://www.sbctc.edu/> • Twitter: @SBCTCWashington<https://twitter.com/SBCTCWashington> • Facebook: @WASBCTC<https://www.facebook.com/wasbctc/>
________________________________
From: Britney Corbitt <bcorbitt at sbctc.edu>
Sent: Friday, April 11, 2025 11:02 AM
To: ctclinkfinaidsupport at lists.ctc.edu <ctclinkfinaidsupport at lists.ctc.edu>; Sanchez, Brianne via DirFinAid <dirfinaid at lists.ctc.edu>
Subject: [UPDATE] Queries Updated Due to Newly Identified FTI Fields
Hello,
I just wanted to notify every one of the latest status of the updated queries.
The following queries were updated again and are now accessible only to college users with security role ZD_DS_QRY_FA_FTI_HIGH_SENS:
* QCS_FA_ISIR_DATA
* QCS_FA_ISIR_DATA_SECURE
* QCS_FA_ISIR_DATA_STGRP
* QCS_FA_NEEDY_WAIVER_ELIG
The following queries will be addressed and updated to allow access to college users once the query freeze ends (After April 29th):
* FISAP_DISTRIBUTION_AUTO_0_EFC
* FISAP_DISTRIBUTION_GRAD
* FISAP_DISTRIBUTION_LTHT
* FISAP_DISTRIBUTION_UGRD_DEPEND
* FISAP_DISTRIBUTION_UGRD_IND
* FISAP_ELIG_APP_GRAD_IND
* FISAP_ELIG_APP_UGRD_DEP_DEG
* FISAP_ELIG_APP_UGRD_DEP_NOT_FT
* FISAP_ELIG_APP_UGRD_DEP_NO_DEG
* FISAP_ELIG_APP_UGRD_IND_DEG
* FISAP_ELIG_APP_UGRD_IND_NO_DEG
* FISAP_NO_DISB_IN_GRAD_MAX_TERM
* FISAP_NO_DISB_NOT_FT_MAX_TERM
Happy Friday!
[Compass]
Britney Corbitt
Functional Analyst, Campus Solutions (Financial Aid)
Washington State Board for Community and Technical Colleges
bcorbitt at sbctc.edu<mailto:bcorbitt at sbctc.edu> • o: 360-704-1841
sbctc.edu<https://www.sbctc.edu/> • Twitter: @SBCTCWashington<https://twitter.com/SBCTCWashington> • Facebook: @WASBCTC<https://www.facebook.com/wasbctc/>
________________________________
From: Britney Corbitt <bcorbitt at sbctc.edu>
Sent: Wednesday, April 2, 2025 4:57 PM
To: ctclinkfinaidsupport at lists.ctc.edu <ctclinkfinaidsupport at lists.ctc.edu>; Sanchez, Brianne via DirFinAid <dirfinaid at lists.ctc.edu>; Britney Corbitt <bcorbitt at sbctc.edu>
Subject: Re: Queries Updated Due to Newly Identified FTI Fields
It has come to our attention that there is an issue with security for the ISIR queries. We are currently working to correct this. We will send an update shortly.
Thank you!
[Compass]
Britney Corbitt
Functional Analyst, Campus Solutions (Financial Aid)
Washington State Board for Community and Technical Colleges
bcorbitt at sbctc.edu<mailto:bcorbitt at sbctc.edu> • o: 360-704-1841
sbctc.edu<https://www.sbctc.edu/> • Twitter: @SBCTCWashington<https://twitter.com/SBCTCWashington> • Facebook: @WASBCTC<https://www.facebook.com/wasbctc/>
________________________________
From: ctcLinkfinaidsupport <ctclinkfinaidsupport-bounces at lists.ctc.edu> on behalf of Britney Corbitt via ctcLinkfinaidsupport <ctclinkfinaidsupport at lists.ctc.edu>
Sent: Wednesday, April 2, 2025 8:48 AM
To: ctclinkfinaidsupport at lists.ctc.edu <ctclinkfinaidsupport at lists.ctc.edu>; Sanchez, Brianne via DirFinAid <dirfinaid at lists.ctc.edu>
Subject: [ctcLinkfinaidsupport] Queries Updated Due to Newly Identified FTI Fields
[Sent from outside SBCTC]
Greetings FA Community,
As of February 11, 2025, the Department of Education updated Electronic Announcement GENERAL-23-34<https://fsapartners.ed.gov/knowledge-center/library/electronic-announcements/2023-05-12/access-and-use-federal-tax-information-fti-federal-student-aid-programs-beginning-2024-25-fafsa-processing-cycle-updated-february-11-2025> to include additional ISIR fields that should be considered Federal Tax Information (FTI). See the list of newly added fields below:
* SFA_PAR_TOT_ALLOW
* SFA_PAR_PAYROLLTAX
* SFA_PAR_IPA
* SFA_PAR_PEEA
* SFA_PAR_PAI
* SFA_PAR_PAAI
* SFA_PAR_CONTRIB
* SFA_STD_PAYROLLTAX
* SFA_STD_IPA
* SFA_STD_PAR_ALLOW
* SFA_STD_SEEA
* SFA_STD_TOT_ALLOW
* SFA_STD_STAI
* SFA_STD_SCI
* SFA_STD_SAAI
* SFA_STD_TOT_CONTRI
* STU_TOTAL_INC_CH
* TOTAL_INCOME_CH
* FISAP_TOTAL_INC_CH
The following queries in ctcLink contain one or more of the newly identified FTI fields:
* QCS_FA_ISIR_DATA
* QCS_FA_ISIR_DATA_SECURE
* QCS_FA_ISIR_DATA_STGRP
* QCS_FA_NEEDY_WAIVER_ELIG
* FISAP_DISTRIBUTION_AUTO_0_EFC
* FISAP_DISTRIBUTION_GRAD
* FISAP_DISTRIBUTION_LTHT
* FISAP_DISTRIBUTION_UGRD_DEPEND
* FISAP_DISTRIBUTION_UGRD_IND
* FISAP_ELIG_APP_GRAD_IND
* FISAP_ELIG_APP_UGRD_DEP_DEG
* FISAP_ELIG_APP_UGRD_DEP_NOT_FT
* FISAP_ELIG_APP_UGRD_DEP_NO_DEG
* FISAP_ELIG_APP_UGRD_IND_DEG
* FISAP_ELIG_APP_UGRD_IND_NO_DEG
* FISAP_NO_DISB_IN_GRAD_MAX_TERM
* FISAP_NO_DISB_NOT_FT_MAX_TERM
Implications:
Users without security role ZD_DS_QRY_FA_FTI_HIGH_SENS will lose access to run the above mentioned queries today, April 2nd, 2025. Additionally, FTI begin and end tags were added to the FTI data fields in each query.
Thank you,
Britney
[Compass]
Britney Corbitt
Functional Analyst, Campus Solutions (Financial Aid)
Washington State Board for Community and Technical Colleges
bcorbitt at sbctc.edu<mailto:bcorbitt at sbctc.edu> • o: 360-704-1841
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/20250502/04ba2d67/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-Compass.png
Type: image/png
Size: 15360 bytes
Desc: Outlook-Compass.png
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20250502/04ba2d67/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-Compass.png
Type: image/png
Size: 15360 bytes
Desc: Outlook-Compass.png
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20250502/04ba2d67/attachment-0005.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-Compass.png
Type: image/png
Size: 15360 bytes
Desc: Outlook-Compass.png
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20250502/04ba2d67/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-Compass.png
Type: image/png
Size: 15360 bytes
Desc: Outlook-Compass.png
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20250502/04ba2d67/attachment-0007.png>
More information about the ctcLinkfinaidsupport
mailing list