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 Billing Sample](https://media.screensteps.com/image_assets/assets/004/045/554/original/e712410e-d4f8-4103-b278-79e7c5afa275.png)
- QCS_SR_RS_ENROLL - Running Start FTE Data
![QCS SR RS ENROLL Sample](https://media.screensteps.com/image_assets/assets/004/045/556/original/44927564-3a6b-4b73-8f51-5b752f5fccab.png)
- QCS_SF_SR_TUITIONDUE - Running Start Tuition Due
![QCS SF SR TUITION DUE Sample](https://media.screensteps.com/image_assets/assets/004/045/813/original/c9cf0dfd-7fad-4dc4-aba3-d412b833f131.png)
- QCS_SF_CONCURR_ENROLLMNT - Term Actv UGRD Stdnts all Inst
![QCS SF CONCURR ENROLLMNT Sample](https://media.screensteps.com/image_assets/assets/004/045/841/original/c0b5b9f6-36df-4506-a2cf-2d17c79bb4ff.png)
- QCS_SF_CONCURRENT_ENRL_2_CNTCT - Concurrent Enroll Stdnts Prefr
![QCS SF CONCURRENT ENRL 2 CNCTC Sample](https://media.screensteps.com/image_assets/assets/004/045/845/original/58f7c923-706e-4f44-b622-acfb39a46520.png)
- QCS_SF_ENROLL_CANCEL_REPORT - Enroll Cancel w/student Group
![QCS SF ENROLL CANCEL REPORT Sample](https://media.screensteps.com/image_assets/assets/004/045/870/original/b775d9ef-4a03-4c44-8955-7ad3c17d32f8.png)
- QCS_SF_TUT_CALC_ERRORS - Tuition Calc Errors
![QCS SF TUT CALC ERRORS Sample](https://media.screensteps.com/image_assets/assets/004/045/894/original/9ced83df-7edb-4df1-b213-cd8dc8d5343d.png)
- QCS_SF_DEPT_RECEIPTS_GL - Missing GL info for dept rec
![QCS SF DEPT RECEIPTS GL Sample](https://media.screensteps.com/image_assets/assets/004/050/987/original/41996239-7f30-48ca-8d87-9445cf68943a.png)
- QCS_SF_E214_ACCTG_LN - SF/GL Acctg Ln
![QCS SF E214 ACCTN LN Sample](https://media.screensteps.com/image_assets/assets/004/051/121/original/58294e87-c0e4-47ef-9f0b-66c3a3ec2278.png)
- QCS_SF_E214_ACCTG_LN_JGEN - Lines not Jrnl Gen by Run Dt
![QCS SF E214 ACCTG LN JGEN Sample](https://media.screensteps.com/image_assets/assets/004/051/148/original/932f271a-0084-4775-ab76-2f3b0b034630.png)
- QCS_SF_E214_FUND_BAL - SF/GL Fund Balanced
![QCS SF E214 FUND BAL Sample](https://media.screensteps.com/image_assets/assets/004/051/168/original/01d97426-3bc8-4009-af0c-989418a4b21b.png)
- QCS_SF_E215_ACCTG_LN - SFC/GL Acctg Ln
![QCS SF E215 ACCTG LN Sample](https://media.screensteps.com/image_assets/assets/004/051/170/original/e7e6c31f-93a7-40e2-85af-e33950a2e7db.png)
- QCS_SF_E215_ACCTG_LN_JGEN - Lines not Jrnl Gen
![QCS SF E215 ACCTG LN JGEN Sample](https://media.screensteps.com/image_assets/assets/004/051/172/original/2f1b562c-acf9-49f8-86e3-750fb9124eaa.png)
- QCS_SF_E215_FUND_BAL - Fund Bal SFC/GL
![QCS SF E215 FUND BAL Sample](https://media.screensteps.com/image_assets/assets/004/051/174/original/ea680813-babf-43fa-893a-19a15f6e9c00.png)
- QCS_SF_VOID_BY_RECEIPT - Reversals by term OperID
![QCS SF VOID BY RECEIPT Sample](https://media.screensteps.com/image_assets/assets/004/051/244/original/275df9e0-0922-4dd9-b13e-26ce0e140212.png)
- QCS_FA_STDNT_ITEM_TYPE_BALANCE - Credit Balance Report
- CTCSF_PMTPRG - Payment Plan Progress Report
- BCS_3PST_IVC - 3rd Party Invoice w/Stdnt Data
![BCS 3PST IVC Sample](https://media.screensteps.com/image_assets/assets/004/053/834/original/9d6c9f86-1bd7-4e25-b19d-65b55fc75cc3.png)
- QCS_SF_3RD_PRTY_VNDR_PAY_RECON - 3RD Party Vendor Pay Recon
![QCS SF 3RD PRTY VNDR PAY RECON Sample](https://media.screensteps.com/image_assets/assets/004/053/836/original/75f29966-2d37-48d4-8418-580149401d49.png)
- CTC_SF_PDUE_CRDHIST - Credit History Temp Pop Pdue
![CTC SF PDUE CRDHIST Sample](https://media.screensteps.com/image_assets/assets/004/055/804/original/4fc63d59-badd-47e5-b452-f5c2a5b4f28a.png)
- CTC_SF_RPT_SF821 - SF Credit History All Students
![CTC SF RPT SF821 Sample](https://media.screensteps.com/image_assets/assets/004/055/806/original/33391938-a52c-40ca-ab43-6ddb67d5bf4c.png)
- SF754_Collections - Students in Collections
![SF754 Collections Sample](https://media.screensteps.com/image_assets/assets/004/055/809/original/67c13d85-c5ea-4a48-a93f-f7ee628845e0.png)
- CTC_SF_PS_3C_COLL_PASTDUE - Pop Sel Collection Past Dues
![CTC SF PS 3C COLL PASTDUE Sample](https://media.screensteps.com/image_assets/assets/004/055/838/original/556a22be-c722-411a-9b4a-fd9c1054ea60.png)
- CTC_SF_PS_COMGEN_LIMIT - Pop Select and CommGen for PER
![CTC SF PS COMGEN LIMIT Sample](https://media.screensteps.com/image_assets/assets/004/055/844/original/8bbd52f6-20d2-410d-b2ea-b572eee1c26f.png)
- 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
![CTC CM CLASS FEES BY STRM Sample](https://media.screensteps.com/image_assets/assets/004/056/429/original/8b1c9caa-10e1-40ea-bcfc-c55aca3a7ab8.png)
- QCS_ABE_COURSE_ID - Course Fee list
![QCS ABE COURSE ID Sample](https://media.screensteps.com/image_assets/assets/004/056/445/original/19b1e467-b00b-4d90-bdf0-94da30bddd36.png)
- QCS_SF_ITEM_TYPE_GL_INFO - Item Types and GL Information
![QCS SF ITEM TYPE GL INFO Sample](https://media.screensteps.com/image_assets/assets/004/056/462/original/1bc878f9-74c2-4606-b653-d6102ac899a6.png)
- CTC_SF_ACCTNG_LN_BY_DATE - Student Financials Transaction
![CTC SF ACCTNG LN BY DATE Sample](https://media.screensteps.com/image_assets/assets/004/056/478/original/1b7fbca9-c1a6-4416-9c74-e990852007de.png)
0 Comments
Add your comment