How to Run Enrollment Query

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

CtcLink landing page, the tile CE Staff Homepage has a red square around it.

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

Navigation bar menu. There are red squares around the nav bar, menu, and reporting tools buttons.

  1. Click on Query, then Query Viewer.

The query menu tab, there is a red square around the Query Viewer button.

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

Query view screen, the query name is highlighted.

  1. If No matching values were found you will need to request access by filling out a ctcLink Security Access Request.
  2. 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. 
  3. Click the HTML link in the column titled Run to HTML. The query will open in a new window.

Returned query screen. There is a red box around the Run to HTML column and the Add to Favorites column.

  1. 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.
  2. Click View results. Results will populate.
  3. Click Download results in: Excel SpreadSheet.

An opened query viewer. There is a red square around the Excel SpreadSheet download button.

  1. 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. 

100% helpful - 1 review
Print Article