ISIR Suspense Management
Purpose: To run an ISIR Suspense report using ctcLink.
Audience: Financial Aid staff.
This QRG reviews the process to run the CTC_FA_SUSPEND_ISIR_DETAIL query in an ad hoc manner. In general, you will want to retrieve your Suspended ISIR query results from your nightly ISIR JobSet.
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.
Navigation: Reporting Tools > Query > Schedule Queries
- The Schedule Query run control selection page displays.
- Enter a new or existing Run Control ID then select Add or Search.
- The Schedule Query page displays.
- In the Query Name field enter CTC_FA_SUSPEND_ISIR_DETAIL.
- Select the Search button.
- The Scheduled Query Search Page displays.
- Select the blue link for the desired query.
- The Scheduled Query Search Page displays.
- Select the blue link for the desired query.
- The CTC_FA_SUSPEND_ISIR_DETAIL edit prompts pagelet displays.
- Enter Institution and Aid Year.
- Select OK.
- The Schedule Query page displays.
- Select Run.
- The Process Scheduler Request page displays.
- Ensure that the Select check box is checked, and that the Format field contains XLS, then select OK.
- The Schedule Query page displays.
- Note the Process Instance number, then select Process Monitor.
- The Process Monitor page displays. For the Instance number noted in the preceding step, ensure that the Run Status is 'Success' and that the Distribution Status is 'Posted'.
- Select Details.
- The Process Detail page displays.
- Select View Log/Trace link located in the Actions section.
- The View Log/Trace page displays.
- From the File List select the Query name with the .xslx extension to open with Excel.
- The list opens in Excel.
Video Tutorial
The video below demonstrates the process actions described in steps listed above. There is no audio included with this video. Select the play button to start the video.
Video Tutorial via Panopto
View the link to ISIR Suspense Management. This link will open in a new tab/window.
Derreck Pressley
Why do you have to use Schedule Query instead of Query Viewer. It appears to be many unnecessary steps to go through Schedule Query?
Kelly Forsberg
Hi Derreck, Thanks for your question! Schedule Query is used because the amount of data in this query can contain thousands of rows, especially toward the end of the Aid Year. Schedule Query is the recommended way to run this data so that it leaves more bandwidth on the server for Query Viewer for more Ad Hoc processes. -Kelly Forsberg, ctcLink Functional Trainer (Fin Aid)
Brianne Sanchez
Does the query work report all ISIRs in suspense or is it only for ISIR files uploaded by the staff person who ran the query?
Kelly Forsberg
Hi Brianne, thanks for your question! The query reports all ISIRs in suspense, but each person running the query in Schedule Query will need to have their own individual run control ID. -Kelly Forsberg ctcLink Trainer (Fin Aid)