...
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 | 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 | 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. | Michael McGovern | Mihai Vladu | New report for Career Development. | M Vladu, C Keck, A. Kamruzzaman, P. Ackerman | ||
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 | 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 | Michael McGovern | Marisol Morales | SEEK report but should work for other student groups. | M Morales, C Keck, A Kamruzzaman 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 | 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 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 | 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 | 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 | 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 | Michael McGovern | Marisol Morales | SEEK report but should work for other student groups. | M Morales, C Keck, A Kamruzzaman Kamruzzaman, 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 | Michael McGovern | Marisol Morales | SEEK report but should work for other student groups. | M Morales, C Keck, A Kamruzzaman 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 | 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 | 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# | Michael McGovern | Rosa Kelley | New report. | A Kamruzzaman, C Keck, R Kelley, 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). | 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 | 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 | 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 |
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 | 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 | Michael McGovern | Maziely Crisostomo | New report. | M Crisostomo, C Keck, A Kamruzzaman 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 | 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 | Michael McGovern | Elaine Cataletto | New report. | E Cataletto, C Keck, A Kamruzzaman, D Berry, T.Lodhi | |
CU_BAR_SR_00024 | ||||||||
CU_BAR_SR_00025 | ||||||||
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
| 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 | Michael McGovern | Marisol Morales | New report. | M Morales, C Keck, A Kamruzzaman 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 | Michael McGovern | Elaine Cataletto | New report. | E Cataletto, C Keck, A Kamruzzaman, D Berry, T.Lodhi | |
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 | Michael McGovern | Elaine Bernstein, Elizabeth Figini | New report. | J Albanese, E Berstein, E Figini, P Davis-Friday, C Keck, A Kamruzzaman Kamruzzaman, T.Lodhi |
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. | 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. |
| Abu Kamruzzaman | Elizabeth Figini | Modified report | J Albanese, E Berstein, E Figini, P Davis-Friday, C Keck, P. Ackerman, T. Lodhi |
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 | 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 | 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 | Michael McGovern | Arthur Downing | New report. | A Downing, A Kamruzzaman, D Berry, C Keck, Gary Hotko 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 Hotko, T.Lodhi |
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 | 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 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_00035 | ADID Updates Term Active | Mid term Term Active updates for ADID | Dixon Berry | Patrick Ackerman | Patrick A. (7/24) | |||
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 | 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 | 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 | Michael McGovern | Sarah Godwin | New report. | A Kamruzzaman, C Keck, S Godwin 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 | Michael McGovern | Czarina Valente | New report. | A Kamruzzaman, C Keck, C Valente, D Mazzia 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 | Michael McGovern | Marisa Delacruz | New report. | M Delacruz, M Figeroa, H Morales, C Keck, A Kamruzzaman, T.Lodhi | |
CU_BAR_SR_00045_1 | 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 | 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 . Ackerman, T.Lodhi | |
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 | 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 | 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 | 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 | Michael McGovern | Millie Figueroa | New report | M Delacruz, M Figeroa, H Morales, M Elbulok, T Nesdill, T Nesdill .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 | 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 | 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 | 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 | Michael McGovern | Elaine Cataletto | New report | E Cataletto, C Keck, A Kamruzzaman 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 |
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 | 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 | 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 | 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 | Michael McGovern | Sandra Fajardo | New report. | S Godwin, C Keck, A Kamruzzaman 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 | 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 | Michael McGovern | Ellen King | New report | E King, L Ballance, C Keck, F Burke, J Makarewycz, A Kamruzzaman 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 | 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 | 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 | 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? | Michael McGovern | Michael Lovaglio | New report | M Lovaglio, A Kamruzzaman, C Keck, T.Lodhi | |
CU_BAR_SR_00066_1 | 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 | 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 | 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 | Patrick Ackerman | New Report | C. Keck, 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_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 |
CU_BAR_SR_00075
| 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 | 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 |