| Warning |
|---|
Do not include non-public information in documentation or attachments when reporting or responding to an issue through this site. Before Copy to any query to anyone from Zicklin School of Business, the user requires permission from the office of the Dean to access queries. |
| 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_ | 0001500014_2 | Degree Audit ReportF1/J1 Visa Students | This is a | listinglist of term-activated 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. AckermanF1 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_ | 32 | DegreeDegree Audit Report | ThisThis 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 progressunits, total | units, totalpassed 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 | HeidenfelderModified report | JHeidenfelder | New report for Registrar. | J Heidenfelder, A Kamruzzaman, | T.LodhiC Keck, P. | Cox, T.LodhiAckerman | ||||||||||||
| CU_BAR_SR_ | 00016Graduation/Stdnt Grps/Srvc Ind | This is a list00015_3 | Degree Audit Report | This is a listing 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 Joincompleted 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 | Michael McGovern | Jason Heidenfelder | New report for Registrar. | J Heidenfelder, A Kamruzzaman, C Keck, T.Lodhi | |||||||||||
| CU_BAR_SR_0001700016 | Graduation/Student GradesStdnt Grps/Srvc Ind | This is a list of students grades 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) and Grade (optional). | Empl IDLast Name, First Name, Middle Name, Last Name, Exp Grad TermEmpl ID, Degree Nbr, Degree, Career, ProgramCompl Term, PlanConfer Dt, ChkoutStatHon Code, SubjectDegree GPA, CatalogDegr Stat, SectionPhone, Session, Units, Grade Official, Primary Instructor, Secondary Instructor Email, Student Group/Service Indicatr | ACAD_PROG DEGR - Student Academic Program Degree Table Hierarchy Join UNION 1: ACAD_DEGR - Student Degree Table Hierarchy Join CU_BIO_VW - Biographical Information View View Hierarchy Join CLASS STDNT_TBL_SE_VW - Class Table Student Enrl View 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 McGovernAbu Kamruzzaman | Jason Heidenfelder | New report for Registrar. | J Heidenfelder, A Kamruzzaman, C Keck, A Cox, T.Lodhi | |||||||||||||||||||
| CU_BAR_SR_0001800017 | International Graduation/Student DataGrades | This is a list of all international students, based on the Citizenship tablestudents grades who have a degree in whatever status for a prompted completion term. Prompt on Institution and Enrollment Term., Completion Term range, Degree Status (optional) and Grade (optional). | Empl IDLast Name, First Name, Middle Name, Empl ID, Mar Status, Sex, Last Name, Exp Grad Term, Career, Program, Plan, Admit TermChkoutStat, Admit TypeSubject, Term UnitsCatalog, PhoneSection, EmailSession, USAUnits, Status, USA Satus Description, other, StatusGrade Official, Primary Instructor, Secondary Instructor | - ACAD_PROG - Student Academic Program Hierarchy Join | Michael McGovern | Rosa Kelley | New report. | VW5 - Distinct Instructors for Class Hierarchy Join | Abu Kamruzzaman | Jason Heidenfelder | New report for Registrar. | J Heidenfelder, A Kamruzzaman, C Keck, R Kelley, D. BerryA Cox, T. Lodhi Lodhi | |||||||||||||||
| CU_BAR_SR_00018 | _1International | 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 | - ACAD_PROG - Student Academic Program Hierarchy Join | Abu | Rosa Michael McGovern | Rosa Kelley | ModifiedNew report. | A Kamruzzaman, C Keck, R Kelley, | DD. Berry | , P. Ackerman, T. | Lodhi, M. McGovernLodhi | |||||||||||||
| CU_BAR_SR_00018_ | 00019Zicklin Graduation Report1 | International Student Data | This is a list of all | Zicklin students who have completed their programs for the prompted terminternational students, based on the Citizenship table. Prompt on Institution and | CompletionEnrollment 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 | , 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 | Michael McGovern | Maziely Crisostomo | New report. | M Crisostomo, C Keck, A Kamruzzaman, T.Lodhi | CU_BAR_SR_0002100020 | Withdrawals Demographics by Student Group | This is a list of students and their demographic information who are active in a prompted student group who have withdrawn from class during a prompted termstudent group (i.e., College Now) for the term prompted. Prompt on Institution, Term and Student Group. | Last Last Name, First Name, Middle Name, Empl ID, Career, Acad Prog, Phone, Email, Subject, Catalog, Session, Section, Class Description, Unit Taken, Grade 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 CU_BAR_SR_0002200021 | Withdrawals by Student GroupMulti_Inst Enrollment by S.G. | This is a list of students active in a prompted student group who have enrollment at another institution for withdrawn from class during a prompted term. Prompt on Institution, Term and Student Group. | Last 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, UnitsUnit 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_0002300022 | Multi_Inst Enrollment by S.G.Student Assessment | This is a list of enrolled students, new and continuing, with contact information, SAT scores, previous schools and degreesstudents active in a prompted student group who have enrollment at another institution for a prompted term. Prompt on Institution, Career and Admit Term range. Term and Student Group. | Last Name, First Name, Middle Name, Empl ID, Career, ProgramPhone, Admit TermEmail, 1st PlanSubject, 2nd PlanCatalog, Term UnitsSession, Total Units, Cum GPA, Phone, Campus Email, Admit Type, Last School, School Name, Degree Nbr, Degree, InstitutionSection, Class Description, Units, Other Institution, Subject, Catalog, Session, Section, Class Description, Units | STDNT_GRPS_HIST - Student Groups History Hierarchy Join | Michael McGovern | Elaine Cataletto | New report. | Michael McGovern | Maziely Crisostomo | New report. | M CrisostomoE Cataletto, C Keck, A Kamruzzaman, D Berry, T.Lodhi | ||||||||||||||||
| CU CU_BAR_SR_00024_100023 | Student AssessmentActive SPA Grad Students | This is a list of SPA Grad enrolled 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.new and continuing, with contact information, SAT scores, previous schools and degrees. Prompt on Institution, Career and Admit Term range. | Empl ID, Last Name, First Name, Middle Name, ProgramEmpl ID, PlanCareer, SubplanProgram, Admit Term Credits, Campus Email, Phone, Exp Grad Term, ChkoutStat, Term GPA, 1st Plan, 2nd Plan, Term Units, Total Units, Cum GPA, program status, completion term, ,ailing address, residency, total completed credits, total attempted credits, gender. Phone, Campus Email, Admit Type, Last School, School Name, Degree Nbr, Degree, Institution | ACAD_PROG - Student Academic Program 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
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 DATA - Admission Application Data Hierarchy Join | Michael McGovern | Elaine Cataletto | New report. | E Cataletto, C Keck, A Kamruzzaman, D Berry, T.Lodhi | |||||||||||||||||||
| Michael McGovern | Sandra Fajardo | New report | S. Godwin, C Keck,P. Ackerman, T.Lodhi, S. Fajardo | CU_BAR_SR_0002500024_1 | Completed Active SPA Grad Students | This is a list of SPA Grad students, who have complete 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 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 Reportreport | S. Godwin, C Keck,P. Ackerman, T.Lodhi, S. Fajardo | |||||||||||||||
| CU_BAR_SR_0002600025 | Completed SPA Grads HoldsGrad Students | This is a list of SPA graduate Grad students who has BUR hold - request was related to hold resulting from AEF being applied. Prompt on Institution and Term., 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, Empl ID, Program, Program, Plan, Subplan, Term Credits, Campus Email, Phone, Exp Grad Term, ChkoutStat, Plan, Term CreditsGPA, Total, Cum GPA, Phone, Email, 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_STDNT_CAR_TERM - Student Career Term Table Hierarchy Join ADDRESSES4_VW Mailing Address Hierarchy Outer Join RESIDENCY_OFF Student Residency Hierarchy Join CUSF_STDNT_BIOPRS_VW - Biographical Information View | A. Kamruzzaman | Sarah Godwin | New report.
| 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_0002700026 | SPA En G Stu Eth Grp Res VisaGrads Holds | This is a list of active , enrolled students by termSPA 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, SexProgram, ResidencyExp Grad, VisaChkoutStat, 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 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_SRSRR_0003000029_1 | ZIcklin Grad StudentsUndergrads > 60 credits/Staub eligibility list for Feit Seminar | This is a list of currently enrolled Zicklin grad studentsactive undergrads who will have completed 60 credits or greater after the prompted term. Prompt on Institution andTerm. 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, Sex, Residency, Visa, Program, 1st Plan, 2nd Plan, ProgramPlan,Admit Term,Term UnitsCredits, Total Units, Cum GPACredits, EthnicitiesExp Grad, Preferred PhoneGPA, Preferred EamilEmail | ACAD_PROG - Student Academic Program Hierarchy Join CU ACAD_BIO_VW - Biographical Information View Hierarchy JoinSF_STDNT_PRS_VW - SF Student Personal Data View Hierarchy JoinPLAN - Student Academic Plan Table STDNT_CAR_TERM - Student Career Term Table Hierarchy Join SCC CU_ETHBIO_GRP_VW - Ethnic Diversity Hierarchy JoinSCC_ETH_GRP_VW - Ethnic Diversity 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_0004600045_2 | Student Enrollment GRADService 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 JoinMichael 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 Sessionand 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, EmailCLASS_TBL - Class Table Hierarchy Join CLASS_INSTR - Class Instructor Table Hierarchy Join CU_BIO_VW - Biographical Information View 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 GPAAdmit 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 | Michael McGovern | Sandra Fajardo |
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 | New report | E Adams, C Keck, S Godwin, T.Lodhi | CU_BAR_SR_0004900045_3 | Student Enrollment UGRDNeed 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). 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, Last Name,, First Name, Middle Name, Empl ID, Admit Type, Admit Term, Career, Program, Admit Term, Program Action, Action Rsn, Preferred Email, 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 SUB QUERY for Does Not Exist:
| Michael McGovern | Millie Figueroa | New report | 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 | M Delacruz, M Figeroa, H Morales, M Elbulok, T Nesdill, T.Lodhi | ||||||||||||
| CU_BAR_SR_0005000046 | Service Indicator AuditImmunizations for Students | This is a list of active students who have no immunization recordsever been in a prompted service indicator. Prompt on Institution and CareerTerm. | Service Ind, Reason Code, Last Name, First Name, Middle Name, Empl ID, Admit TermAction, CareerHow Placed, Program, Plan, Immunizations?, Campus Email User, Date/Time | AUDIT_SRVC_IND - Audit Record - SRVC_IND_DATA ACAD_PROG - Student Academic Program Hierarchy Join SUB QUERY for Does Not Exist: IMMUNIZATIONS - Immunizations | Michael McGovern | Marisa Delacruz | Michael McGovern | Marisol Morales | New report. | M Delacruz, M Figeroa, H Morales, M Elbulok, C Keck, T Nesdill, A Rodriguez, A Kamruzzaman, T.Lodhi | |||||||||||||||||
| CU_BAR_SR_0005100047 | ReClass Instructors-admits w/ GPAs < 2.0Term/Session | 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 SEEKunique instructors for the term and session with their preferred email address. Prompt on Institution, Term and Admit Term rangeSession. | 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 Email | CLASS_TBL - Class Table Hierarchy Join SUB QUERY for STERM: STDNT_CAR_TERM - Student Career Term Table SUB QUERY for Does Not Exist: STDNT_GRPS_HIST - Student Groups History | Michael McGovern | Elaine Cataletto | New report. | Michael McGovern | Edward Adams | New report | E Adams, C Keck, A Cox, A. E Cataletto, C Keck, A Kamruzzaman, T.Lodhi
| ||||||||||||||||
| CUCU_BAR_SR_0005200048 | Students Grads w/ Double Majors Low GPAs | This is a list of new students who have more than one majorless than the prompted GPA. Prompt on Institution and Admit Term range. , Program, Term and GPA. | Last Name, First Name, Middle Name, Empl ID, # of Majors , 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 |
| Michael McGovern | Sandra FajardoMarisa Delacruz | New report. | E Adams, M Delacruz, M Figeroa, H Morales, M Elbulok, C Keck, T Nesdill, A Garfinkel, J Goldstein, F Ferrara, A Rodriguez, A Kamruzzaman, S Godwin, T.Lodhi | |||||||||||||||||
| CU CU_BAR_SR_0005300049 | Need Term Activation 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.students who have not been term activated for the prompted term. Prompt on Institution and , Career, Term, Admit Term range and Program (optional). | Last Last Name,, First Name, Middle Name, Empl ID, TermCareer, Term GPAProgram, Cum GPA, Admit Term, Term Units, GPA Units, Total Units, Career, Program, 1st Plan, 2nd PlanSTDNT_CAR_TERM - Student Career Term Table Hierarchy Join Program Action, Action Rsn, Preferred Email | ACAD_PROG - Student Academic Program Hierarchy Join SUB QUERY for Does Not Exist: STDNT_GRPSCAR_HIST TERM - Student Groups HistoryCareer Term Table | Michael McGovern | Elaine CatalettoMillie Figueroa | New New report | E Cataletto, C Keck, A KamruzzamanM Delacruz, M Figeroa, H Morales, M Elbulok, T Nesdill, 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 | 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 STDNT_CAR_TERM - Student Career Term Table Hierarchy Join ACAD_PROG - Student Academic Program Hierarchy Join | Abu Kamruzzaman | Sarah Godwin | Modified Report | VW - EMAIL FERPA VIEW 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 S. Godwin,A. Kamruzzaman, P. Ackerman, T.Lodhi | |||||
| CU_BAR_SR_00054_4 | SPA Grad Enrollment Counts | 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. 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 unitsName, Empl ID, Career, Program, 1st Plan, 2nd Plan, Admit Term, Email, Phone, ID, ChkoutStat, Term Credits Term, Cum GPA, CUM Baruch GPA Taken, StatusTotal Units, Compl Term, Acad Load, Acad Load, Sub-plan, Country, CountryPhone, Campus Email | ACAD_PROG - Student Academic Program Hierarchy Join SCC STDNT_ CITIZEN_QVW - Citizenship Query View Hierarchy JoinSCC_CITIZEN_QVW - Citizenship Query View Hierarchy Join | Abu Kamruzzaman | Sarah Godwin | Modified Report | S. Godwin,A. Kamruzzaman, P. Ackerman, C Keck, T.Lodhi | 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
| ||||||||||||
| CUCU_BAR_SR_00054_5 | 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. | 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 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 PrgrsName, Empl ID, # of Majors | ACAD_PROG - Student Academic Program Hierarchy Join -STDNT_CAR_TERM - Student Career Term Table Hierarchy Join -ACAD_PROG - Student Academic Program Hierarchy Join -CU_BIO_VW - Biographical Information View 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 | 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.LodhiS. Godwin,D. Battista, P. Ackerman, C Keck, T.Lodhi, S. Fajardo | |||||||||||||
| CU_BAR_SR_0005500053 | New Students w/ GPAs < 2.0Grad School Fair | This is a list of active undergrads who have more than 60 creditsnew 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 Last Name, First Name, Middle Name, Empl ID, Program, Total Credits, Campus EmailTerm, 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_0005600054 | 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. | 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 TypeAcad 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 ACAD_PROG - Student Academic Program Hierarchy Join ACAD_PLAN PROG - Student Academic Plan Table Program Hierarchy Join STDNT_CAR_TERM - Student Career Term Table Hierarchy Join ACAD_PLAN - Student Academic Plan Table Hierarchy Join SUB QUERY for Does Not Exist: STDNT_GRPS_HIST - Student Groups History | Michael McGovern | Elaine Cataletto | New report | Abu Kamruzzaman | Sarah Godwin | Modified Report | S. Godwin,A. Kamruzzaman, P. Ackerman, E Cataletto, C Keck, A Kamruzzaman, T.Lodhi | ||||||||||||||
| CU_BAR_SR_00054_00057 | GRADs w/High GPAs | 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 citizenshipsThis 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, 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 JoinSTDNT_CAR_TERM - Student Career Term ACAD_PLAN - Student Academic Plan Table Hierarchy Join ACAD_SUBPLAN - Student Academic Subplan Table Hierarchy JoinADDRESSES4 SCC_CITIZEN_VW QVW - Addresses Citizenship Query View for Curr EffDT Hierarchy JoinEMAIL SCC_FERPACITIZEN_VW - EMAIL FERPA VIEW QVW - Citizenship Query View Hierarchy Join | Michael McGovern | Sandra Fajardo | New report | Abu Kamruzzaman | Sarah Godwin | Modified Report | S. Godwin,A. Kamruzzaman, P. Ackerman, C KeckS Godwin, C Keck, A Kamruzzaman, T.Lodhi | ||||||||||||||
| 00058 | Term Active/No Enrollment | 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 statusThis 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, 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 Table Hierarchy Join -ACAD_PROG - Student Academic Program Hierarchy Join -CU_BIO_VW - Biographical Information View View Hierarchy Join | Michael McGovern | Sandra Fajardo | New report. |
-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. FajardoS Godwin, C Keck, A Kamruzzaman, T.Lodhi | ||||||||||||||
| CU_BAR_SR_0005900054_6 | Active + Enrolled SPA grad 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 | |||||||||||||||||||||
| 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 - | 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-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 | Michael McGovern | Ellen King | New report | E King, L Ballance, C Keck, F Burke, J Makarewycz, A Kamruzzaman, T. Lodhi | |||
| CU_BAR_SR_0006300054_17 | Active + Enrolled SPA grad 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 | 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 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 - Table Hierarchy Join -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 Hierarchy Join -CITIZEN_STS_TBL - Citizen Status Table Hierarchy Join VISA -CITIZEN_PMTSTS_DATA - EE/Dependent Visa Data Hierarchy Join -SCC_ETH_GRP_VW - Ethnic Diversity Subquery for --EFFECTIVE_TERM | Tabassum Lodhi | same as CU_BAR_SR_00054_7 | Young Hug | ||||||||||||||||||
| 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 | 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 STDNT_GRPS_HIST - Student Groups History 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 UNION 1: STDNT_GRPS_HIST - Student Groups History Hierarchy Join
SUB QUERY for Does Not Exist: STDNT_ADVRGRPS_HIST - Student Advisor Groups History | Abu Kamruzzaman | Michael McGovern | Elaine CatalettoNancy Aries | New report | N. Aries, J. Vaisman, M. McGovern, C. Keck, E Cataletto, C Keck, A Kamruzzaman, T.Lodhi | ||||||||||||||||||
| CU_BAR_SR_0006500057 | GRADs w/High GPAsWeissman Grad Students | This is a list of term-active Weissman graduate students and their bio datagrad students who have not less than the prompted GPA. Prompt on Institution, Program, Career Term and TermGPA. | Last Name, First Name, Middle Name, Email, Phone, Empl ID, NID, Admit Term, Acad Prog, Acad Plan, Take Prgrs, Total Taken Toward GPA, Total Passed Toward GPA, Total, Current GPA, Cumulative GPA, Country, Program, Term Units, Baruch Completed, Total Completed, Home Address 1, Home Address 2, Address 3, City, State, Postal, SexPhone, Effective, Residency, Country, Short Desc, Country, Short Desc, White?, Black?, Hispanic?, Asian?, American Indian?, Not Specified?Campus Email, Cum GPA | 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 | VW - EMAIL FERPA VIEW 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 GovanM Lovaglio, A Kamruzzaman, C Keck, T.Lodhi | |||||||||||||||||||||
| CUCU_BAR_SR_0006600061_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 | Zicklin Grad Awarded Degrees | This is a list of Baruch student groupsZicklin grad students who have been awarded degrees. Prompt on InstitutionCompletion Term. | Group Last Name, Last First Name, First Middle 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 CU_BIO_VW - Biographical Information View Hierarchy Join ACAD_PROG - Student Academic Program Hierarchy Join STDNT_CAR_TERM - Student Career Term Table Hierarchy Join SRVC_IND_DATA - Service Indicator Data Hierarchy Join SRVC_IND_DATA - Service Indicator Data Hierarchy Join EMAIL_FERPA_VW - EMAIL FERPA VIEW Hierarchy Join CLASS_TBL_SE_VW - Class Table Student Enrl View Hierarchy Join CLASS_TBL_SE_VW - Class Table Student Enrl View Hierarchy Join | Patrick Ackerman | 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_00006800062 | Zicklin Grad GPA ChangesGrads by Plan per Acad Year | This is a count list of students who complete their degree during the academic yearZicklin grad students whose Cum GPA has changed from the previous term. Prompt on Institution and Academic Year.Current Term and Prior Term. | Last Name, First Name, Middle Name, Empl IDAcad Year, Career, Program, Plan, Plan Description, Count TERM_TBL - Term Definition Table Hierarchy Join Current Term, Current Cum GPA, Prior Term, Prior Cum GPA | ACAD_PROG - Student Academic Program Hierarchy Join | Michael McGovern | David ChristyEllen King | New report. | D Christy, A KamruzzamanE King, L Ballance, C Keck, F Burke, J Makarewycz, A Kamruzzaman, T.Lodhi | |||||||||||||||||||
| CU_BAR_SR_0006900063_1 | New Zicklin Grad StudentsService 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, | ||||||||||||||||||||
| 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 | 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_200065 | Weissman Grad StudentsEnrl 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. term-active Weissman graduate students and their bio data. Prompt on Institution, term, PI Stu Grp Active - Beg Date and PI Stu Grp Active - End Date (these are newly added). | ID, Campus Email | 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 -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 | |||||||||||||||||||
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 | 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)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, Advisor Last Name, Last First Name, first Name, Empl ID, Admit Term, Srv IND cdInd Cd, Srvc Reasn, Srv Ind Cd, Srvc Reasn, Acad Plan, Acad Plan, Acad Plan, tot Tot Earned, Term Units, Total Attempted, Term GPA, Prior 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 | Abu Kamruzzaman | Nancy Aries | Modified report | Michael McGovern | David Christy | New report. | D Christy, A Kamruzzaman, C Keck 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 | - STDNT_GRPS_HIST - Student Groups History Hierarchy Join00069 | 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 | 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 | 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 | |||||||||||||||||||
- ACAD_PROG - Student Academic Program 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 |
| 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 | - SRVC_IND_DATA - Service Indicator Data Hierarchy Join | Abu Kamruzzaman | Nancy Aries | Modified report | N. Aries, J. Jody Vaisman, P. Ackerman, C. Keck, D. Berry, T. Lodhi, A. Cox
| ||||||||||
| CU_BAR_SR_00072_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. | 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 |
| 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 | |||||||||||||||||||
DATA - Service Indicator Data 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_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 | 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 SUBPLN - Student Academic Plan Table Outer Join for second plan, if it exists 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 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 | QVW - Campus Email Hierarchy Outer 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. FajardoP. Ackerman, C. Keck, T. Lodhi | |||||||||||
| CU_BAR_SR_0007900083 | Zicklin AdmissionsInactive 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 genderZick 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, 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. 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 ADDRESSES4_VW Mailing Address Hierarchy Outer 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 |
| Tabassum Lodhi/Michael McGovern | Sarah Leobis | New Report | S. Godwin, C Keck,P. Ackerman, TC. LodhiKeck, S. Fajardo | |||||||||||||||
| CU_BAR_SR_0008000081 | Students w/o SSN or LIDSPA Grad - Applied for Graduation | This is a list of SPA Grad term-activated 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. 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 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 JoinSCC_EMAIL_QVW - Campus Email Hierarchy Outer 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. | 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 | S. Godwin, C Keck,P. Ackerman, T.Lodhi, S. Fajardo | |||||||||||||||
| 00083 | Student Group Detail Zicklin Admissions | This is a list of Zick students and their admission. It includes students who belongs to a certain student group (SEEK or others) . It lists the name, emplid, email address, 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)and cum GPA. Prompt on Institution, Term, career and Student Group. | 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 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 -ACAD_PROG - Student Academic Program Hierarchy Join STDNT_CAR_TERM - Student Career Term Table Table Hierarchy Join - ACAD_PLAN_TBL PROG - Student Academic Plan Table Program Hierarchy Join -SRVC_IND_DATA - Service Indicator Data Hierarchy Join | Tabassum Lodhi/Michael McGovern | Sarah Leobis | New Report | 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,keck | |||||||||||||||
| CU_BAR_SR_0008100084 | Zicklin Enrl HistoryStudents 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 | 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 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 ViewView Hierarchy Join ACADEMAIL_FERPA_ PROG - Student Academic ProgramVW - EMAIL FERPA VIEW Hierarchy Join ACADSTDNT_CAR_ PLANTERM - Student Academic PlanCareer Term Table Hierarchy JoinSUB 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 | 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 | ModifiedNew Report | |||||||||||||||||||||||||
| CU_BAR_SR_0008200086 | List of Enrolled StudentsStudent 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 | 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 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 left outer joined with E Table Hierarchy Join
ACAD_PLAN_TBL SUBPLAN - Academic Plan Table Hierarchy Join Student Academic Subplan Table left outer joined with G Hierarchy Join Subquery for PLAN_SEQUENCE - | Tabassum Lodhi | Marisol Morales | New Report | 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 | M. Morales, P. Ackerman, C. keck |