How do staff view a class roster?

Article Author Avatar Image
Shelly Scanlan
  • Updated

Navigation:  NavBar > Navigator > Reporting Tools > Query > Query Viewer

Class Roster by Class Number

Query: QCS_AC_CLASS_NUMBER_ROSTER

This returns all students enrolled in the selected class number(s) over the selected term(s). It includes student age and preferred contact details.

Class Roster by Department/Subject

Query: QCS_AC_CLASS_ROSTER_NO_BD

This returns all students enrolled in the selected subject over the term range. It includes class information such as instructor name and credits/units. It includes student information such as plan (e.g. “Associate in Arts AA DTA”), final grade, and student preferred contact details.

Class Roster by Program/Plan

Query: QCS_SR_PROG_ROSTER

This returns class and term enrollment information for all students active in the selected term and plan (e.g. “LASDTAA,” the Associate in Arts AA DTA). Fields include Cumulative Credits, Cumulative GPA, Class Nbr, Unit Taken, Subject, Catalog, and Course Attributes such as “WORKFORCE” and “ACADEMIC.” This query does not include student contact information.

Faculty View

Faculty have a different way to view class rosters and communicate with students. See the article How do faculty view class rosters? for details.

More Information

More information can be found at Running a PeopleSoft Query guide in the ctcLink Reference Center. 

This didn't solve the problem?

Please click the submit a request button below to create a ticket and a Shoreline agent will reply shortly!

Submit a request


Have feedback on this article? Click here to tell us what you think.

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request