Page History

00004New Contact DataThis is a list of new applicants by prompted term and their contact information, Career, and Admit Type (optional). M Delacruz, M Figeroa, H Morales, A Kamruzzaman, C Keck, P Ackerman_DTLThis G , P, Ackerman00007This is a list of new applicants. The list includes the emplid, name, contact information. Prompt , (optional), Program Action (optional) and Student Group M Delacruz, M Figeroa, H Morales, A Cox, C Keck, A Kamruzzaman, 000092This is a list of new MATR UGRD applicants who must sit for the Ability to Benefit (ATB) exam and M Delacruz, M Figeroa, H Morales, A Kamruzzaman, C Keck, P Ackerman, 00010This is a list of MATR applicants who are international, (optional) and Program Action T.Lodhi, P, Ackerman, C.Keck00013This is a list of new MATR applicants who have enrolled and who have previous degrees and .00018_2Immunization for Applicants applicants and their immunization records (or lack thereof), Career, Applicants w/Math Tests math tests, Career, Denyse Ramkaran CU00021Applicants o Indicators are missing prompted /reason codes, Career range and Admit Type Denyse Ramkaran report 00022_2Applicants Needing MTHPL who need the TST/MTHPL service indicator/reason code, Career, and Admit Type (optional)Denyse RamkaranD Ramkaran, G Hotko, C Keck, A Cox, P Ackerman, . Lodhi00022_3Applicants Needing MTHPL need the TST/MTHPL service indicator/reason code, Career, and Admit Type (optional).

Does not post indicator if student has NTMT student group00023Remove TST/MTHPL students/applicants who have the TST/MTHPL service indicator/reason code and have a placement in a math student group as well G Hotko, D Ramkaran, P Ackerman, T Lodhi

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_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 - 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_	00003_2	Applicant	Reading 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	and Admit Term range	. - Updated for Accuplacer Testing	Group,Empl ID,Last Name,First Name,Middle Name, Empl ID, Career, Program, Action, Plan, Admit Term SSN,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	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	, 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	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		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, 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	Denyse Ramkaran	New report		Michael McGovern	Denyse Ramkaran	New report	G Hotko, D Ramkaran, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi
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 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	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, , P AckermanA Kamruzzaman, 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
CU_BAR_AD_00006A_3	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 report New report	G Hotko, D Ramkaran , C Keck , A Kamruzzaman, P Ackerman, T. LodhiLodh
CU_BAR_AD_ 00006B 00006A_ 2 4	Appl Math Place - M3 + RegentsOnly	This query selects applicants who have taken the Regents SMA3 or MATHB and the ACT-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
CU_BAR_AD_00006B_	New Applicants by S.G.	4	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, Empl ID, Student Group, Career, Acad Prog, Prog Actn, Action Date, Admit Term, Admit Type, Last School Attended, Acad Plan, 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 - STDNT_GRPS_HIST - Student Groups History 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		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	G Hotko, D Ramkaran,	P Ackerman, T. Lodhi
CU_BAR_AD_	00006B_	ATB UGRD/MATR Applicants	5	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	. Prompt on Institution	, 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 ID, Career, Program, Action, Plan, Action Date, Admit Term, Admit SSN, Admit Type, Phone, EmailEamil, ResidencyTest ID, Citizenship, High School, H S Name, H S Country, Addr Type, Address 1, Address 2, City, State, PostalTest 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,	T. Lodhi
CU_BAR_AD_00006B_DTL_	Foreign 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	. Prompt on Institution, Career, Admit Term range	and Admit Type	(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 Date	- 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 - RESIDENCY_OFF - Official Residency Data Hierarchy Join - SCC_VISA_P_QVW - Visa Data Query View 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 - 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.	Eamil, Test ID, Component, Test Dt, Data Srce, 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 McGovern	Denyse Ramkaran	New report	G Hotko, D Ramkaran, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi
CU_BAR_AD_00012	Transfers and Transfer Credit	This is a list of new transfers who are enrolled for the term (To Admit Term), and the source of the transfer credit. Prompt on Institution and Admit Term range.	00006C	Appl Math Place - M6 ONLY	This query selects applicants who have taken the 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). Adjusted to use new critera and tests	Empl ID, 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 - 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 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_	New 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	. Prompt on Institution	, Career, Admit Term range	and Admit Type (optional). Adjusted to use new critera and tests	Empl ID, Last Name, Last Name, First Name, Middle Name, Empl ID, Program, Plan, Term Units, Admit TermSSN, 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 - 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 - ACAD_DEGR - Student Degree Table Hierarchy Join - ACAD_DEGR_PLAN - Student Degree Plan Table Hierarchy Join - ACAD_PLAN_TBL - Academic Plan Table 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, 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 - CU_BIO_VW - Biographical Information View Hierarchy Join -ACADADM_APPL_PROG - Student Academic Admission Applicant Program Hierarchy Join - ADM_APPL_DATA PLAN - Admission Application Data Applicant Plan Hierarchy Join - SCCCU_EMAILBIO_QVW - Email Addresses Query VW - Biographical Information View Hierarchy Join UNION 1: - SRVCSTDNT_INDGRPS_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	Marisa Delacruz	New report.	HIST - Student Groups History 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. 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 -RESIDENCY_OFF - Official Residency Data 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_0001600009_2	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, First Name, Middle, ID, Career, Acad Prog, Prog Actn, Acad Plan, Action DateLast Name, First Name, Middle Name, Empl ID, line#, Program, Plan, Term Units, 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 - ADM_APPL_PROG - Admission Applicant Program Hierarchy Join - ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join - STDNTADDRESSES4_CAR_TERM - Student Career Term Table VW - Addresses View for Curr EffDT Hierarchy Join UNION 1: - ADMRESIDENCY_APPL_DATA - Admission Application Data OFF - Official Residency Data Hierarchy Join - ADMSCC_VISA_APPLP_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 QVW - Visa Data Query View Hierarchy Join	Michael McGovern	Mildred Figueroa	Marisa Delacruz	New report.	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, Admit TypeTake Prgrs, Admit Term, Program, Plan, Status, Action, ReasonAdmit Type, 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 STDNT_CAR_TERM - Student Career Term Table 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	Michael McGovern	Marisa Delacruz	New report	M Delacruz, M Figeroa, H Morales, A Kamruzzaman, C Keck, P Ackerman, T. Lodhi	CU_BAR_AD_00019_1	Zicklin GRAD Applicants	Michael McGovern	Marisa Delacruz	New report.	T.Lodhi, P, Ackerman, C.Keck
CU_BAR_AD_00012	Transfers and Transfer Credit	This is a list of new transfers who are enrolled for the term (To Admit Term), and the source of the transfer credit. Prompt on Institution and This is a list of Zicklin GRAD applicants. Prompt on Institution, Career, Admit Term range.	Last Name, First Name, Middle Name , Empl ID, Admit Type, Admit Termline#, Program, Plan, Prog Actn, Phone, Email,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 - ADM_APPL_PROG - Admission Applicant Program Hierarchy Join - ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join - CU_BIO_VW - Biographical Information View 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_00020	- STDNT_CAR_TERM - Student Career Term Table 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.	T.Lodhi, P, Ackerman, C.Keck
CU_BAR_AD_00013	New Students w/Prev Degrees		This is a list of new MATR applicants who have enrolled and who have	previous degrees. Prompt on Institution	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 - 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_TESTCAR_COMP TERM - Student Test Components Career Term Table Hierarchy Join UNION 1: - ADMACAD_APPL_DATA - Admission Application Data DEGR - Student Degree Table Hierarchy Join - ADM_APPL_PROG - Admission Applicant Program Hierarchy Join- ADM_APPLACAD_DEGR_PLAN - Admission Applicant Student Degree Plan Table Hierarchy Join - CUACAD_BIOPLAN_VW - Biographical Information View Hierarchy Join Sub Query for Does Not Exist: -STDNT_TEST_COMP - Student Test Components	Michael McGovern	TBL - Academic Plan Table 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 indicators	. Prompt on Institution	, Admit Term	range and Service Indicator (optional).		Last Name, First Name, Middle Name, Empl ID, ProgramAction, Plan, Action, Action DateStatus, Admit Term, Admit Type, Admit Term, SI Rsn Code, Positive?, Phone Preferred Email, EmailCampus Email	-ADMSRVC_APPLIND_DATA - Admission Application Service Indicator Data Hierarchy Join -ADM_APPLCU_BIO_VW - Biographical Information View Hierarchy Join -ACAD_PROG - Admission Applicant Student Academic Program Hierarchy Join -ADM_APPL_PLAN DATA - Admission Applicant Plan Application Data Hierarchy Join -CUSCC_BIOEMAIL_VW - Biographical Information QVW - Email Addresses Query View 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	Marisa Delacruz	New	report.	T.Lodhi, P, Ackerman, C.Keck
CU_BAR_AD_	00015	New Stdnts w/non-NY Residency	This is a list of new MATR applicants	who have enrolled and who have a non-New-York (in-state, in-city) residency. Prompt on Institution	and Admit Term range	.	Last Name, First Name, Middle Name, Empl ID, Admit Type, Program, Plan, Term Units, Admit Term, Program, Plan, ActionAdmit 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 Sub Query for Does Not Exist: -STDNT_ GRPS CAR_ HIST TERM - Student Groups History Career Term Table Hierarchy Join - STDNT RESIDENCY_ TEST_COMP - Student Test Components-SRVC_IND_DATA - Service Indicator Data OFF - Official Residency Data Hierarchy Join	Michael McGovern	Marisa Delacruz	New report.	T.Lodhi, P, Ackerman, C.Keck
CU_BAR_AD_	00016	"No Show" New Students	This is a list of new MATR applicants who	have not enrolled. Prompt on Institution	and Admit Term range	.	Last Name, First Name, Middle Name, Empl ID, Admit Type, Program, Plan, Term Units, Admit Term, Program, Plan, Action, Admit Type, Phone, Email,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 CAR_ HIST TERM - 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, . Lodhi	Career Term Table Hierarchy Join	Michael McGovern	Marisa Delacruz	New report.	T.Lodhi, P, Ackerman, C.Keck
CU_BAR_AD_	00017	Transfers w/non-Posted Credit	This is a list of	new 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, line#, Program, Plan, Term Units, Admit Term, Admit Type, Phone, Email, Source ID, Group Name, Email , Term, Class#, Subject, Grade, Comp, Units, Status	-ADM_APPL_DATA - Admission Application Data Hierarchy Join -ADM_APPL_PROG - Admission Applicant Program Hierarchy Join -ADM_APPL_PLAN - Admission Applicant Plan -STDNT_GRPS_HIST - Student Groups History Hierarchy Join -CU_BIO_VW - Biographical Information View Hierarchy Join -SRVCSTDNT_INDCAR_DATA - Service Indicator Data TERM - Student Career Term Table Hierarchy Join	Michael McGovern/Tabassum Lodhi	Denyse Ramkaran	New report	D Ramkaran, G Hotko, C Keck, A Cox, T.Lodhi, P, Ackerman	CU_BAR_AD_00024_2	Applicants Needing TST/WRITE	This is a list of applicants who need the TST/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 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	Denyse Ramkaran	New report	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_0002500018_12	Immunization for Applicants Needing TST/READ	This is a list of applicants who need the TST/READ 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_TESTBIO_COMP - Student Test Components	Michael McGovern	Denyse Ramkaran	New report	VW - Biographical Information View Hierarchy Join Sub Query for Does Not Exist: -IMMUNIZATIONS - Immunizations	Michael McGovern	Marisa Delacruz	New report	M Delacruz, M Figeroa, H Morales, A Kamruzzaman, C KeckG Hotko, D Ramkaran, P Ackerman, T. Lodhi
CU_BAR_AD_0002600019_1	Zicklin GRAD 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	Zicklin GRAD applicants. 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	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 P Ackerman, T. Lodhi
CU_BAR_AD_0002600019_2	Applicants Needing ADIDZick GRAD Applicants w/ DEIN	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 Berry, P Ackerman, T Lodhi	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,	- 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 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.	00020	Applicants w/Math Tests	This is a list of new applicants who have math tests. 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, Test ID, Component, Test Dt, Score	-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_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	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 1Sub Query for Does Not Exist: - ADM STDNT_ MC TEST_ 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	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	CU_BAR_AD_00027	Remove TST/WRITE	This is a list of students/new applicants who have the TST/WRITE service indicator/reason code and have a placement in an English student group as wellare missing prompted service indicators/reason codes. Prompt on Institution, Career, Admit Term range and Admit Type (optional).			Michael McGovern	Denyse Ramkaran	New report	G Hotko, D Ramkaran	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		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 -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: -AUDIT_SRVC_IND - Audit Record - SRVC_IND_DATA	Michael McGovern	Denyse Ramkaran	New report	T.Lodhi, P, Ackerman, C.Keck
CU_BAR_AD_0002900022_12	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).	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 Sub Query for Does Not Exist: -STDNT_GRPS_HIST - Student Groups History -STDNT_TEST_COMP - Student Test Components -SRVC_IND_DATA - Service Indicator Data	Michael McGovern	Gary HotkoDenyse Ramkaran	New report.	G Hotko, D Ramkaran, G Hotko, C Keck, A Cox, P Ackerman, T . Lodhi
CU_BAR_AD_0003000022_13	Applicants Needing TST/MATHMTHPL	This is a list of applicants who need the TST/ MATH 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 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 Abu Kamruzzaman	Gary Hotko	Denyse Ramkaran	New Modified report Updated to take Student Group NTMT into account	D Ramkaran, G Hotko, C Keck, A Cox, P Ackerman, . Lodhi
CU_BAR_AD_0003100023	Applicants Needing Remove TST/SKILLMTHPL	This is a list of students/applicants who need have the TST/SKILL 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 -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	Gary HotkoDenyse Ramkaran	New report.	D Ramkaran, G Hotko, P AckermanC Keck, A Cox, T.Lodhi, P, Ackerman
CU_BAR_AD_0003100024_12	Applicants Needing TST/SKILLWRITE	This is a list of applicants who need the TST/SKILL WRITE 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 ComponentsSub 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	Michael McGovern	Denyse Ramkaran	New report	G Hotko, D Ramkaran, P Ackerman, T Lodhi
CU_BAR_AD_00025_1	Applicants Needing TST/READ	This is a list of applicants who need the TST/READ 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_-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 ComponentsSub Query for Exist:DATA - Service Indicator Data Hierarchy Join -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. G Hotko, P Ackerman, T Lodhi
CU_BAR_AD_0003200026_2	Applicants missing National ID	Students missing National ID and displaying LID or blanks	Needing ADID	This is a pre-orientation query to create a list of students needing ADIDs and email ids; Requires NPI access.	Last Name, First Name, Middle Name, Empl ID, Career, Admit Term, Prog Actn, Admit Type, Birthdate, Full LID, Group NameSSN, Last, First Name, Birthdate	Query Requires NPI - ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join - 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 CU_ FERPA R901_ VW BIO - FERPA Personal Data View Hierarchy Join - EXTERNAL_SYSTEM - External System ID's Hierarchy Join - STDNT_GRPS - Student Groups View for Biographical Info Hierarchy Join	Abu Kamruzzaman	Patrick Ackerman	New report.	Modified Report	Dixon Berry, Query 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_0026_000334	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	Grad Applicant Data	This query selects applicants by program. Prompt on Institution, Career, Program and Admit Term range.	Last Name, First Name, Middle Name, Empl ID, Gender, Approved Load, Action, 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, 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 - CITIZEN_STS_TBL - Citizen Status Table Hierarchy Join - CITIZEN_STS_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 - SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join - SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join - SCC_CITIZEN_QVW - Citizenship Query View 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_0003400027	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.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 - SCC_PERS_NI_QVW - Person National ID Query View Hierarchy Join - CU_BIO_VW - Biographical Information View Hierarchy Join Sub Query for Does Not Exist: -STDNT_TEST_COMP - Student Test Components	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 - CU_BIO_VW - Biographical Information View 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 GRPS_ COMP HIST - Student Test Components Sub Query for Exist: Groups History Hierarchy Join -STDNT_TEST_COMP - Student Test Components UNION3: - ADM SRVC_ MC IND_ 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: DATA - Service Indicator Data Hierarchy Join -STDNT_TEST_COMP - Student Test Components Sub Query for Exist: 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_APPL_DATA - Admission Application Data Hierarchy Join -ADM_MCAPPL_VW - Adm Appl Prog Vw for MC PROG - Admission Applicant Program Hierarchy Join - STDNTADM_GRPSAPPL_HIST - Student Groups History PLAN - Admission Applicant Plan Hierarchy Join -CU_BIO_VW - Biographical Information View Hierarchy Join Sub Query for Does Not Exist: -STDNT_TESTGRPS_COMP - Student Test Components UNION1: - ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy HIST - Student Groups History Hierarchy Join -STDNT_GRPSTEST_HIST COMP - Student Groups History Hierarchy JoinTest Components - CUSRVC_BIOIND_VW - Biographical Information View Hierarchy JoinSub Query for Does Not Exist:DATA - Service Indicator Data Hierarchy Join -STDNT_TEST_COMP - Student Test ComponentsUNION2: - 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 UNION3:	Michael McGovern/Tabassum Lodhi	Gary Hotko	New report.	G Hotko, P Ackerman, T Lodhi
CU_BAR_AD_00031_1	Applicants Needing TST/SKILL	This is a list of applicants 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, 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 - 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: -SRVC_IND_DATA - Service Indicator Data Hierarchy Join -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	-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 - 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: -SRVC_IND_DATA - Service Indicator Data Hierarchy Join -STDNT_TEST_COMP - Student Test Components -STDNT_TEST_COMP - Student Test Components- ADDRESSES4_VW - Addresses View for Curr EffDT Hierarchy Join Sub Query for Does Not Exist: -STDNT_GRPSTEST_HIST COMP - Student Groups History Hierarchy Join	Michael McGovern	Marisa Delacruz	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
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	00032	Applicants missing National ID	Students missing National ID and displaying LID or blanks 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, Career, Admit Term, Prog Actn, Admit Type, PhoneBirthdate, Preferred EmailFull LID, Group Name, Address 1, Address 2, City, State, Postal, Country	Query Requires NPI - ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join - CUSCC_PERS_BIONI_VW - Biographical Information QVW - Person National ID Query View Hierarchy Join - STDNTCU_GRPSBIO_HIST - Student Groups History VW - Biographical Information View Hierarchy Join - ADDRESSES4PERSNL_FERPA_VW - Addresses View for Curr EffDT Hierarchy JoinSub Query for Does Not Exist:FERPA Personal Data View Hierarchy Join - EXTERNAL_SYSTEM - External System ID's Hierarchy Join - STDNT_GRPS _HIST - Student Groups History Hierarchy Join	Michael McGovern	Hugo Morales	New report	Abu Kamruzzaman	Patrick Ackerman	New report.	Query Requires NPI C Keck, M Figueroa, M DeLacruzM Delacruz, M Figeroa, H Morales, M Elbulok, C KeckA Rodriguez, T Nesdill, A Rodriguez, A KamruzzamanM Elbulok, P Ackerman, T . Lodhi, M McGovern
CU_BAR_AD_0003900033	SPA Grad Applicant CountData	This query totals all SPA grad applicants (MPA, MSED, ADVCT programs) by their program, action and admit termselects applicants by program. Prompt on Institution, Career, Program and Admit Term range.	Last Name, First Name, Middle Name, Empl ID, Gender, Approved Load, Action, Eff Date, Program, Action, Admit Term, Count of Students, 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, Ethnicity	- 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	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 - CITIZEN_STS_TBL - Citizen Status Table Hierarchy Join - CITIZEN_STS_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 - SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join - SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join - SCC_CITIZEN_QVW - Citizenship Query View 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.Modified report	S Godwin, M Sultana, S Fajardo, D Battista, J Lee, C Keck, A Kamruzzaman, M Elbulok, T Nesdill, P Ackerman, T. Lodhi, Young J. Hah
CU_BAR_AD_0004000034	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	Freshmen Appicants	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, PlanAdmit Type, Phone, Email, Country, Address 1, Address 2, City, State, Postal, Lst School, Grad Dt, HS Name, EthnicityFailed	- 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 - 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 - SF_STDNT_PRS_VW - SF Student Personal Data View 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	Michael McGovern	Hugo Morales, Dana Messinger	New report	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 UNION2: - 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 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	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 - SF_STDNT_PRS_VW - SF Student Personal Data View 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	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

Page tree

Versions Compared

Old Version 122

New Version Current

Key