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:
- ZD_DS_QUERY_VIEWER
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
- 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.
- Select the Search or Add button. The Schedule Query page will display.

- On the Schedule Query page, enter CTC_FA_SRVC_INDICATOR_LIST in the Query Name field.
- Select the Search button. The Scheduled Query Search Page will display.

- On the Scheduled Query Search page, select the query name link. An Edit Prompts pagelet will display.

- Enter the pagelet information:
- Institution
- Active Term
- Srv Ind Cd = FLF
- Select the OK button. A new Schedule Query page will be displayed.

- Select the Run button. The Process Scheduler Request page will display.

- On the Process Scheduler Request page, select the OK button. The Schedule Query page will display.

- On the Schedule Query page, note the assigned Process Instance number.
- Select the Process Monitor link. The Process List tab will display.

- On the Process List tab, select the Refresh button until the Run Status = 'Success' and the Distribution Status = 'Posted'.
- Select the Details link.

- On the Process Details page, select the View Log/Trace link. The Distribution Details page will display.

- 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.
- Use the report to update the listed students.

- The process to run a service indicator list query is now complete.
- End of procedure.
0 Comments
Add your comment