ctcLink Reference CenterFinancial Aid ISIR Processing 23Running Suspense Prospects Query 23b

Running Suspense Prospects Query 23b

The Suspense Prospects query is an opportunity for schools to reach out to students who have submitted a FAFSA to your instutution, but have not applied for enrollment.

This query will include names, addresses and emails from the ISIR for contacting prospect students.

Navigation:  Main Menu > Reporting Tools > Query > Schedule Query

  1. Enter a new or existing Run Control ID.
Find an Existing Value and Add a New Value tabs
  1. Entert the Query Name - CTC_FA_SUSPENSE_PROSPECTS
  2. Click Search.
Schedule Query page
  1. Click the CTC_FA_SUSPENSE_PROSPECTS link.
Schedule Query Search Page
  1. Edit prompts will appear.  Populate the following fields:
    Award Year
    Aid Year
  2. Click OK.
Prompts page

The Schedule Query page will now be populated with the parameters to run the query.

  1. Click Run.
Schedule Query page
  1. Click OK from the Process Scheduler Request page.
Process Scheduler Request page
  1. Click the Process Monitor link and ensure the process runs to "Success" and "Posted".
Process Monitor link
  1. Click  Go Back to Schedule Query link.
Go back to Schedule Query link
  1. Click Report Manager link.
Reports section
  1. Click FA24 Requirement link.
Reperts section
  1. Click the CTC_FA_SUSPENSE_PROSPECTS-xxxxxx.csv link.
File list section
  1. Depending on browser, you will be asked to open the results in Excel.
  2. Click OK to open in Excel.
Excel worksheet

You can now filter the results and work the list accordingly.


Add your comment

E-Mail me when someone replies to this comment