Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This goes over the process to run the Honors Dashboard a generic Query.

Instructions

(warning) Users must have access to run query viewer.

  1. On Campus Solutions, click on Navigator

  2. Go to Campus Solutions → Reporting Tools → Query → Query Viewer

  3. Type in the query name in the search field below (1)

  4. Then click on search, you should see the query pop up that you’re looking for. 

  5. Click on “HTML” to run it. Be sure to click on “Favorites” to save it to your favorites so you don’t have to search for it each time.

  6. A new window will pop up, from here type in the term you wish to look up (or you can click on the magnifying glass) and type in the college:Depending on the query, some may ask for prompts in order to pull the specific information you’re looking for. Common prompts include:

    1. Career

      Code Block
      UGRD = Undergarduate (City, Mesa, Miramar)
      CE = College of Continuing Education
      CEHS = College of Continuing Education High School

    2. Term

      Code Block
      2217 = Fall 2021
      2223 = Spring 2022
      2225 = Summer 2022

    3. Campus

      Code Block
      CITY = City College
      MESA = Mesa College
      MIRA = Miramar College
      ECC = Educational Cultural Complex
      WESTC = West City
      CCHAV = Cesar Chavez
      MCITY = Mid City
      NCCTR = North City / CE (Mesa/Miramar)

  7. Click on “View Results” to run the query.

  8. To download the results, you can click on “Excel SpreadSheet” to download your results.

...