Report ID | Title | Description | Columns Included | Records Included | Developer | Requestor | Comments | Shared with | Technical Specifications |
---|---|---|---|---|---|---|---|---|---|
CU_BAR_AA_00001 | Xsfer Students w/Forgn Language | This is a listing of non-CUNY transfer students for a particular admit term who have transferred certain language courses or who are taking or will take one of those language courses. Prompt on Institution, Career and Admit Term. | Last Name, First Name, Middle Name, Emplid, Last School Attended, Foreign Language Course. | ADM_MC_VW - Admissions Data CU_BIO_VW - Biographical Information View Hierarchy Join SUB QUERY for Does Not Exist: CLASS_TBL_SE_VW - Class Table Student Enrl View SUB QUERY for Does Not Exist: TRNS_CRSE_DTL - Student Transfer Course Detail | Michael McGovern | Sharon Ricks | New report | ||
CU_BAR_AA_00002 | Transfer Credit Evaluation | This is a listing of a student's or applicant's transfer credit. Prompt on Institution, Career and Emplid. | Last Name, First Name, Middle Name, Empl ID, Artic Term, Sourse ID, Course ID, Offer Nbr, Subject, Catalog, Transfer, Grade, Grd Pt/Unt, Description, Designation Formal Description | TRNS_CRSE_DTL - Student Transfer Course Detail Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join CRSE_OFFER - Course Catalog Offerings Hierarchy Join RQMNT_DESIG_TBL - Requirement Designation Table UNION 1: TRNS_OTHR_DTL - Student Other Credit Detail Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join CRSE_OFFER - Course Catalog Offerings Hierarchy Join RQMNT_DESIG_TBL - Requirement Designation Table Hierarchy Join | Michael McGovern | Elaine Cataletto | New report | E Cataletto, D Berry, C Keck, A Kamruzzaman, TLodhi | |
CU_BAR_AA_00003 | 2+ WU Grades | This is a listing of all student who have more than one WU grade per term. Prompt on Institution, Career and Term. | Last Name, First Name, Middle Name, Empl ID, Preferred Email, Cum GPA, Count | CLASS_TBL_SE_VW - Class Table Student Enrl View Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join STDNT_CAR_TERM - Student Career Term Table | Michael McGovern | Elaine Cataletto | New report | E Cataletto, D Berry, C Keck, A Kamruzzaman, TLodhi | |
CU_BAR_AA_00004 | Discontinued Students | This is a list of students who have not completed their degree requirement. It eliminates any students who have completed another program for the same institution. Prompt on Institution, Career, Program and Plan (optional). | Last Name, First Name, Middle Name, Empl ID, Career, Student Career Number, Program, Plan, Admit Term, Expected Graduation Term, Last Term Activated, Term Credits Taken, Term Credits Passed, Career Credits Taken, Career Credits Passed, Term GPA, Cumulative GPA, Other Career Number, Other Career, Other Program, Other Plan, Other Career Status | ACAD_PROG - Academic Program ACAD_PLAN - Academic Plan CU_BIO_VW - Biographical Information View Hierarchy Join STDNT_CAR_TERM - Student Career Term Table ACAD_PROG - Academic Program (Second stack) ACAD_PLAN - Academic Plan (Second stack) SUB QUERY for STRM - TERM: STDNT_CAR_TERM - Student Career Term Table UNION1: -ACAD_PROG - Student Academic Program Hierarchy Join -CU_BIO_VW - Biographical Information View Hierarchy Join -STDNT_CAR_TERM - Student Career Term Table Hierarchy Join -ACAD_PLAN - Student Academic Plan Table Hierarchy Join -SRVC_IND_DATA - Service Indicator Data Hierarchy Join -SRVC_IND_DATA - Service Indicator Data Hierarchy Join SUB QUERY for STRM - TERM: -STDNT_CAR_TERM - Student Career Term Table SUB QUERY Does Not Exist: -ACAD_PROG - Student Academic Program | Michael McGovern | Arthur Downing | New report |