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