Requestor: Helaine J. Korn - Management Department

 

Request:

Requirements for membership as an undergraduate students include:

  1. Have completed at least 30 credits at Baruch College
  2. Hold at least a cumulative 3.25 GPA in the credits taken at Baruch College
  3. Have completed MGT 3120 and MGT 3121 with a grade of B or better in each
  4. Have completed MGT 3300 or MGT 3500 or MGT 3960 with a grade of B or better
  5. Have completed at least one additional MGT prefix course with the grade of B or better
  6. If transfer student exempted from any or all of required 3000 level MGT courses, have completed at least 4 MGT designated courses with a grade of B or better in each

Requirements for membership as a graduate student include:

  1. Have completed at least 24 credits at Baruch College
  2. Hold at least a cumulative 3.5 GPA in the credits completed at Baruch College
  3. Have completed MGT 9600 and MGT 9301 and MGT 9200 with a grade of B or better
  4. Have completed at least one additional MGT prefix course with a grade of B or better

 

In each list I will need emplid, First name, last name, email address, program, major, cum gpa, #loc credits, #tsf credits, #tot credits, address, city, state, postal code.

Please let me know if it is possible to generate and run these queries and/or if any additional information is required.

 

Process:

Undergraduate

Query Name - Tab_CU_SR_00030_6

  1. Academic  Plan is MGT-BBA
  2. Cumulative GPA is 3.25
  3. Tatal credits is 30
  4. subject area is in list MGT-BPL

Graduate 

Query Name - Tab_CU_BAM_SR_00030_4Planer4

  1.  Academic Plans are MGT-MBA, ILR,MS,ENTER-MS
  2. Cumulative GPA is 3.5
  3. Tatal credits is 24
  4. subject area is in list MGT-BUS

 

# Transfer credits called as unit passed, no GPA. 

Query's in progress, when completed titles of query's will change.

  • No labels