Query Viewer
Log on to CunyFirst
Click on Compass Icon (Top right)
Click on "My Favorites"
Click on “CS-Query Viewer”
In the “Search By” choose Query Name, and type CU_SR
Click search and you should receive results.
List of Queries below images
Description of Queries
CU_SR_CLASS_ENRL_ACAD_ORG
Enrollment capacity and enrollment totals by class in an academic department
CU_SR_CLASS_ENRL_ACAD_ORG_CRED
Adds the minimum/maximum credit values from the course catalog
CU_SR_CLASS_ENRL_LOC_TIME
Adds room information and meeting time information
CU_SR_CLASS_ENRL_LOC_TIME_ALL
Same as above for all academic departments
CU_SR_CLASS_ENRL_NOT_ZERO
Enrollment capacity and enrollment totals by class for an academic department, for those classes that HAVE enrollments. Classes with no enrollment are not listed. This is sorted by sessions
CU_SR_CLASS_ENRL_NOT_ZERO_ALL
Same as above for all academic departments
CU_SR_CLASS_ENRL_CAPACITY
Enrollment capacity and enrollment totals compared to room capacity
CU_SR_CLASS_ENRL_CAPACITY_ALL
Same as above for all departments
CU_SR_CLASS_ENRL_SESSION
Enrollment capacity and enrollment totals by class for all academic departments. This is requested for a specific session (PCL)
CU_SR_CLASS_ROSTER
Class roster for a specific class, sorted by student last name. This requires that you know the four or five digit class number that is in the class schedule
CU_SR_GRADES_STATUS
This will list by subject, catalog number, and class section which faculty members have submitted their grades. Only rosters that are “Approved” will have their grades posted
CU_SR_GRADES_STATUS_BY_FAC
This will list by faculty last name which faculty members have submitted their grades. Only rosters that are “Approved” will have their grades posted
CU_SR_FACULTY_CLASSES
Classes that have faculty assigned are listed, in faculty last name order
CU_SR_FACULTY_CLASSES_LOC_TIME
Adds room information and meeting time information. This can be used to see a faculty member’s schedule
CU_SR_SELECT_MAJORS
This query will give you a list of students majoring or minoring in a specific plan
Last updated