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