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. For more information, see How do faculty view class rosters?
More Information
More information can be found at Running a PeopleSoft Query guide in the ctcLink Reference Center.