9.2 Service Indicator List (FLF) Query

Purpose:  Run a query that lists students with the 'FLF' service indicator in ctcLink.

Audience:  Financial Aid staff.

In addition to using the Authorization Failure Report to identify students who have the ‘FLF’ service indicator assigned, colleges have the option to run a query. The query will list only students with the ‘FLF’ service indicator.

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


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

Service Indicator List (FLF) Query

Navigation:  NavBar > Navigator > Reporting Tools > Query > Schedule Query

  1. The Query search page displays.  On the search page, enter an existing Run Control ID or select the Add a New Value tab to create a new value.
  2. Select the Search or Add button.  The Schedule Query page will display.
Schedule Query run control ID
  1. On the Schedule Query page, enter CTC_FA_SRVC_INDICATOR_LIST in the Query Name field.
  2. Select the Search button.  The Scheduled Query Search Page will display.
Query Name
  1. On the Scheduled Query Search page, select the query name link. An Edit Prompts pagelet will display.
Scheduled Query Search Page
  1. Enter the pagelet information:
    1. Institution
    2. Active Term
    3. Srv Ind Cd = FLF
  2. Select the OK button.  A new Schedule Query page will be displayed.
Edit Prompts pagelet
  1. Select the Run button.  The Process Scheduler Request page will display.
Schedule Query Run button
  1. On the Process Scheduler Request page, select the OK button.  The Schedule Query page will display.
Process Scheduler Request
  1. On the Schedule Query page, note the assigned Process Instance number.
  2. Select the Process Monitor link.  The Process List tab will display.
Process Instance number
  1. On the Process List tab, select the Refresh button until the Run Status = 'Success' and the Distribution Status = 'Posted'.
  2. Select the Details link.  
Process List tab
  1. On the Process Details page, select the View Log/Trace link.  The Distribution Details page will display.
Process Detail page
  1. On the View/Log Trace page, select the CTC_FA_SRVC_INDICATOR_LIST-xxxxxxx.csv file link.  A message should be generated asking what to do with the file, i.e., Open, Save, or Cancel.  It opens into an Excel spreadsheet.
  2. Use the report to update the listed students.
View Log/Trace
  1. The process to run a service indicator list query is now complete.
  2. End of procedure.


Add your comment

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