...
| Report ID | Title | Description | Columns Included | Records Included | Developer | Requestor | Comments | Shared with |
|---|---|---|---|---|---|---|---|---|
| CU_BAR_SR_00001 | New Undergrads on Probation | This is a list of undergraduate, degree-seeking students for a certain admit term (last term) who have a low GPA. Prompt on Institution and Admit Term. | Last Name, First Name, Middle Name, Empl ID, 1st Plan, 2nd Plan, Preferred Email, Mail, Address 1, Mail Address 2, Mail City, Mail State, Mail Postal, GPA Credits, Term Grd Points Term GPA, Appl Nbr, Admit Type | - ACAD_PROG - Student Academic Program Hierarchy Join SUB QUERY: Does not Exist -STDNT_GRPS_HIST | Michael McGovern | Elaine Cataletto | New Report | E Cataletto, C Keck, A Kamruzzaman, D Berry, T. Lodhi, P. Ackerman |
| CU_BAR_SR_00002_1 | Student Data by Stdnt Group | This is a list of students active in a prompted student group at the beginning of the prompted term. Prompt on Institution, Career, Term and Student Group. | Empl ID, Last Name, First Name, Middle Name, Active In SG, Preferred Email, Campus Email, Admit Term, Admit Type, Total Transfer Units, Total Cum Units | TERM_TBL - Term Definition Table Hierarchy Join STDNT_GRPS_HIST - Student Groups History Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join EMAIL_FERPA_VW - EMAIL FERPA VIEW Hierarchy Join ACAD_PROG - Student Academic Program Hierarchy Join ADM_APPL_DATA - Admission Application Data Hierarchy Join STDNT_CAR_TERM - Student Career Term Table Hierarchy Join | Michael McGovern | Stephanie Govan | New Report | S Govan, A Kamruzzaman, C Keck, P Sunda, T.Lodhi |
| CU_BAR_SR_00003_2 | Enrolled Students Report
| This is a listing of students enrolled in the prompted term & Career. It lists the name, emplid, email address, career, academic level , program, plan(s). Prompt on Institution and Term. | Last, First Name, Middle, Empl ID, Career, Academic Level, Program, Admit Term, Email, 1st Plan, 1st Sub-Plan, 2nd Plan, 2nd Sub-Plan, 3rd Plan, 3rd Sub-Plan | STDNT_CAR_TERM - Student Career Term Table Hierarchy Join ACAD_PROG - Student Academic Program Hierarchy Join SCC_EMAIL_QVW - Email Addresses Query View Hierarchy Join ACAD_PLAN - Student Academic Plan Table Hierarchy Join ACAD_SUBPLAN - Student Academic Subplan Table Hierarchy Join ACAD_PLAN - Student Academic Plan Table Hierarchy Join ACAD_SUBPLAN - Student Academic Subplan Table Hierarchy Join ACAD_PLAN - Student Academic Plan Table Hierarchy Join ACAD_SUBPLAN - Student Academic Subplan Table Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join
| Michael McGovern | Mihai Vladu | New report for Career Development. | M Vladu, C Keck, A. Kamruzzaman, P. Ackerman, S. Loebis |
| CU_BAR_SR_00004 | Completions Report | This is a listing of students who have completed their programs in the prompted term. It lists the name, emplid, email address, career, program, plan(s), plan description, action and effective dates, gender, ethnicity and cum GPA. Prompt on Institution and Term. | Last Name, First Name, Middle Name, Empl ID, Sex, Career, Program, Degree, Acad Plan, Plan Description, Compl Term, Confer Dt, Degr GPA, Campus Email, Ethnicity1, Ethnicity2, Ethnicity3, Ethnicity4, Ethnicity5 | ACAD_DEGR - Student Degree Table Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join SF_STDNT_PRS_VW - SF Student Personal Data View Hierarchy Join ACAD_PROG - Student Academic Program Hierarchy Join ACAD_PLAN - Student Academic Plan Table Hierarchy Join ACAD_PLAN_TBL - Academic Plan Table Hierarchy Join SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join | Michael McGovern | Mihai Vladu | New report for Career Development. | M Vladu, C Keck, T.Lodhi |
| CU_BAR_SR_00005 | Non-Enrolled Students by SG | This is a list of students in a prompted student group who are not enrolled in the term. It lists the name, emplid, email address, career, program, plan(s) and cum GPA. Prompt on Institution, Term and Student Group. | Last Name, First Name, Middle Name, Empl ID, Cum GPA, Admit Term, Admit Type, Career, Program, Plan, Plan Description, Email | STDNT_GRPS_HIST - Student Groups History Hierarchy Join SUB QUERY Does not Exist: STDNT_ENRL - Student Enrollment Table | Michael McGovern | Marisol Morales | SEEK report but should work for other student groups. | M Morales, C Keck, A Kamruzzaman, T.Lodhi |
| CU_BAR_SR_00006 | Completed Students by SG | This is a list of students in a prompted student group who have completed their degree. It lists the name, emplid, email address, career, program, plan(s) and cum GPA. Prompt on Institution, Completion Term and Student Group. | Last Name, First Name, Middle Name, Empl ID, SG Status, Cum GPA, Compl Term, Career, Program, Plan, Plan Description, Email, Address 1, Address 2, City, State, Postal | STDNT_GRPS_HIST - Student Groups History Hierarchy Join | Michael McGovern | Marisol Morales | SEEK report but should work for other student groups. | M Morales, C Keck, A Kamruzzaman, T.Lodhi |
| CU_BAR_SR_00007 | Enrollments by SG | This is a list of class enrollments with grades, in a prompted student group. It lists the name, emplid, email address, cum GPA, FA credits and class enrollments. Prompt on Institution, Enrollment Term and Student Group. | Last Name, First Name, Middle Name, Empl ID, Admit Term, Exp Grad, FA Taken, Cum GPA, Status, Status Date, Program, Plan, Campus Email, Subject, Catalog, Section, Session, Grade | TERM_TBL - Term Definition Table Hierarchy Join UNION: TERM_TBL - Term Definition Table Hierarchy Join STDNT_GRPS_HIST - Student Groups History Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join ACAD_PROG - Student Academic Program Hierarchy Join CLASS_TBL_SE_VW - Class Table Student Enrl View Hierarchy Join
| Michael McGovern | Marisol Morales | SEEK report but should work for other student groups. | M Morales, C Keck, A Kamruzzaman, T.Lodhi |
| CU_BAR_SR_00008 | Re-entries by Student Group | This is a list of SEEK students who had a break from school. Prompt on Institution, Career, Term and Student Group. | Last Name, First Name, Middle Name, Empl ID, Acad Prog, Cum GPA, Admit Term, Terms at Baruch, Preferred Phone, Preferred Email | TERM_TBL - Term Definition Table Hierarchy Join SUB QUERY for STERM -Term: TERM_TBL - Term Definition Table SUB QUERY for Exist: STDNT_CAR_TERM - Student Career Term Table SUB QUERY Does not Exist: STDNT_CAR_TERM - Student Career Term Table
| Michael McGovern | Marisol Morales | SEEK report but should work for other student groups.. | M Morales, C Keck, A Kamruzzaman,T.Lodhi |
| CU_BAR_SR_00009 | All Service Indicators by SG | This is a list of students and their service indicators who are active in a student group. Prompt on Institution, Career, Term and Student Group. | Last Name, First Name, Middle Name, Empl ID, Service Ind, Reason Code | TERM_TBL - Term Definition Table Hierarchy Join | Michael McGovern | Marisol Morales | SEEK report but should work for other student groups. | M Morales, C Keck, A Kamruzzaman, T.Lodhi |
| CU_BAR_SR_00010 | Class Enrollments by SG | This is a list of class enrollments and grades in a prompted student group. Prompt on Institution, Career, Term, Student Group, Subject(optional) and Catalog Number (optional). | Last Name, First Name, Middle Name, Empl ID, Subject, Catalog,Class Description, Section, Session, Grade | TERM_TBL - Term Definition Table Hierarchy Join | Michael McGovern | Marisol Morales | SEEK report but should work for other student groups. | M Morales, C Keck, A Kamruzzaman, T.Lodhi |
| CU_BAR_SR_00010_1 | Class Enrollments Hist by SG | This is a list of class enrollments and grades history for students in given term. Prompt on Institution, Career, Term. | Last Name, First Name, Middle Name, Empl ID, Subject, Catalog,Class Description, Section, Session, Grade | TERM_TBL - Term Definition Table Hierarchy Join STDNT_GRPS_HIST - Student Groups History Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join CLASS_TBL_SE_VW - Class Table Student Enrl View Hierarchy Join | Tabassum Lodhi | Sarah Loebis | Modified but Zicklin report | S.Loebis, P. Ackerman, T. Lodhi |
| CU_BAR_SR_00011 | GPA Between by SG | This is a list of students in a prompted student group who have GPAs between certain prompted amounts. It lists the name, emplid, email address, career, program, plan(s) and cum GPA. Prompt on Institution, Term and Student Group. | Last Name, First Name, Middle Name, Empl ID, FA Eligible Units, Program, Plan, Plan Description, Cum GPA, Email | STDNT_GRPS_HIST - Student Groups History Hierarchy Join | Michael McGovern | Marisol Morales | SEEK report but should work for other student groups. | M Morales, C Keck, A Kamruzzaman, T.Lodhi |
| CU_BAR_SR_00012 | New Students w/Student Groups | This is a list of new students and the active student groups. Prompt on Institution, Career, Admit Term range and Admit Type (optional). | Last Name, First Name, Middle Name, Empl ID, Program, Plan, Admit Type, Preferred Email, Campus Email, Student Group | ACAD_PROG - Student Academic Program Hierarchy Join UNION: ACAD_PROG - Student Academic Program Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join STDNT_GRPS_HIST - Student Groups History Hierarchy Join ADM_APPL_DATA - Admission Application Data Hierarchy Join
| Michael McGovern | Stephanie Govan | New report. | S Govan, A Kamruzzaman, C Keck, T.Lodhi |
| CU_BAR_SR_00013 | Academic Standing Report | This is a listing of students whose academic standing is not 'Good'. Prompt on Institution and Term. | Term, Acad Standing, Acad Level, Empl ID, Last Name, First Name, Total Credits, Term GPA, Cum GPA, Campus Email | STDNT_CAR_TERM - Student Career Term Table Hierarchy Join | Michael McGovern | Czarina Valente | New report. | C Valente, C Keck, A Kamruzzaman, T.Lodhi |
| CU_BAR_SR_00014 | F1/J1 Visa Students | This is a list of term-activated students who have F1 or J1 visas. Prompt on Institution and Term. | Last Name, First Name, Middle Name, Empl ID, Career, Term, Term Units, Phone, Email, Country, Visa, Status, Status Date, Issue Date, Expire Dt, Visa/Pmt# | STDNT_CAR_TERM - Student Career Term Table Hierarchy Join SUB QUERY Effective Date: SCC_VISA_P_QVW - Visa Data Query View | Michael McGovern | Rosa Kelley | New report. | A Kamruzzaman, C Keck, R Kelley, T.Lodhi |
CU_BAR_SR_00014_2 | F1/J1 Visa Students | This is a list of term-activated students who have F1 or J1 visas. Prompt on Institution and Term. | Last Name, First Name, Middle Name, Empl ID, Career, Term, Term Units, Phone, Email, Country, Visa, Status, Status Date, Issue Date, Expire Dt, Visa/Pmt#
| Tabassum Lodhi | Angel Arcelay | modified report | A.Arcelay, T.Lodhi | |
| CU_BAR_SR_00015_2 | Degree Audit Report | This is a listing of students who have completed their programs in the prompted term. It lists the name, emplid, email address, career, academic group, program, admit term, plans (up to 2 majors, 3 minors), plan transcript description, subplans, gender, contact information, degree status, confer date, honors suffix, SEEK indicator, HONR indicator, total units, total passed units and cum GPA. Prompt on Institution, Completion Term range and Degree Status (optional). | Empl ID Primary First Name Primary Middle Name Primary Last Name Primary Suffix Degree First Name Degree Middle Name Degree Last Name Degree Suffix Home Address 1 Home Address 2 City State Postal Country Preferred Phone Campus Email Sex Birthdate Cum GPA Degr GPA Exp Grad Term Compl Term Confer Dt ChkoutStat Degree Hon Code Career Group Program 1st Plan 1st Sub-Plan 2nd Plan 2nd Sub-Plan 3rd Plan 3rd Sub-Plan 4th Plan 4th Sub-Plan 5th Plan 5th Sub-Plan Admit Term In Pr GPA Tot Baruch Units Tot Transfer Total SEEK/IEXP? | - ACAD_PROG - Student Academic Program Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join - EMAIL_FERPA_VW - EMAIL FERPA VIEW Hierarchy Join | Abu Kamruzzaman | Jason Heidenfelder | New report for Registrar. | J Heidenfelder, A Kamruzzaman, C Keck, P. Ackerman |
| CU_BAR_SR_00015_3 | Degree Audit Report | This is a listing of students who have completed their programs in the prompted term. It lists the name, emplid, email address, career, academic group, program, admit term, plans (up to 2 majors, 3 minors), plan transcript description, subplans, gender, contact information, degree status, confer date, honors suffix, SEEK indicator, HONR indicator, total in progress units, total units, total passed units and cum GPA. Prompt on Institution, Completion Term range and Degree Status (optional). | Empl ID Primary First Name Primary Middle Name Primary Last Name Primary Suffix Degree First Name Degree Middle Name Degree Last Name Degree Suffix Home Address 1 Home Address 2 City State Postal Country Preferred Phone Campus Email Sex Birthdate Cum GPA Degr GPA Exp Grad Term Compl Term Confer Dt ChkoutStat Degree Hon Code Career Group Program 1st Plan 1st Sub-Plan 2nd Plan 2nd Sub-Plan 3rd Plan 3rd Sub-Plan 4th Plan 4th Sub-Plan 5th Plan 5th Sub-Plan Admit Term In Pr GPA Tot Baruch Units Tot Transfer Total SEEK/IEXP? | - ACAD_PROG - Student Academic Program Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join - EMAIL_FERPA_VW - EMAIL FERPA VIEW Hierarchy Join | Abu Kamruzzaman | Jason Heidenfelder | Modified report | J Heidenfelder, A Kamruzzaman, T.Lodhi, . Cox, T.Lodhi |
| CU_BAR_SR_00016 | Graduation/Stdnt Grps/Srvc Ind | This is a list of students who have a degree in whatever status for a prompted completion term and who are active in any student group or service indicator. Prompt on Institution, Completion Term range and Degree Status (optional). | Last Name, First Name, Middle Name, Empl ID, Degree Nbr, Degree, Career, Compl Term, Confer Dt, Hon Code, Degree GPA, Degr Stat, Phone, Email, Student Group/Service Indicatr | ACAD_DEGR - Student Degree Table Hierarchy Join UNION 1: ACAD_DEGR - Student Degree Table Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join STDNT_GRPS_HIST - Student Groups History Hierarchy Join UNION 2: ACAD_DEGR - Student Degree Table Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join STDNT_GRPS_HIST - Student Groups History Hierarchy Join
| Michael McGovern | Jason Heidenfelder | New report for Registrar. | J Heidenfelder, A Kamruzzaman, C Keck, T.Lodhi |
| CU_BAR_SR_00017 | Graduation/Student Grades | This is a list of students grades who have a degree in whatever status for a prompted completion term. Prompt on Institution, Completion Term range, Degree Status (optional) and Grade (optional). | Empl ID, First Name, Middle Name, Last Name, Exp Grad Term, Career, Program, Plan, ChkoutStat, Subject, Catalog, Section, Session, Units, Grade Official, Primary Instructor, Secondary Instructor | ACAD_PROG - Student Academic Program Hierarchy Join | Abu Kamruzzaman | Jason Heidenfelder | New report for Registrar. | J Heidenfelder, A Kamruzzaman, C Keck, A Cox, T.Lodhi |
| CU_BAR_SR_00018 | International Student Data | This is a list of all international students, based on the Citizenship table. Prompt on Institution and Enrollment Term. | Last Name, First Name, Middle Name, Empl ID, Mar Status, Sex, Career, Program, Plan, Admit Term, Admit Type, Term Units, Phone, Email, USA, Status, USA Satus Description, other, Status | - ACAD_PROG - Student Academic Program Hierarchy Join | Michael McGovern | Rosa Kelley | New report. | A Kamruzzaman, C Keck, R Kelley, D. Berry, T. Lodhi |
| CU_BAR_SR_00018_1 | International Student Data | This is a list of all international students, based on the Citizenship table. Prompt on Institution and Enrollment Term, Career. | Last Name, First Name, Middle Name, Empl ID, Mar Status, Sex, Career, Program, Plan, Admit Term, Admit Type, Term Units, Phone, Email, USA, Status, USA Satus Description, other, Status |
| Abu | Rosa Kelley | Modified report | C Keck, R Kelley, D. Berry, P. Ackerman, T. Lodhi, M. McGovern |
| CU_BAR_SR_00019 | Zicklin Graduation Report | This is a list of all Zicklin students who have completed their programs for the prompted term. Prompt on Institution and Completion Term. | Michael McGovern | Elaine Berstein | New report. | J Albanese, E Berstein, E Figini, P Davis-Friday, C Keck, A Kamruzzaman
| ||
| CU_BAR_SR_00020 | Demographics by Student Group | This is a list of students and their demographic information who are active in a student group (i.e., College Now) for the term prompted. Prompt on Institution, Term and Student Group. | Last Name, First Name, Middle Name, Empl ID, Career, Acad Prog, Phone, Mail Address 1, Mail Address 2, City, State, Postal, Email | ACAD_PROG - Student Academic Program Hierarchy Join | Michael McGovern | Maziely Crisostomo | New report. | M Crisostomo, C Keck, A Kamruzzaman, T.Lodhi |
| CU_BAR_SR_00021 | Withdrawals by Student Group | This is a list of students active in a prompted student group who have withdrawn from class during a prompted term. Prompt on Institution, Term and Student Group. | Last Name, First Name, Middle Name, Empl ID, Career, Phone, Email, Subject, Catalog, Session, Section, Class Description, Unit Taken, Grade | STDNT_GRPS_HIST - Student Groups History Hierarchy Join | Michael McGovern | Maziely Crisostomo | New report. | M Crisostomo, C Keck, A Kamruzzaman, T.Lodhi |
| CU_BAR_SR_00022 | Multi_Inst Enrollment by S.G. | This is a list of students active in a prompted student group who have enrollment at another institution for a prompted term. Prompt on Institution, Term and Student Group. | Last Name, First Name, Middle Name, Empl ID, Career, Phone, Email, Subject, Catalog, Session, Section, Class Description, Units, Other Institution, Subject, Catalog, Session, Section, Class Description, Units | STDNT_GRPS_HIST - Student Groups History Hierarchy Join | Michael McGovern | Maziely Crisostomo | New report. | M Crisostomo, C Keck, A Kamruzzaman, T.Lodhi |
| CU_BAR_SR_00023 | Student Assessment | This is a list of enrolled students, new and continuing, with contact information, SAT scores, previous schools and degrees. Prompt on Institution, Career and Admit Term range. | Last Name, First Name, Middle Name, Empl ID, Career, Program, Admit Term, 1st Plan, 2nd Plan, Term Units, Total Units, Cum GPA, Phone, Campus Email, Admit Type, Last School, School Name, Degree Nbr, Degree, Institution | ACAD_PROG - Student Academic Program Hierarchy Join | Michael McGovern | Elaine Cataletto | New report. | E Cataletto, C Keck, A Kamruzzaman, D Berry, T.Lodhi |
| CU_BAR_SR_00024_1 | Active SPA Grad Students | This is a list of SPA Grad students, active in a MPA, MSED or ADVCT program. It lists the emplid, name (sort order) program, plan, subplan, term credits, admit term, campus email, phone, expected graduation term, check out status, term GPA, cum GPA, status, completion term, mailing address, residency, total completed credits, total attempted credits and gender. Prompt on Term. | Empl ID, Last Name, First Name, Middle Name, Program, Plan, Subplan, Term Credits, Campus Email, Phone, Exp Grad Term, ChkoutStat, Term GPA, Cum GPA, program status, completion term, ,ailing address, residency, total completed credits, total attempted credits, gender. | ACAD_PROG - Student Academic Program Hierarchy Join ACAD_PLAN - Student Academic Plan Table Hierarchy Join ACAD_SUBPLN - Student Academic Subplan Table Hierarchy Join NAME_CURR_VW - Primary Name View Outer Join SCC_PERS_PH_QVW - Preferred Phone View Outer Join STDNT_CAR_TERM - Student Career Term Table Hierarchy Join ADDRESSES4_VW Mailing Address Hierarchy Outer Join RESIDENCY_OFF Student Residency Hierarchy Join SF_STDNT_PRS_VW Student Gender Hierarchy Join SUB QUERY- EFFICTIVE _TERM RESIDENCY_OFF - Official Residency Data | Michael McGovern | Sandra Fajardo | New report | S. Godwin, C Keck,P. Ackerman, T.Lodhi, S. Fajardo |
| CU_BAR_SR_00025 | Completed SPA Grad Students | This is a list of SPA Grad students, who have complete a MPA, MSED or ADVCT program. It lists the emplid, name (sort order) program, plan, subplan, term credits, admit term, campus email, phone, expected graduation term, check out status, term GPA, cum GPA, status, completion term, mailing address, residency, total completed credits, total attempted credits and gender. Prompt on Completion Term. | Empl ID, Last Name, First Name, Middle Name, Program, Plan, Subplan, Term Credits, Campus Email, Phone, Exp Grad Term, ChkoutStat, Term GPA, Cum GPA, program status, completion term, ,ailing address, residency, total completed credits, total attempted credits, gender. | ACAD_PROG - Student Academic Program Hierarchy Join ACAD_PLAN - Student Academic Plan Table Hierarchy Join ACAD_SUBPLN - Student Academic Subplan Table Hierarchy Join NAME_CURR_VW - Primary Name View Outer Join SCC_PERS_PH_QVW- Preferred Phone View Outer Join STDNT_CAR_TERM - Student Career Term Table Hierarchy Join ADDRESSES4_VW Mailing Address Hierarchy Outer Join RESIDENCY_OFF Student Residency Hierarchy Join SF_STDNT_PRS_VW Student Gender Hierarchy Join SUB QUERY for EFFICTIVE _TERM RESIDENCY_OFF - Official Residency Data | Michael McGovern | Sandra Fajardo | New Report | S. Godwin, C Keck,P. Ackerman, T.Lodhi, S. Fajardo |
| CU_BAR_SR_00026 | SPA Grads Holds | This is a list of SPA graduate students who has BUR hold - request was related to hold resulting from AEF being applied. Prompt on Institution and Term. | Last Name, First Name, Middle Name, Empl ID, Program, Exp Grad, ChkoutStat, Plan, Term Credits, Total, Cum GPA, Phone, Email | ACAD_PROG - Student Academic Program Hierarchy Join ACAD_PLAN - Student Academic Plan Table Hierarchy Join STDNT_CAR_TERM - Student Career Term Table Hierarchy Join SRVC_IND_DATA - Service Indicator Data Hierarchy Join CU_BIO_VW - Biographical Information View | A. Kamruzzaman | Sarah Godwin | New report.
| S. Godwin, C Keck,P. Ackerman, T.Lodhi |
| CU_BAR_SR_00027 | SPA En G Stu Eth Grp Res Visa | This is a list of active , enrolled students by term. Prompt on Institution , Term. | Last Name, First Name, Middle Name, Empl ID, Sex, Residency, Visa, Program, 1st Plan, Sub-Plan, 2nd Plan, Sub-Plan, Admit Term, Term Units, Total Units, Cum GPA, Ethnicities, Preferred Phone, Preferred Email | ACAD_PROG - Student Academic Program Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join SF_STDNT_PRS_VW - SF Student Personal Data View Hierarchy Join STDNT_CAR_TERM - Student Career Term Table Hierarchy Join SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join ACAD_PLAN - Student Academic Plan Table Hierarchy Join ACAD_PLAN - Student Academic Plan Table Hierarchy Join RESIDENCY_OFF - Official Residency Data Hierarchy Join SCC_VISA_P_QVW - Visa Data Query View Hierarchy Join ACAD_SUBPLAN - Student Academic Subplan Table Hierarchy Join SUB QUERY for PLAN_SEQUESNCE: ACAD_PLAN - Student Academic Plan Table SUB QUERY for EFFICTIVE _TERM RESIDENCY_OFF - Official Residency Data
| A. Kamruzzaman | Suzanne Grossman | Modified report | S. Grossman, S. Godwin, C Keck,P. Ackerman, T.Lodhi |
| CU_BAR_SR_00028 | Students by Service Indicators | This is a list of students, no matter the status, who have the prompted service indicator. Prompt on Institution and Service Indicator. | Service Indicator Cd, Reason Code, Last Name, First Name, Middle Name, Empl ID, Positive, Acad Prog, Status, Acad Plan, Phone, Email | SRVC_IND_DATA - Service Indicator Data Hierarchy Join | Michael McGovern | Marisol Morales | New report. | M Morales, C Keck, A Kamruzzaman, T.Lodhi |
| CU_BAR_SR_00029 | Undergrads < 62 Credits | This is a list of active undergrads with less than 62 Credits. Prompt on Term. | Last Name, First Name, Middle Name, Empl ID, Program, Plan, Admit Term, Term Credits, Cum Credits | ACAD_PROG - Student Academic Program Hierarchy Join | Michael McGovern | Elaine Cataletto | New report. | E Cataletto, C Keck, A Kamruzzaman, D Berry, T.Lodhi |
| CU_BAR_SRR_00029_1 | Undergrads > 60 credits/Staub eligibility list for Feit Seminar | This is a list of active undergrads who will have completed 60 credits or greater after the prompted term. Prompt on Term. Expected graduation term needs to be updated based on term run. C.TOT_CUMULATIVE + C.UNT_TAKEN_PRGRSS not less than 60 because we want the junior status students | Last Name,First Name,Middle Name,Empl ID,ProgramPlan,Admit Term,Term Credits,Cum Credits,Exp Grad,GPA,Email | ACAD_PROG - Student Academic Program ACAD_PLAN - Student Academic Plan Table STDNT_CAR_TERM - Student Career Term Table CU_BIO_VW - Biographical Information View CU_CLS_TL_SE_VW - Custom Class Tbl Std Enrl View
| Tabassum Lodhi | Michael Staub | New Report | Stephanie Govan |
| CU_BAR_SR_00030_1 | ZIcklin Grad Students | This is a list of currently enrolled Zicklin grad students. Prompt on Institution and Term. | Last Name, First Name, Middle Name, Empl ID, Sex, Residency, Visa, Program, 1st Plan, 2nd Plan, Admit Term, Term Units, Total Units, Cum GPA, Ethnicities, Preferred Phone, Preferred Eamil | ACAD_PROG - Student Academic Program Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join SF_STDNT_PRS_VW - SF Student Personal Data View Hierarchy Join STDNT_CAR_TERM - Student Career Term Table Hierarchy Join SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join ACAD_PLAN - Student Academic Plan Table Hierarchy Join ACAD_PLAN - Student Academic Plan Table Hierarchy Join RESIDENCY_OFF - Official Residency Data Hierarchy Join SCC_VISA_P_QVW - Visa Data Query View SUB QUERY for PLAN_SEQUESNCE: ACAD_PLAN - Student Academic Plan Table SUB QUERY for EFFICTIVE _TERM RESIDENCY_OFF - Official Residency Data | Michael McGovern | Elaine Bernstein, Elizabeth Figini | New report. | J Albanese, E Berstein, E Figini, P Davis-Friday, C Keck, A Kamruzzaman, T.Lodhi, P. Ackerman, S, Loebis, Q. Hu |
| CU_BAR_SR_00030_2 | Enroll Stu Ethnic Grp Res Visa | This is a list of currently enrolled students Ethnic Groups, Residency, Visa, Plan and Sub-Plan. Prompt on Institution, Career, Term and Acad Plan. | Last Name, First Name, Middle Name, Empl ID, Sex, Residency, Visa, Program, 1st Plan, Sub-Plan,2nd Plan, Sub-Plan, Admit, Term, Term Units, Total Units, Cum GPA, Ethnicities, Preferred Phone, Preferred Email
| ACAD_PROG - Student Academic Program Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join SF_STDNT_PRS_VW - SF Student Personal Data View Hierarchy Join STDNT_CAR_TERM - Student Career Term Table Hierarchy Join SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join ACAD_PLAN - Student Academic Plan Table Hierarchy Join ACAD_PLAN - Student Academic Plan Table Hierarchy Join RESIDENCY_OFF - Official Residency Data Hierarchy Join SCC_VISA_P_QVW - Visa Data Query View Hierarchy Join ACAD_SUBPLAN - Student Academic Subplan Table Hierarchy Join ACAD_SUBPLAN - Student Academic Subplan Table Hierarchy Join SUB QUERY for PLAN_SEQUESNCE: ACAD_PLAN - Student Academic Plan Table SUB QUERY for EFFICTIVE _TERM RESIDENCY_OFF - Official Residency Data
| Abu Kamruzzaman | Margo Weaker | New Report | M. Weaker, C Keck, |
| CU_BAR_SR_00030_3 | Zicklin Grad Students | This is a list of currently enrolled students Ethnic Groups, Residency, Visa, Plan, Sub-Plan and MBFT student group. Prompt on Institution and Term. | Last Name, First Name, Middle Name, Empl ID, Sex, Residency, Visa, Program, 1st Plan, Sub-Plan, 2nd Plan, Sub-Plan, Admit Term, Term Units, Total Units, Cum GPA, Ethnicities, Preferred Phone, Preferred Email, Group Name. |
SUB QUERY for PLAN_SEQUESNCE: ACAD_PLAN - Student Academic Plan Table SUB QUERY for EFFICTIVE _TERM RESIDENCY_OFF - Official Residency Data | Abu Kamruzzaman | Elizabeth Figini | Modified report | J Albanese, E Berstein, E Figini, P Davis-Friday, C Keck, P. Ackerman, T. Lodhi, M. McGovern, Q. Hu |
| CU_BAR_SR_00030_4 | Zicklin Grad GPA>3.5 n 12 crd | This is a list of Grad active students who has GPA > 3.5 and above, have minimum 12 credits | Last Name, First Name, Middle Name, Empl ID, Sex, Residency, Visa, Program, 1st Plan, Sub-Plan, 2nd Plan, Sub-Plan, Admit Term, Term Units, Total Units, Cum GPA, Ethnicities, Preferred Phone, Preferred Email | - ACAD_PROG - Student Academic Program Hierarchy Join SUB QUERY for PLAN_SEQUESNCE: ACAD_PLAN - Student Academic Plan Table SUB QUERY for EFFICTIVE _TERM RESIDENCY_OFF - Official Residency Data | Tabassum Lodhi | Sarah Leobis | Modified report | S Leobis, T. Lodhi, P. Ackerman, C. Keck |
| CU_BAR_SR_00030_5 | Zicklin UNGD GPA>3.25 n 30 crd | This is a list of Undergraduate active students who has GPA > 3.5 and above, have minimum 12 credits | Last Name, First Name, Middle Name, Empl ID, Sex, Residency, Visa, Program, 1st Plan, Sub-Plan, 2nd Plan, Sub-Plan, Admit Term, Term Units, Total Units, Cum GPA, Ethnicities, Preferred Phone, Preferred Email | - ACAD_PROG - Student Academic Program Hierarchy Join SUB QUERY for PLAN_SEQUESNCE: ACAD_PLAN - Student Academic Plan Table SUB QUERY for EFFICTIVE _TERM RESIDENCY_OFF - Official Residency Data | Tabassum Lodhi | Sarah Leobis | Modified report | S Leobis, T. Lodhi, P. Ackerman, C. Keck, Q. Hu |
| CU_BAR_SR_00030_6 | Zicklin UNGD Enrollment | This is a list of active, enrolled zicklin Undergraduate students by term. Prompt on Institution, Term and Acad Plan. | Empl ID, Last Name, First Name, Middle Name, Sex, Residency, Visa, Program, 1st Plan, Sub-Plan, 2nd Plan, Sub-Plan, Admit Term, Term Units, Total Units, Cum GPA, Ethnicities, Preferred Phone, Preferred Email, Career, Acad Load, Citizenship | -ACAD_PROG - Student Academic Program Hierarchy Join SUB QUERY for PLAN_SEQUESNCE: ACAD_PLAN - Student Academic Plan Table SUB QUERY for EFFICTIVE _TERM RESIDENCY_OFF - Official Residency Data | Tabassum Lodhi | Sarah Leobis | Modified report | S Leobis, T. Lodhi, P. Ackerman, C. Keck |
| CU_BAR_SR_00030_7 | Zicklin UNGD ENROLL ON ACCBBA | This is a list of active, enrolled zicklin Undergraduate ACC-BBA students by term. Prompt on Institution, Term. | Empl ID, Last Name, First Name, Middle Name, Sex, Residency, Visa, Program, 1st Plan, Sub-Plan, 2nd Plan, Sub-Plan, Admit Term, Term Units, Total Units, Cum GPA, Ethnicities, Preferred Phone, Preferred Email, Career, Acad Load, Citizenship | -ACAD_PROG - Student Academic Program Hierarchy Join SUB QUERY for PLAN_SEQUESNCE: ACAD_PLAN - Student Academic Plan Table SUB QUERY for EFFICTIVE _TERM RESIDENCY_OFF - Official Residency Data | Tabassum Lodhi | Sarah Leobis | Modified report | P. Ackerman, T.Lodhi |
| Zick Grad Stu Enroll by Term | This is a list of active, enrolled Zicklin Grad students by term. Prompt on Institution and Term. | Empl ID, Last Name, First Name, Middle Name, Sex, Residency, Visa, Program, 1st Plan, Sub-Plan, 2nd Plan, Sub-Plan, Admit Term, Term Units, Total Units, Cum GPA, Ethnicities, Preferred Phone, Preferred Email, Career, Acad Load, Citizenship | -ACAD_PROG - Student Academic Program Hierarchy Join SUB QUERY for PLAN_SEQUESNCE: ACAD_PLAN - Student Academic Plan Table SUB QUERY for EFFICTIVE _TERM RESIDENCY_OFF - Official Residency Data | Tabassum Lodhi | Sarah Leobis | Modified Report | P. Ackerman, T.Lodhi, S. Leobis | |
| CU_BAR_SR_00030_12 | Zick FWA Recruitment | This is a list of active, enrolled Undergraduate students by term who has GPA more than 3.50 and have between 50 - 80 credits or more . Prompt on Institution, Term and Acad Plan. | same as above | same as the above only logic changed | Tabassum Lodhi | Samantha Brown and Olga B | Modified Report | |
| CU_BAR_SR_00031 | SPA Honors Report | This is a list of SPA students who have completed or will complete their degree work for a prompted term range. It includes their name, GPA and degree. Prompt on Institution and Completion Term range. | GPA, Last Name, First Name, Middle Name, Empl ID, Gender, Compl Term, ChkoutStat, Exp Grad, Total Baruch Credits, 1st Plan, 1st Sub-Plan, 2nd Plan, 2nd Sub-Plan, 3rd Plan, 3rd Sub-Plan | ACAD_PROG - Student Academic Program Hierarchy Join SUB QUERY for Exist SRVC_IND_DATA - Service Indicator Data SUB QUERY for STERM STDNT_CAR_TERM - Student Career Term Table | Michael McGovern | Sandra Fajardo, Angelina Delgado | New report. | M Delacruz, M Figeroa, H Morales, M Elbulok, C Keck, T Nesdill, A Garfinkel, J Goldstein, F Ferrara, A Rodriguez, A Kamruzzaman, T.Lodhi |
| CU_BAR_SR_00032 | Student Term Credits | This is a list of students who have term credits. Prompt on Institution and Term. | Last Name, First Name, Middle Name, Empl ID, Career, Term Units, Preferred Email | STDNT_CAR_TERM - Student Career Term Table Hierarchy Join | Michael McGovern | Christian Keck | New report. | A Kamruzzaman, C Keck, P.Ackerman, T.Lodhi |
| CU_BAR_SR_00033 | SmartEvals Student Data | This is a list of currently active students. Prompt on Institution and Term. | Empl ID, Grad Year, Grad Term, First Name, Last Name, GPA, Transfer | ACAD_PROG - Student Academic Program Hierarchy Join | Michael McGovern | Arthur Downing | New report. | A Downing, A Kamruzzaman, D Berry, C Keck, Gary Hotko, T.Lodhi |
| CU_BAR_SR_00033_2 | SmartEvals Student Data | This is a list of currently active students with campus email addresses, academic standing. Prompt on Institution and Term. | Empl ID, Grad Year, Grad Term, First Name, Last Name, GPA, Transfer, Email, Academic Level | ACAD_PROG - Student Academic Program Hierarchy Join STDNT_CAR_TERM - Student Career Term Table Hierarchy Join NAME_CURR_VW - Current Name Vw all types Hierarchy Join SCC_EMAIL_QVW - Email Addresses Query View | Abu Kamruzzaman | Arthur Downing | Modified Report | A Downing, T. Lodhi, P Ackerman, C Keck, Gary Hotko |
| CU_BAR_SR_00033_3 | SmartEvals all Student Data | This is a list of currently active students with 0 or more credits. Prompt on Institution and Term. | Empl ID, Grad Year, Grad Term, First Name, Last Name, GPA, Transfer, Email, Acedemic Level | ACAD_PROG - Student Academic Program Hierarchy Join SUB QUERY for Exist: STDNT_ENRL - Student Enrollment Table Hierarchy Join | Michael McGovern/Tabassum Lodhi | Gary Hotko | Modified Report | P Ackerman, C Keck, Gary Hotko, D. Ramkaran |
| CU_BAR_SR_00034_2 | SmartEvals Enrollment Data | This is a list of currently active students and their enrollment. Prompt on Institution and Term. | Course Number, Student ID, Subject, Catalog, Course Number, Course Description, Component, Session, Section, Career, Results Visible?, Primary Instructor ID, Instructor First Name, Instructor Last Name, Secondary Instructor ID, Instructor Last Name, Instructor First Name | CLASS_TBL - Class Table Hierarchy Join | Michael McGovern | Arthur Downing | New report. | A Downing, A Kamruzzaman, D Berry, C Keck, T.Lodhi |
| CU_BAR_SR_00034_3 | A Kamruzzaman, Gary Hotko, | |||||||
| CU_BAR_SR_00034_4 | SmartEvals Enrollment Data | This is a list of currently Enrolled students and their enrollment. Prompt on Institution and Term, Acad Org | Course Number, Student ID, Subject, Catalog, Course Number, Course Description, Component, Session, Section, Career, Result Visible?, Primary Instructor ID, Instructor First Name, Instructor Last Name, Secondary Instructor ID, Instructor Last Name, Instructor First Name, Pri Email, Sec Email | CLASS_TBL - Class Table Hierarchy Join CLASS_INSTR_VW5 - Distinct Instructors for Class Hierarchy Join STDNT_ENRL - Student Enrollment Table Hierarchy Join CLASS_INSTR_VW5 - Distinct Instructors for Class Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join CU_BIO_VW - Biographical Information View | Abu Kamruzzaman | Gary Hotko | Modified Report | A Downing, T. Lodhi, P Ackerman, C Keck, G. Hotko, A Cox, T.Lodhi |
| CU_BAR_SR_00034_5 | SmartEvals Enrollment Data | This is a list of currently Enrolled students and their enrollment. Prompt on Institution and Term, Acad Org | Course Number, Student ID, Subject, Catalog, Course Number, Course Description, Component, Session, Section, Career, Result Visible?, Primary Instructor ID, Instructor First Name, Instructor Last Name, Secondary Instructor ID, Instructor Last Name, Instructor First Name, Pri Email, Sec Email | CLASS_TBL - Class Table Hierarchy Join CLASS_INSTR_VW5 - Distinct Instructors for Class Hierarchy Join STDNT_ENRL - Student Enrollment Table Hierarchy Join CLASS_INSTR_VW5 - Distinct Instructors for Class Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join CU_BIO_VW - Biographical Information View | P Ackerman | Gary Hotko | Modified Report Modification of CU_BAR_SR_00034_4 on Criteria to include enrollment "ENRL" and "EWAT" | A Downing, T. Lodhi, P Ackerman, C Keck, G. Hotko, A Cox, T.Lodhi |
| CU_BAR_SR_00034_6 | SmartEvals Enrollment Data - ALL | Same as CU_BAR_SR_00034_5 except does not prompt on Acad. Org. This is a list of ALL currently Enrolled students and their enrollment. Prompt on Institution and Term, Must be Scheduled - Cannot be ran on demand | Course Number, Student ID, Subject, Catalog, Course Number, Course Description, Component, Session, Section, Career, Result Visible?, Primary Instructor ID, Instructor First Name, Instructor Last Name, Secondary Instructor ID, Instructor Last Name, Instructor First Name, Pri Email, Sec Email | CLASS_TBL - Class Table Hierarchy Join CLASS_INSTR_VW5 - Distinct Instructors for Class Hierarchy Join STDNT_ENRL - Student Enrollment Table Hierarchy Join CLASS_INSTR_VW5 - Distinct Instructors for Class Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join CU_BIO_VW - Biographical Information View | Gary Hotko | Gary Hotko | Modified Report Modification of CU_BAR_SR_00034_5 to not require Acad. Org. | A Downing, T. Lodhi, P Ackerman, C Keck, G. Hotko, A Cox, T.Lodhi, D. Ramkaran |
| CU_BAR_SR_00035_OLD | ADID Updates Term Active | Mid term Term Active updates for ADID | Dixon Berry | Patrick Ackerman | Patrick A., T. Lodhi | |||
ADID Updates Active Term Range | Term Active students for AD ID/Baruch Username account assignment/creation. Prompt on Institution, From Enroll Term, To Enroll Term | Career, Term, Last, First Name, NID Type, NID, Birthdate | STDNT_CAR_TERM - Student Career Term Table Hierarchy Join NAME_CURR_VW - Current Name Vw all types Hierarchy Join SCC_PERS_NI_QVW - Person National ID Query View Hierarchy Join PERSNL_FERPA_VW - FERPA Personal Data View Hierarchy Join UNION 1: STDNT_CAR_TERM - Student Career Term Table Hierarchy Join NAME_CURR_VW - Current Name Vw all types Hierarchy Join PERSNL_FERPA_VW - FERPA Personal Data View Hierarchy Join EXTERNAL_SYSTEM - External System ID's Hierarchy Join SUB QUERY for Exist: SCC_PERS_NI_QVW - Person National ID Query View | Tabassum Lodhi/Michael Mcgroven | Patrick Ackerman | Modified Report | Patrick A., D, Berry | |
| CU_BAR_SR_00036 | Honors Program Master List | this query selects currently enrolled honors students for Student Group = 'MHC', 'BSCH', 'PROV'; Prompts are 'BAR01' and term | Abu Kamruzzaman | Nancy Aries | ||||
| CU_BAR_SR_00037 | Baruch Enrolled Students List | this query selects enrolled students using term and institution as prompt with EMPLID,campus email and name | ID, First Name, Middle, Last, Email | STDNT_CAR_TERM - Student Career Term Table Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join SCC_EMAIL_QVW - Email Addresses Query View Hierarchy Join | Abu Kamruzzaman | Patrick Ackerman | T. Lodhi | |
| CU_BAR_SR_00037_1 | Baruch Enrolled Stu List bySub | this query selects enrolled students in CIS using term and institution as prompt with EMPLID name | Abu Kamruzzaman | Patrick Ackerman | ||||
| CU_BAR_SR_00038 | Undergrads w/Foreign Degrees | This is a list of active undergrads who have a bachelor's degree from a foreign institution. Prompt on Institution. | ID, Org ID, Degree Nbr, Degree, Descr, Deg Dt, Deg Status, Career, Data Nbr, Data Srce, Descr, Srch Name, Org Type, City, State, Country, Location | ACAD_PROG - Student Academic Program Hierarchy Join | Michael McGovern | Jacob Goldstein | New report. | A Kamruzzaman, C Keck, J Goldstein, T.Lodhi |
| CU_BAR_SR_00039 | SPA Undergrads | This is a list of undergraduate students who are formerly in the SPA school (they have the positive service indicator ACP/SPAF). Prompt on Institution and Term. | Last Name,First Name,Middle Name,Empl ID,Program,Exp Grad,ChkoutStat,Plan,Term Credits,Total,Cum GPA,Phone,Email | ACAD_PROG - Student Academic Program Hierarchy Join | Michael McGovern | Sarah Godwin | New report. | A Kamruzzaman, C Keck, S Godwin, T.Lodhi |
| CU_BAR_SR_00040 | SPA Grad Students | This is a list of graduate students who are formerly in the SPA school (they are in MPA or MSED programs). Prompt on Institution, Career, Program and Term. | Last Name,First Name,Middle Name,Empl ID,Sex,Program,Plan,Sub-Plan,Admit Term,Exp Grad,Degree Checkout Status,Program Status,Term Units,Baruch Units,Baruch Passed,Term + Total Units,Cum GPA,Home Address 1,Home Address 2,City,State,Postal,Ethnicities | ACAD_PROG - Student Academic Program Hierarchy Join | Michael McGovern | Sarah Godwin | New report. | A Kamruzzaman, C Keck, S Godwin, T.Lodhi |
| CU_BAR_SR_00041 | Class Conflict Report | This query lists any classes which meet at overlapping times for the same student. Prompt on Institution and Term. | Empl ID, Last Name, First Name, Middle Name, Career, Class Nbr, Subject, Catalog, Section, Session, Mtg Start, Mtg End, Class Days, Class Nbr, Subject, Catalog, Section, Session, Mtg Start, Mtg End, Class Days | CLASS_MTG_VW2 - Class Meeting View2 Hierarchy Join | Michael McGovern | Czarina Valente | New report. | A Kamruzzaman, C Keck, C Valente, D Mazzia, T.Lodhi |
| CU_BAR_SR_00042_2 | New Student Enroll Rpt | This is a list of new (MATR, WADM) applicants in the UGRD program and career for a prompted admit term range who are term activated for a prompted enroll term and who have progress units greater than zero. Prompt on Institution, Admit Term range and the Enrollment Term. | Last Name, First Name, Middle Name, Empl ID, Admit Type, Term Units, Preferred Email, Preferred Phone, Home Address 1, Home Address 2, City, State, Postal, Country | ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join | Michael McGovern | Marisa Delacruz | New report. | M Delacruz, M Figeroa, H Morales, C Keck, A Kamruzzaman, T.Lodhi |
| Student Enrollment | This is a list of students and their current enrollment. It includes the name, emplid, career, program, plan(s), admit type, cum GPA, attempted units, total GPA units, academic level and degree type. Prompt on Institution, Career, Term, Degree (optional), Program (optional) and Plan (optional). | Last Name, First Name, Middle Name, Empl ID, Admit Type, Admit Term, Career, Program, Plan, Seq, Plan Description, Degree, Degree Level, Academic Level, Term Units, Total Units, Total Baruch Credits, Cum GPA, Phone, Email, APS Service Ind, ACP Service Ind | ACAD_PROG - Student Academic Program Hierarchy Join | Michael McGovern | Stephanie Govan | New report. | S Govan, S Godwin, M Sultana, S Fajardo, D Battista, J Lee, C Keck, A Kamruzzaman, M Elbulok, T Nesdill, J. Mitchell, D. Berry, P. Ackerman, T.Lodhi, Q. Hu | |
| CU_BAR_SR_00045_2 | Student Enrollment GRAD | This is a list of students and their current enrollment. It includes the name, emplid, career, program, plan(s), admit type, cum GPA, attempted units, total GPA units, academic level and degree type, degree checkout status, subplan(s), service indicator, student group. Prompt on Institution, Career, Term, Degree (optional), Program (optional) and Plan (optional). | Last Name, First Name, Middle Name, Empl ID, Admit Type, Admit Term, Career, Program, Plan, Seq, Plan Description, Degree, Degree Level, Academic Level, Term Units, Total Units, Total Baruch Credits, Cum GPA, Phone, Email, APS Service Ind, ACP Service Ind, Sub plan, Student Group | ACAD_PROG - Student Academic Program Hierarchy Join ACAD_SUBPLAN - Student Academic Subplan Table Hierarchy Join SUB QUERY for PLAN_SEQUESNCE: ACAD_PLAN - Student Academic Plan Table
| Tabassum Lodhi | Stephanie Govan | New Report | |
| CU_BAR_SR_00045_3 | Student Enrollment UGRD | This is a list of students and their current enrollment. It includes the name, emplid, career, program, plan(s), admit type, cum GPA, attempted units, total GPA units, academic level and degree type, degree checkout status, subplan(s), service indicator, student group. Prompt on Institution, Career, Term, Degree (optional), Program (optional) and Plan (optional). | Last Name, First Name, Middle Name, Empl ID, Admit Type, Admit Term, Career, Program, Plan, Seq, Plan Description, Degree, Degree Level, Academic Level, Term Units, Total Units, Total Baruch Credits, Cum GPA, Phone, Email, APS Service Ind, ACP Service Ind, Sub plan, Student Group | ACAD_PROG - Student Academic Program Hierarchy Join ACAD_SUBPLAN - Student Academic Subplan Table Hierarchy Join SUB QUERY for PLAN_SEQUESNCE: ACAD_PLAN - Student Academic Plan Table
| Tabassum Lodhi | Stephanie Govan | Modified Report | |
| CU_BAR_SR_00046 | Service Indicator Audit | This is a list of students who have ever been in a prompted service indicator. Prompt on Institution and Term. | Service Ind, Reason Code, Last Name, First Name, Middle Name, Empl ID, Action, How Placed, User, Date/Time | AUDIT_SRVC_IND - Audit Record - SRVC_IND_DATA Hierarchy Join | Michael McGovern | Marisol Morales | New report. | M Morales, C Keck, A Kamruzzaman, T.Lodhi |
| CU_BAR_SR_00047 | Class Instructors-Term/Session | This is a list of unique instructors for the term and session with their preferred email address. Prompt on Institution, Term and Session. | Last Name, First Name, Middle Name, Empl ID, Email | CLASS_TBL - Class Table Hierarchy Join | Michael McGovern | Edward Adams | New report | E Adams, C Keck, A Cox, A. Kamruzzaman, T.Lodhi |
| CU_BAR_SR_00048 | Grads w/ Low GPAs | This is a list of students who have less than the prompted GPA. Prompt on Institution, Program, Term and GPA. | Last Name, First Name, Middle Name, Empl ID, Admit Term, Program, Term Units, Baruch Completed, Total Completed, Home Address 1, Home Address 2, City, State, Postal, Phone, Campus Email, Cum GPA | ACAD_PROG - Student Academic Program Hierarchy Join | Michael McGovern | Sandra Fajardo | New report | E Adams, C Keck, S Godwin, T.Lodhi |
| CU_BAR_SR_00049 | Need Term Activation | This is a list of students who have not been term activated for the prompted term. Prompt on Institution, Career, Term, Admit Term range and Program (optional). | Last Name,, First Name, Middle Name, Empl ID, Career, Program, Admit Term, Program Action, Action Rsn, Preferred Email | ACAD_PROG - Student Academic Program Hierarchy Join SUB QUERY for Does Not Exist: STDNT_CAR_TERM - Student Career Term Table | Michael McGovern | Millie Figueroa | New report | M Delacruz, M Figeroa, H Morales, M Elbulok, T Nesdill, T.Lodhi |
| CU_BAR_SR_00050 | Immunizations for Students | This is a list of active students who have no immunization records. Prompt on Institution and Career. | Last Name, First Name, Middle Name, Empl ID, Admit Term, Career, Program, Plan, Immunizations?, Campus Email | ACAD_PROG - Student Academic Program Hierarchy Join SUB QUERY for Does Not Exist: IMMUNIZATIONS - Immunizations | Michael McGovern | Marisa Delacruz | New report. | M Delacruz, M Figeroa, H Morales, M Elbulok, C Keck, T Nesdill, A Rodriguez, A Kamruzzaman, T.Lodhi |
| CU_BAR_SR_00051 | Re-admits w/ GPAs < 2.0 | This is a list of re-admitted, undergrads for a prompted admit term range, who have a Cum GPA 2.0 and who are not active in student groups BSCH, CPIN, MHC or SEEK. Prompt on Institution and Admit Term range. | Last Name, First Name, Middle Name, Empl ID, Career, Program, 1st Plan, 2nd Plan, Admit Term, Credits Term, Cum GPA, Baruch GPA Taken, Total Units, Phone, Campus Email | ACAD_PROG - Student Academic Program Hierarchy Join
STDNT_GRPS- Student Groups SUB QUERY for STERM: STDNT_CAR_TERM - Student Career Term Table | Michael McGovern | Elaine Cataletto | New report. | E Cataletto, C Keck, A Kamruzzaman, T.Lodhi
|
| CU_BAR_SR_00052 | Students w/Double Majors | This is a list of new students who have more than one major. Prompt on Institution and Admit Term range. | Last Name, First Name, Middle Name, Empl ID, # of Majors | ACAD_PROG - Student Academic Program Hierarchy Join | Michael McGovern | Marisa Delacruz | New report. | M Delacruz, M Figeroa, H Morales, M Elbulok, C Keck, T Nesdill, A Garfinkel, J Goldstein, F Ferrara, A Rodriguez, A Kamruzzaman, T.Lodhi |
| CU_BAR_SR_00053 | New Students w/ GPAs < 2.0 | This is a list of new undergrads for a prompted admit term range, who have a Cum GPA < 2.0 and who are not active in student groups BSCH, CPIN, MHC or SEEK. Prompt on Institution and Admit Term range. | Last Name, First Name, Middle Name, Empl ID, Term, Term GPA, Cum GPA, Admit Term, Term Units, GPA Units, Total Units, Career, Program, 1st Plan, 2nd Plan | STDNT_CAR_TERM - Student Career Term Table Hierarchy Join SUB QUERY for Does Not Exist: STDNT_GRPS_HIST - Student Groups History | Michael McGovern | Elaine Cataletto | New report | E Cataletto, C Keck, A Kamruzzaman, T.Lodhi |
| CU_BAR_SR_00054 | SPA Grad Enrollment Counts | This query counts SPA grad students, both new and continuing), who are active in a program (MPA, MSED, ADVCT) and who have enrolled in greater than 0 credits for the prompted term. | Michael McGovern | Sarah Godwin | New report | |||
| CU_BAR_SR_00054_3 | SPA Grad Enrollment Counts | This query counts SPA grad students, both new and continuing), who are active in a program (MPA, MSED, ADVCT) and who have enrolled in greater than 0 credits for the prompted term. | Last Name, First Name, Middle, Acad Prog, Acad Plan, Current term units, Admit Term, Email, Phone, ID, ChkoutStat, Term GPA, Status, Compl Term, Acad Load, Acad Load | STDNT_CAR_TERM - Student Career Term Table Hierarchy Join ACAD_PROG - Student Academic Program Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join ACAD_PLAN - Student Academic Plan Table | Abu Kamruzzaman | Sarah Godwin | Modified Report | S. Godwin,A. Kamruzzaman, P. Ackerman, T.Lodhi |
| CU_BAR_SR_00054_4 | SPA Grad Enrollment Counts | This query counts SPA grad students, both new and continuing), who are active in a program (MPA, MSED, ADVCT) and who have enrolled in greater than 0 credits for the prompted term. Added Subplan and dual citizenships | Last Name, First Name, Middle, Acad Prog, Acad Plan, Current term units, Admit Term, Email, Phone, ID, ChkoutStat, Term GPA, CUM GPA, Status, Compl Term, Acad Load, Acad Load, Sub-plan, Country, Country | STDNT_CAR_TERM - Student Career Term Table Hierarchy Join ACAD_PROG - Student Academic Program Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join ACAD_PLAN - Student Academic Plan Table Hierarchy Join ACAD_SUBPLAN - Student Academic Subplan Table Hierarchy Join SCC_CITIZEN_QVW - Citizenship Query View Hierarchy Join SCC_CITIZEN_QVW - Citizenship Query View Hierarchy Join | Abu Kamruzzaman | Sarah Godwin | Modified Report | S. Godwin,A. Kamruzzaman, P. Ackerman, C Keck, T.Lodhi |
SPA GRAD Student Counts | This query counts SPA grad students, both new and continuing), who are active in a program (MPA, MSED, ADVCT) and who have enrolled in greater than 0 credits for the prompted term. With FT/PT status. | Last Name, First Name, Middle, Acad Prog, Acad Plan, Current term, units, Admit Term, Email, Phone, ID, Chkout, Stat, Term GPA, CUM GPA, Status, Compl Term, Acad Load, Acad Load, Sub-Plan, Address 1, Address 2, City, State, Postal, Residency, Prim Prog, Full/Part, VisaPmtType, Country, Country, Take Prgrs, Pass Prgrs | -STDNT_CAR_TERM - Student Career Term Table Hierarchy Join -ACAD_PROG - Student Academic Program Hierarchy Join -CU_BIO_VW - Biographical Information View Hierarchy Join -ACAD_PLAN - Student Academic Plan Table Hierarchy Join -ACAD_SUBPLAN - Student Academic Subplan Table Hierarchy Join -ADDRESSES4_VW - Addresses View for Curr EffDT Hierarchy Join -RESIDENCY_OFF - Official Residency Data Hierarchy Join -SCC_VISA_P_QVW - Visa Data Query View Hierarchy Join -SCC_CITIZEN_QVW - Citizenship Query View Hierarchy Join -SCC_CITIZEN_QVW - Citizenship Query View Hierarchy Join
| Tabassum Lodhi | Sarah Godwin | Modified Report | S. Godwin,D. Battista, P. Ackerman, C Keck, T.Lodhi, S. Fajardo | |
| CU_BAR_SR_00054_6 | Active + Enrolled SPA grad Students | This is a list of SPA Grad students, active in a MPA, MSED or ADVCT program. It lists the emplid, name (sort order) program, plan, subplan, term credits, admit term, campus email, phone, expected graduation term, check out status, term GPA, cum GPA, status, completion term, mailing address, residency, total completed credits, total attempted credits and gender. Prompt on Term. | EmplID, LastName, FirstName, MiddleName, rogram, Plan, Sub-Plan, TermCredits, AdmitTerm, CampusEmail, PreferredPhone, ExpGradTerm, ChkoutStat, TermGPA, CumGPA, Status, MailingAddress1, Address2, City, State, Postal, Residency, TotCompCredits, TotAttCredits, Sex, AcadLoad(Full/Parttime), AcadLoad, ComplTerm, PrimProg, Country, CitizenshipStatus, Country, CitizenshipStatus, Ethnicity | -ACAD_PROG - Student Academic Program Hierarchy Join -ACAD_PLAN - Student Academic Plan Table -ACAD_SUBPLAN - Student Academic Subplan Table -STDNT_CAR_TERM - Student Career Term Table -SCC_EMAIL_QVW - Email Addresses Query View -ADDRESSES4_VW - Addresses View for Curr EffDT -RESIDENCY_OFF - Official Residency Data -SF_STDNT_PRS_VW - SF Student Personal Data View -SCC_PERS_PH_QVW - Phone Numbers Query View -NAME_CURR_VW - Current Name Vw all types -SCC_CITIZEN_QVW - Citizenship Query View -SCC_CITIZEN_QVW - Citizenship Query View -CITIZEN_STS_TBL - Citizen Status Table -CITIZEN_STS_TBL - Citizen Status Table -SCC_ETH_GRP_VW - Ethnic Diversity Subquery for --EFFECTIVE_TERM | Tabassum Lodhi | Daniel Battista, Sandra Fajardo | New Report | D. Battista, S. Fajardo, P. Ackerman and T. Lodhi |
| CU_BAR_SR_00054_7 | Active + Enrolled SPA grad Students | This is a list of SPA Grad students, active in a MPA, MSED or ADVCT program. It lists the emplid, name (sort order) program, plan, subplan, term credits, admit term, campus email, phone, expected graduation term, check out status, term GPA, cum GPA, status, completion term, mailing address, residency, total completed credits, total attempted credits and gender. Prompt on Term. | EmplID, LastName, FirstName, MiddleName, rogram, Plan, Sub-Plan, TermCredits, AdmitTerm, CampusEmail, PreferredPhone, ExpGradTerm, ChkoutStat, TermGPA, CumGPA, Status, MailingAddress1, Address2, City, State, Postal, Residency, TotCompCredits, TotAttCredits, Sex, AcadLoad(Full/Parttime), AcadLoad, ComplTerm, PrimProg, Country, CitizenshipStatus, Country, CitizenshipStatus, Ethnicity | -ACAD_PROG - Student Academic Program Hierarchy Join -ACAD_PLAN - Student Academic Plan Table -ACAD_SUBPLAN - Student Academic Subplan Table -STDNT_CAR_TERM - Student Career Term Table -SCC_EMAIL_QVW - Email Addresses Query View -ADDRESSES4_VW - Addresses View for Curr EffDT -RESIDENCY_OFF - Official Residency Data -SF_STDNT_PRS_VW - SF Student Personal Data View -SCC_PERS_PH_QVW - Phone Numbers Query View -NAME_CURR_VW - Current Name Vw all types -SCC_CITIZEN_QVW - Citizenship Query View -SCC_CITIZEN_QVW - Citizenship Query View -CITIZEN_STS_TBL - Citizen Status Table -CITIZEN_STS_TBL - Citizen Status Table -SCC_ETH_GRP_VW - Ethnic Diversity Subquery for --EFFECTIVE_TERM | Tabassum Lodhi | same as CU_BAR_SR_00054_7 | Young Hug | |
| CU_BAR_SR_00055 | Grad School Fair | This is a list of active undergrads who have more than 60 credits. Prompt on Institution and Term. | Last Name, First Name, Middle Name, Empl ID, Program, Total Credits, Campus Email | STDNT_CAR_TERM - Student Career Term Table Hierarchy Join | Michael McGovern | Elaine Cataletto | New report | E Cataletto, C Keck, A Kamruzzaman, T.Lodhi |
| CU_BAR_SR_00056 | Undergrads by Credit Level | This is a list of active undergrads by their credit level. Prompt on Institution and Term. | Level, Last Name, First Name, Middle Name, Empl ID, Program, 1st Plan, 2nd Plan, Term Units, Total Units, Cum GPA, Email, Admit Term, Admit Type | ACAD_PROG - Student Academic Program Hierarchy Join SUB QUERY for Does Not Exist: STDNT_GRPS_HIST - Student Groups History | Michael McGovern | Elaine Cataletto | New report | E Cataletto, C Keck, A Kamruzzaman, T.Lodhi |
| CU_BAR_SR_00057 | GRADs w/High GPAs | This is a list of grad students who have not less than the prompted GPA. Prompt on Institution, Program, Term and GPA. | Last Name, First Name, Middle Name, Empl ID, Admit Term, Program, Term Units, Baruch Completed, Total Completed, Home Address 1, Home Address 2, City, State, Postal, Phone, Campus Email, Cum GPA | ACAD_PROG - Student Academic Program Hierarchy Join | Michael McGovern | Sandra Fajardo | New report | S Godwin, C Keck, A Kamruzzaman, T.Lodhi |
| CU_BAR_SR_00058 | Term Active/No Enrollment | This is a list of term activated grad students who have no enrollment. Prompt on Institution, Program and Term. | Last Name, First Name, Middle Name, Empl ID, Units Taken for Progress, Baruch Earned Units, Total Units, Cum GPA | STDNT_CAR_TERM - Student Career Term Table Hierarchy Join | Michael McGovern | Sandra Fajardo | New report. | S Godwin, C Keck, A Kamruzzaman, T.Lodhi |
| CU_BAR_SR_00059 | Three-peat Students | This is a list of students who have taken or are taking a class three or more times. Prompt on Institution and Term. | Empl ID, Subject, Catalog, Class Description, Count | CLASS_TBL_SE_VW - Class Table Student Enrl View Hierarchy Join | Michael McGovern | Czarina Valenta | New report | C Valente, C Keck, A Kamruzzaman, T.Lodhi |
| CU_BAR_SR_00060 | COM Internship Eligibility | This is a list of active students in Business Communication with the sub plan of Corporate Communication, who have completed MKT 3000 and MGT 3120, two of the following: COM 3068, COM 3102, COM 3150, and any other COM 3000 or 4000 level course. | Michael McGovern | Stephanie Govan | New report | S Govan, A Kamruzzaman, C Keck, T.Lodhi | ||
| CU_BAR_SR_00061_1 | Zicklin Grad Awarded Degrees | This is a list of Zicklin grad students who have been awarded degrees. Prompt on Completion Term. | Last Name, First Name, Middle Name, Empl ID, Career, Program/Degree, Plan | ACAD_PROG - Student Academic Program Hierarchy Join | Michael McGovern | Ellen King | New report | E King, L Ballance, C Keck, F Burke, J Makarewycz, A Kamruzzaman, T.Lodhi |
| CU_BAR_SR_00062 | Zicklin Grad GPA Changes | This is a list of Zicklin grad students whose Cum GPA has changed from the previous term. Prompt on Current Term and Prior Term. | Last Name, First Name, Middle Name, Empl ID, Career, Program, Plan, Current Term, Current Cum GPA, Prior Term, Prior Cum GPA | ACAD_PROG - Student Academic Program Hierarchy Join | Michael McGovern | Ellen King | New report | E King, L Ballance, C Keck, F Burke, J Makarewycz, A Kamruzzaman, T.Lodhi |
| CU_BAR_SR_00063_1 | New Zicklin Grad Students | This is a list of new Zicklin grad students. Prompt on the Admit Term range. | Last Name, First Name, Middle Name, Empl ID, Career, Program/Degree, Plan, Sex, Email, Citizenship, VisPmtType, Last School Attended | ACAD_PROG - Student Academic Program Hierarchy Join | Michael McGovern | Ellen King | New report | E King, L Ballance, C Keck, F Burke, J Makarewycz, A Kamruzzaman, T.Lodhi |
| CU_BAR_SR_00064_1 | Honors Program Contact Info | this query selects currently enrolled Active honors students in Program for Student Group = 'MHC', 'BSCH', 'PROV'; Prompts are 'BAR01' | Group Name, Advisor Last Name, Last Name, First Name, Empl ID, Campus Email, Preferred Email, Preferred Phone, Home Address 1, Home Address 2, City, State, Postal, Country | STDNT_GRPS_HIST - Student Groups History Hierarchy Join UNION 1: STDNT_GRPS_HIST - Student Groups History Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join ADDRESSES4_VW - Addresses View for Curr EffDT Hierarchy Join EMAIL_FERPA_VW - EMAIL FERPA VIEW Hierarchy Join ACAD_PROG - Student Academic Program Hierarchy Join SUB QUERY for Does Not Exist: STDNT_ADVR_HIST - Student Advisor History | Abu Kamruzzaman | Nancy Aries | New report | N. Aries, J. Vaisman, M. McGovern, C. Keck, T.Lodhi |
| CU_BAR_SR_00065 | Weissman Grad Students | This is a list of term-active Weissman graduate students and their bio data. Prompt on Institution, Career and Term. | Last Name, First Name, Middle, Email, Phone, ID, NID, Admit Term, Acad Prog, Acad Plan, Take Prgrs, Total Taken Toward GPA, Total Passed Toward GPA, Total, Current GPA, Cumulative GPA, Country, Address 1, Address 2, Address 3, City, State, Postal, Sex, Effective, Residency, Country, Short Desc, Country, Short Desc, White?, Black?, Hispanic?, Asian?, American Indian?, Not Specified? | ACAD_PROG - Student Academic Program Hierarchy Join SUB QUERY for Does Not Exist: STDNT_GRPS_HIST - Student Groups History SUB QUERY for EFFECTIVE TERM: RESIDENCY_OFF - Official Residency Data | Michael McGovern | Michael Lovaglio | New report | M Lovaglio, A Kamruzzaman, C Keck, T.Lodhi, Stephanie Govan |
| CU_BAR_SR_00066 | document the process | |||||||
| | Honors Program Grade Review | this query selects currently enrolled honors students for Student Group = 'MHC', 'BSCH', 'PROV'; Prompts are 'BAR01' and term | Abu Kamruzzaman | Nancy Aries | New report | N. Aries, J. Vaisman, P. Ackerman, C. Keck | ||
| CU_BAR_SR_00067 | Student Groups | This is a list of Baruch student groups. Prompt on Institution. | Group Name, Last Name, First Name, Empl ID, Admit Term, Srv Ind Cd, Srvc Reasn, Srv Ind Cd, Srvc Reasn, Tot Earned, Term Units, Total Attempted, Term GPA, Cum GPA, Campus Email, Preferred Email, Previous H Classes, Current H Classes | STDNT_GRPS_HIST - Student Groups History Hierarchy Join | Patrick Ackerman | T.Lodhi | ||
| CU_BAR_SR_000068 | Grads by Plan per Acad Year | This is a count of students who complete their degree during the academic year. Prompt on Institution and Academic Year. | Acad Year, Career, Program, Plan, Plan Description, Count | TERM_TBL - Term Definition Table Hierarchy Join | Michael McGovern | David Christy | New report. | D Christy, A Kamruzzaman, C Keck, T.Lodhi |
| CU_BAR_SR_00069 | Service Indicators | This is a list of Baruch service indicators and reason codes. Prompt on Institution. | Institution, Srv Ind Cd, Eff Date, Status, Descr, Short Desc, Positive, Self-Service, Person, Organization, Active Date, Default Term, Reason, Deceased, Srvc Reasn, Descr, Short Desc, Reference, DeptID, Position, Multiples, Descr | SRVC_IND_CD_TBL - Service Indicator Code Table Hierarchy Join SRVC_IN_RSN_TBL - Service Indicator Reason Hierarchy Join | Patrick Ackerman | Patrick Ackerman | T. Lodhi, | |
| CU_BAR_SR_00070 | Service Indicators and Impact | This is a list of Baruch service indicators impact. Prompt on Institution. | Srv Ind Cd, Descr, Positive, Impact, Short Desc, Descr, short Desc | SRVC_IND_CD_TBL - Service Indicator Code Table Hierarchy Join SERVICE_IMPACT - Service Impact Hierarchy Join SRVC_IMPACT_TBL - Service Impact Table Hierarchy Join | Patrick Ackerman | Patrick Ackerman | T. Lodhi, | |
| CU_BAR_SR_00071 | Enrl Stdnt Campus Email | This is a list of students enrolled for specified term who are not in a permit in student group with Campus email listed. Prompt on Institution and term. | ID, Email | - STDNT_CAR_TERM - Student Career Term Table Hierarchy Join - EMAIL_FERPA_VW - EMAIL FERPA VIEW Hierarchy Join -STDNT_GRPS_HIST SUB QUERY for Does Not Exist: STDNT_GRPS_HIST - Student Groups History | Patrick Ackerman | New Report | C. Keck, T. Lodhi, | |
Enrl Stdnt NOCamp Email not PI | This is a list of students enrolled for specified term who are not permit in with OTHER Campus email listed. Who does not have Baruch email address. Prompt on Institution and term. | ID, Campus Email | -STDNT_CAR_TERM - Student Career Term Table -SCC_EMAIL_QVW - Email Addresses Query View -SCC_EMAIL_QVW - Email Addresses Query View SUB QUERY for Does Not Exist: STDNT_GRPS_HIST - Student Groups History SUB QUERY for Does Not Exist: SCC_EMAIL_QVW - Email Addresses Query View SUB QUERY for Exist: SCC_EMAIL_QVW - Email Addresses Query View | Tabassum Lodhi | New Report | P. Ackerman, T. Lodhi | ||
| CU_BAR_SR_00071_2 | Enrl Stdnt NOCamp Email not PI with active students | This is a list of students enrolled for specified term who are not permit in with OTHER Campus email listed and dates are for active permit in student group. Prompt on Institution, term, PI Stu Grp Active - Beg Date and PI Stu Grp Active - End Date (these are newly added). | ID, Campus Email | -STDNT_CAR_TERM - Student Career Term Table -SCC_EMAIL_QVW - Email Addresses Query View -SCC_EMAIL_QVW - Email Addresses Query View SUB QUERY for Does Not Exist: STDNT_GRPS_HIST - Student Groups History SUB QUERY for Does Not Exist: SCC_EMAIL_QVW - Email Addresses Query View SUB QUERY for Exist: SCC_EMAIL_QVW - Email Addresses Query View | Tabassum Lodhi | Modified Report | P. Ackerman, T. Lodhi | |
| CU_BAR_SR_00072 | Honors Program Academic Standing | this query selects currently enrolled honors students for Student Group = 'MHC', 'BSCH', 'PROV'; Prompts are 'BAR01' and terms(current and prior) | Group Name, Last Name, First Name, Empl ID, Admit Term, Srv Ind Cd, Srvc Reasn, Srv Ind Cd, Srvc Reasn, Acad Plan, Acad Plan, Acad Plan, tot Earned, Term Units, Total Attempted, Term GPA, Prior Term GPA, Cum GPA, Campus Email, Preferred Email | - STDNT_GRPS_HIST - Student Groups History Hierarchy Join | Abu Kamruzzaman | Nancy Aries | New report | N. Aries, J. Vaisman, P. Ackerman, C. Keck, D. Berry, T. Lodhi, A. Cox |
| CU_BAR_SR_00072_1 | Honors Program Academic Standing with Advisor Last Name | this query selects currently enrolled honors students for Student Group = 'MHC', 'BSCH', 'PROV'; Prompts are 'BAR01' and terms(current and prior) | Group Name, Advisor Last Name, Last Name, first Name, Empl ID, Admit Term, Srv IND cd, Srvc Reasn, Srv Ind Cd, Srvc Reasn, Acad Plan, Acad Plan, Acad Plan, tot Earned, Term Units, Total Attempted, Term GPA, Prior Term GPA, Cum GPA, Campus Email, Preferred Email | - STDNT_GRPS_HIST - Student Groups History Hierarchy Join | Abu Kamruzzaman | Nancy Aries | Modified report | N. Aries, J. Vaisman, P. Ackerman, C. Keck, D. Berry, T. Lodhi, A. Cox |
| CU_BAR_SR_00072_2 | Honors Program Academic Standing with Advisor Last Name currently enrolled H courses count | this query selects currently enrolled honors students for Student Group = 'MHC', 'BSCH', 'PROV'; Prompts are 'BAR01' and terms(current and prior) | Group Name, Advisor Last Name, Last Name, first Name, Empl ID, Admit Term, Srv IND cd, Srvc Reasn, Srv Ind Cd, Srvc Reasn, Acad Plan, Acad Plan, Acad Plan, tot Earned, Term Units, Total Attempted, Term GPA, Prior Term GPA, Cum GPA, Campus Email, Preferred Email, Currently Enrolled |
- STDNT_GRPS_HIST - Student Groups History Hierarchy Join | Abu Kamruzzaman | Nancy Aries | Modified report | N. Aries, J. Vaisman, P. Ackerman, C. Keck, D. Berry, T. Lodhi, A. Cox |
| CU_BAR_SR_00072_3 | Honors Program Academic Standing with Advisor Last Name prior to current semester enrolled H courses count | this query selects currently enrolled honors students for Student Group = 'MHC', 'BSCH', 'PROV'; Prompts are 'BAR01' and terms(current and prior) | Group Name, Advisor Last Name, Last Name, first Name, Empl ID, Admit Term, Srv IND cd, Srvc Reasn, Srv Ind Cd, Srvc Reasn, Acad Plan, Acad Plan, Acad Plan, tot Earned, Term Units, Total Attempted, Term GPA, Prior Term GPA, Cum GPA, Campus Email, Preferred Email, Completed H Crs |
| Abu Kamruzzaman | Nancy Aries | Modified report | N. Aries, J. Vaisman, P. Ackerman, C. Keck, D. Berry, T. Lodhi, A. Cox |
| CU_BAR_SR_00073 | Class Instructor By term | this query selects class information with the instructor name, prompts are BAR01 and term(current and prior) | Term, Session, Institution, Career, Subject, Catalog, Section, Class Nbr, Descr, Tot Enrl, Enrl Stat, Class Stat, Class Type, Cap Enrl, Wait Cap, Wait Tot, Min Enrl, Component, Course ID, Offer Nbr, Instructor Last Name, Instructor First Name, Start Date, End Date | - CLASS_TBL - Class Table Hierarchy Join - CLASS_INSTR - Class Instructor Table Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join | Abu Kamruzzaman | Gary Hotko | New Report | G. Hotko, P. Ackerman, C. Keck, A. Downing, D. Ramkaran, T. Lodhi |
| CU_BAR_SR_00073_1 | Class instructor by term with data for SmartEvals | Query selects selects class information with the instructors name, prompts are Institution and term. Returns Class Information, instructor information, SmartEval Course Number
Variants: | Term, Session, Institution, Career, Subject, Catalog, Section, Class Nbr, Descr, Tot Enrl, Enrl Stat, Class Stat, Class Type, Cap Enrl, Wait Cap, Wait Tot, Min Enrl, Component, Course ID, Offer Nbr, Instructor Last Name, Instructor First Name, Start Date, End Date, OTE_START (blank column), OTE_END (blank column), Eval Start (Blank Column), Eval End (Blank Column), Eval Cycle (Calculated), Notes (Calculated), Smart Eval Course# (Calculated) | - CLASS_TBL - Class Table Hierarchy Join - CLASS_INSTR - Class Instructor Table Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join | Gary Hotko | Gary Hotko | Modification | G. Hotko, D.Ramkaran, B. Ho, A. Downing, P. Ackerman, T. Lodhi |
| CU_BAR_SR_00073_2 | Class instructor by term with data for SmartEvals Search by Class Number | Query selects selects class information with the instructors name, Returns Class Information, instructor information, SmartEval Course Number, for a specific section.
Prompts are Institution, Term and Class Number
| Term, Session, Institution, Career, Subject, Catalog, Section, Class Nbr, Descr, Tot Enrl, Enrl Stat, Class Stat, Class Type, Cap Enrl, Wait Cap, Wait Tot, Min Enrl, Component, Course ID, Offer Nbr, Instructor Last Name, Instructor First Name, Start Date, End Date, OTE_START (blank column), OTE_END (blank column), Eval Start (Blank Column), Eval End (Blank Column), Eval Cycle (Calculated), Notes (Calculated), Smart Eval Course# (Calculated) | - CLASS_TBL - Class Table Hierarchy Join - CLASS_INSTR - Class Instructor Table Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join | Gary Hotko | Gary Hotko | Modification | G. Hotko, D.Ramkaran, B. Ho, A. Downing, P. Ackerman, T. Lodhi |
| CU_BAR_SR_00074 | Rosters+Grades By Term | This is a list of roster and grades, selected by term. Prompts are Institution, Term and Career | Institution, Term, Session, Subject, Catalog, Section, Component, Name, ID, Career, Class NBR, Descr, Progress, Grade, Grade In | - STDNT_ENRL - Student Enrollment Table Hierarchy Join - CLASS_TBL - Class Table Hierarchy Join - PEOPLE_SRCH - People Search View joined with A.EMPLID - Empl ID Hierarchy Join | Tabassum Lodhi | Nidzaida Garcia | Modify Report | C. Keck, P. Ackerman, Nidzaida Garcia, T.Lodhi |
| Searching Students for Honor Courses | This query select Students with GPA is 3.4 or higher with honors course. The prompts are Prior term and Current term. | ID, First Name, Last Name, Admit Term, Career, Institution, Acad Prog, Term Acad Load (Full/part/half time), Take GPA, Pass GPA, Take Prgrs, GPA, GPA, Email | ACAD_PROG - Student Academic Program Hierarchy Join SUB QUERY for Does Not Exist: STDNT_GRPS_HIST - Student Groups History | Michael McGovern, Tabassum Lodhi | Jody Vaisman | New Report | Jody Vaisman, P.Ackerman, T.Lodhi
|
| CU_BAR_SR_00076 | Class Enrollment Detail | This main query selects active classes based on the prompts. It lists the subject, catalog number, class section, description, class number, session code, academic group, enrollment capacity, enrollment total, instruction mode, facility id, meeting time start and end, class days and instructor name. The union query selects the emplid, name (last, first, middle), SSN4, preferred phone, preferred email and campus email of those students enrolled in the class. The prompts are Institution, Term, Academic Organization, Subject (optional) and Catalog Number (optional). | Main query: subject, catalog_nbr, class_section, descr, class_nbr, session_code, acad_group, earl_cap, enrl_tot, instruction_mode, facility_id, meeting_time_start, meeting_time_end, class days (MON || TUES || etc), name_display (instructor). Union query: (student) emplid, last name, first name, middle name, SSN4, (preferred) phone, (preferred) email. (campus) email. | - CLASS_TBL - Class Table Hierarchy Join - CLASS_MTG_PAT - Class Meeting Pattern Table Hierarchy Join - CLASS_INSTR_ VW5 - Class Instructor View with Name Hierarchy Join Union - CLASS_TBL - Class Table Hierarchy Join - STDNT_ENRL - Student Enrollment Hierarchy Join - CU_BIO_VW - Student Personal Info STDNT_ENRL.EMPLID Join - SCC_PERS_NI_QVW - Student SSN Info STDNT_ENRL.EMPLID Join - SCC_EMAIL_QVW - Student Campus Email STDNT_ENRL.EMPLID , Type = 'CAMP' Outer Join | Michael McGovern | Christian Keck for the departments heads | New Report | |
| CU_BAR_SR_00077 | Real Estate major or second major for Grad Students. | The query select students who have real estate major or second major as their academic program. The select contains ID, First Name, Last Name, Career, Acad Prog, status,Acad Plan, Eamil. The prompts are Institution and Term. | ID, First Name, Last Name, Career, Acad Prog, status,Acad Plan, Eamil | ACAD_PROG - Student Academic Program Hierarchy Join | Michael McGovern, Tabassum Lodhi | Margo Weaker | New Report | Margo Weaker, P. Ackerman, C. Keck |
| CU_BAR_SR_00077_1 | Zic Grad Students w/ RES-MBA | This is a list of active, enrolled Zicklin Grad students by term. Added Plan, Subplan, GPA, Sex, Admit Term, Total Units, Current Units, Email Address Prompt on Institution and Term. The query returns only 'MBFT' students. | Last Name, First Name, Middle Name,Empl ID, Sex, Residency, Visa, Program, 1st Plan, Sub-Plan, 2nd Plan, Sub-Plan, Admit Term, Term Units, Total Units, Cum GPA, Ethnicities, Preferred Phone, Preferred Email, Group Name | -ACAD_PROG - Student Academic Program Hierarchy Join -CU_BIO_VW - Biographical Information View Hierarchy Join -SF_STDNT_PRS_VW - SF Student Personal Data View Hierarchy Join -STDNT_CAR_TERM - Student Career Term Table Hierarchy Join -SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join -SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join -SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join -SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join -SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join -SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join -ACAD_PLAN - Student Academic Plan Table Hierarchy Join -ACAD_PLAN - Student Academic Plan Table Hierarchy Join -RESIDENCY_OFF - Official Residency Data Hierarchy Join -SCC_VISA_P_QVW - Visa Data Query View Hierarchy Join -ACAD_SUBPLAN - Student Academic Subplan Table Hierarchy Join -ACAD_SUBPLAN - Student Academic Subplan Table Hierarchy Join -STDNT_GRPS_HIST - Student Groups History SUB QUERY for EFFECTIVE_TERM: -RESIDENCY_OFF - Official Residency Data
| Tabassum Lodhi | Margo Weaker | New Report | Margo Weaker, P. Ackerman, C. Keck |
| CU_BAR_SR_00077_2 | Zic Grad Students w/ RES-MBA | This is a list of active, enrolled Zicklin Grad students by term. Added Plan, Subplan, GPA, Sex, Admit Term, Total Units, Current Units, Email Address Prompt on Institution and Term. The query returns all categories | Last Name, First Name, Middle Name,Empl ID, Sex, Residency, Visa, Program, 1st Plan, Sub-Plan, 2nd Plan, Sub-Plan, Admit Term, Term Units, Total Units, Cum GPA, Ethnicities, Preferred Phone, Preferred Email, Group Name | -ACAD_PROG - Student Academic Program Hierarchy Join -CU_BIO_VW - Biographical Information View Hierarchy Join -SF_STDNT_PRS_VW - SF Student Personal Data View Hierarchy Join -STDNT_CAR_TERM - Student Career Term Table Hierarchy Join -SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join -SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join -SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join -SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join -SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join -SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join -ACAD_PLAN - Student Academic Plan Table Hierarchy Join -ACAD_PLAN - Student Academic Plan Table Hierarchy Join -RESIDENCY_OFF - Official Residency Data Hierarchy Join -SCC_VISA_P_QVW - Visa Data Query View Hierarchy Join -ACAD_SUBPLAN - Student Academic Subplan Table Hierarchy Join -ACAD_SUBPLAN - Student Academic Subplan Table Hierarchy Join -STDNT_GRPS_HIST - Student Groups History
SUB QUERY for EFFECTIVE_TERM: -RESIDENCY_OFF - Official Residency Data
| Tabassum Lodhi | Margo Weaker | Modified Report | Margo Weaker, P. Ackerman, C. Keck |
| CU_BAR_SR_00077_3 | Zic Grad Students w/ RES-MBA | This is a list of active, enrolled Zicklin Grad students by current term. Added Plan, Subplan, GPA, Sex, Admit Term, Total Units, Current Units, Email Address Prompt on Institution and Term. | Last Name, First Name, Middle Name,Empl ID, Sex, Residency, Visa, Program, 1st Plan, Sub-Plan, 2nd Plan, Sub-Plan, Admit Term, Term Units, Total Units, Cum GPA, Ethnicities, Preferred Phone, Preferred Email, Group Name | -ACAD_PROG - Student Academic Program Hierarchy Join -CU_BIO_VW - Biographical Information View Hierarchy Join -SF_STDNT_PRS_VW - SF Student Personal Data View Hierarchy Join -STDNT_CAR_TERM - Student Career Term Table Hierarchy Join -SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join -SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join -SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join -SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join -SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join -SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join -ACAD_PLAN - Student Academic Plan Table Hierarchy Join -ACAD_PLAN - Student Academic Plan Table Hierarchy Join -RESIDENCY_OFF - Official Residency Data Hierarchy Join -SCC_VISA_P_QVW - Visa Data Query View Hierarchy Join -ACAD_SUBPLAN - Student Academic Subplan Table Hierarchy Join -ACAD_SUBPLAN - Student Academic Subplan Table Hierarchy Join -STDNT_GRPS_HIST - Student Groups History SUB QUERY for EFFECTIVE_TERM: -RESIDENCY_OFF - Official Residency Data | Tabassum Lodhi | Margo Weaker | Modified Report | Margo Weaker, P. Ackerman |
| CU_BAR_SR_00078 | Zicklin Grad Stdnts (no Execs) | This is a list of Zicklin graduate students (programs MBA and MS, minus IOP and FINENGR plans) who are enrolled for the prompted term. It also drops the International/Executive students (student group IEXP). Prompt on Institution, Current Term and Prior Term. | Last name, first name, middle name, emplid, 1st plan, 2nd plan, career, admit term, term units taken, total units taken, total units passed, Cum GPA and prior term GPA. | ACAD_PROG - Student Academic Program Hierarchy Join ACAD_PLAN - Student Academic Plan Table Outer Join for second plan, if it exists STDNT_CAR_TERM - Student Career Term Table Outer Join for prior term, if it exists CU_BIO_VW - Biographical Information View Hierarchy Join CU_STDNTGRP_VW - Student group data in a sub-query to eliminate IEXP students SUB QUERY for Does Not Exist: CU_STDNTGRP_VW SUB QUERY for PLAN_SEQUENCE: ACAD_PLAN - Student Academic Plan Table | Michael McGovern | Kevin Taylor | New Report | P. Ackerman, C. Keck, T. Lodhi |
| CU_BAR_SR_00078_1 | Zicklin Grad Stdnts (no Execs) | This is a list of currently active and enrolled Zicklin graduate students (programs MBA and MS, minus IOP, FINENGR, ILR-MS, HCA-MBA plans) who are enrolled for the prompted term. It also drops the International/Executive students (student group IEXP). Prompt on Institution, Current Term and Prior Term. | emplid, Last name, first name, middle name, 1st plan, Academic Sub-Plan, 2nd plan, career, admit term, term units taken, total units taken, total units passed, Cum GPA and prior term GPA, Sex (Gender) | -ACAD_PROG - Student Academic Program SUB QUERY for Does Not Exist: CU_STDNTGRP_VW SUB QUERY for PLAN_SEQUENCE: ACAD_PLAN - Student Academic Plan Table | Tabassum Lodhi | Kevin Taylor | Modified Report | P. Ackerman, T. Lodhi |
| CU_BAR_SR_00079 | Inactive SPA Grad Students | This is a list of SPA Grad students, inactive in a MPA, MSED or ADVCT program. It lists the emplid, name (sort order) program, plan, subplan, term credits, admit term, campus email, phone, expected graduation term, check out status, term GPA, cum GPA, status, completion term, mailing address, residency, total completed credits, total attempted credits and gender. | Empl ID, Last Name, First Name, Middle Name, Program, Plan, Subplan, Term Credits, Campus Email, Phone, Exp Grad Term, ChkoutStat, Term GPA, Cum GPA, program status, completion term, ,ailing address, residency, total completed credits, total attempted credits, gender. | ACAD_PROG - Student Academic Program Hierarchy Join ACAD_PLAN - Student Academic Plan Table Hierarchy Join ACAD_SUBPLN - Student Academic Subplan Table Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join ADDRESSES4_VW Mailing Address Hierarchy Outer Join RESIDENCY_OFF Student Residency Hierarchy Join SF_STDNT_PRS_VW Student Gender Hierarchy Join SUB QUERY for STRM: STDNT_CAR_TERM - Student Career Term Table SUB QUERY for EFFECTIVE_TERM: RESIDENCY_OFF - Official Residency Data | Michael McGovern | Sandra Fajardo | New report | S. Godwin, C Keck,P. Ackerman, T.Lodhi, S. Fajardo |
| CU_BAR_SR_00080 | SPA Grad - Applied for Graduation | This is a list of SPA Grad students, who are in a MPA, MSED or ADVCT program and who have applied for graduation. It lists the emplid, name (sort order) program, plan, subplan, term credits, admit term, campus email, phone, expected graduation term, check out status, term GPA, cum GPA, status, completion term, mailing address, residency, total completed credits, total attempted credits and gender. | Empl ID, Last Name, First Name, Middle Name, Program, Plan, Subplan, Term Credits, Campus Email, Phone, Exp Grad Term, ChkoutStat, Term GPA, Cum GPA, program status, completion term, ,ailing address, residency, total completed credits, total attempted credits, gender. | ACAD_PROG - Student Academic Program Hierarchy Join ACAD_PLAN - Student Academic Plan Table Hierarchy Join ACAD_SUBPLN - Student Academic Subplan Table Hierarchy Join NAME_CURR_VW - Primary Name View Outer Join SCC_PERS_PH_QVW - Preferred Phone View Outer Join STDNT_CAR_TERM - Student Career Term Table Hierarchy Join ADDRESSES4_VW Mailing Address Hierarchy Outer Join RESIDENCY_OFF Student Residency Hierarchy Join SF_STDNT_PRS_VW Student Gender Hierarchy Join | Michael McGovern | Sandra Fajardo | New report. | S. Godwin, C Keck,P. Ackerman, T.Lodhi, S. Fajardo |
| CU_BAR_SR_00083 | Zicklin Admissions | This is a list of Zick students and their admission. It includes the name, emplid, career, program, plan(s), admit type, cum GPA, attempted units, total GPA units, academic level and degree type. Prompt on Institution, Career, Term, Degree (optional), Program (optional) and Plan (optional). | Empl ID, Last Name, First Name, Middle Name, Admit Type, Admit Term, Career, Program, Plan, Sub-Plan, Seq Plan, Description, Degree, Degree Level, Academic Level, Term Units, Total Units, Total Baruch Credits, Cum GPA, Phone, Email, APS Service Ind, ACP Service Ind | -ACAD_PROG - Student Academic Program Hierarchy Join | Tabassum Lodhi/Michael McGovern | Sarah Leobis | New Report | P. Ackerman, C. Keck, |
| CU_BAR_SR_00081 | Students w/o SSN or LID | This is a list of term-activated students who do not have a national id/NID (SSN) or an assigned SSN/LID. Prompt on Institution and Activation Term. | Emplid, Term(STRM), Units Taken Progress, First Name, Middle Name, Last Name, Career, Plan, NID | STDNT_CAR_TERM - Student Career Term Table Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join SCC_PERS_NI_QVW - National ID view ACAD_PROG - Student Academic Program ACAD_PLAN - Student Academic Plan Table EXTERNAL_SYSTEMS - External System ID (LID) SUB QUERY for Does Not Exist: EXTERNAL_SYSTEM - External System ID's UNION 1: STDNT_GRPS_HIST - Student Groups History Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join ACAD_PROG - Student Academic Program Hierarchy Join ACAD_PLAN - Student Academic Plan Table Hierarchy Join SUB QUERY for Does Not Exist: SCC_PERS_NI_QVW - Person National ID Query View SUB QUERY for Does Not Exist: EXTERNAL_SYSTEM - External System ID's | Michael McGovern | Patrick Ackerman | New Report | |
Student Group Detail | This is a list of students who belongs to a certain student group (SEEK or others) . It lists the name, emplid, email address, career, program, plan(s) and cum GPA. Prompt on Institution, Term, career and Student Group. | Empl ID, Last Name, First Name, Program, Plan, Cum GPA, Total Credit, Transfer Credit, Total Credit Attempt, Total Credit Earned, Total Grade Unit, Grade Points, Take Prgrs, Email | STDNT_GRPS_HIST - Student Groups History Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join STDNT_CAR_TERM - Student Career Term Table Hierarchy Join ACAD_PROG - Student Academic Program Hierarchy Join ACAD_PLAN - Student Academic Plan Table Hierarchy Join ACAD_PLAN_TBL - Academic Plan Table Hierarchy Join | Tabassum Lodhi | Marisol Morales | New Report | M. Morales, P. Ackerman, C. keck | |
| CU_BAR_SR_00084 | Zicklin Enrl History | This is a list of students who had enrolled zicklin in 1159 with class, grade, plan, admit term, subject, catalog and cum GPA. Prompt on Institution, Term, career | Last,First Name,Middle,ID,Admit Term,Exp Grad,FA Taken,Cum GPA,Status,Eff Date,Acad Prog,Acad Plan,Email,Class Nbr,Subject,Catalog,Session,Grade | TERM_TBL - Term Definition Table Hierarchy Join ACAD_PROG - Student Academic Program Hierarchy Join ACAD_PLAN - Student Academic Plan Table Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join EMAIL_FERPA_VW - EMAIL FERPA VIEW Hierarchy Join STDNT_CAR_TERM - Student Career Term Table Hierarchy Join CLASS_TBL_SE_VW - Class Table Student Enrl View Hierarchy Join
| Tabassum Lodhi | Sarah Leobis | New Report | Sarah Leobis |
| CU_SR_CLASS_ROSTERS_SUBJ_Email | Rosters+Grades By Term Subject_email | Modified | ||||||
| CU_BAR_SR_00086 | List of Enrolled Students | This query is designed for Rachel Fester in Provost office to extracting student enrollment info per semester after the add/withdraw period ends | Career, Acad Prog, ID, SEX - Gender, Address, City, Postal, Emai,l Last Name, Frist Name, ACAD Plan, Sub-Plan, ACAD Plan2, Sub-Plan |
STDNT_CAR_TERM - Student Career Term Table Hierarchy Join
SCC_PERDATA_QVW - PERSONAL_DATA Query View Hierarchy Join
SCC_EMAIL_QVW - Email Addresses Query View left outer joined with B Hierarchy Join
ACAD_PROG - Student Academic Program Hierarchy Join
ACAD_PLAN - Student Academic Plan Table Hierarchy Join
ACAD_SUBPLAN - Student Academic Subplan Table left outer joined with E Hierarchy Join
ACAD_PLAN - Student Academic Plan Table left outer joined with E Hierarchy Join
ACAD_SUBPLAN - Student Academic Subplan Table left outer joined with G Hierarchy Join Subquery for PLAN_SEQUENCE - | Tabassum Lodhi | Rachel Fester | New | |
CU_BAR_SR_00087 | List of MATH enrolled students with their math history | MATH History for Warren. This query will pull current math enrolled students with their math history. Prompt on term. | Tabassum Lodhi |