Most Used and Favorite Queries

Purpose: To provide a list of queries which have been ran and/or favorited by users the most.

Audience: Query Developers and end users

Note: This list is updated quarterly and is in Excel format for easy filtering and searching.

Most Used:         Query has been executed more than 100 times

Most Favorited:      Query is in someone's favorite list and has been executed more than 10 times


Tanjagay Martin

Hi Grace. Thank you for your comment. The following link will direct you to a website where you can search for various queries: One of the great things about MetaLink is that it allows users to search for queries, reports, and pivot grids across a variety of fields from a single input source. Have a great day! -Tanjagay Martin | ctcLink Trainer

Margaret R Harrison


Is there a query we can run to see all students who have an undecided / undeclared academic plan?


Kelly Forsberg

Hello Margaret, you can run QCS_SR_OPEN_PPS_IN_ACAD_PLAN. You can run it for UNDECLAC (academic) UNDCLPR (proftech) UNDECLTR (transitional). Hope this helps! -Kelly Forsberg, ctcLink Functional Trainer, Financial Aid

Mary Adamski

Hello, I am wondering if there is a query that we can run that shows course enrollment/grades for students with a certain attribute (SWRT for example). Similar to how the query QCS_SR_CLASS_ENR_STUGRP uses the student group.

Tanjagay Martin

Hi Mary,

The query you listed will work. You can enter 'SWRT' in the Select Student Group prompt field. First, the Student Attributes are manually assigned by college staff along with the Student Attribute Values to identify a student's participation in particular programs. Then, students are "mass-assigned" to Student Groups based on these Student Attributes. Thank you so much for your question! Have an amazing day. ~Tanjagay Martin | CS Core Functional Trainer

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.