Report ID | Title | Description | Columns Included | Records Included | Developer | Requestor | Comments | Shared with | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CU_BAR_AD_00001 | New Applicants | This is a list of new applicants. The list includes the emplid, name, contact information. Prompt on Institution, Career, Admit Term, Admit Type (optional) and Program Action (optional). | Last, First Name, Middle, ID, Career, Acad Prog, Prog Actn, Acad Plan, Action Date, Admit Term, Admit Type, Last School Attended, School Name, Residency, Phone, Email |
- ADM_APPL_PROG - Admission Applicant Program Hierarchy Join - ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join - EXT_ORG_VW - External Organization Tbl View Hierarchy Join - RESIDENCY_OFF - Official Residency Data Hierarchy Join | Michael McGovern | Marisa Delacruz | New report | M Delacruz, M Figeroa, H Morales, A Cox, C Keck, P Ackerman, T. Lodhi | |||||||||||||||||||
CU_BAR_AD_00002_3 | Applicant Writing Placement | This query selects applicants for an Institution and Admit Term, and determines into which writing course the applicant should be placed. This selection is for undergraduate, degree-seeking applicants. Prompt on Institution, Career, Admit Term range and Admit Type. | Group,Empl ID,Last Name, First Name, Middle Name, SSN, Admit Type, Phone, Email, Test ID, Component, Score, Test Dt, ESL | ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join STDNT_TEST_COMP - Student Test Components Hierarchy Join SCC_PERS_NI_QVW - Person National ID Query View Hierarchy Join CU_ST_TEST_COMP - CU_ST_TEST_COMP SUB QUERY for Does Not Exist: STDNT_GRPS_HIST - Student Groups History SUB QUERY for Does Not Exist: STDNT_TEST_COMP - Student Test Components Subquery for F.TEST_DT - Test Date: -STDNT_TEST_COMP - Student Test Components UNION1: -ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join -CU_BIO_VW - Biographical Information View Hierarchy Join -SCC_PERS_NI_QVW - Person National ID Query View Hierarchy Join -STDNT_TEST_COMP - Student Test Components Hierarchy Join Sub query for does not exist: -STDNT_GRPS_HIST - Student Groups History | Michael McGovern | Denyse Ramkaran | New report | G Hotko, D Ramkaran, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi | |||||||||||||||||||
CU_BAR_AD_00003_1 | Applicant Reading Placement | This query selects applicants for an Institution and Admit Term, and determines into which reading course the applicant should be placed. This selection is for undergraduate, degree-seeking applicants. Prompt on Institution and Admit Term range. | Group,Empl ID,Last Name, First Name, Middle Name, SSN, Admit Type, Phone, Email, RAF Score, RAF test Dt, RAF Ltr Score, REF Score, REF Test Dt, REF Ltr Score | ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join STDNT_TEST_COMP - Student Test Components Hierarchy Join STDNT_TEST_COMP - Student Test Components Hierarchy Join SCC_PERS_NI_QVW - Person National ID Query View Subquery for does not exist: -STDNT_TEST_COMP - Student Test Components Subquery for does not exist: -STDNT_GRPS_HIST - Student Groups History Subquery for exist: -STDNT_TEST_COMP - Student Test Components Subquery for does not exist: -STDNT_TEST_COMP - Student Test Components | Michael McGovern | Denyse Ramkaran | New report | G Hotko, D Ramkaran, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi | |||||||||||||||||||
CU_BAR_AD_ | 0000400003_2 | NewApplicant | Contact DataThis is a list of new applicants by prompted term and their contact informationReading Plcmnt Accup | This query selects applicants for an Institution and Admit Term, and determines into which reading course the applicant should be placed. This selection is for undergraduate, degree-seeking applicants. Prompt on Institution | , Career,and Admit Term range | and Admit Type (optional).. - Updated for Accuplacer Testing | Group,Empl ID,Last Name,First Name,Middle Name, Empl ID, Career, Program, Action, Plan, Admit TermSSN,Admit Type,Phone,Email, Addr Type, Address 1, Address 2, City, State, Postal | - ADM_APPL_DATA - Admission Application Data Hierarchy Join - ADM_APPL_PROG - Admission Applicant Program Hierarchy Join - ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join - ADDRESSES4_VW - Addresses View for Curr EffDT Hierarchy Join | Michael McGovern | Marisa Delacruz | New Report | M Delacruz, M Figeroa, H Morales, A Kamruzzaman, C Keck,RAF Score,RAF Test Dt,RAF Ltr Score,REF Score,REF Test Dt,REF Ltr Score,ARF Test Dt,ARF Score,ARF Ltr Score, | ADM_MC_VW - Adm Appl Prog Vw for MC CU_BIO_VW - Biographical Information View STDNT_TEST_COMP - Student Test Components STDNT_TEST_COMP - Student Test Components SCC_PERS_NI_QVW - Person National ID Query View STDNT_TEST_COMP - Student Test Components
| Gary Hotko | Gary hotko | Modified Report | G. hotko, D Ramkaran, | P Ackerman,T. Lodhi | |||||||||
CU_BAR_AD_00005 | Number available | 00004 | New Applicant Contact Data | This is a list of new applicants by prompted term and their contact information. Prompt on Institution, Career, Admit Term range and Admit Type (optional). | CU_BAR_AD_00006A | Appl Math Place - M3 Only | This query selects applicants who have taken the ACT-MATH-3 within the past two years for an Institution and Admit Term. It then determines into which math student group the applicant should be placed. This selection is for undergraduate, degree-seeking applicants. Prompt on Institution, Career, Admit Term range and Admit Type (optional). | S G, Empl ID, Last Name, First Name, Middle Name, SSN, Empl ID, Career, Program, Action, Plan, Admit Term, Admit Type, Phone, Eamil, Test ID, Test DT, Data Srce, Total Score | ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join C CU_BIO_VW - Biographical Information View Hierarchy Join SCC_PERS_NI_QVW - Person National ID Query View Hierarchy Join STDNT_TEST_COMP - Student Test Components | Michael McGovern | Denyse Ramkaran | New report | , Email, Addr Type, Address 1, Address 2, City, State, Postal | - ADM_APPL_DATA - Admission Application Data Hierarchy Join - ADM_APPL_PROG - Admission Applicant Program Hierarchy Join - ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join - ADDRESSES4_VW - Addresses View for Curr EffDT Hierarchy Join | Michael McGovern | Marisa Delacruz | New Report | M Delacruz, M Figeroa, H Morales, A Kamruzzaman, C Keck G Hotko, D Ramkaran, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi | |||||||||
CU_BAR_AD_00005 | Number available | ||||||||||||||||||||||||||
CU_BAR_AD_00006A | _DTLAppl Math Place - M3 Only | ThisThis query selects applicants who have taken the ACT-MATH-3 within the past two years for an Institution and Admit Term. It then determines into which math student group the applicant should be placed. This selection is for undergraduate, degree-seeking applicants. Prompt on Institution, Career, Admit Term range and Admit Type (optional). | S G, Empl ID, Last Name, First Name, Middle Name, SSN, Admit Type, Phone, EmailEamil, Test ID, Component, Test DtDT, Data Srce, Total Score | - ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join- C CU_BIO_VW - Biographical Information View Hierarchy Join - SCC_PERS_NI_QVW - Person National ID Query View Hierarchy Join- STDNT_TEST_COMP - Student Test Components Hierarchy Join Sub query for Does Not Exist -STDNT_GRPS_HIST - Student Groups History Sub query for Does Not Exist -STDNT_TEST_COMP - Student Test Components | Michael McGovern | DenyseDenyse Ramkaran | NewNew report | GG Hotko, D Ramkaran, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi | , P, Ackerman|||||||||||||||||||
CU_BAR_AD_00006A_1DTL | Appl Math Place - M3 Only | This This query selects applicants who have taken the ACT-MATH-3 within the past two years for an Institution and Admit Term. It then determines into which math student group the applicant should be placed. This selection is for undergraduate, degree-seeking applicants. Prompt on Institution, Career, Admit Term range and Admit Type (optional). | S G, Empl ID, Last Name, First Name, Middle Name, SSN, Admit Type, Phone, EamilEmail, Test ID, Component, Test DTDt, Data Srce, Total Score | - ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join | Gary Hotko | Denyse Ramkaran | Modified report Modified to recognize students with NTMT Student Group Placement to not issue new student groups. | Hierarchy Join Sub query for Does Not Exist -STDNT_GRPS_HIST - Student Groups History Sub query for Does Not Exist -STDNT_TEST_COMP - Student Test Components | Michael McGovern | Denyse Ramkaran | New report | G G Hotko, D Ramkaran, C Keck, A Kamruzzaman, P Ackerman, T.Lodhi, P, Ackerman | |||||||||||||||
CU_BAR_AD_00006A_31 | Appl Math Place - M3 Only | This query selects applicants who have taken the ACT-MATH-3 within the past two years for an Institution and Admit Term. It then determines into which math student group the applicant should be placed. This selection is for undergraduate, degree-seeking applicants. Prompt on Institution, Career, Admit Term range and Admit Type (optional). | S G, Empl ID, Last Name, First Name, Middle Name, SSN, Admit Type, Phone, Eamil, Test ID, Test DT, Data Srce, Total Score | ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join C CU_BIO_VW - Biographical Information View Hierarchy Join SCC_PERS_NI_QVW - Person National ID Query View Hierarchy Join STDNT_TEST_COMP - Student Test Components SUB QURIES: Subquery for D.TEST_DT - Test - STDNT_TEST_COMP does not exist: STDNT_TEST_COMP - Student Test Components does not exist STDNT_TEST_COMP - Student Test Components for exists STDNT_TEST_COMP - Student Test Components for exists STDNT_TEST_COMP - Student Test Components for exists STDNT_TEST_COMP - Student Test Components | Tabassum Lodhi | Gary Hotko | Modified report
| G Hotko, D Ramkaran , P Ackerman, T. Lodh | Gary Hotko | Denyse Ramkaran | Modified report Modified to recognize students with NTMT Student Group Placement to not issue new student groups. | G Hotko, D Ramkaran, C Keck, , P Ackerman, T. Lodhi | |||||||||||||||
Appl Math Place - M3 Only | This | CU_BAR_AD_00006B_1 | Appl Math Place - M3 + Regents | This query selects applicants who have taken the Regents SMA3 or MATHB and the ACT-MATH-3 within the past two years for an Institution and Admit Term. It then determines into which math student group the applicant should be placed. This selection is for undergraduate, degree-seeking applicants. Prompt on Institution, Career, Admit Term range and Admit Type (optional). | S G, Empl ID, Last Name, First Name, Middle Name, SSN, Admit Type, Phone, Eamil, Test ID, Test DT, Data Srce, Total M3 Score, Regents, Component, Score | ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join C CU_BIO_VW - Biographical Information View Hierarchy Join SCC_PERS_NI_QVW - Person National ID Query View Hierarchy Join STDNT_TEST_COMP - Student Test Components Hierarchy JoinSTDNT_ SUB QURIES: Subquery for D.TEST_COMP DT - Student Test Components
Sub query for Does Not Exist: - STDNT_GRPS_HIST - Student Groups History Sub Query for Exist: STDNT_TEST_COMP - Student Test Components does not existSub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist:does not exist STDNT_TEST_COMP - Student Test Components Sub Query for Exist:exists STDNT_TEST_COMP - Student Test Components Sub Query for Exist:exists STDNT_TEST_COMP - Student Test Components Sub Query for J.TEST_DT - Test Date for exists STDNT_TEST_COMP - Student Test Components | Michael McGovern | Denyse Ramkaran | Tabassum Lodhi | Gary Hotko | Modified Newreport
| G Hotko, D Ramkaran , C Keck , A Kamruzzaman, P Ackerman, T. LodhiLodh | |||||||||||||||
00006B2 | Appl Math Place - M3 + RegentsOnly | This query selects applicants who have taken the Regents SMA3 or MATHB and theACT-MATH-3 and Never took ACC-MATH-6 within the past two years for an Institution and Admit Term. It then determines into which math student group the applicant should be placed. This selection is for undergraduate, degree-seeking applicants. Prompt on Institution, Career, Admit Term range and Admit Type (optional). Modified to remove M1 from Criteria and created date thru sub query to get the latest test date. | S G, Empl ID, Last Name, First Name, Middle Name, SSN, Admit Type, Phone, Eamil, Test ID, Test DT, Data Srce, Total M3 Score, Regents, Component, Score | ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join C CU_BIO_VW - Biographical Information View Hierarchy Join SCC_PERS_NI_QVW - Person National ID Query View Hierarchy Join STDNT_TEST_COMP - Student Test Components Hierarchy JoinSTDNT_ SUB QURIES: Subquery for D.TEST_COMP DT - Student Test Components
Sub query for Does Not Exist: - STDNT_GRPS_HIST - Student Groups HistoryTEST_COMP does not existSub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist:does not exist STDNT_TEST_COMP - Student Test Components Sub Query for Exist:exists STDNT_TEST_COMP - Student Test Components Sub Query for Exist:exists STDNT_TEST_COMP - Student Test Components Sub Query for Exist:exists STDNT_TEST_COMP - Student Test Components Sub Query for J.TEST_DT - Test Date STDNT_TEST_COMP - Student Test Components | Gary Hotko | Gary Hotko | Denyse Ramkaran | Modified report Modified to recognize students with NTMT Student Group Placement to not issue new student groups. | Modified report | G Hotko, D Ramkaran , C Keck, , P Ackerman , T. LodhiLodh | |||||||||||||||||
CU_BAR_AD_00006B_41 | Appl Math Place - M3 + Regents | This query selects applicants who have taken the Regents SMA3 or MATHB and the ACT-MATH-3 within the past two years for an Institution and Admit Term. It then determines into which math student group the applicant should be placed. This selection is for undergraduate, degree-seeking applicants. Prompt on Institution, Career, Admit Term range and Admit Type (optional). | S G, Empl ID, Last Name, First Name, Middle Name, SSN, Admit Type, Phone, Eamil, Test ID, Test DT, Data Srce, Total M3 Score, Regents, Component, Score | ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join SCC_PERS_NI_QVW - Person National ID Query View Hierarchy Join STDNT_TEST_COMP - Student Test Components Hierarchy Join STDNT_TEST_COMP - Student Test Components SUB QURIES: Subquery for D.TEST_DT - Test - STDNT_TEST_COMP - Student Test Components
Sub query for Does Not Exist: -STDNT_GRPS_HIST - Student Groups History Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components
Sub Query for J.TEST_DT - Test Date STDNT_TEST_COMP - Student Test Components | Tabassum Lodhi | Gary Hotko | Modified report
| Michael McGovern | Denyse Ramkaran | New report | G G Hotko, D Ramkaran, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi | ||||||||||||||||
CU_BAR_AD_00006B_DTL_12 | Appl Math Place - M3 + Regents | This query selects applicants who have taken the Regents SMA3 or MATHB and the ACT-MATH-3 within the past two years for an Institution and Admit Term. It then determines into which math student group the applicant should be placed. This selection is for undergraduate, degree-seeking applicants. Prompt on Institution, Career, Admit Term range and Admit Type (optional). | S G, Empl ID, Last Name, First Name, Middle Name, SSN, Admit Type, Phone, Eamil, Test ID, Component, Test DtDT, Data Srce, Total M3 Score, Regents, Component, Score | ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join SCC_PERS_NI_QVW - Person National ID Query View Hierarchy Join STDNT_TEST_COMP - Student Test Components Hierarchy Join STDNT_TEST_COMP - Student Test Components Hierarchy Join
Sub query for Does Not Exist: -STDNT_GRPS_HIST - Student Groups History Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for J.TEST_DT - Test Date STDNT_TEST_COMP - Student Test Components | Michael McGovernGary Hotko | Denyse Ramkaran | New report | Modified report Modified to recognize students with NTMT Student Group Placement to not issue new student groups. | G Hotko, D Ramkaran, C Keck, A Kamruzzaman , P Ackerman, T. Lodhi | ||||||||||||||||||
00007 | New Applicants by S.G. | Appl Math Place - M3 + Regents | This query selects applicants who have taken the Regents SMA3 or MATHB and the ACT-MATH-3 within the past two years for an Institution and Admit Term. It then determines into which math student group the applicant should be placed. This selection is for undergraduate, degree-seeking applicants. Prompt on | This is a list of new applicants. The list includes the emplid, name, contact information. Prompt onInstitution, Career, Admit Term | ,range and Admit Type (optional) | , Program Action (optional) and Student Group (optional). | S G, Empl ID, Last Name, First Name, Middle Name, Empl ID, Student Group, Career, Acad Prog, Prog Actn, Action Date, Admit Term, Admit Type, Last School Attended, Acad Plan, Phone, EmailSSN, Admit Type, Phone, Eamil, Test ID, Test DT, Data Srce, Total M3 Score, Regents, Component, Score | ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join - ADM_APPL_DATA - Admission Application Data Hierarchy Join - ADM_APPL_PROG - Admission Applicant Program Hierarchy Join - ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join SCC_PERS_NI_QVW - Person National ID Query View Hierarchy Join STDNT_GRPSTEST_HIST COMP - Student Groups History Test Components Hierarchy Join | Michael McGovern | Marisa Delacruz | New report | M Delacruz, M Figeroa, H Morales, A Cox, C Keck, G Hotko, D Ramkaran, P Ackerman, T. Lodhi | CU_BAR_AD_00008 | UGRD Applicants w/o M3 Exam | This is a list of new MATR UGRD applicants who have not taken the M3 exam. Prompt on Institution and Admit Term range. | Last, FirstName, Middle, ID, Career, Acad Prog, Prog Actn, Acad Plan, Action Date, Admit Term, Admit Type, Phone, Email | ADM_APPL_DATA - Admission Application Data Hierarchy Join ADM_APPL_PROG - Admission Applicant Program Hierarchy Join ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join CU_BIO_VW - Biographical Information View | Michael McGovern | Marisa Delacruz | STDNT_TEST_COMP - Student Test Components SUB QURIES: Subquery for D.TEST_DT - Test - STDNT_TEST_COMP - Student Test Components
Sub query for Does Not Exist: -STDNT_GRPS_HIST - Student Groups History Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for J.TEST_DT - Test Date STDNT_TEST_COMP - Student Test Components | Tabassum Lodhi | Gary Hotko | Modified report
| G Hotko, D Ramkaran, | M Delacruz, M Figeroa, H Morales, A Cox, C Keck, A Kamruzzaman,P Ackerman, T. Lodhi | ||
00009 | 2 | ATB UGRD/MATR Applicants | Appl Math Place - M3 + Regents | This query selects applicants who have taken the Regents SMA3 or MATHB and the ACT-MATH-3 but not ACC-MATH-6 within the past two years for an Institution and Admit Term. It then determines into which math student group the applicant should be placed. This selection is for undergraduate, degree-seeking applicants | This is a list of new MATR UGRD applicants who must sit for the Ability to Benefit (ATB) exam. Prompt on Institution | and , Career, Admit Term range and Admit Type (optional). Remove M1 from Criteria and created Test Date as sub query for find the latest test date. | S G, Empl ID, Last Name, First Name, Middle Name, Empl IDSSN, Career, Program, Action, Plan, Action Date, Admit Term, Admit Type, Phone, Email, Residency, Citizenship, High School, H S Name, H S Country, Addr Type, Address 1, Address 2, City, State, PostalAdmit Type, Phone, Eamil, Test ID, Test DT, Data Srce, Total M3 Score, Regents, Component, Score | ADM_MC_VW - Adm Appl Prog Vw for MC ADM_APPL_DATA - Admission Application Data Hierarchy Join ADM_APPL_PROG - Admission Applicant Program Hierarchy Join ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy JoinEXT SCC_PERS_ORGNI_VW - External Organization Tbl QVW - Person National ID Query View Hierarchy Join RESIDENCYSTDNT_TEST_OFF - Official Residency Data COMP - Student Test Components Hierarchy JoinEXT STDNT_ACADTEST_DATA - External Academic Data Hierarchy Join SCC_CITIZEN_QVW - Citizenship Query View Hierarchy Join CITIZEN_STS_TBL - Citizen Status Table Hierarchy Join ADDRESSES4_VW - Addresses View for Curr EffDT Hierarchy Join | Michael McGovern | Marisa Delacruz | COMP - Student Test Components SUB QURIES: Subquery for D.TEST_DT - Test - STDNT_TEST_COMP - Student Test Components
Sub query for Does Not Exist: -STDNT_GRPS_HIST - Student Groups History Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for J.TEST_DT - Test Date STDNT_TEST_COMP - Student Test Components | Gary Hotko | Gary Hotko | Modified report | G Hotko, D Ramkaran, | M Delacruz, M Figeroa, H Morales, A Kamruzzaman, C Keck, P Ackerman,T. Lodhi | |||||||||||
CU_BAR_AD_00006B_DTL_ | 00010Foreign Applicants/Citizenship | 1 | Appl Math Place - M3 + Regents | This query selects applicants who have taken the Regents SMA3 or MATHB and the ACT-MATH-3 within the past two years for an Institution and Admit Term. It then determines into which math student group the applicant should be placed. This selection is for undergraduate, degree-seeking applicants | This is a list of MATR applicants who are international. Prompt on Institution, Career, Admit Term range | ,and Admit Type (optional) | and Program Action (optional). | Empl ID, Last Name, First Name, Middle Name, IDSSN, CareerAdmit Type, Acad ProgPhone, Prog Actn, Acad Plan, Action Date, Admit Term, Admit Type, Last School Attended, Phone, Email, Home Address 1, Address 2, City, State, Postal, Country, Effective Term, Residency, Tuition Res, Visa Country, Visa Type, Visa Status, Status Date, Issue Date, Expire DateEamil, Test ID, Component, Test Dt, Data Srce, Score, Regents, Component, Score | ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join - ADM_APPL_DATA - Admission Application Data Hierarchy Join | Michael McGovern | Marisa Delacruz | T.Lodhi, P, Ackerman, C.Keck | CU_BAR_AD_00011 | New Enrolled UGRDs by Plan | This is a list of new students who are enrolled for the term (To Admit Term), sorted by plan. Prompt on Institution and Admit Term range. | Plan, Last Name, First Name, Middle Name, Empl ID, Program, Take Prgrs, Admit Term, Admit Type, Phone, Email | - ADM_APPL_DATA - Admission Application Data Hierarchy Join | Michael McGovern | Marisa Delacruz | New report. | SCC_PERS_NI_QVW - Person National ID Query View Hierarchy Join STDNT_TEST_COMP - Student Test Components Hierarchy Join STDNT_TEST_COMP - Student Test Components Hierarchy Join Sub query for Does Not Exist: -STDNT_GRPS_HIST - Student Groups History Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components
Sub Query for J.TEST_DT - Test Date STDNT_TEST_COMP - Student Test Components | Michael McGovern | Denyse Ramkaran | New report | G Hotko, D Ramkaran, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi | T.Lodhi, P, Ackerman, C.Keck||
CU_BAR_AD_00012 | Transfers and Transfer Credit | 00006C | Appl Math Place - M6 ONLY | This query selects applicants who have taken the ACC-MATH-6 within the past two years for an This is a list of new transfers who are enrolled for the term (To Admit Term), and the source of the transfer credit. Prompt onInstitution and Admit Term range.. It then determines into which math student group the applicant should be placed. This selection is for undergraduate, degree-seeking applicants. Prompt on Institution, Career, Admit Term range and Admit Type (optional). Adjusted to use new critera and tests | Empl ID, Last Last Name, First Name, Middle Name Empl ID, line#, Program, Plan, Term Units, SSN, Admit Term, Admit Type, Phone, EmailEamil, External Org, Source Institution, CUNY Inst, Transfer, Other Units, Model Status | - ADM_APPL_DATA - Admission Application Data Hierarchy Join UNION1: -ADM_APPL_DATA - Admission Application Data Hierarchy Join -ADM_APPL_PROG - Admission Applicant Program Hierarchy Join -STDNT_CAR_TERM - Student Career Term Table Hierarchy Join -NAME_CURR_VW - Current Name Vw all types Hierarchy Join -TRNS_CRSE_SCH - Student Transfer Credit School Hierarchy Join | Michael McGovern | Mildred Figueroa | New report. | Test ID, Component, Test Dt, Data Srce, M6 Score | ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join SCC_PERS_NI_QVW - Person National ID Query View Hierarchy Join STDNT_TEST_COMP - Student Test Components Hierarchy Join STDNT_TEST_COMP - Student Test Components Hierarchy Join Sub query for Does Not Exist: -STDNT_GRPS_HIST - Student Groups History Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components
Sub Query for J.TEST_DT - Test Date STDNT_TEST_COMP - Student Test Components | Gary Hotko | Gary Hotko | New Report | G Hotko, D Ramkaran, T. LodhiT.Lodhi, P, Ackerman, C.Keck | ||||||||||||
CU_BAR_AD_ | 00013New Students w/Prev Degrees | 00006D | Appl Math Place - M6 + Regents | This query selects applicants who have taken the Regents TRGCC (Alg 2/Trig Common Core) or TRIG (Algebra II/ Trigonometry, Non Common Core) and the ACC-MATH-6 but not ACT-MATH-3 within the past two years for an Institution and Admit Term. It then determines into which math student group the applicant should be placed. This selection is for undergraduate, degree-seeking applicants | This is a list of new MATR applicants who have enrolled and who have previous degrees. Prompt on Institution | and , Career, Admit Term range | .and Admit Type (optional). Adjusted to use new critera and tests | Last Name, First Name, Middle Name, Empl ID, ProgramLast Name, Plan, Term Units, Admit TermFirst Name, Middle Name, SSN, Admit Type, Phone, EmailEamil, Degree NbrTest ID, InstitutionComponent, DegreeTest Dt, Plan, Plan Description, Compl Term, Confer Dt, Hon SuffixData Srce, M6 Score, Regents, Component, Score | ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join CU_BIO_VW - Biographical Information View Hierarchy Join SCC_PERS_NI_QVW - Person National ID Query View Hierarchy Join STDNT_TEST_COMP - Student Test Components Hierarchy Join STDNT_TEST_COMP - Student Test Components Hierarchy Join Sub query for Does Not Exist: -STDNT_GRPS_HIST - Student Groups History Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components
Sub Query for J.TEST_DT - Test Date STDNT_TEST_COMP - Student Test Components | Gary Hotko | Gary Hotko | New Report | G Hotko, D Ramkaran, T. Lodhi | ||||||||||||||
CU_BAR_AD_00007 | New Applicants by S.G. | - ADM_APPL_DATA - Admission Application Data Hierarchy Join | Michael McGovern | Marisa Delacruz | New report. | T.Lodhi, P, Ackerman, C.Keck | CU_BAR_AD_00014 | New Students w/Service Ind | This is a list of new MATR applicants who have enrolled and who have service indicatorsapplicants. The list includes the emplid, name, contact information. Prompt on Institution, Career, Admit Term range and Service Indicator , Admit Type (optional)., Program Action (optional) and Student Group (optional). | Last Name, Last Name, First Name, Middle Name, Empl ID, Student Group, Career, Acad Prog, Prog Actn, Action Date, Status, Admit Term, Admit Type, SI Rsn Code, Positive?Last School Attended, Acad Plan, Phone Preferred , Email, Campus Email | - SRVCADM_INDAPPL_DATA - Service Indicator Admission Application Data Hierarchy Join - CUADM_BIO_VW - Biographical Information View Hierarchy Join - ADM_APPL_DATA PLAN - Admission Application Data Applicant Plan Hierarchy Join - SCCCU_EMAILBIO_QVW - Email Addresses Query VW - Biographical Information View Hierarchy JoinUNION 1: - SRVCSTDNT_INDGRPS_DATA - Service Indicator Data HIST - Student Groups History Hierarchy Join -CU_BIO_VW - Biographical Information View Hierarchy Join -ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join -SCC_EMAIL_QVW - Email Addresses Query View Hierarchy Join | Michael McGovern | Michael McGovern | Marisa Marisa Delacruz | New report . | M Delacruz, M Figeroa, H Morales, A Cox, C Keck, G Hotko, D Ramkaran, P Ackerman, T. LodhiT.Lodhi, P, Ackerman, C.Keck | |||||||||||
CU_BAR_AD_0001500008 | New Stdnts UGRD Applicants w/non-NY Residencyo M3 Exam | This is a list of new MATR UGRD applicants who have enrolled and who have a non-New-York (in-state, in-city) residency. Prompt on Institution and Admit Term range.not taken the M3 exam. Prompt on Institution and Admit Term range. | Last, FirstName, Middle, ID, Career, Acad Prog, Prog Actn, Acad Plan, Action DateLast Name, First Name, Middle Name, Empl ID, Program, Plan, Term Units, Admit Term, Admit Type, Phone, Email, Effective, Residency | -ADM_APPL_DATA - Admission Application Data Hierarchy Join- ADM_APPL_PROG - Admission Applicant Program Hierarchy Join -ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join- CU_BIO_VW - Biographical Information View Hierarchy Join -STDNT_CAR_TERM - Student Career Term Table Hierarchy Join | Michael McGovern | Marisa Delacruz | New report. | M Delacruz, M Figeroa, H Morales, A Cox, C Keck, A Kamruzzaman, P Ackerman, T. LodhiT.Lodhi, P, Ackerman, C.Keck | |||||||||||||||||||
CU_BAR_AD_00009_000162 | ATB UGRD/MATR Applicants"No Show" New Students | This is a list of new MATR UGRD applicants who have not enrolledmust sit for the Ability to Benefit (ATB) exam. Prompt on Institution and Admit Term range. | Last Name, First Name, Middle Name, Empl ID, Career, Program, Action, Plan, Term UnitsAction Date, Admit Term, Admit Type, Phone, Email , Email, Residency, Citizenship, High School, H S Name, H S Country, Addr Type, Address 1, Address 2, City, State, Postal | -ADM_APPL_DATA - Admission Application Data Hierarchy Join- ADM_APPL_PROG - Admission Applicant Program Hierarchy Join -ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join- CU_BIO_VW - Biographical Information View Hierarchy Join-STDNT EXT_CARORG_TERM - Student Career Term Table VW - External Organization Tbl View Hierarchy Join | Michael McGovern | Marisa Delacruz | New report. | RESIDENCY_OFF - Official Residency Data Hierarchy Join EXT_ACAD_DATA - External Academic Data Hierarchy Join SCC_CITIZEN_QVW - Citizenship Query View Hierarchy Join CITIZEN_STS_TBL - Citizen Status Table Hierarchy Join ADDRESSES4_VW - Addresses View for Curr EffDT Hierarchy Join | Michael McGovern | Marisa Delacruz | M Delacruz, M Figeroa, H Morales, A Kamruzzaman, C Keck, P Ackerman, T. LodhiT.Lodhi, P, Ackerman, C.Keck | ||||||||||||||||
CU_BAR_AD_0001700010 | Transfers w/non-Posted CreditForeign Applicants/Citizenship | This is a list of new transfers who are enrolled for the term (To Admit Term), and who have non-posted transfer creditMATR applicants who are international. Prompt on Institution and , Admit Term range, Admit Type (optional) and Program Action (optional). | Last Name, First Name, Middle Name, Empl ID, Career, line#Acad Prog, ProgramProg Actn, Acad Plan, Term UnitsAction Date, Admit Term, Admit Type, Last School Attended, Phone, Email, Source ID, Group, Term, Class#, Subject, Grade, Comp, Units, Status, Home Address 1, Address 2, City, State, Postal, Country, Effective Term, Residency, Tuition Res, Visa Country, Visa Type, Visa Status, Status Date, Issue Date, Expire Date | - ADM_APPL_DATA - Admission Application Data Hierarchy Join UNION 1: -ADM_APPL_DATA - Admission Application Data Hierarchy Join -ADM_APPL_PROG - Admission Applicant Program Hierarchy Join -STDNT_CAR_TERM - Student Career Term Table Hierarchy Join -NAME_CURR_VW - Current Name Vw all types Hierarchy Join -TRNS_CRSE_SCH - Student Transfer Credit School Hierarchy Join -TRNS_CRSE_DTL - Student Transfer Course Detail Hierarchy Join | Michael McGovern | Mildred Figueroa | New report. | VW - Addresses View for Curr EffDT Hierarchy Join | Michael McGovern | Marisa Delacruz | T.T.Lodhi, P, Ackerman, C.Keck | ||||||||||||||||
CU_BAR_AD_ | 00018_2Immunization for Applicants00011 | New Enrolled UGRDs by Plan | This is a list of | applicants and their immunization records (or lack thereof)new students who are enrolled for the term (To Admit Term), sorted by plan. Prompt on Institution | , Career,and Admit Term range. | Plan, Last Name, First Name, Middle Name, Empl ID, Admit TypeProgram, Take Prgrs, Admit Term, Program, Plan, Status, Action, Reason, Admit Type, Phone, Preferred Email, Immunization, Date Taken, Expiration Date, Status, Without Immunizations | - ADM_APPL_DATA - Admission Application Data Hierarchy Join UNION1: -ADM_APPL_DATA - Admission Application Data Hierarchy Join -ADM_APPL_PROG - Admission Applicant Program Hierarchy Join -ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join -CU_BIO_VW - Biographical Information View Hierarchy Join Sub Query for Does Not Exist: -IMMUNIZATIONS - Immunizations STDNT_CAR_TERM - Student Career Term Table Hierarchy Join | Michael McGovern | Marisa | DelacruzDelacruz | New report. | T.Lodhi, P, Ackerman, C.Keck | |||||||||||||||
M Delacruz, M Figeroa, H Morales, A Kamruzzaman, C Keck, P Ackerman, T. Lodhi | CU_BAR_AD_00019_100012 | Transfers and Transfer CreditZicklin GRAD Applicants | This is a list of Zicklin GRAD applicantsof new transfers who are enrolled for the term (To Admit Term), and the source of the transfer credit. Prompt on Institution , Career, and Admit Term range. | Last Name, First Name, Middle Name , Empl ID, Admit Type, Admit Termline#, Program, Plan, Prog Actn, Term Units, Admit Term, Admit Type, Phone, Email, External Org, Source Institution, CUNY Inst, Transfer, Other Units, Model Status | - ADM_APPL_DATA - Admission Application Data Hierarchy Join | Michael McGovern | Elaine Bernstein, Elizabeth Figini | New report | J Albanese, E Berstein, E Figini, P Davis-Friday, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi | CU_BAR_AD_00019_2 | Zick GRAD Applicants w/ DEIN | This is a list of Zicklin GRAD applicants with DEIN group. Prompt on Institution, Career, Admit Term range. | Last Name, First Name, Middle Name, Empl ID, Admit Type, Admit Term, Program, Plan, Prog Actn, Phone, Email, | - STDNT_CAR_TERM - Student Career Term Table Hierarchy Join UNION1: -- ADM_APPL_DATA - Admission Application Data Data Hierarchy Join -ADM_APPL_PROG - Admission Applicant Program Program Hierarchy Join - ADMSTDNT_APPLCAR_PLAN - Admission Applicant Plan TERM - Student Career Term Table Hierarchy Join - CUNAME_BIOCURR_VW - Biographical Information View Hierarchy Join | Tabassum Lodhi | - Current Name Vw all types Hierarchy Join -TRNS_CRSE_SCH - Student Transfer Credit School Hierarchy Join | Michael McGovern | Mildred Figueroa | New report. | T.Lodhi, P, Ackerman, C.Keck | |||||||
Kevin B. Taylor | Modified report | P Ackerman, T. Lodhi
| CU_BAR_AD_ | 0002000013 | ApplicantsNew Students w/ | Math TestsPrev Degrees | This is a list of new MATR applicants who have enrolled and who have | math testsprevious degrees. Prompt on Institution | , Career,and Admit Term range. | Last range and Admit Type (optional). Last Name, First Name, Middle Name, Empl ID, Program, Plan, Action, Action DateTerm Units, Admit Term, Admit Type, Admit Term, Phone, Email, Test ID, Component, Test Dt, Score Degree Nbr, Institution, Degree, Plan, Plan Description, Compl Term, Confer Dt, Hon Suffix | - ADM_APPL_DATA - Admission Application Data Hierarchy Join UNION 1: - ADMACAD_APPL_DATA - Admission Application Data DEGR - Student Degree Table Hierarchy Join Sub Query for Does Not Exist: -STDNT_TEST_COMP - Student Test Components | Michael McGovern | Denyse RamkaranTBL - Academic Plan Table Hierarchy Join | Michael McGovern | Marisa Delacruz | New report. | T.Lodhi, P, Ackerman, C.Keck | ||||||||||
CU_BAR_AD_ | 0002100014 | ApplicantsNew Students w/ | oService | IndicatorsInd | This is a list of new MATR applicants who | are missing promptedhave enrolled and who have service indicators | /reason codes. Prompt on Institution, | Career,Admit Term | range and Admit Typerange and Service Indicator (optional). | Last Name, First Name, Middle Name, Empl ID, ProgramAction, PlanStatus, ActionAdmit Term, Action Date, Admit Type, Admit TermSI Rsn Code, Positive?, Phone Preferred Email, EmailCampus Email | -ADMSRVC_APPLIND_DATA - Admission Application Service Indicator Data Hierarchy Join Sub Query for Does Not ExistUNION 1: - AUDIT_SRVC_IND - Audit Record - SRVC_IND_DATA_DATA - Service Indicator Data Hierarchy Join -CU_BIO_VW - Biographical Information View Hierarchy Join -ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join -SCC_EMAIL_QVW - Email Addresses Query View Hierarchy Join | Michael McGovern | Denyse RamkaranMarisa Delacruz | New | reportreport. | T.Lodhi, P, Ackerman, C.Keck | |||||||||||
CU_BAR_AD_ | 00022_2Applicants Needing MTHPL00015 | New Stdnts w/non-NY Residency | This is a list of | applicants who need the TST/MTHPL service indicator/reason codenew MATR applicants who have enrolled and who have a non-New-York (in-state, in-city) residency. Prompt on Institution | , Career,and Admit Term range | and Admit Type (optional). | Last Name, First Name, Middle Name, Empl ID, Admit Type, Admit Term, Program, Plan, ActionTerm Units, Admit Term, Admit Type, Phone, Email, Effective, Residency | -ADM_APPL_DATA - Admission Application Data Hierarchy Join Sub Query for Does Not Exist:
CAR_ HISTTERM - Student Groups HistoryCareer Term Table Hierarchy Join RESIDENCY_ TEST_COMP - Student Test Components-SRVC_IND_DATA - Service Indicator DataOFF - Official Residency Data Hierarchy Join | Michael McGovern | Denyse RamkaranMarisa Delacruz | New report. | D Ramkaran, G Hotko, C Keck, A Cox, P Ackerman, . LodhiT.Lodhi, P, Ackerman, C.Keck | |||||||||||||||
CU_BAR_AD_ | 00022_3Applicants Needing MTHPL00016 | "No Show" New Students | This is a list of new MATR applicants who | need the TST/MTHPL service indicator/reason codehave not enrolled. Prompt on Institution | , Career,and Admit Term range | and Admit Type (optional). |
Does not post indicator if student has NTMT student group Last Name, First Name, Middle Name, Empl ID, Admit TypeProgram, Plan, Term Units, Admit Term, Program, Plan, Action, Admit Type, Phone, Email,Email | -ADM_APPL_DATA - Admission Application Data Hierarchy Join CAR_ HISTTERM - Student Groups History-STDNT_TEST_COMP - Student Test Components -SRVC_IND_DATA - Service Indicator Data | Gary Hotko | Denyse Ramkaran | Modified report
Updated to take Student Group NTMT into account | D Ramkaran, G Hotko, C Keck, A Cox, P Ackerman, . LodhiCareer Term Table Hierarchy Join | Michael McGovern | Marisa Delacruz | New report. | T.Lodhi, P, Ackerman, C.Keck | |||||||||||
CU_BAR_AD_ | 0002300017 | Remove TST/MTHPLTransfers w/non-Posted Credit | This is a list of | students/applicants who have the TST/MTHPL service indicator/reason code and have a placement in a math student group as wellnew transfers who are enrolled for the term (To Admit Term), and who have non-posted transfer credit. Prompt on Institution and Admit Term range. | Last Last Name, First Name, Middle Name, Empl ID, Group Name, Email line#, Program, Plan, Term Units, Admit Term, Admit Type, Phone, Email, Source ID, Group, Term, Class#, Subject, Grade, Comp, Units, Status | -ADM_APPL_DATA - Admission Application Data -STDNT_GRPS_HIST - Student Groups History Hierarchy Join | Michael McGovern/Tabassum Lodhi | Denyse Ramkaran | New report | D Ramkaran, G Hotko, C Keck, A Cox, T.Lodhi, P, Ackerman | UNION 1: -ADM_APPL_DATA - Admission Application Data Hierarchy Join -ADM_APPL_PROG - Admission Applicant Program Hierarchy Join -STDNT_CAR_TERM - Student Career Term Table Hierarchy Join -NAME_CURR_VW - Current Name Vw all types Hierarchy Join -TRNS_CRSE_SCH - Student Transfer Credit School Hierarchy Join -TRNS_CRSE_DTL - Student Transfer Course Detail Hierarchy Join | Michael McGovern | Mildred Figueroa | New report. | T.Lodhi, P, Ackerman, C.Keck | ||||||||||||
CU_BAR_AD_00018_2 | Immunization for Applicants | CU_BAR_AD_00024_2 | Applicants Needing TST/WRITE | This is a list of applicants who need the TST/WRITE service indicator/reason codeand their immunization records (or lack thereof). Prompt on Institution, Career, Admit Term range and Admit Type (optional). | Last Name, First Name, Middle Name, Empl ID, Admit Type, Admit Term, Program, Plan, Status, Action, Reason, Phone, Preferred Email, Immunization, Date Taken, Expiration Date, Status, Without Immunizations | - ADM_APPL_DATA - Admission Application Data Hierarchy Join - ADM_APPL_PROG - Admission Applicant Program Hierarchy Join - ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join - IMMUNIZATIONS - Immunizations Hierarchy Join UNION1Sub Query for Does Not Exist: -STDNTADM_GRPSAPPL_HIST - Student Groups History DATA - Admission Application Data Hierarchy Join -STDNTADM_TESTAPPL_COMP - Student Test ComponentsPROG - Admission Applicant Program Hierarchy Join -SRVCADM_INDAPPL_DATA - Service Indicator Data PLAN - Admission Applicant Plan Hierarchy Join -STDNTCU_TEST_COMP - Student Test ComponentsBIO_VW - Biographical Information View Hierarchy Join Sub Query for Does Not Exist: -IMMUNIZATIONS - Immunizations | Michael McGovern | Denyse RamkaranMarisa Delacruz | New reportreport | G Hotko, D RamkaranM Delacruz, M Figeroa, H Morales, A Kamruzzaman, C Keck, P Ackerman, T. Lodhi | |||||||||||||||||
CU_BAR_AD_0002500019_1 | Zicklin GRAD Applicants Needing TST/READ | This is a list of applicants who need the TST/READ service indicator/reason codeZicklin GRAD applicants. Prompt on Institution, Career, Admit Term range and Admit Type (optional). | Last Name, First Name, Middle Name, Empl ID, Admit Type, Admit Term, Program, Plan, ActionProg Actn, Phone, Email, | - ADM_APPL_DATA - Admission Application Data Hierarchy Join - ADM_APPL_PROG - Admission Applicant Program Hierarchy Join - ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join - CU_BIO_VW - Biographical Information View Sub Query for Does Not Exist: -STDNT_GRPS_HIST - Student Groups History Hierarchy Join -STDNT_TEST_COMP - Student Test Components -SRVC_IND_DATA - Service Indicator Data Hierarchy Join-STDNT_TEST_COMP - Student Test Components | Michael McGovernDenyse Ramkaran | Elaine Bernstein, Elizabeth Figini | New reportreport | J Albanese, E Berstein, E Figini, P Davis-Friday, C Keck, A KamruzzamanG Hotko, D Ramkaran, P Ackerman, T Lodhi. Lodhi | |||||||||||||||||||
CU_BAR_AD_00019_000262 | Applicants Needing ADIDZick GRAD Applicants w/ DEIN | This is a pre-orientation query to create a list of students needing ADIDs and email ids | ID, Career, Admit Term, SSN, Last, First Name, Birthdate | ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join SCC_PERS_NI_QVW - Person National ID Query View Hierarchy Join NAME_CURR_VW - Current Name Vw all types Hierarchy Join PERSONAL_DATA - PERSONAL_DATA for Rpting left outer joined with C Hierarchy Join | Dixon Berry | Patrick Ackerman | New Report | Zicklin GRAD applicants with DEIN group. Prompt on Institution, Career, Admit Term range. | Last Name, First Name, Middle Name, Empl ID, Admit Type, Admit Term, Program, Plan, Prog Actn, Phone, Email, | - ADM_APPL_DATA - Admission Application Data Hierarchy Join - ADM_APPL_PROG - Admission Applicant Program Hierarchy Join - ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join | Tabassum Lodhi | Kevin B. Taylor | Modified report | P PAckerman, T. Lodhi
| |||||||||||||
CU_BAR_AD_00026_200020 | Applicants Needing ADIDw/Math Tests | This is a pre-orientation query to create a list of students needing ADIDs and email ids; Requires NPI access.IDnew applicants who have math tests. Prompt on Institution, Career, Admit Term , SSN, Last, First Name, Birthdate | ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join SCC_PERS_NI_QVW - Person National ID Query View Hierarchy Join NAME_CURR_VW - Current Name Vw all types Hierarchy Join CU_R901_BIO - View for Biographical Info Hierarchy Join | Abu Kamruzzaman | Patrick Ackerman | Modified Report | Dixon Berry, P Ackerman, T Lodhi | ||||||||||||||||||||
CU_BAR_AD_0026_4 | GRAD applicants needing ADID | This is grad student with MATR in ADM_APPL | ID, Career, Admit Term, SSN, Last, First Name, Birthdate | ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join SCC_PERS_NI_QVW - Person National ID Query View Hierarchy Join NAME_CURR_VW - Current Name Vw all types Hierarchy Join PERSONAL_DATA - PERSONAL_DATA for Rpting Hierarchy Join | Dixon Berry | Patrick Ackerman | New report | Dixon Berry, Abu K. Patrick A., T Lodhi | |||||||||||||||||||
CU_BAR_AD_00026_5 | Undergrad Applicants Needing ADID | Query to create a list of for undergraduate applicants needing ADIDs and email ids from ADM_APP, includes NID or LID and indicate external system ID identifier; Requires NPI access. Dixon added phone for Orientation need. | Last, First Name, Middle, Empl ID, Career, Admit Term, SSN, Prog Actn, Admit Type, Birthdate, ' ' | - ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join - SCC_PERS_NI_QVW - Person National ID Query View Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join -PERSNL_FERPA_VW - FERPA Personal Data View Hierarchy Join UNION 1: -ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join -CU_BIO_VW - Biographical Information View Hierarchy Join -PERSNL_FERPA_VW - FERPA Personal Data View Hierarchy Join -EXTERNAL_SYSTEM - External System ID's Hierarchy Join Sub Query for Does Not Exist:
-SCC_PERS_NI_QVW - Person National ID Query View Sub Query for Exist:
-SCC_PERS_NI_QVW - Person National ID Query View | Dixon Berry | Patrick Ackerman | Modified Report | P Ackerman, T Lodhi | |||||||||||||||||||
CU_BAR_AD_00027 | Remove TST/WRITE | This is a list of students/applicants who have the TST/WRITE service indicator/reason code and have a placement in an English student group as well. Prompt on Institution. |
| Michael McGovern | Denyse Ramkaran | New report | G Hotko, D Ramkaran | ||||||||||||||||||||
range and Admit Type (optional). | Last Name, First Name, Middle Name, Empl ID, Program, Plan, Action, Action Date, Admit Type, Admit Term, Phone, Email, Test ID, Component, Test Dt, Score | -ADM_APPL_DATA - Admission Application Data Hierarchy Join -STDNT_TEST_COMP - Student Test Components Hierarchy Join UNION 1: - ADM_APPL_DATA - Admission Application Data Hierarchy Join - ADM_APPL_PROG - Admission Applicant Program Hierarchy Join - ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join Sub Query for Does Not Exist: -STDNT_TEST_COMP - Student Test Components | Michael McGovern | Denyse Ramkaran | New report. | T.Lodhi, P, Ackerman, C.Keck | |||||||||||||||||||||
CU_BAR_AD_00021 | Applicants w/o Service Indicators | This is a list of new applicants who are missing prompted service indicators/reason codes. Prompt on Institution, Career, Admit Term range and Admit Type (optional). | Last Name, First Name, Middle Name, Empl ID, Program, Plan, Action, Action Date, Admit Type, Admit Term, Phone, Email | -ADM_APPL_DATA - Admission Application Data Hierarchy Join Sub Query for Does Not Exist: -AUDIT_SRVC_IND - Audit Record - SRVC_IND_DATA | Michael McGovern | Denyse Ramkaran | New report | T.Lodhi, P, Ackerman, C.Keck | |||||||||||||||||||
CU_BAR_AD_00022_2 | Applicants Needing MTHPL | This is a list of applicants who need the TST/MTHPL service indicator/reason code. Prompt on Institution, Career, Admit Term range and Admit Type (optional). | Last Name, First Name, Middle Name, Empl ID, Admit Type, Admit Term, Program, Plan, Action, Phone, Email, | - ADM_APPL_DATA - Admission Application Data Hierarchy Join - ADM_APPL_PROG - Admission Applicant Program Hierarchy Join - ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join Sub Query for Does Not Exist: -STDNT_GRPS_HIST - Student Groups History -STDNT_TEST_COMP - Student Test Components -SRVC_IND_DATA - Service Indicator Data | CU_BAR_AD_00028 | Remove TST/READ | This is a list of students/applicants who have the TST/READ service indicator/reason code and have a placement in an English student group as well. Prompt on Institution | | Michael McGovern | Denyse Ramkaran | New report | CU_BAR_AD_00029_1 | . | D Ramkaran, G Hotko, C Keck, A Cox, P Ackerman, . Lodhi | |||||||||||||
CU_BAR_AD_00022_3 | Applicants Needing MTHPLMultiple Math Placements | This is a list of students who have multiple math placements.applicants who need the TST/MTHPL service indicator/reason code. Prompt on Institution, Career, Admit Term range and Admit Type (optional).
Does not post indicator if student has NTMT student group | Last Last Name, First Name, Middle Name, Empl ID, Institution, Group Name, Group Name, NID , Admit Type, Admit Term, Program, Plan, Action, Phone, Email, | - ADM_APPL_DATA - Admission Application Data - STDNT_GRPS_HIST - Student Groups History Hierarchy Join - STDNTADM_GRPSAPPL_HIST - Student Groups History PROG - Admission Applicant Program Hierarchy Join - SCCADM_PERSAPPL_NI_QVW - Person National ID Query View PLAN - Admission Applicant Plan Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join Michael McGovernSub Query for Does Not Exist: -STDNT_GRPS_HIST - Student Groups History -STDNT_TEST_COMP - Student Test Components -SRVC_IND_DATA - Service Indicator Data | Gary Hotko | Denyse Ramkaran | New report | Modified report
Updated to take Student Group NTMT into account | G Hotko, D Ramkaran, G Hotko, C Keck, A Cox, P Ackerman, T . Lodhi | ||||||||||||||||||
CU_BAR_AD_00030_100023 | Remove Applicants Needing TST/MATHMTHPL | This is a list of students/applicants who need have the TST/MATH MTHPL service indicator/reason codecode and have a placement in a math student group as well. Prompt on Institution, Career, Admit Term range and Admit Type (optional).. | Last Last Name, First Name, Middle Name, Empl ID, Admit Type, Admit Term, Program, Plan, Action, Phone, EmailGroup Name, Email | -STDNT_GRPS_HIST - Student Groups History Hierarchy Join - ADM_APPL_DATA - Admission Application Data Hierarchy Join - ADM_APPL_PROG - Admission Applicant Program Hierarchy Join - ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join Sub Query for Does Not Exist: -STDNT_GRPS_HIST - Student Groups History Hierarchy Join -STDNT_TEST_COMP - Student Test Components -STDNT_TEST_COMP - Student Test Components | Abu Kamruzzaman | Gary Hotko | New report | Michael McGovern/Tabassum Lodhi | Denyse Ramkaran | New report | D Ramkaran, G Hotko, C Keck, A Cox, T.Lodhi, P, Ackerman | ||||||||||||||||
CU_BAR_AD_0003100024_2 | Applicants Needing TST/SKILLWRITE | This is a list of applicants who need the TST/SKILL WRITE service indicator/reason code. Prompt on Institution, Career, Admit Term range and Admit Type (optional). | Last Name, First Name, Middle Name, Empl ID, Admit Type, Admit Term, Program, Plan, Action, Phone, Email, | -ADM_APPL_DATA - Admission Application Data Hierarchy Join- ADM_APPL_PROG - Admission Applicant Program Hierarchy Join -ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join- CU_BIO_VW - Biographical Information View Hierarchy Join Sub Query for Does Not Exist: -STDNT_GRPS_HIST - Student Groups History Hierarchy Join -STDNT_TEST_COMP - Student Test Components -SRVC_IND_DATA - Service Indicator Data Hierarchy Join -STDNT_TEST_COMP - Student Test Components | Michael McGovern/Tabassum Lodhi | Denyse RamkaranGary Hotko | New report. | G Hotko, D Ramkaran, P Ackerman, T Lodhi | |||||||||||||||||||
CU_BAR_AD_0003100025_1 | Applicants Needing TST/SKILLREAD | This is a list of applicants who need the TST/SKILL READ service indicator/reason code with any of math, read or write exemption or fail any of CUNY final of math, read, or write tests. Prompt on Institution, Career, Admit Term range and Admit Type (optional). | Last Name, First Name, Middle Name, Empl ID, Admit Type, Admit Term, Program, Plan, Action, Phone, Email, | -ADM_APPL_DATA - Admission Application Data Hierarchy Join -ADM_APPL_PROG - Admission Applicant Program Hierarchy Join -ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join -CU_BIO_VW - Biographical Information View Hierarchy Join Sub Query for Does Not Exist: -SRVCSTDNT_INDGRPS_DATA - Service Indicator Data HIST - Student Groups History Hierarchy Join -STDNT_TEST_COMP - Student Test Components -STDNTSRVC_TESTIND_COMP - Student Test Components Sub Query for Exist: DATA - Service Indicator Data Hierarchy Join -STDNT_TEST_COMP - Student Test Components UNION 1: -ADM_APPL_DATA - Admission Application Data Hierarchy Join -ADM_APPL_PROG - Admission Applicant Program Hierarchy Join -ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join -CU_BIO_VW - Biographical Information View Hierarchy Join Sub Query for Does Not Exist: -SRVC_IND_DATA - Service Indicator Data Hierarchy Join -STDNT_TEST_COMP - Student Test Components -STDNT_TEST_COMP - Student Test Components Sub Query for Exist: -STDNT_TEST_COMP - Student Test Components UNION 2: -ADM_APPL_DATA - Admission Application Data Hierarchy Join -ADM_APPL_PROG - Admission Applicant Program Hierarchy Join -ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join -CU_BIO_VW - Biographical Information View Hierarchy Join Sub Query for Does Not Exist: -SRVC_IND_DATA - Service Indicator Data Hierarchy Join -STDNT_TEST_COMP - Student Test Components -STDNT_TEST_COMP - Student Test Components Sub Query for Exist: -STDNT_TEST_COMP - Student Test Components | Tabassum Lodhi/Gary Hotko | Gary HotKo | New Report | Michael McGovern | Denyse Ramkaran | New report | G Hotko, D Ramkaran, P Ackerman, T Lodhi | ||||||||||||||||
CU_BAR_AD_00026 | Applicants Needing ADID | This is a pre-orientation query to create a list of students needing ADIDs and email ids | ID, Career, Admit Term, SSN, Last, First Name, Birthdate | ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join SCC_PERS_NI_QVW - Person National ID Query View Hierarchy Join NAME_CURR_VW - Current Name Vw all types Hierarchy Join PERSONAL_DATA - PERSONAL_DATA for Rpting left outer joined with C Hierarchy Join | Dixon Berry | Patrick Ackerman | New Report | P Ackerman, T. Lodhi | |||||||||||||||||||
CU_BAR_AD_00026_2 | Applicants Needing ADID | This is a pre-orientation query to create a list of students needing ADIDs and email ids; Requires NPI access. | ID, Career, Admit Term, SSN, Last, First Name, Birthdate | ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join SCC_PERS_NI_QVW - Person National ID Query View Hierarchy Join NAME_CURR_VW - Current Name Vw all types Hierarchy Join CU_R901_BIO - View for Biographical Info Hierarchy Join | Abu Kamruzzaman | Patrick Ackerman | Modified Report | Dixon BerryG Hotko, P Ackerman, T Lodhi | |||||||||||||||||||
CU_BAR_AD_0026_00032 | Applicants missing National ID | Students missing National ID and displaying LID or blanks | 4 | GRAD applicants needing ADID | This is grad student with MATR in ADM_APPL | Last Name, First Name, Middle Name, Empl ID, Career, Admit Term, SSN, Prog Actn, Admit TypeLast, First Name, Birthdate, Full LID, Group Name | Query Requires NPI - SCC_PERS_NI_QVW - Person National ID Query View Hierarchy Join- CU NAME_BIOCURR_VW - Biographical Information View Current Name Vw all types Hierarchy Join - PERSNL_FERPA_VW - FERPA Personal Data View Hierarchy Join - EXTERNAL_SYSTEM - External System ID's Hierarchy Join - STDNT_GRPS - Student Groups Hierarchy Join | Abu Kamruzzaman | PERSONAL_DATA - PERSONAL_DATA for Rpting Hierarchy Join | Dixon Berry | Patrick Ackerman | New report. | Dixon Berry, Abu K. Patrick A., T LodhiQuery Requires NPI C Keck, M Figueroa, M DeLacruz, H Morales, A Rodriguez, T Nesdill, M Elbulok, P Ackerman, T Lodhi, M McGovern | ||||||||||||||
CU_BAR_AD_00026_00033 | Grad Applicant Data | This query selects applicants by program. Prompt on Institution, Career, Program and Admit Term range. | 5 | Undergrad Applicants Needing ADID | Query to create a list of for undergraduate applicants needing ADIDs and email ids from ADM_APP, includes NID or LID and indicate external system ID identifier; Requires NPI access. Dixon added phone for Orientation need. | LastLast Name, First Name, Middle Name, Empl ID, GenderCareer, Approved LoadAdmit Term, ActionSSN, Eff Date, Program, Plan, Sub-Plan, Preferred Phone, Home Address 1, Home Address 2, City, State, Postal, Country, Preferred Email, USA Visa, Other Country, Other Visa, Mil Status, EthnicityProg Actn, Admit Type, Birthdate, ' ' | - ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join - ADMSCC_APPL_PLAN - Admission Applicant Plan Hierarchy Join- ADM_APPL_SBPLAN - Admission Applicant Subplan PERS_NI_QVW - Person National ID Query View Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join - SFPERSNL_STDNTFERPA_PRS_VW - SF Student FERPA Personal Data View Hierarchy Join UNION 1: - ADDRESSES4ADM_MC_VW - Addresses View for Curr EffDT Adm Appl Prog Vw for MC Hierarchy Join - CITIZENCU_STSBIO_TBL - Citizen Status Table VW - Biographical Information View Hierarchy Join - CITIZENPERSNL_STSFERPA_TBL - Citizen Status Table VW - FERPA Personal Data View Hierarchy Join - SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy JoinEXTERNAL_SYSTEM - External System ID's Hierarchy Join Sub Query for Does Not Exist:
-SCC_ ETHPERS_ GRPNI_ VW - Ethnic Diversity Hierarchy JoinQVW - Person National ID Query View Sub Query for Exist:
- 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_CITIZEN_QVW - Citizenship Query View Hierarchy Join -PERS_DATA_US_VW - Extension of PERSON for USA Hierarchy Join
| Michael McGovern | Sarah Godwin | New report. | S Godwin, M Sultana, S Fajardo, D Battista, J Lee, C Keck, A Kamruzzaman, M Elbulok, T Nesdill, P Ackerman, T. Lodhi | PERS_NI_QVW - Person National ID Query View | Dixon Berry | Patrick Ackerman | Modified Report | P Ackerman, T Lodhi | |||||||||||
CU_BAR_AD_00027 | Remove TST/WRITE | This is a list of students/applicants who have the TST/WRITE service indicator/reason code and have a placement in an English student group as well. Prompt on Institution. | CU_BAR_AD_00034 | Applicants in DEIN group |
| Abu Kamruzzaman | Michael McGovern | Denyse RamkaranPatrick Ackerman | New report | G Hotko, D Ramkaran | |||||||||||||||||
CU_BAR_AD_0003500028 | Remove TST/READ | This is a list of students/applicants who have the TST/READ service indicator/reason code and have a placement in an English student group as well. Prompt on Institution | Michael McGovern | Denyse Ramkaran | New report | ||||||||||||||||||||||
CU_BAR_AD_00029_1 | Multiple Math Placements | This is a list of students who have multiple math placements. | Last | Failed Tests/SEEK Applicants | This query lists Baruch undergraduate applicants who are in the SEEK student group and who have taken but not passed the M1, M2, CATW or CNY-READING exams. Prompt on the Admit Term range. | Last Name, First Name, Middle Name, Empl ID, Admit TypeInstitution, PhoneGroup Name, EmailGroup Name, FailedNID | - ADMSTDNT_MCGRPS_VW - Adm Appl Prog Vw for MC HIST - Student Groups History Hierarchy Join - STDNT_GRPS_HIST - Student Groups History Hierarchy Join - CUSCC_BIO_VW - Biographical Information View Hierarchy Join Sub Query for Does Not Exist: -STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components UNION1: -ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join PERS_NI_QVW - Person National ID Query View Hierarchy Join - CU_BIO_VW - Biographical Information ViewView Hierarchy Join | Michael McGovern | Gary Hotko | New report | G Hotko, D Ramkaran, C Keck, A Cox, P Ackerman, T Lodhi | ||||||||||||||||
CU_BAR_AD_00030_1 | Applicants Needing TST/MATH | This is a list of applicants who need the TST/MATH service indicator/reason code. Prompt on Institution, Career, Admit Term range and Admit Type (optional). | Last Name, First Name, Middle Name, Empl ID, Admit Type, Admit Term, Program, Plan, Action, Phone, Email | - ADM_APPL_DATA - Admission Application Data Hierarchy Join - ADM_APPL_PROG - Admission Applicant Program Hierarchy Join - ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join -STDNT_GRPS_HIST - Student Groups History Hierarchy Join UNION2: -ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join -CU_BIO_VW - Biographical Information View Hierarchy Join -STDNT_GRPS_HIST - Student Groups History Hierarchy Join Sub Query for Does Not Exist: -STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components UNION3: -ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join - CU_BIO_VW - Biographical Information ViewView Hierarchy Join Sub Query for Does Not Exist: -STDNT_GRPS_HIST - Student Groups HistoryHistory Hierarchy Join Sub Query for Does Not Exist:-STDNT_TEST_COMP - Student Test Components Sub Query for Exist: -SRVC_IND_DATA - Service Indicator Data Hierarchy Join -STDNT_TEST_COMP - Student Test Components | Michael McGovern | Abu Kamruzzaman | Gary HotkoDavid Rosen | New report | M Morales, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi | ||||||||||||||||||
CU_BAR_AD_0003600031 | Missing Tests/SEEK Applicants | Applicants Needing TST/SKILL | This is a list of applicants who need the TST/SKILL service indicator/reason code. Prompt on Institution, Career, Admit Term range and Admit Type (optional)This query lists Baruch undergraduate applicants who are in the SEEK student group and who have not taken the M1, M2, CATW or CNY-READING exams. Prompt on the Admit Term range. | Last Name, First Name, Middle NamName, Empl ID, Admit Type, Admit Term, Program, Plan, Action, Phone, Email, What's Missing | -ADM_MCAPPL_VW - Adm Appl Prog Vw for MC DATA - Admission Application Data Hierarchy Join Sub Query for Does Not Exist: -STDNT_TEST_COMP - Student Test Components UNION1: - ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join - STDNT_GRPS_HIST - Student Groups History Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join Sub Query for Does Not Exist: -STDNT_TEST_COMP - Student Test ComponentsUNION2: - ADMSRVC_MCIND_VW - Adm Appl Prog Vw for MC DATA - Service Indicator Data Hierarchy Join -STDNT_GRPSTEST_HIST COMP - Student Groups History Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join Sub Query for Does Not Exist: -STDNT_TEST_COMP - Student Test Components UNION3:- ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join - STDNT_GRPS_HIST - Student Groups History Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join Sub Query for Does Not Exist: -STDNT_TEST_COMP - Student Test Components | Michael McGovern | David Rosen | New report | Test Components | Michael McGovern/Tabassum Lodhi | Gary Hotko | New report. | G HotkoM Morales, C Keck, A Kamruzzaman, P Ackerman, T . Lodhi | ||||||||||||||
CU_BAR_AD_0003700031_21 | Applicants Needing TST/SKILLOrientation for Transfers | This is a list of transfer applicants in ADMT, DEIN, MATR or WADM status, not in TROR student group but in a math placement or NTMT student groupapplicants who need the TST/SKILL service indicator/reason code with any of math, read or write exemption or fail any of CUNY final of math, read, or write tests. Prompt on Institution, Admit Term range. Career, Admit Term range and Admit Type (optional). | Last Name, First Name, Middle Name, Empl ID, Admit Type, Prog ActnAdmit Term, PhoneProgram, Preferred EmailPlan, Group Name, Mail Address 1, Mail Address 2, City, State, Postal, Country Action, Phone, Email | -ADM_MCAPPL_VW - Adm Appl Prog Vw for MC DATA - Admission Application Data Hierarchy Join - CUADM_BIOAPPL_VW - Biographical Information View PROG - Admission Applicant Program Hierarchy Join - STDNTADM_GRPSAPPL_HIST - Student Groups History PLAN - Admission Applicant Plan Hierarchy Join - ADDRESSES4CU_BIO_VW - Addresses Biographical Information View for Curr EffDT Hierarchy Join Sub Query for Does Not Exist: - STDNTSRVC_GRPSIND_HIST - Student Groups History DATA - Service Indicator Data Hierarchy Join | Michael McGovern | Marisa Delacruz | New report | M Delacruz, M Figeroa, H Morales, M Elbulok, C Keck, T Nesdill, A Rodriguez, A Kamruzzaman, P Ackerman, T. Lodhi | -STDNT_TEST_COMP - Student Test Components -STDNT_TEST_COMP - Student Test Components Sub Query for Exist: -STDNT_TEST_COMP - Student Test Components UNION 1: -ADM_APPL_DATA - Admission Application Data Hierarchy Join -ADM_APPL_PROG - Admission Applicant Program Hierarchy Join -ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join -CU_BIO_VW - Biographical Information View | CU_BAR_AD_00038 | Orientation for Freshmen | This is a list of applicants in DEIN, MATR or WADM status, not in FROR student group but in a math or English placement student group. Also, they are not in student groups SEEK, SCD1, SCD3, BSCO, BSCH, MHC, MHO, CPIN or FRDF. Prompt on Institution, Admit Term range. | Last Name, First Name, Middle Name, Empl ID, Admit Type, Phone, Preferred Email, Group Name, Address 1, Address 2, City, State, Postal, Country | - ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join - STDNT_GRPS_HIST - Student Groups History Hierarchy Join - ADDRESSES4_VW - Addresses View for Curr EffDT Hierarchy Join Sub Query for Does Not Exist: - STDNTSRVC_GRPSIND_HIST - Student Groups History DATA - Service Indicator Data Hierarchy Join | Michael McGovern | Hugo Morales | New report | M Delacruz, M Figeroa, H Morales, M Elbulok, C Keck, T Nesdill, A Rodriguez, A Kamruzzaman, P Ackerman, T. Lodhi | |||||||||
CU_BAR_AD_00039 | SPA Grad Applicant Count | This query totals all SPA grad applicants (MPA, MSED, ADVCT programs) by their program, action and admit term. Prompt on Institution and Admit Term range | Program, Action, Admit Term, Count of Students | ADM_MC_VW - Adm Appl Prog Vw for MC | Michael McGovern | Sarah Godwin | New report | S Godwin, M Sultana, S Fajardo, D Battista, J Lee, C Keck, A Kamruzzaman, M Elbulok, T Nesdill, P Ackerman, T. Lodhi | |||||||||||||||||||
-STDNT_TEST_COMP - Student Test Components -STDNT_TEST_COMP - Student Test Components Sub Query for Exist: -STDNT_TEST_COMP - Student Test Components UNION 2: -ADM_APPL_DATA - Admission Application Data Hierarchy Join -ADM_APPL_PROG - Admission Applicant Program Hierarchy Join -ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join -CU_BIO_VW - Biographical Information View Hierarchy Join Sub Query for Does Not Exist: -SRVC_IND_DATA - Service Indicator Data Hierarchy Join -STDNT_TEST_COMP - Student Test Components -STDNT_TEST_COMP - Student Test Components Sub Query for Exist: -STDNT_TEST_COMP - Student Test Components | Tabassum Lodhi/Gary Hotko | Gary HotKo | New Report | G Hotko, P Ackerman, T Lodhi | |||||||||||||||||||||||
CU_BAR_AD_00032 | Applicants missing National ID | Students missing National ID and displaying LID or blanks | Last Name, First Name, Middle Name, Empl ID, Career, Admit Term, Prog Actn, Admit Type, Birthdate, Full LID, Group Name | Query Requires NPI | CU_BAR_AD_00039_DTL | SPA Grad Applicant Count | This query totals all SPA grad applicants Detail (MPA, MSED, ADVCT programs) by their program, action and admit term. Prompt on Institution and Admit Term range | Program, Action, Admit Term, ID, First Name, Middle, Last Name, Email, Phone | ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join - SCC_PERS_NI_QVW - Person National ID Query View Hierarchy Join - CU_BIO_VW - Biographical Information View | Michael McGovern | Sarah Godwin | Modified report | Hierarchy Join - PERSNL_FERPA_VW - FERPA Personal Data View Hierarchy Join - EXTERNAL_SYSTEM - External System ID's Hierarchy Join - STDNT_GRPS - Student Groups Hierarchy Join | Abu Kamruzzaman | Patrick Ackerman | New report. | Query Requires NPI C Keck, M Figueroa, M DeLacruz, H Morales, A Rodriguez, T Nesdill, M ElbulokS Godwin, M Sultana, S Fajardo, D Battista, P Ackerman, T . Lodhi, Young J. HahM McGovern | ||||||||||
CU_BAR_AD_00040 | Freshmen Appicants | 00033 | Grad Applicant Data | This query selects applicants by programThis is a list of new freshman applicants with SAT data, ethnicity, gender, etc. Prompt on Institution, Career, Program and Admit Term range. | Last Name, First Name, Middle Name, Empl ID, Gender, SexApproved Load, Action, ReasonEff Date, Program, Plan, Sub-Plan, Preferred Phone, Email, Country, Address Home Address 1, Home Address 2, City, State, Postal, Lst School, Grad Dt, HS Name, Country, Preferred Email, USA Visa, Other Country, Other Visa, Mil Status, Ethnicity | - ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join - ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join - ADM_APPL_SBPLAN - Admission Applicant Subplan Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join - SF_STDNT_PRS_VW - SF Student Personal Data View Hierarchy Join - ADDRESSES4_VW - Addresses View for Curr EffDT Hierarchy Join - EXTCITIZEN_ORGSTS_VW - External Organization Tbl View TBL - Citizen Status Table Hierarchy Join - ADMCITIZEN_APPLSTS_PLAN - Admission Applicant Plan TBL - Citizen Status 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 | Michael McGovern | Hugo Morales, Dana Messinger | New report | - Ethnic Diversity Hierarchy Join - SCC_CITIZEN_QVW - Citizenship Query View Hierarchy Join -PERS_DATA_US_VW - Extension of PERSON for USA Hierarchy Join
| Michael McGovern | Sarah Godwin | New report. | S Godwin, M Sultana, S Fajardo, D Battista, J Lee, C Keck, A Kamruzzaman, M Elbulok, T Nesdill, P Ackerman, T. Lodhi | |||||||||||||
CU_BAR_AD_00034 | Applicants in DEIN group | Abu Kamruzzaman | Patrick Ackerman | New report | |||||||||||||||||||||||
CU_BAR_AD_00035 | Failed Tests/SEEK Applicants | This query lists Baruch undergraduate applicants who are in the SEEK student group and who have taken but not passed the M1, M2, CATW or CNY-READING exams. Prompt on the Admit Term range. | Last Name, First Name, Middle Name, Empl ID, Admit Type, Phone, Email, Failed | - ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join - STDNT_GRPS_HIST - Student Groups History Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join Sub Query for Does Not Exist: -STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components UNION1: -ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join -CU_BIO_VW - Biographical Information View Hierarchy Join -STDNT_GRPS_HIST - Student Groups History Hierarchy Join UNION2: -ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join -CU_BIO_VW - Biographical Information View Hierarchy Join -STDNT_GRPS_HIST - Student Groups History Hierarchy Join Sub Query for Does Not Exist: -STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components UNION3: -ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join -CU_BIO_VW - Biographical Information View Hierarchy Join -STDNT_GRPS_HIST - Student Groups History Hierarchy Join Sub Query for Does Not Exist: -STDNT_TEST_COMP - Student Test Components Sub Query for Exist: STDNT_TEST_COMP - Student Test Components | Michael McGovern | David Rosen | New report | M Morales, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi | |||||||||||||||||||
CU_BAR_AD_00036 | Missing Tests/SEEK Applicants | This query lists Baruch undergraduate applicants who are in the SEEK student group and who have not taken the M1, M2, CATW or CNY-READING exams. Prompt on the Admit Term range. | Last Name, First Name, Middle Nam, Empl ID, Admit Type, Phone, Email, What's Missing | - ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join - STDNT_GRPS_HIST - Student Groups History Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join Sub Query for Does Not Exist: -STDNT_TEST_COMP - Student Test Components UNION1: - ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join - STDNT_GRPS_HIST - Student Groups History Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join Sub Query for Does Not Exist: -STDNT_TEST_COMP - Student Test Components
- ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join - STDNT_GRPS_HIST - Student Groups History Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join Sub Query for Does Not Exist: -STDNT_TEST_COMP - Student Test Components
- ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join - STDNT_GRPS_HIST - Student Groups History Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join Sub Query for Does Not Exist: -STDNT_TEST_COMP - Student Test Components | Michael McGovern | David Rosen | New report | M Morales, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi | |||||||||||||||||||
CU_BAR_AD_00037_2 | Orientation for Transfers | This is a list of transfer applicants in ADMT, DEIN, MATR or WADM status, not in TROR student group but in a math placement or NTMT student group. Prompt on Institution, Admit Term range. | Last Name, First Name, Middle Name, Empl ID, Admit Type, Prog Actn, Phone, Preferred Email, Group Name, Mail Address 1, Mail Address 2, City, State, Postal, Country | - ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join - STDNT_GRPS_HIST - Student Groups History Hierarchy Join - ADDRESSES4_VW - Addresses View for Curr EffDT Hierarchy Join Sub Query for Does Not Exist: - STDNT_GRPS_HIST - Student Groups History Hierarchy Join | Michael McGovern | Marisa Delacruz | New report | M Delacruz, M Figeroa, H Morales, M Elbulok, C Keck, T Nesdill, A Rodriguez, A Kamruzzaman, P Ackerman, T. Lodhi | |||||||||||||||||||
CU_BAR_AD_00038 | Orientation for Freshmen | This is a list of applicants in DEIN, MATR or WADM status, not in FROR student group but in a math or English placement student group. Also, they are not in student groups SEEK, SCD1, SCD3, BSCO, BSCH, MHC, MHO, CPIN or FRDF. Prompt on Institution, Admit Term range. | Last Name, First Name, Middle Name, Empl ID, Admit Type, Phone, Preferred Email, Group Name, Address 1, Address 2, City, State, Postal, Country | - ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join - STDNT_GRPS_HIST - Student Groups History Hierarchy Join - ADDRESSES4_VW - Addresses View for Curr EffDT Hierarchy Join Sub Query for Does Not Exist: - STDNT_GRPS_HIST - Student Groups History Hierarchy Join | Michael McGovern | Hugo Morales | New report | M Delacruz, M Figeroa, H Morales, M Elbulok, C Keck, T Nesdill, A Rodriguez, A Kamruzzaman, P Ackerman, T. Lodhi | |||||||||||||||||||
CU_BAR_AD_00039 | SPA Grad Applicant Count | This query totals all SPA grad applicants (MPA, MSED, ADVCT programs) by their program, action and admit term. Prompt on Institution and Admit Term range | Program, Action, Admit Term, Count of Students | ADM_MC_VW - Adm Appl Prog Vw for MC | Michael McGovern | Sarah Godwin | New report | S Godwin, M Sultana, S Fajardo, D Battista, J Lee, C Keck, A Kamruzzaman, M Elbulok, T Nesdill, P Ackerman, T. Lodhi | |||||||||||||||||||
CU_BAR_AD_00039_DTL | SPA Grad Applicant Count | This query totals all SPA grad applicants Detail (MPA, MSED, ADVCT programs) by their program, action and admit term. Prompt on Institution and Admit Term range | Program, Action, Admit Term, ID, First Name, Middle, Last Name, Email, Phone | ADM_MC_VW - Adm Appl Prog Vw for MC CU_BIO_VW - Biographical Information View | Michael McGovern | Sarah Godwin | Modified report | S Godwin, M Sultana, S Fajardo, D Battista, P Ackerman, T. Lodhi, Young J. Hah | |||||||||||||||||||
CU_BAR_AD_00040 | Freshmen Applicants | This is a list of new freshman applicants with SAT data, ethnicity, gender, etc. Prompt on Institution and Admit Term range. | Last Name, First Name, Middle Name, Empl ID, Sex, Action, Reason, Program, Plan, Phone, Email, Country, Address 1, Address 2, City, State, Postal, Lst School, Grad Dt, HS Name, Ethnicity | - ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join - ADDRESSES4_VW - Addresses View for Curr EffDT Hierarchy Join - EXT_ORG_VW - External Organization Tbl View Hierarchy Join - ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join | Michael McGovern | Hugo Morales, Dana Messinger | New report | M Delacruz, H Morales, M Elbulok, C Keck, T Nesdill, A Kamruzzaman, D Messinger, P Ackerman, T. Lodhi,
| |||||||||||||||||||
CU_BAR_SR_CLNUP_SG_PASS_CLASS | Pass Class and in Student Group | Creates a list of students active in a particular student group who have a grade that CUNYFirst considers to be passing at Baruch College in a particular course. | ID – Student EMPLID Institution Group Name – Student Group Name Eff Date – Effective Date of Student Group Record Status – Student Group Status (A = Active, I = Inactive) Career – Course Career Term – Term Code for Semester Student Passed Class Session – Session Code for Semester Session Where Student Passed Class Subject – Course Subject Catalog – Course Catalog Number Grade in – Grade Input Descr – Long name for Term Student Passed Class Cleanup Comment – Comment that includes Term and Class that Student Completed course. | Gary Hotko | Gary hotko | New Report | Gary hotko. Tabassum Lodhi, Nicole Bailey, Abdullah Arafeen | ||||||||||||||||||||
CU_BAR_AD_FR_ENG_DATA M Delacruz, H Morales, M Elbulok, C Keck, T Nesdill, A Kamruzzaman, D Messinger, P Ackerman, T. Lodhi, | Gary Hotko |