Query Viewer

1. Log on to CunyFirst

2. Click on Compass Icon (Top right)

3. Click on "My Favorites"

4. Click on “CS-Query Viewer”

5. In the “Search By” choose Query Name, and type CU_SR

6. Click search and you should receive results.

• List of Queries below images

---

---

---

---

---

Description of Queries

1. CU_SR_CLASS_ENRL_ACAD_ORG

Enrollment capacity and enrollment totals by class in an academic department

1. CU_SR_CLASS_ENRL_ACAD_ORG_CRED

Adds the minimum/maximum credit values from the course catalog

1. CU_SR_CLASS_ENRL_LOC_TIME

Adds room information and meeting time information

1. CU_SR_CLASS_ENRL_LOC_TIME_ALL

Same as above for all academic departments

1. 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

1. CU_SR_CLASS_ENRL_NOT_ZERO_ALL

Same as above for all academic departments

1. CU_SR_CLASS_ENRL_CAPACITY

Enrollment capacity and enrollment totals compared to room capacity

1. CU_SR_CLASS_ENRL_CAPACITY_ALL

Same as above for all departments

1. CU_SR_CLASS_ENRL_SESSION

Enrollment capacity and enrollment totals by class for all academic departments. This is requested for a specific session (PCL)

1. 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

1. 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

1. 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

1. CU_SR_FACULTY_CLASSES

Classes that have faculty assigned are listed, in faculty last name order

1. CU_SR_FACULTY_CLASSES_LOC_TIME

Adds room information and meeting time information. This can be used to see a faculty member’s schedule

1. CU_SR_SELECT_MAJORS

This query will give you a list of students majoring or minoring in a specific plan

---