9.2 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
- On the Query Viewer page next to *Search By, select Query Name from the drop down menu and enter QCS_RA_ADM_APPLS into the begins with box.
- Select Search.
![Query Viewer Search Page](https://media.screensteps.com/image_assets/assets/002/046/541/original/764cac61-cb00-4ceb-b14a-55eda9431804.png)
- The Search Results display at the bottom of the page. Select a Run To option; in this example, we will select HTML.
Note: If HTML is the only hyper-linked "Run to" option, run the process in HTML, then a user will have the option to download to Excel after the results are returned.
![Query Viewer Search Results Page](https://media.screensteps.com/image_assets/assets/002/046/547/original/30716d89-6ddd-4718-b97a-db37309afb0a.png)
- The QCS_RA_ADM_APPLS prompts page displays in a new window.
- Enter or look up information for the following:
- Institution
- Admit Type
- Admit Term
- Select View Results.
The query includes a column listing SDI/SXF/SVR Service Indicators for all institutions and encourage colleges to monitor for information in that column before processing apps.
- SDI - duplicate marked for deletion
- SVR - student data verified
- SXF - fraudulent application
![Query Prompts Page](https://media.screensteps.com/image_assets/assets/002/046/543/original/11d0d644-84cb-4e74-95f8-4cfc7ff13ab9.png)
The results display at the bottom of the QCS_RA_ADM_APPLS prompts page. You can download the results to an Excel Spreadsheet, a CSV Text File, or an XML File if you wish.
![Query Results Page](https://media.screensteps.com/image_assets/assets/002/046/545/original/7db8ea94-0273-4bd9-bfe5-fe56f5d24691.png)
- Close the new window.
- Process complete.
0 Comments
Add your comment