This page uses javascript to help render elements, if you have problems please enable javascript.
 
You are now inside the main content area
 
 
 
left col

MyQueries for Class Schedule Data

right col
 
left col

Navigation

  • CMS Home
  • Main Menu
  • Fullerton SA Customizations
  • My Queries
right col
 
 
left col

Select the Query Name in your list of queries.

If the query is not on the first page, try clicking View All.

Or you can click Find then search for part of the query name.

screen shot of my queries page

right col
 
left col

Common Useful Queries for Class Schedule Data

right col
 
 
 
 
left col

Class Schedule by Term Only

List of all class sections offered for a given semester.

Class Schedule by Term web page

Class Section Topics

List of variable topics classes offered for a given semester. Use this to verify that the correct topic is assigned to each section.

Class Section Notes

List of class notes attached to each section. Class notes roll from the previous year to the next. Use this query to review and add/remove what is needed.

Learning Mode and Space Type

List of classes with their values for the Learning Mode and Space Type fields. The Learning Mode value defaults to 09 – Face to Face. Be sure to update these fields for all online classes.

right col
 
 
 
 
left col

Combined Sections Table with Section Data

List of combined sections for a given semester. Email scheduling@fullerton.edu if any cross-listings or combinations need to be set up or removed.

Sections with No Grade Access

List of sections with missing instructors or missing “Approve” access to submit grades

Course Catalog by Offering

List of active and inactive courses. Useful to check which course numbers are not yet taken. Also provides the CS Number (staffing formula) for all courses.

Fields to Enter:

1 = State Support Classes

Today’s Date: This field allows the query to provide both current and future effective dated rows (i.e., to capture any catalog number changes)

Current Courses / Attribute

For a list of WEB-APPROVED courses, type in "WEB" when prompted.

right col
 
left col
right col