9.2 Financial Aid Training Course Query List (1/25/2021)
Purpose: This document provides a list of queries that are mentioned in Financial Aid Canvas training courses.
Audience: Financial Aid staff
Each foldable section below corresponds to a single Financial Aid Canvas training course.
Within each foldable section, you'll find a list of hyperlinked query names, titles, and output samples. Click on the hyperlinked query name to open, in a new window, the Canvas course module that contains the query.
- CTC_FA_SB_AD_007 - Valid ISIRs rcve inti fm CEMLI
- CTC_FA_SB_PS_ATB - ATB Population Selection
- CTC_FA_SUSPEND_ISIR_DETAIL - ISIR Suspense With Details
- CTC_FA_SB_AD_016 - Homeless Youth on FAFSA CEMLI
- CTC_FA_SB_SL_XX9 - Initial To Do List Slect CEMLI
- CTC_FA_SB_PS_NSLDS_WEEKLY_PUSH - Aggregate Push No date limit
- CTC_FA_REMOVE_PRGRSS_UNITS - Remove FA progress units
- CTC_FA_ZEROFAUNITS - ABE/AESL Enroll w/FA Prg Unit
- CTC_FA_SB_FIX_TERM_WEEKS_INSTR - Fix Weeks of Instruction
- CTC_FA_BUDFLAG_Y_ALLTERMS - Upd budget flag Y for othr trm
- CTC_FA_SB_SL_SHOPPING_SHEET - R-231 Federal Shopping Sheet
- CTC_FA_HIGHER_ONE_SELECT_1 - Rvw Status Cmplte no R2CP CEML
- CTC_FA_HIGHER_ONE_SELECT_2 - Chklist Cmpltd No R2CP CEMLI
- CTC_FA_HIGHER_ONE_SELECT_3 - Awrd in Off/Acpt N R2CP CEMLI
- CTC_FA_SNG_POPULATE - E008 SNG Populate
- CTC_FA_SNG_POPULATE_ONE_ID - E008 SNG Populate 1 Emplid
- CTC_FA_SNG_ELIGIBILITY - E008 SNG Eligibility
- CTC_FA_SNG_OVERRIDE - E008 SNG Override
- CTC_FA_SB_PS_NSLDS_TM_CHKL_REQ - NSLDS TM Rqst Chklst Asgn CEMLI
- CTC_FA_NSLDS_TM_CHKL_REQ_2 - NSLDS TM Reqst Chklst Assign 2
- CTC_FA_SB_PS_NSLDS_REQ - Select NSLDS Xfer Monitor
- CTC_FA_SB_PS_NSLDS_WEEKLY_PUSH - Aggregate Push No date limit
- CTC_FA_SB_NSLDS_CHKLST_TO_COMP - Set NSLDS Chklst to comp CEMLI
- CTC_FA_RDY2PKG - Ready to package students
- CTC_FA_MASS_PACKAGE_SELECT_01 - Slct by Priority Filg Dte CEML
- CTC_FA_MASS_PACKAGE_SELECT_02 - Selct by Fle Cmplte Date CEMLI
- CTC_FA_MASS_PACKAGE_SELECT_03 - Priorty Filing date/SAP = U
- CTC_FA_TUIT_HOLD_SI_ASSIGN_01 - Accptd Awd & Acct Bl > 0 CEMLI
- CTC_FA_SB_1ST_AWRD_NOTIF - E004 1st Award Notification
- CTC_FA_MAX_REMEDIAL_CREDITS - Stdt Excds 45 Remd Crdits CEML
- CTC_FA_ASSIGN_PGK_VARS_F - Char1,2,3,4 = F
- CTC_FA_ENRL_SERVICE_IND_ADD - Add SrvcInd for mismatch enrl
- CTC_FA_SRVC_INDICATOR_LIST - List of Srvc Ind by Term
- CTC_FA_THIRD_PARTY_PAYMENTS - R-270 Non Credit Awds & Waivrs
- CTC_FA_SF_DISCREPANCY_LIST - discrepancy between dates
- CTC_SF_FINAID_REFUND_SUMMARY - FA to SF Summary by Date
- CTC_SF_FINAID_REFUND_DETAILS - FA to SF applied funds
- SFA_PELL_ORIGINATION - Pell Origination
- CTC_FA_MPN_CHECKLIST_ADD - Add MPN Checklist CEMLI
- QCS_FA_LOANS_NO_MPN_ON_ORIG - Loans w out MPN on Origination
- CTC_FA_ENT_LOAN_CHECKLIST_ADD - Add Entrce Loan Chklist CEMLI
- CTC_FA_ENTRANCE_LOAN_ADD - Add Entrance Loan Counseling
- CTC_FA_EC_LOAN_CNSL_ISSUES - Entrance Ln Counseling Issues
- CTC_FA_DL_ACDYREND_EXCSUMM_TRL - DLs to Excl Summ for Tri Coll
- CTC_FA_DL_ACADYEAR_POPUPD - UpdOfferActivity
- CTC_FA_SB_SL_LOANDISB - E-012 Loan Disb selection 3C
- CTC_FA_EXITLOAN_ASSIGN_1 - Add Exit Ltrs fr Grads CEMLI
- CTC_FA_EXITLOAN_ASSIGN_2 - Exit Ltrs for LTHT stdts CEMLI
- CTC_FA_EXITLOAN_ASSIGN_3 - Ad Exit Ltrs(did not rtn)CEMLI
- CTC_FA_LOAN_DEBT_NOTIF - Pop Select/Msg Ctr Loan Notif
- CTC_FA_EXIT_LOAN_ADD - Update Exit Cnsl via CRECMYOP
- CTC_FA_SULA_SERV_IND_ASSIGN - Assign SULA No Pack Sl
- CTC_FA_SERVICE_INDICATOR_LIST - List of assigned SI's
- CTC_FA_SULA_AWRDED_RVS - SULA Adjust List
- CTC_FA_YRP_ELIGIBILITY - Year Round Pell Eligibility
- CTC_FA_YRP_ELIGIBILITY_TRAILER - Year Round Pell Elg-Trailer
- CTC_FA_WITHDRAWN_F03_SVC_IND - Withdrawn FA Assigns Srv Ind
- CTC_FA_UNOFFICIAL_WITHDRAWN - Unofficial Withdrawn FA
- CTC_FA_SERVICE_INDICATOR_LIST - List of assigned SI's
- CTC_FA_NEED_R2T4_WKSHT - Have Srv Ind for R2TIV
- CTC_FA_WITHDRAWN_AID_AWARDS - Withdrawn FA students for R2T4
- CTC_FA_POST_WITHDRAWN - Post Withdrawn FA students
- CTC_FA_WITHDRAWN_UNOFF_AID_AWD - Unofficial Withdrawn FA R2T4
- CTC_FA_LDA_BY_STUDENT - Last Date of AttendancebyEMPLD
- CTC_FA_WAIVE_R2T4_SRV_IND - Need Srv Ind for R2T4 Waived
- CTC_FA_SNG_COMPARE - E008 SNG Compare
- CTC_R074A_MISSING_NATIONAL_ID - Missing National ID error rpt
- CTC_FA_FISAP_WORKSTUDY_EXTRACT - FISAP WORKSTUDY EXTRACT
- QCS_SR_FISAP_UNDUPL_HEADCOUNT - Undupl Headcount by Aid Year
- QCS_SF_FISAP_TUITAMT - FISAP Tuition Amount
- CTC_FA920 - Fund Roster query #1
- CTC_FA_CBS_AND_SNG_LIST - Awrd'd CBS and SNG Awards
- CTC_FA_ITEM_DISBURSED - FA item disbursed quarterly
- CTC_FA_WAITLISTED_AWARDS - students w/waitlist item type
- CTC_FA_TERM_ITEM_TYPE_AWARDED - Term Awarded by Item Type
- CTC_FA_TERM_OVERAWARDED - Term Budget Overawards
0 Comments
Add your comment