ctcLink Reference Center9.2 Campus Solutions9.2 CS - Academic AdvisementGenerating Advisement ReportsDegree Boost Query (Identify Students Near Completion but Not Enrolled)

Degree Boost Query (Identify Students Near Completion but Not Enrolled)

Purpose: Use this document to run the QCS_AA_DEGREE_BOOST query to identify students close to completing their degree, but who are no longer enrolled.

Audience: All Staff

The Degree Boost CEMLI query, QCS_AA_DEGREE_BOOST, is used to identify students who are near completion but no longer enrolled. The query results can be used for outreach and retention purposes.

In order for students to be returned in query results, the college must correctly configure a "TotalUnits" academic requirement for each academic plan. In addition, students must have a generated Academic Advisement Report (AAR). The following describes academic requirement configuration, how AARs are generated for students, and how to run the QCS_AA_DEGREE_BOOST query.

Configuring Academic Requirements

Navigation: NavBar > Navigator > Academic Advisement > Academic Requirements > Define Academic Requirements

The college must configure a "TotalUnits" academic requirement for all academic plans it would like to evaluate with QCS_AA_DEGREE_BOOST. Plans without a "TotalUnits" academic requirement will not be returned in query results.

Line Item Tab
  • Line Type: Course Requirement
  • Short Search Description: "TotalUnits" (no spaces, case sensitive)
  • Display of Status: Hide Status not checked
The image highlights the Line Item tab
Line Item Parameters Tab
  • Minimum Units: Must be populated
  • Credit Include Mode: Verify Only, Never Include
  • Print Control: Print on audit reports
  • Reporting: Always Report
The image highlights the Line Item Parameters tab with a focus on Minimum Units, Credit Include Mode, and Display Control fields
Line Item Detail Tab
  • Line Detail Sequence: 1
  • Line Detail Type: DLST
  • List Recall Mode: All Courses used
The image displays the Line Item Detail tab
Generating Academic Advisement Reports

Navigation: NavBar > Navigator > Academic Advisement > Student Advisement > Request Advisement Report

QCS_AA_DEGREE_BOOST uses Academic Advising Reports (AAR)s to identify students who are near completion but no longer enrolled. A student must have an AAR available to be included in query results.

AARs are generated in batch by SBCTC for term active students. Old AARs are purged to reduce AAR processing time. If a student does not have an AAR, staff members can manually generate an AAR for the student.

The image displays the Request Advisement Report - Advisement Report Request tab

Navigation:  Main Menu -> Reporting Tools -> Query -> Query Viewer

Due to the amount of data being analyzed when QCS_AA_DEGREE_BOOST is run, it is recommended to schedule this query instead of running it to HTML or Excel. This query is likely to time out if it is not scheduled.

Prompt values include the following:

  • Institution
  • Academic Career: UGRD or CNED.
  • Last Enrolled Term: The last term that the student had enrollment activity.
  • GPA (Minimum): The student's minimum cumulative GPA.
  • % Complete (Minimum): The minimum percentage of completed AAR requirements. (For example, "50"would return students who have completed 50% or more of their AAR requirements.)
  • Academic Program Like (Optional): The student's academic program. This prompt may be left blank to return students in all academic programs.
  • Academic Plan Like (Optional): The student's academic plan. This prompt may be left blank to return students in all academic plans.

Related Queries:

QCS_AA_NOT_ENROLLED_LAST_ENRL, a query based on, QCS_AA_DEGREE_BOOST has been rewritten accordingly.  This query identifies students with an active Student Program/Plan who do not have enrollment in the upcoming term and who last enrolled in a prompted date range.  This query contains optional prompts for degree, plan, and advisor.  Multiple student records indicate more than one assigned advisor.

QCS_SR_STU_GRP_ENRL_CHNG and QCS_AA_ADVISEE_ENRL_CHNG, use this query to identify enrollment changes for a Student Group (first query) or for an advisor's advisees (second query) during a certain timeframe OR within the last X days.  To use last X days, enter a value in X Days prompt, enter any values in the date prompts (they'll be ignored) and leave "Only Trans in last X days" checked.  To use date range, uncheck "Only trans in last X days."


Add your comment

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