Helpful CUNYFirst Data Queries
CUNYFIRST Queries* |
|||
QUERY Name |
Description |
Type |
Comments |
CU_SR_BI_STDNT_ENRL_MAJOR_ALL |
BI: Stdnt Enrl All For A Major |
student information |
|
CU_SR_CLASS_ENRL_ACAD_ORG |
Class Enrollments By Acad Org |
course and enrollment |
|
CU_SR_CLASS_ENRL_ALL |
Class Details |
course schedules and enrollment |
|
CU_SR_CLASS_ENRL_ALL_NEWSTDNT |
Class Details |
course schedules and enrollment |
contains designation, credits/hrs, and faculty info does not include labs with assoc # 9999 |
CU_SR_CLASS_ROSTERS |
Class Rosters By Term |
student information |
|
CU_SR_CLASS_SCHED_DATA_MOD_999 |
Incl. 9999 Assoc numbers |
course schedules and enrollment |
Master scheduling report |
CU_SR_CLASS_WAITLIST_ALL_X |
Waitlisted Stdnt By Inst/Term |
course and waitlist |
|
CU_SR_CLASS_WAITLIST_DEPT_X |
Waitlisted Students By Dept |
course and waitlist |
|
CU_SR_CLASS_WAITLIST_SUBJ_X |
Waitlisted Students By Subject |
course and waitlist |
|
CU_SR_CRSECAT_ACTIVE |
Active course in crs catalog |
course information |
|
CU_SR_CRSECAT_INACTIVE |
Inactive rows in course catalo |
course information |
|
CU_SR_PLAN_COUNT_TERM |
# of Students by Term & Plan |
analytics student data |
|
CU_SR_SELECT_MAJORS |
Majors / Minors List |
student information |
|
CU_SR_SELECT_PLAN |
Majors / Minors List |
student information |
|
CU_SR_STDNT_ENRL_BY_SUBJ_TERM |
Student Enrl By Subject Term |
student information |
*to run queries you must have CUNYFirst security access to reporting tools/ query manager or viewer.