9.2 Campus Solutions Training Course Query List (1/12/2021)
Purpose: This document provides a list of queries that are mentioned in core Campus Solutions Canvas training courses.
Audience: Campus Solutions staff.
Each foldable section below corresponds to a single Campus Solutions Canvas training course.
Within each foldable section, you'll find a list of hyperlinked query names, titles, and output samples. Select the hyperlinked query name to open, in a new window, the Canvas course module that contains the query.
This course does not contain any queries.
- QCS_AA_ADVISOR_ASSIGN_1 - Students assigned to advisor
![QCS AA ADVISOR ASSIGN 1 Sample](https://media.screensteps.com/image_assets/assets/004/059/232/original/9069db4f-68e9-4c10-9159-5f1a729a7968.png)
- QCS_AA_ADVISOR_ASSIGN_2 - Enrolled with no advisor
![QCS AA ADVISOR ASSIGN 2 Sample](https://media.screensteps.com/image_assets/assets/004/059/311/original/4ad5a2a7-f2d3-4d4c-8f2a-f14989a45426.png)
- QCS_CC_SRVC_IND_DA_V2 - Service indicator data
![QCS CC SRVC IND DA V2 Sample](https://media.screensteps.com/image_assets/assets/004/061/687/original/7ef1c741-aad9-4841-b80a-4bf822af4295.png)
- QCS_CC_SRVC_IND_INFO - Service Indicator Information
![QCS CC SRVC IND INFO Sample](https://media.screensteps.com/image_assets/assets/004/061/695/original/098543d5-3781-47c3-9c8b-cd480920644a.png)
- QCS_CC_SRVC_IN_RSN - Service indicator reason
![QCS CC SRVC IN RSN Sample](https://media.screensteps.com/image_assets/assets/004/061/703/original/c64bf189-c399-4f82-be67-0f755a54913c.png)
- CTC_SR_MNID_POPSEL - Missing SSN no INTL
![CTC SR MNID POPSEL Sample](https://media.screensteps.com/image_assets/assets/004/062/826/original/6a4fe20e-18c2-4def-8908-35a8cfc3ddac.png)
This course does not contain any queries.
This course does not contain any queries.
This course does not contain any queries.
- QCS_RA_APP_OAA - Document Upload through OAA
![QCS RA APP OAA Sample](https://media.screensteps.com/image_assets/assets/004/070/474/original/aea9ec89-1d66-4f94-8bc6-3a56ea7e8e06.png)
- QCS_RA_ADM_APPLS - Applications to be processed
![QCS RA ADM APPLS Sample](https://media.screensteps.com/image_assets/assets/004/070/501/original/fb6965f8-435f-40f5-b6a8-a629cea4d89f.png)
- CTC_AD_3CENGINE_RESID - 3C Engine PopSel Query CEMLI
![CTC AD 3CENGINE RESID Sample](https://media.screensteps.com/image_assets/assets/004/070/543/original/951826e6-2d24-479e-b3b3-e16815e96013.png)
- QCS_CM_CLASS_MISSING_CNTCT_HRS - Classes Missing Contact Hours
![QCS CM CLASS MISSING CNTCT HRS Sample](https://media.screensteps.com/image_assets/assets/004/070/780/original/b75120ee-5fc2-48eb-a7c9-a909a7677df0.png)
- QCS_CM_CRSE_MISSING_CNTCT_HRS - Courses Missing Contact Hours
![QCS CM CRSE MISSING CNTCT HRS Sample](https://media.screensteps.com/image_assets/assets/004/070/794/original/392bbb03-1f98-4487-b2c1-0674a2724bd0.png)
- QCS_CM_CLASS_MISSING_CNTCT_HRS - Classes Missing Contact Hours
![QCS CM CLASS MISSING CNTCT HRS Sample](https://media.screensteps.com/image_assets/assets/004/073/061/original/7cc6c8f1-141f-424f-aa60-7a552259e3ea.png)
- QCS_CM_CRSE_MISSING_CNTCT_HRS - Courses Missing Contact Hours
![QCS CM CRSE MISSING CNTCT HRS Sample](https://media.screensteps.com/image_assets/assets/004/073/063/original/715505eb-45ca-452f-8c55-4d6e4009bb89.png)
- QCS_SR_NSC_DISCONTINUED_STACKS - Stacks Discontinued Mid-Term
![QCS SR NSC DISCONTINUED STACKS Sample](https://media.screensteps.com/image_assets/assets/004/073/208/original/41e8c724-97a9-42a7-ad3e-6e2b7df7d2c8.png)
- QCS_SR_WAITLISTED_STUDENTS - Waitlisted Students
![QCS SR WAITLISTED STUDENTS Sample](https://media.screensteps.com/image_assets/assets/004/073/637/original/f1177f98-975c-4830-bca4-6d44f935b1dc.png)
- SSR_STD_ENR_BLK_BY_CAR_PROG - Block Enrollment by Car & Prog
![SSR STD ENR BLK BY CAR PROG Sample](https://media.screensteps.com/image_assets/assets/004/073/676/original/1e17408e-6412-42fa-ae0e-0ff727d7c776.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/073/692/original/55ac416e-5fd2-4124-ac64-f6b71425c54c.png)
- CTC_SR_WAITLIST - CTC_SR_WAITLIST
![CTC_SR_WAITLIST Sample](https://media.screensteps.com/image_assets/assets/004/073/793/original/1285d140-7764-430e-958c-1433c553a2f2.png)
- QCS_SR_WITHDRAWN - Withdrawing from all classes
![QCS SR WITHDRAWN Sample](https://media.screensteps.com/image_assets/assets/004/073/804/original/fbc87926-2bf3-4ad9-b3ff-5e616b64eec8.png)
- SSR_TS_ADVISOR - Transcript Query by Advisor
![SSR TS ADVISOR Sample](https://media.screensteps.com/image_assets/assets/004/073/850/original/b74df67b-c0b6-480d-9865-e44121afb31d.png)
- SSR_MLSTN_PROGRAM - Milestones Process by Program
![SSR MLSTN PROGRAM Sample](https://media.screensteps.com/image_assets/assets/004/073/881/original/15ff21ec-3752-4a0b-a97a-958d12bfef74.png)
- QCS_SR_GRD_ROSTER_TRNSCRP_NOTE - Grade Roster Transcript Notes
![QCS SR GRD ROSTER TRNSCRP NOTE Sample](https://media.screensteps.com/image_assets/assets/004/075/725/original/13fbfdbe-3722-4f63-a442-85ab68618a4b.png)
- SSR_REQS_CAREER - Post Enrl Req Select by Career
![SSR REQS CAREER Sample](https://media.screensteps.com/image_assets/assets/004/075/796/original/7aa4718a-9c0e-41bc-95e3-d00be914334f.png)
- QCS_CM_PERC_REPORT_DETAIL - PERC Report Student Detail
![QCS CM PERC REPORT DETAIL Sample](https://media.screensteps.com/image_assets/assets/004/075/798/original/661a69d1-fa75-49e6-8fd5-f043aabb8125.png)
- QCS_CM_PERC_REPORT_SUMMARY - PERC Report Class Summary
![QS CM PERC REPORT SUMMARY Sample](https://media.screensteps.com/image_assets/assets/004/075/816/original/3cdb9c0b-67bf-48b4-b971-35a468c6ea97.png)
- QCS_SR_ELCTRNC_TRANS_RECEIVED - Electronic Transcripts Rcvd
![QCS SR ELCTRNC TRANS RECEIVED Sample](https://media.screensteps.com/image_assets/assets/004/075/983/original/51757d3d-a612-47a7-a4ec-7a1fd53aa778.png)
- QCS_SR_CTC_TRANS_REQ - CTC to CTC Transcript Requests
![QCS SR CTC TRANS REQ Sample](https://media.screensteps.com/image_assets/assets/004/076/004/original/9f344c4b-4b29-4e39-91cc-f9697b8dbf1b.png)
- QA_CS_SR_PS_TRAN_BY_PROGRAM - Query for pop select testing
![QA CS SR PS TRAN BY PROGRAM Sample](https://media.screensteps.com/image_assets/assets/004/076/258/original/9dee8fc8-b4e6-488f-b62d-23d7d0f0058d.png)
- QCS_SR_RSTRANSCRIPTS - Running Start Batch Transcript
![QCS_SR_RSTRANSCRIPTS Sample](https://media.screensteps.com/image_assets/assets/004/076/269/original/546e9be3-c49b-4b60-826e-3c985a59ac2f.png)
- SSR_TS_ACADLEVEL - Transcript Query by Acad Level
![SSR TS ACADLEVEL Sample](https://media.screensteps.com/image_assets/assets/004/076/277/original/4b2cbfa9-0386-4bbf-a187-fb4ac8d15076.png)
- SSR_TS_ADVISOR - Transcript Query by Advisor
![SSR TS ADVISOR Sample](https://media.screensteps.com/image_assets/assets/004/076/316/original/67efe69c-d635-4f9a-b861-93acf0ebf2bd.png)
- SSR_TS_CAREER - Transcript Query by Career
![SSR TS CAREER Sample](https://media.screensteps.com/image_assets/assets/004/076/320/original/7105deb8-df59-44ef-aa51-9d4c42c8b666.png)
- SSR_TS_PROGPLAN - Transcript Query by Prog Plan
![SSR TS PROGPLAN Sample](https://media.screensteps.com/image_assets/assets/004/076/336/original/30d87efa-c230-4956-9eea-c422799415f7.png)
- SSR_TS_PROGRAM - Transcript Query by Program
![SSR TS PROGRAM Sample](https://media.screensteps.com/image_assets/assets/004/076/347/original/191be483-2f27-4652-a4cc-ac2e22831afa.png)
- SSR_TS_STUDENT_GRP - Transcript Query by Stdnt Grp
![SSR TS STUDENT GRP Sample](https://media.screensteps.com/image_assets/assets/004/076/353/original/4d4e4aba-317a-4f42-8830-e5c5892c0b44.png)
- SSR_TS_UT001 - Transcript Unit Test
![SSR TS UT001 Sample](https://media.screensteps.com/image_assets/assets/004/076/355/original/61edaaf3-9d86-4fc8-9935-3ffc315e64f5.png)
- CTC_POP_GRADPRG_CHKOUT_MSNG - Pop Select prgm/plan updates
![CTC POP GRADPRG CHKOUT MSNG Sample](https://media.screensteps.com/image_assets/assets/004/076/393/original/7cab7ed1-b58d-4623-a352-cf881ce1d3a7.png)
- SSR_GRADPRG_AA_RESULTS - Graduation Prog AA Results
![SSR GRADPRG AA RESULTS Sample](https://media.screensteps.com/image_assets/assets/004/076/402/original/795a1417-7b38-457f-90b1-49989ca5fa5d.png)
- SSR_GRADPRG_CHKOUTSTAT - Graduation Prog Degr Checkout
![SSR GRADPRG CHKOUTSTAT Sample](https://media.screensteps.com/image_assets/assets/004/076/407/original/55b1d69d-baac-437e-9e34-45ad72e99a7a.png)
- SSR_GRADPRG_CHKOUTSTAT2 - Graduation Prog Term Chkout St
![SSR GRADPRG CHKOUTSTAT2 Sample](https://media.screensteps.com/image_assets/assets/004/076/428/original/94cfc1b9-ccac-4bc5-9e74-08e923af0dc4.png)
- SSR_GRADPRG_EMPLID - Graduation Prog Emplid
![SSR GRADPRG EMPLID Sample](https://media.screensteps.com/image_assets/assets/004/076/453/original/01d950eb-3358-41b9-bfa7-213933982412.png)
- SSR_GRADPRG_EXPGRADTERM - Graduation Prog Exp Grad Term
![SSR GRADPRG EXPGRADTERM Sample](https://media.screensteps.com/image_assets/assets/004/076/455/original/72dc19c4-8e43-4c4a-b651-0a8739ec10f9.png)
- SSR_GRADPRG_GRADTRACK - Graduation Prog Grad Tracking
![SSR GRADPRG GRADTRACK Sample](https://media.screensteps.com/image_assets/assets/004/076/459/original/52e51041-7317-422d-9cad-54de5f181649.png)
- SSR_GRADPRG_STDNTCARTERM - Graduation Prog Stdnt car term
![SSR GRADPRG STDNTCARTERM Sample](https://media.screensteps.com/image_assets/assets/004/076/465/original/177f0d2e-2e38-4f3f-86a2-a6c025c961ce.png)
- CTC_SR_POPSEL_ELIG_BLANK - R188 Grad Eligibility Blank
![CTC SR POPSEL ELIG BLANK Sample](https://media.screensteps.com/image_assets/assets/004/076/675/original/36172988-e4f7-48b1-bd64-854e72cebb58.png)
- CTC_SR_POPSEL_ELIG_APPROVED - R188 Grad Eligibility Approved
![CTC SR POPSEL ELIG APPROVED Sample](https://media.screensteps.com/image_assets/assets/004/076/691/original/01ea89ab-2d72-4d74-a60d-d27497e9e885.png)
- CTC_SR_POPSEL_ELIG_AWARDED - R188 Grad Eligibility Awarded
![CTC SR POPSEL ELIG AWARDED Sample](https://media.screensteps.com/image_assets/assets/004/076/696/original/354c4b94-ab31-421e-b383-8c45ec9a5ac4.png)
- CTC_SR_POPSEL_ELIG_DENIED - R188 Grad Eligibility Denied
![CTC SR POPSEL ELIG DENIED Sample](https://media.screensteps.com/image_assets/assets/004/076/711/original/43da79b7-a602-4df8-91b8-24c49140bad8.png)
- CTC_NSC_DEGREE_CC1 - Degree Info for NSC - Header
![CTC NSC DEGREE CC1 Sample](https://media.screensteps.com/image_assets/assets/004/076/796/original/e34fd45b-68df-47b0-b389-bbc7561425ef.png)
- SSR_VB_POP_ROLL_BNSUMM - PSQuery for PopSelect
![SSR VB POP ROLL BNSUMM Sample](https://media.screensteps.com/image_assets/assets/004/082/059/original/4bc62939-79f8-4634-b515-ff88cd8dd268.png)
- CTC_VB_POP_UPDTERM - Update term PopSelect Query
![CTC VB POP UPDTERM Sample](https://media.screensteps.com/image_assets/assets/004/082/069/original/16ae9e61-bbe3-4417-8748-b7284081c9bc.png)
- QCS_SR_VB_ENROLL_UPDATE - Veteran Enrollment Updates
![QCS SR VB ENROLL UPDATE Sample](https://media.screensteps.com/image_assets/assets/004/082/103/original/486fdbd7-f705-48ea-be4e-6926837a4fe0.png)
- CTC_SR_VET_BENEFIT - Veterans Benefit
![CTC SR VET BENEFIT Sample](https://media.screensteps.com/image_assets/assets/004/082/106/original/1152ea7c-3072-468c-9eaf-a74c8bebf750.png)
- QCS_SR_VB_REPORTED - Reported Veteran Enrollment
![QCS SR VB REPORTED Sample](https://media.screensteps.com/image_assets/assets/004/082/126/original/2c0034bd-dcb8-47c9-a25a-b0eb910ae319.png)
0 Comments
Add your comment