How to Run Enrollment Query

1. Log into ctcLink.
2. Click CS or CS Staff Homepage.

3. Click on Nav bar in the upper right corner of your screen.
4. Click on Menu.
5. Click on Reporting Tools.

6. Click on Query, then Query Viewer.

7. Copy this Query Name QCS_CM_CLASS_ENROLLMENTS_OPEN and paste it into the begins with box. Click the Search button.

8. If No matching values were found you will need to request access by filling out a ctcLink Security Access Request.
9. Locate the query in search results. If this is your first time running this query, click Favorite under the Add to Favorites column so you can access it more easily next time. 
10. Click the HTML link in the column titled Run to HTML. The query will open in a new window.

8. Enter the following parameters:  
   1. Institution: Type WA070. 
   2. Term: Click the magnifying glass to select the term.
   3. Acad Group (optional): 
   4. Class Status (optional): Select Active.
9. Click View results. Results will populate.
10. Click Download results in: Excel SpreadSheet.

11. Open the file. Click File, then Save as and save to SharePoint or OneDrive.

Questions

If you have any questions or want to set up some one on one time with the CES Administrator, please submit a ticket or view 9.2 Running a PeopleSoft Query.