Banner Commencement Groups

Owned by Former user (Deleted)
Last updated: May 03, 2023 by Pamela Dart

This logic is also contained in the f_cc_get_grad_order function.  They should be kept in sync.  This is used for commencement report regr143 and above.                                             (regr043 is old and should not be used.)

All college Honors groups as 00.

Sort NumberProgram/MajorTitle
1
All College Honors - College of Arts and Sciences
2program = 'AA-AS' Associate of Arts
3program in ('BA-AS','AS-BA-DUAL') Bachelor of Arts - Arts and Sciences
4program in ('BS-AS','AS-BS-DUAL') and major1 in ('ABEC') Bachelor of Science - Animal Behavior, Ecology and Conservation
5program in ('BS-AS','AS-BS-DUAL') and major1 in ('BIO','ENV','DSPB') Bachelor of Science - Biology and Environmental Sciences 
6program in ('BS-AS','AS-BS-DUAL') and major1 in ('BCH','CHM','DSPC','CHMH','CHMA','MDT','PHY','BCHA','MLSC','EN32','CHMB','DSPB') Bachelor of Science - Biochemistry, Chemistry, Clinical Laboratory Science, and Physics
7program IN ('BS-AS','AS-BS-DUAL') and major1 in ('CSC','CSC1','DC1C','DCSC','DS1C','DCSC') Bachelor of Science - Computer Science
8program in ('BS-AS','AS-BS-DUAL') and major1 in ('CRJ1') Bachelor of Science - Criminal Justice
9program in ('BS-AS','AS-BS-DUAL') and major1 in ('DMA','JRN') Bachelor of Science - Digital Media Arts
10program in ('BS-AS','AS-BS-DUAL') and major1 in ('IMC') Bachelor of Science - Integrated Marketing Communication
11program in ('BS-AS','AS-BS-DUAL') and major1 in ('PSY1') Bachelor of Science - Psychology
12program in ('BS-AS','AS-BS-DUAL') and major1 in ('SSC') Bachelor of Science - Social Sciences
13
All College Honors - School of Education and Human Services and Wehle School of Business
14program in ('BA-ED','BA-EDAD','BA-EDCH','BA-EDEC','BA-EDEC-EDCH', 'ED-BA-DUAL') Bachelor of Arts - School of Education and Human Services
18program in ('BS-ED','BS-SPEC-EDCH','BS-SPEC-EDEC','ED-BS-DUAL')  Bachelor of Arts - School of Education and Human Services
15program = 'BS-PHED' and major1 in  ('SPEX','HEWE') Bachelor of Science - Health and Wellness, Sports and Exercise Health Care   
16program in ('BS-ED') and major1 in ('HUSR') Bachelor of Science - Human Services, Physical Education and Health, Physical Education Sport Pedagogy
16program in ('BS-PHED','ED-BS-DUAL') and major1 in ('PEHL','PESP','PHED') Bachelor of Science - Human Services, Physical Education and Health, Physical Education Sport Pedagogy
17program in ('BS-ED') and major1 IN ('PS1') Bachelor of Science - Professional Technical Studies
19program in ('BA-BU', 'BU-BA-DUAL') and major1 in ('ECON') Bachelor of Arts - School of Business
20program in ('BS-BU','BU-BS-DUAL') Bachelor of Science - School of Business
21program = 'MS-AS' and major1 in ('ANZO') Master of Science - Anthrozoology
22program = 'MS-AS' and major1 in ('CYB','DCY1','DCY') Master of Science - Cybersecurity
23program = 'MS-AS' and major1 in ('DAT') Master of Science - Data Analytics
24 program = 'ADV-CERT-BU' and  major1 in ('DATC')  Advanced Certificate - Data Analytics
25program = 'MS-ED' and major1 LIKE 'NTR%' Master of Science - Applied Nutrition
26program = 'MS-ED' and major1 in ('SAC','CLMH') Master of Science - Counseling and Human Services
27program = 'MS-ED' and major1 in ('EDAO','OSBD') Master of Science - Educational Leadership    
28program = 'MS-ED' and   major1 = 'HHP' Master of Science - Health and Human Performance
29program = 'MS-ED' and   major1 = 'HESA' Master of Science - Higher Education & Student Affairs Administration    
30program = 'MS-ED' and major1 in ('ITC','ITC2')  Master of Science - Instructional Technologies and Curriculum Design
31program = 'MS-ED' and major1 IN ('ONPA') Master of Science - Physical Education and Athletics  
32program = 'MS-ED' and major1 IN ('PAS') Master of Science - Physician Assistant Studies
33 major1 like 'RES%'  Master of Science - Respiratory Care
34program = 'MS-ED' and major1 LIKE 'ONE%' Master of Science - Teaching English to Speakers of Other Languages
35program = 'MSED-ED' and major1 in ('EDG','EDCH','EDAD','EDBM','AUE', 'CUE','ECU','CHTG','EADG', 'DSWB','DSWC','DSWE','DSWH','DSWM','DSWP') Master of Science in Education - Adolescence Education, Business Educataion, Childhood Education, General Education
36program = 'MSED-ED' and major1 in ('EDDI') Master of Science in Education - Differentiated Instruction
37program = 'MSED-ED' and major1 in  ('LTCY','ONLT') Master of Science in Education - Literacy
38program = 'MSED-ED' and major1 in ('PHED','ONPE') Master of Science in Education - Physical Education
39program IN ('MSED-ED','MSED-ED' ) and major1 in ('WNYT','SPM7','SPGN','SPGN','SPG1','SPEA','SPE7','SPM1') Master of Science in Education - Special Education   
40program = 'ADV-CERT-ED' and  major1 in ('CLMC')  Advanced Certificate - Clinical Mental Health Counseling
41program = 'ADV-CERT-ED' and  major1 in ('COCC')  Advanced Certificate - Coaching 
42program = 'ADV-CERT-ED' and  major1 in ('ITCC')  Advanced Certificate - Instructional Technologies and Curriculum Design 
43program = 'ADV-CERT-ED' and  major1 in ('ONSB')  Advanced Certificate - School Building Leader
44program = 'ADV-CERT-ED' and  major1 in ('SACC')  Advanced Certificate - School Counseling 
45program = 'ADV-CERT-ED' and  major1 in ('SLDC')  Advanced Certificate - School District Business Leader
46program = 'ADV-CERT-ED' and  major1 in ('ONSD')  Advanced Certificate - School District Leader
47program = 'MBA-BU' and  major1 in ( 'MBAO','MBA', 'DMAA','MBAA') Master of Business Administration
48program = 'MBA-BU' AND major1 = 'MBAP'  Master of Business Administration in Professional Accounting 
49program = 'MS-BU' and  major1 in ('BANM')  Master of Science - Business Analytics 
50program = 'MS-BU' and  major1 = 'FING' Master of Science - Finance
51program = 'MS-BU' and  major1 in ('MSA' ,'ONSA')  Master of Science - Sport Administration 
52program = 'MS-BU' and  major1 in ('SPD')  Master of Science - Sport Product Development   
53program = 'ADV-CERT-ED' and  major1 in ('BSC2')  Advanced Certificate - Advanced Business Skills
54program = 'ADV-CERT-ED' and  major1 in ('BUSC')  Advanced Certificate - Business  
55program = 'ADV-CERT-BU' and  major1 in ('BANC')  Advanced Certificate - Business Analytics   
56program = 'ADV-CERT-ED' and  major1 in ('BSC1')  Advanced Certificate - Business Skills  
57program = 'ADV-CERT-ED' and  major1 in ('GSCC')  Advanced Certificate - Global Supply Chain Management     
58program = 'ADV-CERT-ED' and  major1 in ('FINC')  Advanced Certificate - Finance  
59program = 'ADV-CERT-ED' and  major1 in ('MKTC')  Advanced Certificate - Marketing Â