[ctcLinkfinaidsupport] FA census queries updated to include enrollment intensity

[Stephanie Casino]

Good Morning FA-

The queries below have been modified to include the new enrollment intensity field. These updates are now available in PRD:

  *   CTC_FA_LOAD_COMP_BETWEEN_DATE
  *   QCS_FA_CENSUS_DATE_LIST
     *   The following item types were also added to query criteria: 912000000105(WCG Connect), 920000000010 (Passport) and 920000000020 (Passport Incentive)
  *   QCS_FA_LOAD_DECREASE_B4_CENSUS
     *   The following item types were also added to query criteria: 911000000030 (Iraq Afghanistan Service Grant), 912000000105 (WCG Connect) ,912000000160 (National Guard Grant), 912000000250 (WA Bridge), 913000000100 (Need Based Tuition Grant)

FA Support is in the process of reviewing all public FA queries that contain FA Load to determine if the enrollment intensity field should be included and updating queries where appropriate.

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/20240724/3df3e908/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/20240724/3df3e908/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/20240724/3df3e908/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/20240724/3df3e908/attachment-0005.png>