9.2 SF Training Course Query List (9/13/2021)
Purpose: This document provides a list of queries that are mentioned in Student Financials Canvas training courses.
Audience: Student Financials staff
Each foldable section below corresponds to a single Student Financials 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.
- QCS_SR_RSBILLING - Running Start Billing Info

- QCS_SR_RS_ENROLL - Running Start FTE Data

- QCS_SF_SR_TUITIONDUE - Running Start Tuition Due

- QCS_SF_CONCURR_ENROLLMNT - Term Actv UGRD Stdnts all Inst

- QCS_SF_CONCURRENT_ENRL_2_CNTCT - Concurrent Enroll Stdnts Prefr

- QCS_SF_ENROLL_CANCEL_REPORT - Enroll Cancel w/student Group

- QCS_SF_TUT_CALC_ERRORS - Tuition Calc Errors

- QCS_SF_DEPT_RECEIPTS_GL - Missing GL info for dept rec

- QCS_SF_E214_ACCTG_LN - SF/GL Acctg Ln

- QCS_SF_E214_ACCTG_LN_JGEN - Lines not Jrnl Gen by Run Dt

- QCS_SF_E214_FUND_BAL - SF/GL Fund Balanced

- QCS_SF_E215_ACCTG_LN - SFC/GL Acctg Ln

- QCS_SF_E215_ACCTG_LN_JGEN - Lines not Jrnl Gen

- QCS_SF_E215_FUND_BAL - Fund Bal SFC/GL

- QCS_SF_VOID_BY_RECEIPT - Reversals by term OperID

- QCS_FA_STDNT_ITEM_TYPE_BALANCE - Credit Balance Report
- CTCSF_PMTPRG - Payment Plan Progress Report
- BCS_3PST_IVC - 3rd Party Invoice w/Stdnt Data

- QCS_SF_3RD_PRTY_VNDR_PAY_RECON - 3RD Party Vendor Pay Recon

- CTC_SF_PDUE_CRDHIST - Credit History Temp Pop Pdue

- CTC_SF_RPT_SF821 - SF Credit History All Students

- SF754_Collections - Students in Collections

- CTC_SF_PS_3C_COLL_PASTDUE - Pop Sel Collection Past Dues

- CTC_SF_PS_COMGEN_LIMIT - Pop Select and CommGen for PER

- QCS_SF_COLLECT_AGREE_PYMNT_RCN - Collection Agreement Recon/Payment Query
QCS_SF_PAST_DUE_COLLECTIONS - Students in Collections
- CTC_CM_CLASS_FEES_BY_STRM - Class fees by term

- QCS_ABE_COURSE_ID - Course Fee list

- QCS_SF_ITEM_TYPE_GL_INFO - Item Types and GL Information

- CTC_SF_ACCTNG_LN_BY_DATE - Student Financials Transaction

0 Comments
Add your comment