Applicant Writing Placement
| 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). | Michael McGovern | Marisa Delacruz | New report | M Delacruz, M Figeroa, H Morales, A Cox, C Keck | ||
| 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 | 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 | Michael McGovern | Denyse Ramkaran | New report | G Hotko, D Ramkaran, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi |
| CU_BAR_AD_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). | Michael McGovern | Marisa Delacruz | New Report | M Delacruz, M Figeroa, H Morales, A Kamruzzaman, C Keck | ||
| 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, 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 | G Hotko, D Ramkaran, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi |
| CU_BAR_AD_00006A_DTL | 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). | Michael McGovern | Denyse Ramkaran | New report | G Hotko, D Ramkaran, C Keck, A Kamruzzaman | ||
| 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 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 | Michael McGovern | Denyse Ramkaran | New report | G Hotko, D Ramkaran, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi |
| CU_BAR_AD_00006B_DTL_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, SSN, Admit Type, Phone, 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 | Michael McGovern | Denyse Ramkaran | New report | G Hotko, D Ramkaran, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi |
| CU_BAR_AD_00007 | New Applicants by S.G. | This is a list of new applicants. The list includes the emplid, name, contact information. Prompt on Institution, Career, Admit Term, Admit Type (optional), Program Action (optional) and Student Group (optional). | Michael McGovern | Marisa Delacruz | New report | M Delacruz, M Figeroa, H Morales, A Cox, C Keck, G Hotko, D Ramkaran | ||
| 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 | M Delacruz, M Figeroa, H Morales, A Cox, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi | |
| CU_BAR_AD_00009_2 | ATB UGRD/MATR Applicants | This is a list of new MATR UGRD applicants who must 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, 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, 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 EXT_ORG_VW - External Organization Tbl View Hierarchy Join 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. Lodhi | |
| CU_BAR_AD_00010 | Foreign Applicants/Citizenship | This is a list of MATR applicants who are international. Prompt on Institution, Admit Term range, Admit Type (optional) and Program Action (optional). | Michael McGovern | Marisa Delacruz | ||||
| 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. | Michael McGovern | Marisa Delacruz | New report. | |||
| 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. | Michael McGovern | Mildred Figueroa | New report. | |||
| 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. | Michael McGovern | Marisa Delacruz | New report. | |||
| 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). | Michael McGovern | Marisa Delacruz | New report. | |||
| 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. | Michael McGovern | Marisa Delacruz | New report. | |||
| 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. | Michael McGovern | Marisa Delacruz | New report. | |||
| 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. | Michael McGovern | Mildred Figueroa | New report. | |||
| CU_BAR_AD_00018_2 | Immunization for Applicants | This is a list of applicants and their immunization records (or lack thereof). Prompt on Institution, Career, Admit Term range. | 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 |
| 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 | 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 Term, Program, Plan, Prog Actn, Phone, Email, |
| 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 | 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). | Michael McGovern | Denyse Ramkaran | New report. | |||
| 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). | Michael McGovern | Denyse Ramkaran | New report | |||
| 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, | Michael McGovern | Denyse Ramkaran | New report. | D Ramkaran, G Hotko, C Keck, A Cox, P Ackerman | |
| CU_BAR_AD_00023 | Remove TST/MTHPL | 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 well. Prompt on Institution. | Michael McGovern | Denyse Ramkaran | New report | D Ramkaran, G Hotko, C Keck, A Cox | ||
| 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 | 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_PROG - Admission Applicant Program Hierarchy Join ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join CU_BIO_VW - Biographical Information View | 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 |
| 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 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. | 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 | |
| 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 | Multiple Math Placements | This is a list of students who have multiple math placements. | 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). | Abu Kamruzzaman | Gary Hotko | New report | |||
| CU_BAR_AD_00031 | 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). | Michael McGovern | Gary Hotko | New report. | |||
| CU_BAR_AD_00032 | Applicants missing National ID | Students missing National ID and displaying LID or blanks | Abu Kamruzzaman | Patrick Ackerman | New report. | C Keck, M Figueroa, M DeLacruz, H Morales, A Rodriguez, T Nesdill, M Elbulok, P Ackerman, T Lodhi | ||
| CU_BAR_AD_00033 | Grad Applicant Data | This query selects applicants by program. Prompt on Institution, Career, Program and Admit Term range. | Michael McGovern | Sarah Godwin | New report. | S Godwin, M Sultana, S Fajardo, D Battista, J Lee, C Keck, A Kamruzzaman, M Elbulok, T Nesdill | ||
| 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. | Michael McGovern | David Rosen | New report | M Morales, C Keck, A Kamruzzaman | ||
| 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. | Michael McGovern | David Rosen | New report | M Morales, C Keck, A Kamruzzaman | ||
| 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. | Michael McGovern | Marisa Delacruz | New report | M Delacruz, M Figeroa, H Morales, M Elbulok, C Keck, T Nesdill, A Rodriguez, A Kamruzzaman | ||
| 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. | Michael McGovern | Hugo Morales | New report | M Delacruz, M Figeroa, H Morales, M Elbulok, C Keck, T Nesdill, A Rodriguez, A Kamruzzaman | ||
| 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. | Michael McGovern | Sarah Godwin | New report | S Godwin, M Sultana, S Fajardo, D Battista, J Lee, C Keck, A Kamruzzaman, M Elbulok, T Nesdill | ||
| CU_BAR_AD_00040 | Freshmen Appicants | This is a list of new freshman applicants with SAT data, ethnicity, gender, etc. Prompt on Institution and Admit Term range. | Michael McGovern | Hugo Morales, Dana Messinger | New report | M Delacruz, H Morales, M Elbulok, C Keck, T Nesdill, A Kamruzzaman, D Messinger | ||