Running Admissions Query

Purpose: Use this document as a reference for running an admissions query in ctcLink.

Audience:Admissions Staff.

You must have at least one of these local college-managed security roles:

  • ZD_DS_QUERY_VIEWER

You must also set these SACR Security permissions:

If you need assistance with the above security roles or SACR settings, please contact your local college supervisor or IT Admin to request role access.

  • Navigation: Reporting Tools > Query > Query Viewer
  • Navigation: ctcLink CS Staff Homepage > Admissions Processing > Applications to be Processed

Accessing the Query

  1. On the Query Viewer page, locate the Search By field.
  2. From the drop-down menu, select Query Name.
  3. In the begins with box, enter QCS_RA_ADM_APPLS, then select Search.

Running the Query

  1. The Search Results display at the bottom of the page.
  2. Select a Run To option.
  3. In this example, choose HTML.
  4. 📝Note: If HTML is the only available “Run to” hyperlink, select it to run the process. After the results are returned, you will have the option to download to Excel.

Entering Prompt Values

  1. The QCS_RA_ADM_APPLS Prompts page opens in a new window.
  2. Enter or look up values for the following fields:
    • Institution (Required)
    • Admit Type (Blank = all)
    • Admit Term (Blank = all)
    • Acad Plan (Optional)
  3. Select View Results.
Query Results

Reviewing Query Results

  1. The query results display.
  2. Results can be downloaded as:
    • Excel Spreadsheet
    • CSV Text File
    • XML File

Interpreting Key Columns

  1. The results include a column that lists SDI, SXF, and SVR Service Indicators for all institutions.
  2. Colleges are encouraged to monitor this information before processing applications.
  3. Process complete.
Code Description
SDI Duplicate marked for deletion
SVR Student data verified
SXF Fraudulent application

0 Comments

Add your comment

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