Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
00007This is a list of new applicants.  The list includes the emplid, name, contact information, , Program Action (optional) and Student Group (optional).M Delacruz, M Figeroa, H Morales, A Cox, C Keck, A Kamruzzaman, P Ackerman, 000092This is a list of new MATR UGRD applicants who must sit for the Ability to Benefit (ATB) exam and T.Lodhi, P, Ackerman, C.Keck 00019_1Zicklin GRAD Applicants Zicklin GRAD applicants, Career, J Albanese, E Berstein, E Figini, P Davis-Friday, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi 00019_2Zick GRAD Applicants DEIN Zicklin GRAD applicants with DEIN group, CareerApplicants w/Math Tests  who have math tests, Career, Denyse Ramkaran   CU00021Applicants w/o Service Indicators  are missing prompted service indicators/reason codes, Career, range and Admit Type (optional).   Denyse Ramkaran   report  00022_2Applicants Needing MTHPL applicants 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, . Lodhi
Report IDTitleDescriptionColumns IncludedRecords IncludedDeveloperRequestorCommentsShared with
CU_BAR_AD_00001New ApplicantsThis 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 McGovernMarisa Delacruz New reportM Delacruz, M Figeroa, H Morales, A Cox, C Keck, P Ackerman, T. Lodhi
CU_BAR_AD_00002_3 Applicant Writing PlacementThis 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 McGovernDenyse Ramkaran New report 

G Hotko, D Ramkaran, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi

CU_BAR_AD_00003_1Applicant 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 RamkaranNew report  G Hotko, D Ramkaran, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi
CU_BAR_AD_00003_2Applicant Reading Plcmnt AccupThis 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,SSN,Admit Type,Phone,Email,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 HotkoGary hotkoModified ReportG. hotko, D Ramkaran, T. Lodhi
CU_BAR_AD_00004New Applicant Contact DataThis is a list of new applicants by prompted term and their contact information.  Prompt on Institution, Career, Admit Term range and Admit Type (optional). Last Name, First Name, Middle Name, Empl ID, Career, Program, Action, Plan, Admit Term, Admit Type, Phone, Email, Addr Type, Address 1, Address 2, City, State, Postal

- ADM_APPL_DATA - Admission Application Data Hierarchy Join

- ADM_APPL_PROG - Admission Applicant Program Hierarchy Join

- ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join

- CU_BIO_VW - Biographical Information View Hierarchy Join

- ADDRESSES4_VW - Addresses View for Curr EffDT Hierarchy Join

Michael McGovern Marisa Delacruz New Report M Delacruz, M Figeroa, H Morales, A Kamruzzaman, C Keck, P Ackerman, T. Lodhi
CU_BAR_AD_00005Number available       
CU_BAR_AD_00006AAppl 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_DTLAppl Math Place - M3 OnlyThis 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).Empl ID, Last Name, First Name, Middle Name, SSN, Admit Type, Phone, Email, Test ID, Component, Test Dt, Data Srce, 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

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 McGovernDenyse RamkaranNew report  G Hotko, D Ramkaran, C Keck, A Kamruzzaman, T.Lodhi, P, Ackerman
CU_BAR_AD_00006A_1Appl 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

Gary Hotko Denyse Ramkaran

 Modified  report 

Modified to recognize students with NTMT Student Group Placement to not issue new student groups.

   G Hotko, D Ramkaran, C Keck, , P Ackerman, T. Lodhi
Appl Math Place - M3 Only This 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
00006B1Appl 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 Join

SUB QURIES:

Subquery for D.TEST_DT - Test - STDNT_TEST_COMP - Student Test Components

 

Sub query for Does Not Exist

does not exist:-

STDNT_
GRPS
TEST_
HIST
COMP - Student Test Components

does not exist Groups HistorySub Query for 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 Exist:

STDNT_TEST_COMP - Student Test Components

 

Sub Query for J.TEST_DT - Test Date
STDNT_TEST_COMP - Student Test Components
Michael McGovernDenyse RamkaranGary HotkoGary HotkoModified  New reportG Hotko, D Ramkaran , C Keck , A Kamruzzaman, P Ackerman, T. LodhiLodh
CU_BAR_AD_00006B_21Appl Math Place - M3 + RegentsThis 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 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 HotkoMichael McGovernDenyse Ramkaran

 Modified  report 

Modified to recognize students with NTMT Student Group Placement to not issue new student groups.

New report   G Hotko, D Ramkaran, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi
CU_BAR_AD_00006B_42Appl Math Place - M3 + RegentsThis 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:

 

Sub query for Does Not Exist:

-STDNT_-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 LodhiGary Hotko

Modified  report

 

Denyse Ramkaran

 Modified  report 

Modified to recognize students with NTMT Student Group Placement to not issue new student groups.

   G  G Hotko, D Ramkaran, C Keck, , P Ackerman, T. Lodhi
DTL_1Appl Math Place - M3 + RegentsThis 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

SUB QURIES:

Subquery for D.TEST_DT - Test - 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 McGovernDenyse RamkaranNew reportTabassum LodhiGary Hotko

Modified  report

 

 G G Hotko, D Ramkaran, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi
New Applicants by S.G.Appl Math Place - M3 + Regents

This query selects applicants who have taken the Regents SMA3 or MATHB and the ACT-MATH-3 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, Student Group, Career, Acad Prog, Prog Actn, Action Date, Admit Term, Admit Type, Last School Attended, Acad Plan, Phone, EmailSSN, Admit Type, Phone, Eamil, Test ID, Test DT, Data Srce, Total M3 Score, Regents, Component, Score

ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join

- ADM_APPL_DATA - Admission Application Data Hierarchy Join

- ADM_APPL_PROG - Admission Applicant Program Hierarchy Join

- ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join

- CU_BIO_VW - Biographical Information View Hierarchy Join

- STDNT_GRPS_HIST - Student Groups History Hierarchy Join

Michael McGovernMarisa DelacruzNew report  M Delacruz, M Figeroa, H Morales, A Cox, C Keck, G Hotko, D Ramkaran, P Ackerman, T. LodhiCU_BAR_AD_00008UGRD Applicants w/o M3 ExamThis 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 McGovernMarisa Delacruz 

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
Gary HotkoGary HotkoModified  reportG Hotko, D Ramkaran,  T. Lodhi
CU_BAR_AD_00006B_DTL_ATB UGRD/MATR Applicants1Appl Math Place - M3 + RegentsThis 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, Empl IDSSN, CareerAdmit Type, ProgramPhone, ActionEamil, PlanTest ID, 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, PostalComponent, Test Dt, Data Srce, Score, Regents, Component, Score

ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join

ADM_APPL_DATA - Admission Application Data Hierarchy Join

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 Join

EXTSTDNT_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 McGovernMarisa Delacruz  M Delacruz, M Figeroa, H Morales, A Kamruzzaman, C Keck, P Ackerman, T. LodhiCU_BAR_AD_00010Foreign Applicants/CitizenshipThis is a list of MATR applicants who are international.  Prompt on Institution, Admit Term range, Admit Type (optional) and Program Action (optional).

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 McGovernDenyse RamkaranNew reportG Hotko, D Ramkaran, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi
CU_BAR_AD_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, SSN, Admit Type, Phone, Eamil, Test ID, Component, Test Dt, Data Srce, M6 Score
Last, First Name, Middle, ID, Career, Acad Prog, 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_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join

- ADM_APPL_DATA - Admission Application Data Hierarchy Join
- ADM_APPL_PROG - Admission Applicant Program Hierarchy Join
- ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join
- CU_BIO_VW - Biographical Information View Hierarchy Join- 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 McGovernMarisa Delacruz T.Lodhi, P, Ackerman, C.Keck

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 HotkoGary HotkoNew ReportG Hotko, D Ramkaran,  T. LodhiCU_BAR_AD_00011New Enrolled UGRDs by PlanThis 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 McGovernMarisa DelacruzNew report.
CU_BAR_AD_00012Transfers and Transfer CreditThis 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.Last Name, First Name, Middle Name Empl ID, line#, Program, Plan, 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
- 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 McGovernMildred FigueroaNew report.00006DAppl 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, First Name, Middle Name, SSN, Admit Type, Phone, Eamil, Test ID, Component, Test Dt, Data 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 HotkoGary HotkoNew ReportG Hotko, D Ramkaran,  T. LodhiT.Lodhi, P, Ackerman, C.Keck
CU_BAR_AD_0001300007New Students w/Prev DegreesApplicants by S.G.This is a list of new MATR applicants who have enrolled and who have previous degreesapplicants.  The list includes the emplid, name, contact information.  Prompt on Institution and Admit Term range, Career, Admit Term, Admit Type (optional), Program Action (optional) and Student Group (optional).Last Name, First Name, Middle Name, Empl ID, Program, Plan, Term Units, Student Group, Career, Acad Prog, Prog Actn, Action Date, Admit Term, Admit Type, Phone, Email, Degree Nbr, Institution, Degree, Plan, Plan Description, Compl Term, Confer Dt, Hon SuffixLast 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_CARGRPS_TERM HIST - Student Career Term Table Groups History 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 McGovernMichael McGovernMarisa Marisa DelacruzNew 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_0001400008New Students UGRD Applicants w/Service Indo M3 ExamThis is a list of new MATR UGRD applicants who have enrolled and who have service indicatorsnot taken the M3 exam.  Prompt on Institution , and Admit Term range and Service Indicator (optional).Last Name, First NameFirstName, Middle Name, Empl IDID, Career, Acad Prog, Prog Actn, Acad Plan, Action Date, Status, Admit Term, Admit Type, SI Rsn Code, Positive?, Phone Preferred Email, Campus Email Phone, Email

ADM_APPL-SRVC_IND_DATA - Service Indicator Admission Application Data Hierarchy Join-CU

ADM_BIO_VW - Biographical Information View Hierarchy Join
-ACAD_PROG - Student Academic APPL_PROG - Admission Applicant Program Hierarchy Join-

ADM_APPL_DATA PLAN - Admission Application Data Applicant Plan Hierarchy Join-SCC_EMAIL_QVW - Email Addresses Query View Hierarchy Join

UNION 1:

-SRVC_IND_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 McGovernMarisa DelacruzNew report.

View

Michael McGovernMarisa Delacruz M Delacruz, M Figeroa, H Morales, A Cox, C Keck, A Kamruzzaman, P Ackerman, T. LodhiT.Lodhi, P, Ackerman, C.Keck
CU_BAR_AD_00009_000152ATB UGRD/MATR ApplicantsNew Stdnts w/non-NY ResidencyThis is a list of new MATR applicants who have enrolled and who have a non-New-York (in-state, in-city) residencyUGRD 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, Term UnitsAction Date, Admit Term, Admit Type, Phone, Email, Effective, Residency , Residency, Citizenship, High School, H S Name, H S Country, Addr Type, Address 1, Address 2, City, State, Postal

ADM_APPL_DATA -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

-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 McGovernMarisa DelacruzNew report.T.Lodhi, P, Ackerman, C.Keck  M Delacruz, M Figeroa, H Morales, A Kamruzzaman, C Keck, P Ackerman, T. Lodhi
CU_BAR_AD_0001600010Foreign Applicants/Citizenship"No Show" New StudentsThis is a list of new MATR applicants who have not enrolledare international.  Prompt on Institution and , Admit Term range, Admit Type (optional) and Program Action (optional).Last Name, First Name, Middle Name, Empl ID, Program, Plan, Term Units, Career, Acad Prog, Prog Actn, Acad Plan, Action Date, Admit Term, Admit Type, Last School Attended, Phone, Email , 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
- STDNTADDRESSES4_CAR_TERM - Student Career Term Table 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 McGovernMarisa DelacruzNew report. T.Lodhi, P, Ackerman, C.Keck
CU_BAR_AD_0001700011New Enrolled UGRDs by PlanTransfers w/non-Posted CreditThis is a list of new transfers students who are enrolled for the term (To Admit Term), and who have non-posted transfer creditsorted by plan.  Prompt on Institution and Admit Term range.Plan, Last Name, First Name, Middle Name, Empl ID, line#, Program, Plan, Term UnitsTake Prgrs, Admit Term, Admit Type, Phone, Email, Source ID, Group, 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 Hierarchy Join
- CU_BIO_VW - Biographical Information View Hierarchy Join
- STDNT_CAR_TERM - Student Career Term Table Hierarchy Join

UNION 1:

-ADM_APPL_DATA - Admission Application Data  Hierarchy Join  

-ADM_APPL_PROG - Admission Applicant Program  Hierarchy Join  

-STDNT_CAR_TERM - Student Career Term Table  Hierarchy Join  

-NAME_CURR_VW - Current Name Vw all types  Hierarchy Join  

-TRNS_CRSE_SCH - Student Transfer Credit School  Hierarchy Join  

-TRNS_CRSE_DTL - Student Transfer Course Detail  Hierarchy Join 

Michael McGovernMildred FigueroaMichael McGovernMarisa DelacruzNew reportNew report.T.Lodhi, P, Ackerman, C.Keck
CU_BAR_AD_00018_200012Transfers and Transfer CreditImmunization for ApplicantsThis is a list of applicants and their immunization records (or lack thereof).new transfers who are enrolled for the term (To Admit Term), and the source of the transfer credit.  Prompt on Institution , Career, and Admit Term range. Last Name, First Name, Middle Name , Empl ID, Admit Typeline#, Admit Term, Program, Plan, StatusTerm Units, ActionAdmit Term, ReasonAdmit Type, Phone, Preferred Email, Immunization, Date Taken, Expiration Date, Status, Without Immunizations, 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
- 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  

-ADMSTDNT_APPLCAR_PLAN - Admission Applicant Plan  TERM - Student Career Term Table  Hierarchy Join  

-CUNAME_BIOCURR_VW - Biographical Information View  Current Name Vw all types  Hierarchy Join  Sub Query for Does Not Exist:

-

IMMUNIZATIONS - Immunizations

TRNS_CRSE_SCH - Student Transfer Credit School  Hierarchy Join  

Michael McGovernMarisa Delacruz Mildred FigueroaNew report M Delacruz, M Figeroa, H Morales, A Kamruzzaman, C Keck, P Ackerman, T. Lodhireport.T.Lodhi, P, Ackerman, C.Keck
CU_BAR_AD_00013New Students w/Prev DegreesThis is a list of new MATR applicants who have enrolled and who have previous degrees.  Prompt on Institution and Admit Term range.Last Name, First Name, Middle Name, Empl ID, Program, Plan, Term Units, Admit Term, Admit Type, Admit Term, Program, Phone, Email, Degree Nbr, Institution, Degree, Plan, Prog Actn, Phone, Email,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

Michael McGovern Elaine Bernstein, Elizabeth FiginiNew report 

- 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 McGovernMarisa DelacruzNew report.T.Lodhi, P, Ackerman, C.Keck
CU_BAR_AD_00014New Students w/Service IndThis 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, Admit TypeAction, Status, Admit Term, Program, Plan, Prog Actn, Phone, Email,Admit Type, SI Rsn Code, Positive?, Phone Preferred Email, Campus Email 

-SRVC_IND_DATA - Service Indicator - ADM_APPL_DATA - Admission Application Data Hierarchy Join

- ADM_APPLCU_BIO_VW - Biographical Information View Hierarchy Join

-ACAD_PROG - Admission Applicant Student Academic Program Hierarchy Join

-ADM_APPL_PLAN - Admission Applicant Plan DATA - Admission Application Data Hierarchy Join

-SCC_EMAIL_QVW - Email Addresses Query View Hierarchy Join

UNION 1:

-SRVC_IND_DATA - Service Indicator Data  Hierarchy Join   Hierarchy Join

-CU_BIO_VW - Biographical Information View View  Hierarchy Join

Tabassum LodhiKevin B. TaylorModified report

P Ackerman, T. Lodhi

 

 CU_BAR_AD_00020

 

-ADM_MC_VW - Adm Appl Prog Vw for MC  Hierarchy Join  

-SCC_EMAIL_QVW - Email Addresses Query View  Hierarchy Join  

Michael McGovernMarisa DelacruzNew report.T.Lodhi, P, Ackerman, C.Keck
CU_BAR_AD_00015New Stdnts w/non-NY ResidencyThis 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 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 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_TESTCAR_COMP TERM - Student Test Components Career Term Table Hierarchy Join

UNION 1:


- ADMRESIDENCY_APPL_DATA - Admission Application OFF - Official Residency Data Hierarchy Join

- ADM_APPL_PROG - Admission Applicant Program Hierarchy Join

- ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join

- CU_BIO_VW - Biographical Information View Hierarchy Join

Sub Query for Does Not Exist:

-STDNT_TEST_COMP - Student Test Components
Michael McGovern Michael McGovernMarisa DelacruzNew report.T.Lodhi, P, Ackerman, C.Keck
CU_BAR_AD_00016"No Show" New StudentsThis 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, Program, Plan, Action, Action DateTerm Units, Admit Term, Admit Type, Admit Term, Phone, EmailEmail 

-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

STDNT_

SRVC

CAR_

IND - Audit Record - SRVC_IND_DATA

TERM - Student Career Term Table Hierarchy Join

Michael McGovernMarisa DelacruzNew report.T.Lodhi, P, Ackerman, C.Keck
CU_BAR_AD_00017Transfers w/non-Posted CreditThis 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 Name, First Name, Middle Name, Empl ID, line#, Program, Plan, Term Units, Admit Term, Admit Type, Admit , Phone, Email, Source ID, Group, Term, ProgramClass#, PlanSubject, ActionGrade, PhoneComp, EmailUnits, 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

Sub Query for Does Not Exist:

-STDNT_GRPS_HIST - Student Groups History

UNION 1:

-ADM_APPL_DATA - Admission Application Data  Hierarchy Join  

-ADM_APPL_PROG - Admission Applicant Program  Hierarchy Join  

-STDNT_

TEST

CAR_

COMP

TERM - Student

Test Components

Career Term Table  Hierarchy Join  

-

SRVC

NAME_

IND

CURR_

DATA - Service Indicator Data
Michael McGovern

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 McGovernMildred FigueroaNew report.T.Lodhi, P, Ackerman, C.Keck
CU_BAR_AD_0002200018_32Immunization for Applicants Needing MTHPLThis is a list of applicants who need the TST/MTHPL service indicator/reason codeand their immunization records (or lack thereof).  Prompt on Institution, Career, Admit Term range and Admit Type (optional). Does not post indicator if student has NTMT student groupLast 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:

-

STDNT

ADM_

GRPS

APPL_

HIST - Student Groups History

DATA - Admission Application Data  Hierarchy Join  

-

STDNT

ADM_

TEST

APPL_

COMP - Student Test Components

PROG - Admission Applicant Program  Hierarchy Join  

-

SRVC

ADM_

IND

APPL_

DATA - Service Indicator Data
Gary HotkoDenyse Ramkaran

Modified report

 

Updated to take Student Group NTMT into account

D Ramkaran, G Hotko, C Keck, A Cox, P Ackerman, . Lodhi

PLAN - Admission Applicant Plan  Hierarchy Join  

-CU_BIO_VW - Biographical Information View  Hierarchy Join  

Sub Query for Does Not Exist:

-IMMUNIZATIONS - Immunizations
Michael McGovernMarisa Delacruz New report M Delacruz, M Figeroa, H Morales, A Kamruzzaman, C Keck, P Ackerman, T. Lodhi
 CU_BAR_AD_00019_000231Zicklin GRAD ApplicantsRemove TST/MTHPLThis 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 wellZicklin GRAD applicants.  Prompt on Institution, Career, Admit Term range.  Last Last Name, First Name, Middle Name, Empl ID, Group Name, Email , Admit Type, Admit Term, Program, Plan, Prog Actn, Phone, Email,

- ADM_APPL_DATA - Admission Application Data -STDNT_GRPS_HIST - Student Groups History Hierarchy Join

- CUADM_BIOAPPL_VW - Biographical Information View PROG - Admission Applicant Program Hierarchy Join

- SRVCADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join

- CU_BIO_VW - Biographical Information View IND_DATA - Service Indicator Data Hierarchy Join

Michael McGovern/Tabassum Lodhi Elaine Bernstein, Elizabeth FiginiDenyse RamkaranNew reportreport J Albanese, E Berstein, E Figini, P Davis-FridayD Ramkaran, G Hotko, C Keck, A CoxKamruzzaman, P Ackerman, T. Lodhi, P, AckermanLodhi 
CU_BAR_AD_0002400019_2Zick GRAD Applicants Needing TSTw/ WRITEDEINThis is a list of applicants who need the TST/WRITE service indicator/reason codeZicklin GRAD applicants with DEIN group.  Prompt on Institution, Career, Admit Term range and Admit Type (optional).Last Name, First Name, Middle Name, Empl ID, Admit Type, Admit Term, Program, Plan, ActionProg Actn, Phone, Email,

- ADM_APPL_DATA - Admission Application Data Hierarchy Join

- ADM_APPL_PROG - Admission Applicant Program Hierarchy Join

- ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join

- CU_BIO_VW - Biographical Information View

Sub Query for Does Not Exist:

-STDNT_GRPS_HIST - Student Groups History Hierarchy Join

-STDNT_TEST_COMP - Student Test Components

-SRVC_IND_DATA - Service Indicator Data Hierarchy Join

-STDNT_TEST_COMP - Student Test Components

Michael McGovernDenyse RamkaranNew report

Hierarchy Join

Tabassum LodhiKevin B. TaylorModified reportG Hotko, D Ramkaran,

P Ackerman, T. Lodhi

 

 CU_BAR_AD_00025_100020Applicants Needing TSTw/READMath Tests This is a list of new applicants who need the TST/READ service indicator/reason codehave math tests.  Prompt on Institution, Career, Admit Term range and range and Admit Type (optional). Last  Last Name, First Name, Middle Name, Empl ID, Program, Plan, Action, Action Date, Admit Type, Admit Term, Program, Plan, Action, 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

Sub Query for Does Not Exist:

-STDNT_GRPS_HIST - Student Groups History Hierarchy Join

-STDNT_TEST_COMP - Student Test Components Hierarchy Join

UNION 1:

- SRVCADM_INDAPPL_DATA - Service Indicator Data Admission Application Data Hierarchy Join

- ADM_APPL_PROG - Admission Applicant Program Hierarchy Join

- ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join

- CU_BIO_VW - Biographical Information View Hierarchy Join

Sub Query for Does Not Exist:

-STDNT_TEST_COMP - Student Test Components
Michael McGovernMcGovern Denyse RamkaranRamkaran  New report.G Hotko, D Ramkaran, P Ackerman, T LodhiT.Lodhi, P, Ackerman, C.Keck
 CUCU_BAR_AD_0002600021Applicants Needing ADIDw/o Service Indicators This is a pre-orientation query to create a list of students needing ADIDs and email idsIDlist of new applicants who are missing prompted service indicators/reason codes.  Prompt on Institution, Career, Admit Term range and Admit Type (optional).   Last Name, 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 BerryPatrick AckermanNew ReportMiddle 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 McGovernDenyse Ramkaran  New report  T.Lodhi, P, Ackerman, C.Keck P Ackerman, T. Lodhi
CU_BAR_AD_0002600022_2Applicants Needing ADIDMTHPLThis is a pre-orientation query to create a list of students needing ADIDs and email ids; Requires NPI access.IDapplicants who need the TST/MTHPL service indicator/reason code.  Prompt on Institution, Career, Admit Term range and Admit Type (optional).Last Name, 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 KamruzzamanPatrick AckermanModified ReportMiddle Name, Empl ID, Admit Type, Admit Term, Program, Plan, Action, Phone, Email,

- ADM_APPL_DATA - Admission Application Data Hierarchy Join

- ADM_APPL_PROG - Admission Applicant Program Hierarchy Join

- ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join

- CU_BIO_VW - Biographical Information View Hierarchy Join

Sub Query for Does Not Exist:

-STDNT_GRPS_HIST - Student Groups History

-STDNT_TEST_COMP - Student Test Components

-SRVC_IND_DATA - Service Indicator Data
Michael McGovernDenyse RamkaranNew report.D Ramkaran, G Hotko, C Keck, A Cox, P Ackerman, . Dixon Berry, P Ackerman, T Lodhi
CU_BAR_AD_002600022_4GRAD applicants needing ADIDThis is grad student with MATR in ADM_APPLID, 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 BerryPatrick AckermanNew report3Applicants 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).

 

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

-STDNT_TEST_COMP - Student Test Components

-SRVC_IND_DATA - Service Indicator Data
Gary HotkoDenyse Ramkaran

Modified report

 

Updated to take Student Group NTMT into account

D Ramkaran, G Hotko, C Keck, A Cox, P Ackerman, . Dixon Berry, Abu K. Patrick A., T Lodhi
CU_BAR_AD_00026_5Undergrad Applicants Needing ADID00023Remove TST/MTHPLThis is 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.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.  Last Name Last, First Name, Middle Name, Empl ID, Career, Admit Term, SSN, Prog Actn, Admit Type, Birthdate, ' ' Group Name, Email 

-STDNT_GRPS_HIST - Student Groups History

- 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

-PERSNLSRVC_FERPAIND_VW DATA - FERPA Personal Service Indicator 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 BerryPatrick AckermanModified ReportP Ackerman, T Lodhi

Michael McGovern/Tabassum LodhiDenyse RamkaranNew reportD Ramkaran, G Hotko, C Keck, A Cox, T.Lodhi, P, Ackerman
CU_BAR_AD_00024_2Applicants Needing TST/WRITEThis 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

CU_BAR_AD_00027Remove TST/WRITEThis 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 McGovernDenyse RamkaranNew reportG Hotko, D Ramkaran, P Ackerman, T Lodhi
CU_BAR_AD_00025_000281Remove Applicants Needing TST/READThis is a list of students/ applicants who have need the TST/READ service indicator/reason code and have a placement in an English student group as well.  Prompt on Institution  Michael McGovernDenyse RamkaranNew report CU_BAR_AD_00029_1Multiple Math PlacementsThis is a list of students who have multiple math placements. .  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 Hierarchy Join

ADM_APPL_PROG - Admission Applicant Program Hierarchy Join

ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join

- STDNT_GRPS_HIST - Student Groups History Hierarchy Join

- 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

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 McGovernGary HotkoDenyse RamkaranNew report G G Hotko, D Ramkaran, C Keck, A Cox, P Ackerman, T Lodhi
CU_BAR_AD_00030_100026Applicants Needing TST/MATHADIDThis is a list a pre-orientation query to create a list of students needing ADIDs and email idsID of applicants who need the TST/MATH service indicator/reason code.  Prompt on Institution, Career, Admit Term range and Admit Type (optional).Last Name, SSN, Last, 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 KamruzzamanGary HotkoNew reportBirthdate

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 BerryPatrick AckermanNew Report P Ackerman, T. Lodhi 
CU_BAR_AD_00026_000312Applicants Needing TST/SKILLADIDThis is a pre-orientation query to create a list of applicants who need the TST/SKILL service indicator/reason code.  Prompt on Institutionstudents needing ADIDs and email ids; Requires NPI access.ID, Career, Admit Term range and Admit Type (optional).Last Name, SSN, Last, First Name, Middle Name, Empl ID, Admit Type, Admit Term, Program, Plan, Action, Phone, Email-ADM_APPL_DATA - Admission Application Data Hierarchy Join
-ADM_APPL_PROG - Admission Applicant Program Hierarchy Join
-ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join
-CU_BIO_VW - Biographical Information View Hierarchy Join

Sub Query for Does Not Exist:

-STDNT_GRPS_HIST - Student Groups History Hierarchy Join

-STDNT_TEST_COMP - Student Test Components

-SRVC_IND_DATA - Service Indicator Data Hierarchy Join

-STDNT_TEST_COMP - Student Test Components

Michael McGovern/Tabassum LodhiGary HotkoNew report.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 KamruzzamanPatrick AckermanModified ReportDixon BerryG Hotko, P Ackerman, T Lodhi
CU_BAR_AD_000310026_14GRAD applicants needing ADIDThis is grad student with MATR in ADM_APPLID, 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 BerryPatrick AckermanNew reportDixon Berry, Abu K. Patrick A., T Lodhi
CU_BAR_AD_00026_5Undergrad Applicants Needing ADIDQuery 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

Applicants Needing TST/SKILLThis 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 Hierarchy Join

-CU_BIO_VW - Biographical Information View Hierarchy Join

Sub Query for Does Not Exist:

-SRVC_IND_DATA - Service Indicator Data Hierarchy Join

-STDNT_TEST_COMP - Student Test Components

-STDNT_TEST_COMP - Student Test Components

Sub Query for Exist:

-STDNT_TEST_COMP - Student Test Components

UNION 1:

-ADM_APPL_DATA - Admission Application Data Hierarchy Join

-ADM_APPL_PROG - Admission Applicant Program Hierarchy Join

-ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join

- CU_BIO_VW - Biographical Information View Hierarchy JoinSub Query for Does Not Exist:

-SRVCPERSNL_INDFERPA_DATA VW - Service Indicator FERPA Personal Data View Hierarchy Join

UNION 1:

-STDNTADM_TESTMC_COMP - Student Test Components

-STDNT_TEST_COMP - Student Test Components

Sub Query for Exist:

-STDNT_TEST_COMP - Student Test Components

UNION 2:

-ADM_APPL_DATA - Admission Application Data Hierarchy Join

-ADM_APPL_PROG - Admission Applicant Program Hierarchy Join

-ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join

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  -CU_BIO_VW - Biographical Information View Hierarchy Join

Sub Query for Does Not Exist:

 

-
SRVC
SCC_PERS_
IND
NI_
DATA - Service Indicator Data Hierarchy Join
QVW - Person National ID Query View

-STDNT_TEST_COMP - Student Test Components

-STDNT_TEST_COMP - Student Test Components

Sub Query for Exist:

 

-
STDNT
SCC_PERS_
TEST
NI_
COMP - Student Test Components
Tabassum Lodhi/Gary HotkoGary HotKoNew Report
QVW - Person National ID Query View
Dixon BerryPatrick AckermanModified ReportG Hotko, P Ackerman, T Lodhi
CU_BAR_AD_0003200027Remove TST/WRITEThis 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 McGovernDenyse RamkaranNew reportG Hotko, D Ramkaran
CU_BAR_AD_00028Remove TST/READThis 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 McGovernDenyse RamkaranNew report 
CU_BAR_AD_00029_1Multiple Math PlacementsThis is a list of students who have multiple math placements.  Last Applicants missing National IDStudents missing National ID and displaying LID or blanksLast Name, First Name, Middle Name, Empl ID, Career, Admit Term, Prog Actn, Admit Type, Birthdate, Full LID, Group NameInstitution, Group Name, Group Name, NID 

- STDNT_GRPS_HIST - Student Groups History Hierarchy Join

- STDNT_GRPS_HIST - Student Groups History 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_BIO_VW - Biographical Information View Hierarchy Join

- PERSNL_FERPA_VW - FERPA Personal Data View Hierarchy Join

- EXTERNAL_SYSTEM - External System ID's Hierarchy Join

- STDNT_GRPS - Student Groups Hierarchy Join

Abu KamruzzamanMichael McGovernGary HotkoPatrick AckermanNew report. G Hotko, D Ramkaran, Query Requires NPI
C Keck, M Figueroa, M DeLacruz, H Morales, A Rodriguez, T Nesdill, M Elbulok, P Ackerman, T Lodhi, M McGovernA Cox, P Ackerman, T Lodhi
CU_BAR_AD_00033Grad Applicant Data00030_1Applicants Needing TST/MATHThis is a list of applicants who need the TST/MATH service indicator/reason codeThis query selects applicants by program.  Prompt on Institution, Career, Program and Admit Term range and Admit Type (optional).Last Name, First Name, Middle Name, Empl ID, Gender, Approved Load, Action, Eff Date, Admit Type, Admit Term, Program, Plan, Sub-PlanAction, Preferred Phone, Home Address 1, Home Address 2, City, State, Postal, Country, Preferred Email, USA Visa, Other Country, Other Visa, Mil Status, Ethnicity

- ADM_MCAPPL_VW - Adm Appl Prog Vw for MC DATA - Admission Application Data Hierarchy Join

- ADM_APPL_PLAN PROG - Admission Applicant Plan Program Hierarchy Join

- ADM_APPL_SBPLAN PLAN - Admission Applicant Subplan Plan Hierarchy Join

- CU_BIO_VW - Biographical Information View Hierarchy Join

Sub Query for Does Not Exist:

-- SF_STDNT_PRSGRPS_VW HIST - SF Student Personal Data View Groups History Hierarchy Join

- ADDRESSES4STDNT_TEST_VW - Addresses View for Curr EffDT Hierarchy JoinCOMP - Student Test Components

- CITIZENSRVC_STSIND_TBL - Citizen Status Table DATA - Service Indicator Data Hierarchy Join

- CITIZENSTDNT_STSTEST_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 McGovernSarah GodwinNew report.

COMP - Student Test Components

Abu KamruzzamanGary HotkoNew report 
CU_BAR_AD_00031Applicants Needing TST/SKILLThis 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).Last Name, First Name, Middle Name, Empl ID, Admit Type, Admit Term, Program, Plan, Action, Phone, Email

-ADM_APPL_DATA - Admission Application Data Hierarchy Join

-ADM_APPL_PROG - Admission Applicant Program Hierarchy Join

-ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join

-CU_BIO_VW - Biographical Information View Hierarchy Join

Sub Query for Does Not Exist:

-STDNT_GRPS_HIST - Student Groups History Hierarchy Join

-STDNT_TEST_COMP - Student Test Components

-SRVC_IND_DATA - Service Indicator Data Hierarchy Join

-STDNT_TEST_COMP - Student Test Components

Michael McGovern/Tabassum LodhiGary HotkoNew report.G Hotko, P Ackerman, T 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_00031_000341Applicants in DEIN group   Abu KamruzzamanPatrick AckermanNew report CU_BAR_AD_00035Failed Tests/SEEK ApplicantsNeeding TST/SKILLThis 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)This query lists Baruch undergraduate applicants who are in the SEEK student group and who have taken but not passed the M1, M2, CATW or CNY-READING exams.  Prompt on the Admit Term range.Last Name, First Name, Middle Name, Empl ID, Admit Type, Admit Term, Program, Plan, Action, Phone, Email, Failed

-ADM_APPL_DATA - Admission Application Data Hierarchy Join

-ADM_APPL_PROG - Admission Applicant Program MC_VW - Adm Appl Prog Vw for MC 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:

-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

UNION1

UNION 1:

-ADM_

MC

APPL_

VW - Adm Appl Prog Vw for MC 

DATA - Admission Application Data Hierarchy Join

 

-

CU

ADM_

BIO

APPL_

VW - Biographical Information View 

PROG - Admission Applicant Program Hierarchy Join

 

-

STDNT

ADM_

GRPS

APPL_

HIST - Student Groups History 

PLAN - Admission Applicant Plan Hierarchy Join

UNION2:

-

ADM

CU_

MC

BIO_VW -

Adm Appl Prog Vw for MC  Hierarchy Join  -CU_BIO_VW - Biographical Information View  Hierarchy Join  

Biographical Information View Hierarchy Join

Sub Query for Does Not Exist:

-SRVC_IND_DATA - Service Indicator Data Hierarchy Join

-STDNT_

GRPS

TEST_

HIST

COMP - Student

Groups History  Hierarchy JoinSub Query for Does Not Exist:

Test Components

-STDNT_TEST_COMP - Student Test Components

Sub Query for Exist:

-STDNT_TEST_COMP - Student Test Components

UNION3

UNION 2:

-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 

_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

SRVC_

TEST

IND_

COMP - Student Test Components

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

Michael McGovernTabassum Lodhi/Gary HotkoGary HotKoDavid RosenNew reportReportG Hotko, M Morales, C Keck, A Kamruzzaman, P Ackerman, T . Lodhi
CU_BAR_AD_0003600032Missing Tests/SEEK Applicants missing National IDStudents missing National ID and displaying LID or blanksThis 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, Career, Admit Term, Prog Actn, Admit Type, PhoneBirthdate, Email, What's Missing Full LID, Group Name

Query Requires NPI
- ADM_MC_VW - Adm Appl Prog Vw for MC Hierarchy Join

- STDNTSCC_PERS_GRPSNI_HIST - Student Groups History 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

UNION1:

- PERSNL_FERPA_VW - FERPA Personal Data View Hierarchy Join

- EXTERNAL_SYSTEM - External System ID's - 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:

Abu KamruzzamanPatrick AckermanNew report.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_00033Grad Applicant DataThis 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_

- 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

- ADM_APPL_PLAN - Admission Applicant Plan Hierarchy Join

- STDNTADM_GRPSAPPL_HIST - Student Groups History SBPLAN - Admission Applicant Subplan Hierarchy Join

- CU_BIO_VW - Biographical Information View Hierarchy JoinSub Query for Does Not Exist:

- SF_STDNT_TESTPRS_COMP VW - Student Test Components

Michael McGovernDavid RosenNew reportM Morales, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi

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 McGovernSarah GodwinNew report.S Godwin, M Sultana, S Fajardo, D Battista, J Lee, C Keck, A Kamruzzaman, M Elbulok, T NesdillCU_BAR_AD_00037_2Orientation for TransfersThis 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_0003800034Applicants in DEIN group   Abu KamruzzamanPatrick AckermanNew report 
CU_BAR_AD_00035Failed Tests/SEEK ApplicantsThis 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.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, CountryFailed

- 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
_GRPS_HIST - Student Groups History Hierarchy Join

- ADDRESSES4_VW - Addresses View for Curr EffDT Hierarchy Join

_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  

Sub Query for Does Not Exist:

-STDNT_GRPS_HIST - Student Groups

History

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_00039SPA Grad Applicant CountThis query totals all SPA grad applicants (MPA, MSED, ADVCT programs) by their program, action and admit term.  Prompt on Institution and Admit Term rangeProgram, Action, Admit Term, Count of StudentsADM_MC_VW - Adm Appl Prog Vw for MCMichael McGovernSarah GodwinNew reportS Godwin, M Sultana, S Fajardo, D Battista, J Lee, C Keck, A Kamruzzaman, M Elbulok, T Nesdill, P Ackerman, T. Lodhi
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 McGovernDavid RosenNew reportM Morales, C Keck, A Kamruzzaman CU_BAR_AD_00039_DTL SPA Grad Applicant CountThis query totals all SPA grad applicants Detail (MPA, MSED, ADVCT programs) by their program, action and admit term.  Prompt on Institution and Admit Term rangeProgram, 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 McGovernSarah GodwinModified reportS Godwin, M Sultana, S Fajardo, D Battista, P Ackerman, T. Lodhi, Young J. Hah
CU_BAR_AD_00040Freshmen Appicants00036Missing Tests/SEEK ApplicantsThis query lists Baruch undergraduate applicants who are in the SEEK student group and who have not taken the M1, M2, CATW or CNY-READING examsThis is a list of new freshman applicants with SAT data, ethnicity, gender, etc.  Prompt on Institution and the Admit Term range.Last Name, First Name, Middle NameNam, Empl ID, Sex, Action, Reason, Program, Plan, Admit Type, Phone, Email, Country, Address 1, Address 2, City, State, Postal, Lst School, Grad Dt, HS Name, EthnicityWhat'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

- ADDRESSES4_VW - Addresses View for Curr EffDT Hierarchy Join

Sub Query for Does Not Exist:

-STDNT_TEST_COMP - Student Test Components

UNION1:- EXT_ORG_VW - External Organization Tbl View Hierarchy Join

- ADM_APPLMC_PLAN - Admission Applicant Plan VW - Adm Appl Prog Vw for MC Hierarchy Join

- SF_ STDNT_PRSGRPS_VW HIST - SF Student Personal Data View Groups History Hierarchy Join

- SCCCU_ETHBIO_GRP_VW - Ethnic Diversity Biographical Information View Hierarchy Join

Sub Query for Does Not Exist:

- SCCSTDNT_ETHTEST_COMP - Student Test Components


UNION2:

- ADM_MC_VW - Adm Appl Prog Vw for MC GRP_VW - Ethnic Diversity Hierarchy Join
- SCC_ETH_GRP_VW - Ethnic Diversity Hierarchy Join

- SCCSTDNT_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 MessingerNew report 

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 McGovernDavid RosenNew reportM Morales, C Keck, A Kamruzzaman, P Ackerman, T. Lodhi
CU_BAR_AD_00037_2Orientation for TransfersThis 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_00038Orientation 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_00039SPA Grad Applicant CountThis query totals all SPA grad applicants (MPA, MSED, ADVCT programs) by their program, action and admit term.  Prompt on Institution and Admit Term rangeProgram, Action, Admit Term, Count of StudentsADM_MC_VW - Adm Appl Prog Vw for MCMichael McGovernSarah GodwinNew reportS 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 CountThis query totals all SPA grad applicants Detail (MPA, MSED, ADVCT programs) by their program, action and admit term.  Prompt on Institution and Admit Term rangeProgram, 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 McGovernSarah GodwinModified reportS Godwin, M Sultana, S Fajardo, D Battista, P Ackerman, T. Lodhi, Young J. Hah
CU_BAR_AD_00040Freshmen ApplicantsThis 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 MessingerNew 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_CLASSPass Class and in Student GroupCreates 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 HotkoGary hotkoNew ReportGary 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