Definitions
Follow this link to our data dictionary definition for Degree/certificate Seeking Student and Non-degree-seeking Student.
The most commonly used field
UM_DEGREE_NONDEG field is widely used to determine whether a student is degree/certificate-seeking or not. The SQL code is the following:
The code for UM_DEGREE_NONDEG field (The alias A is UM_STUD_EXTRACT.)
CASE
WHEN A.INSTITUTION = 'UMS02' and A.DEGREE = 'CGS' THEN 'Degree'
WHEN A.INSTITUTION = 'UMS06' and A.ACAD_PLAN LIKE '%-CERT' THEN 'Degree'
WHEN A.INSTITUTION = 'UMS06' and A.ACAD_PLAN LIKE '%-CGS' THEN 'Degree'
WHEN A.ACAD_PLAN = 'IEI' AND A.INSTITUTION = 'UMS05' THEN 'Non-Degree'
WHEN A.ACAD_PLAN LIKE 'VIS%' AND A.INSTITUTION = 'UMS05' THEN 'Non-Degree'
WHEN A.ACAD_PROG_PRIMARY IN ('NDEC', 'NECN', 'NDUG', 'DIST', 'P-NON', 'NONCR', 'NDPR', 'NDGR', 'GRNON', 'NDPN', 'NSEU', 'NDUMA', 'APNDU') THEN 'Non-Degree'
WHEN A.ACAD_PROG_PRIMARY LIKE '%UN' THEN 'Non-Degree'
WHEN A.ACAD_PROG_PRIMARY LIKE '%GN' THEN 'Non-Degree'
WHEN A.ACAD_CAREER = 'NCRD' AND A.INSTITUTION = 'UMS07' THEN 'Non-Degree'
ELSE 'Degree'
END DEGREE_NONDEGREE
Jump to the Other Related Code
These fields use degree/non-degree coding logic in UM_STUD_EXT_VW and UM_STUD_CENS_VW. Select a field name below to jump to the SQL code. (The alias A is UM_STUD_EXTRACT.)
- /*1- UM_STUDENT_LEVEL*/
- /*2- UM_STUD_LEVEL_SORT*/
- /*3- UM_STUD_LEVEL_SUM*/
- /*4- UM_STD_LVL_SUM_SRT*/
- /*5- UM_STD_LVL_SUM_UG*/
- /*6- UM_NEASC_LEVEL*/
- /*7- UM_NEASC_LEVEL_SRT*/
- /*8- UM_ADMIT_TYPE_DESC*/
- /*9- UM_ADMIT_TYPE_SORT*/
- /*10- UM_ADMIT_TYPE_D_ND*/
- /*11- UM_FIRST_TIME*/
- /*12- UM_FIRST_TIME_NDEG */
/*1- UM_STUDENT_LEVEL*/
CASE WHEN A.INSTITUTION = 'UMS02' AND A.DEGREE = 'CGS' THEN 'Graduate'
WHEN A.INSTITUTION = 'UMS06' AND A.ACAD_PLAN LIKE '%-CERT' THEN 'Baccalaureate'
WHEN A.INSTITUTION = 'UMS06' AND A.ACAD_PLAN LIKE '%-CGS' THEN 'Graduate'
WHEN A.INSTITUTION = 'UMS05' AND A.ACAD_PLAN = 'IEI' THEN 'Non-Degree Undergraduate'
WHEN A.INSTITUTION = 'UMS05' AND A.ACAD_PLAN LIKE 'VIS%' AND A.ACAD_CAREER = 'GRAD' THEN 'Non-Degree Graduate'
WHEN A.INSTITUTION = 'UMS05' AND A.ACAD_PLAN LIKE 'VIS%' AND A.ACAD_CAREER = 'UGRD' THEN 'Non-Degree Undergraduate'
WHEN A.INSTITUTION = 'UMS06' AND A.ACAD_PROG_PRIMARY in ('NDPR', 'NDPN') THEN 'Non-Degree Law'
WHEN A.ACAD_PROG_PRIMARY IN ('NDEC', 'NECN', 'NDUG', 'DIST', 'P-NON', 'NONCR', 'NDPR', 'NSEU', 'NDUMA', 'APNDU') THEN 'Non-Degree Undergraduate'
WHEN A.ACAD_PROG_PRIMARY IN ('NDGR', 'GRNON') THEN 'Non-Degree Graduate'
WHEN A.ACAD_PROG_PRIMARY LIKE '%UN' THEN 'Non-Degree Undergraduate'
WHEN A.ACAD_PROG_PRIMARY LIKE '%GN' THEN 'Non-Degree Graduate'
WHEN A.LEVEL_LOAD_RULE in ('UG2YR', 'UGAS', 'UGA', 'AA') THEN 'Associate'
WHEN A.LEVEL_LOAD_RULE in ('UG4YR', 'UG') THEN 'Baccalaureate'
WHEN A.Acad_Level_Bot = 'PHD' THEN 'Graduate'
WHEN A.LEVEL_LOAD_RULE in ('GR', 'GRAD') THEN 'Graduate'
WHEN A.Level_Load_Rule = 'LAW' THEN 'Law'
WHEN A.ACAD_CAREER = 'NCRD' AND A.INSTITUTION = 'UMS07' THEN 'Non-Degree Undergraduate'
WHEN A.Acad_Career = 'UGRD' THEN 'Baccalaureate'
WHEN A.Acad_Career = 'GRAD' THEN 'Graduate'
WHEN A.Acad_Career = 'LAW' THEN 'Law'
WHEN A.Acad_Career = 'PBAC' THEN 'Baccalaureate'
ELSE 'Other'
END
/*2- UM_STUD_LEVEL_SORT*/
CASE WHEN A.INSTITUTION = 'UMS02' AND A.DEGREE = 'CGS' THEN '13'
WHEN A.INSTITUTION = 'UMS06' AND A.ACAD_PLAN LIKE '%-CERT' THEN '11'
WHEN A.INSTITUTION = 'UMS06' AND A.ACAD_PLAN LIKE '%-CGS' THEN '13'
WHEN A.INSTITUTION = 'UMS05' AND A.ACAD_PLAN = 'IEI' THEN '12'
WHEN A.INSTITUTION = 'UMS05' AND A.ACAD_PLAN LIKE 'VIS%' AND A.ACAD_CAREER = 'GRAD' THEN '14'
WHEN A.INSTITUTION = 'UMS05' AND A.ACAD_PLAN LIKE 'VIS%' AND A.ACAD_CAREER = 'UGRD' THEN '12'
WHEN A.INSTITUTION = 'UMS06' AND A.ACAD_PROG_PRIMARY in ('NDPR', 'NDPN') THEN '16'
WHEN A.ACAD_PROG_PRIMARY IN ('NDEC', 'NECN', 'NDUG', 'DIST', 'P-NON', 'NONCR', 'NDPR', 'NSEU', 'NDUMA', 'APNDU') THEN '12'
WHEN A.ACAD_PROG_PRIMARY IN ('NDGR', 'GRNON') THEN '14'
WHEN A.ACAD_PROG_PRIMARY LIKE '%UN' THEN '12'
WHEN A.ACAD_PROG_PRIMARY LIKE '%GN' THEN '14'
WHEN A.LEVEL_LOAD_RULE in ('UG2YR', 'UGAS', 'UGA', 'AA') THEN '10'
WHEN A.LEVEL_LOAD_RULE in ('UG4YR', 'UG') THEN '11'
WHEN A.Acad_Level_Bot = 'PHD' THEN '13'
WHEN A.LEVEL_LOAD_RULE in ('GR', 'GRAD') THEN '13'
WHEN A.Level_Load_Rule = '15' THEN '15'
WHEN A.ACAD_CAREER = 'NCRD' AND A.INSTITUTION = 'UMS07' THEN '12'
WHEN A.Acad_Career = 'UGRD' THEN '11'
WHEN A.Acad_Career = 'GRAD' THEN '13'
WHEN A.Acad_Career = '15' THEN '15'
WHEN A.Acad_Career = 'PBAC' THEN '11'
ELSE '20'
END
/*3- UM_STUD_LEVEL_SUM*/
CASE WHEN A.INSTITUTION = 'UMS02' AND A.DEGREE = 'CGS' THEN 'Graduate'
WHEN A.INSTITUTION = 'UMS06' AND A.ACAD_PLAN LIKE '%-CERT' THEN 'Undergraduate'
WHEN A.INSTITUTION = 'UMS06' AND A.ACAD_PLAN LIKE '%-CGS' THEN 'Graduate'
WHEN A.INSTITUTION = 'UMS05' AND A.ACAD_PLAN = 'IEI' THEN 'Undergraduate'
WHEN A.INSTITUTION = 'UMS05' AND A.ACAD_PLAN LIKE 'VIS%' AND A.ACAD_CAREER = 'GRAD' THEN 'Graduate'
WHEN A.INSTITUTION = 'UMS05' AND A.ACAD_PLAN LIKE 'VIS%' AND A.ACAD_CAREER = 'UGRD' THEN 'Undergraduate'
WHEN A.INSTITUTION = 'UMS06' AND A.ACAD_PROG_PRIMARY in ('NDPR', 'NDPN') THEN 'Law'
WHEN A.ACAD_PROG_PRIMARY IN ('NDEC', 'NECN', 'NDUG', 'DIST', 'P-NON', 'NONCR', 'NDPR', 'NSEU', 'NDUMA', 'APNDU') THEN 'Undergraduate'
WHEN A.ACAD_PROG_PRIMARY IN ('NDGR', 'GRNON') THEN 'Graduate'
WHEN A.ACAD_PROG_PRIMARY LIKE '%UN' THEN 'Undergraduate'
WHEN A.ACAD_PROG_PRIMARY LIKE '%GN' THEN 'Graduate'
WHEN A.LEVEL_LOAD_RULE in ('UG2YR', 'UGAS', 'UGA', 'AA') THEN 'Undergraduate'
WHEN A.LEVEL_LOAD_RULE in ('UG4YR', 'UG') THEN 'Undergraduate'
WHEN A.Acad_Level_Bot = 'PHD' THEN 'Graduate'
WHEN A.LEVEL_LOAD_RULE in ('GR', 'GRAD') THEN 'Graduate'
WHEN A.Level_Load_Rule = 'LAW' THEN 'Law'
WHEN A.ACAD_CAREER = 'NCRD' AND A.INSTITUTION = 'UMS07' THEN 'Undergraduate'
WHEN A.Acad_Career = 'UGRD' THEN 'Undergraduate'
WHEN A.Acad_Career = 'GRAD' THEN 'Graduate'
WHEN A.Acad_Career = 'LAW' THEN 'Law'
WHEN A.Acad_Career = 'PBAC' THEN 'Undergraduate'
ELSE 'Other'
END
/*4- UM_STD_LVL_SUM_SRT*/
CASE WHEN A.INSTITUTION = 'UMS02' AND A.DEGREE = 'CGS' THEN '11'
WHEN A.INSTITUTION = 'UMS06' AND A.ACAD_PLAN LIKE '%-CERT' THEN '10'
WHEN A.INSTITUTION = 'UMS06' AND A.ACAD_PLAN LIKE '%-CGS' THEN '11'
WHEN A.INSTITUTION = 'UMS05' AND A.ACAD_PLAN = 'IEI' THEN '10'
WHEN A.INSTITUTION = 'UMS05' AND A.ACAD_PLAN LIKE 'VIS%' AND A.ACAD_CAREER = 'GRAD' THEN '11'
WHEN A.INSTITUTION = 'UMS05' AND A.ACAD_PLAN LIKE 'VIS%' AND A.ACAD_CAREER = 'UGRD' THEN '10'
WHEN A.INSTITUTION = 'UMS06' AND A.ACAD_PROG_PRIMARY in ('NDPR', 'NDPN') THEN '12'
WHEN A.ACAD_PROG_PRIMARY IN ('NDEC', 'NECN', 'NDUG', 'DIST', 'P-NON', 'NONCR', 'NDPR', 'NSEU', 'NDUMA', 'APNDU') THEN '10'
WHEN A.ACAD_PROG_PRIMARY IN ('NDGR', 'GRNON') THEN '11'
WHEN A.ACAD_PROG_PRIMARY LIKE '%UN' THEN '10'
WHEN A.ACAD_PROG_PRIMARY LIKE '%GN' THEN '11'
WHEN A.LEVEL_LOAD_RULE in ('UG2YR', 'UGAS', 'UGA', 'AA') THEN '10'
WHEN A.LEVEL_LOAD_RULE in ('UG4YR', 'UG') THEN '10'
WHEN A.Acad_Level_Bot = 'PHD' THEN '11'
WHEN A.LEVEL_LOAD_RULE in ('GR', 'GRAD') THEN '11'
WHEN A.Level_Load_Rule = '12' THEN '12'
WHEN A.ACAD_CAREER = 'NCRD' AND A.INSTITUTION = 'UMS07' THEN '10'
WHEN A.Acad_Career = 'UGRD' THEN '10'
WHEN A.Acad_Career = 'GRAD' THEN '11'
WHEN A.Acad_Career = '12' THEN '12'
WHEN A.Acad_Career = 'PBAC' THEN '10'
ELSE '20'
END
/*5- UM_STD_LVL_SUM_UG*/
CASE WHEN A.INSTITUTION = 'UMS02' AND A.DEGREE = 'CGS' THEN 'Graduate'
WHEN A.INSTITUTION = 'UMS06' AND A.ACAD_PLAN LIKE '%-CERT' THEN 'Undergraduate'
WHEN A.INSTITUTION = 'UMS06' AND A.ACAD_PLAN LIKE '%-CGS' THEN 'Graduate'
WHEN A.INSTITUTION = 'UMS05' AND A.ACAD_PLAN = 'IEI' THEN 'Undergraduate'
WHEN A.INSTITUTION = 'UMS05' AND A.ACAD_PLAN LIKE 'VIS%' AND A.ACAD_CAREER = 'GRAD' THEN 'Graduate'
WHEN A.INSTITUTION = 'UMS05' AND A.ACAD_PLAN LIKE 'VIS%' AND A.ACAD_CAREER = 'UGRD' THEN 'Undergraduate'
WHEN A.INSTITUTION = 'UMS06' AND A.ACAD_PROG_PRIMARY in ('NDPR', 'NDPN') THEN 'Graduate'
WHEN A.ACAD_PROG_PRIMARY IN ('NDEC', 'NECN', 'NDUG', 'DIST', 'P-NON', 'NONCR', 'NDPR', 'NSEU', 'NDUMA', 'APNDU') THEN 'Undergraduate'
WHEN A.ACAD_PROG_PRIMARY IN ('NDGR', 'GRNON') THEN 'Graduate'
WHEN A.ACAD_PROG_PRIMARY LIKE '%UN' THEN 'Undergraduate'
WHEN A.ACAD_PROG_PRIMARY LIKE '%GN' THEN 'Graduate'
WHEN A.LEVEL_LOAD_RULE in ('UG2YR', 'UGAS', 'UGA', 'AA') THEN 'Undergraduate'
WHEN A.LEVEL_LOAD_RULE in ('UG4YR', 'UG') THEN 'Undergraduate'
WHEN A.Acad_Level_Bot = 'PHD' THEN 'Graduate'
WHEN A.LEVEL_LOAD_RULE in ('GR', 'GRAD') THEN 'Graduate'
WHEN A.Level_Load_Rule = 'Graduate' THEN 'Graduate'
WHEN A.ACAD_CAREER = 'NCRD' AND A.INSTITUTION = 'UMS07' THEN 'Undergraduate'
WHEN A.Acad_Career = 'UGRD' THEN 'Undergraduate'
WHEN A.Acad_Career = 'GRAD' THEN 'Graduate'
WHEN A.Acad_Career = 'Graduate' THEN 'Graduate'
WHEN A.Acad_Career = 'PBAC' THEN 'Undergraduate'
ELSE 'Other'
END
/*6- UM_NEASC_LEVEL*/
CASE WHEN A.INSTITUTION = 'UMS02' AND A.DEGREE = 'CGS' THEN 'Masters'
WHEN A.INSTITUTION = 'UMS06' AND A.ACAD_PLAN LIKE '%-CERT' THEN 'Baccalaureate'
WHEN A.INSTITUTION = 'UMS06' AND A.ACAD_PLAN LIKE '%-CGS' THEN 'Masters'
WHEN A.INSTITUTION = 'UMS05' AND A.ACAD_PLAN = 'IEI' THEN 'Non-Degree Undergraduate'
WHEN A.INSTITUTION = 'UMS05' AND A.ACAD_PLAN LIKE 'VIS%' AND A.ACAD_CAREER = 'GRAD' THEN 'Non-Degree Graduate'
WHEN A.INSTITUTION = 'UMS05' AND A.ACAD_PLAN LIKE 'VIS%' AND A.ACAD_CAREER = 'UGRD' THEN 'Non-Degree Undergraduate'
WHEN A.INSTITUTION = 'UMS06' AND A.ACAD_PROG_PRIMARY in ('NDPR', 'NDPN') THEN 'Non-Degree Law'
WHEN A.ACAD_PROG_PRIMARY IN ('NDEC', 'NECN', 'NDUG', 'DIST', 'P-NON', 'NONCR', 'NDPR', 'NSEU', 'NDUMA', 'APNDU') THEN 'Non-Degree Undergraduate'
WHEN A.ACAD_PROG_PRIMARY IN ('NDGR', 'GRNON') THEN 'Non-Degree Graduate'
WHEN A.ACAD_PROG_PRIMARY LIKE '%UN' THEN 'Non-Degree Undergraduate'
WHEN A.ACAD_PROG_PRIMARY LIKE '%GN' THEN 'Non-Degree Graduate'
WHEN A.LEVEL_LOAD_RULE in ('UG2YR', 'UGAS', 'UGA', 'AA') THEN 'Associate'
WHEN A.LEVEL_LOAD_RULE in ('UG4YR', 'UG') THEN 'Baccalaureate'
WHEN A.Acad_Level_Bot = 'PHD' THEN 'Doctorate'
WHEN A.LEVEL_LOAD_RULE in ('GR', 'GRAD') THEN 'Masters'
WHEN A.Level_Load_Rule = 'LAW' THEN 'Law'
WHEN A.ACAD_CAREER = 'NCRD' AND A.INSTITUTION = 'UMS07' THEN 'Non-Degree Undergraduate'
WHEN A.Acad_Career = 'UGRD' THEN 'Baccalaureate'
WHEN A.Acad_Career = 'GRAD' THEN 'Masters'
WHEN A.Acad_Career = 'LAW' THEN 'Law'
WHEN A.Acad_Career = 'PBAC' THEN 'Baccalaureate'
ELSE 'Other'
END
/*7- UM_NEASC_LEVEL_SRT*/
CASE WHEN A.INSTITUTION = 'UMS02' AND A.DEGREE = 'CGS' THEN '13'
WHEN A.INSTITUTION = 'UMS06' AND A.ACAD_PLAN LIKE '%-CERT' THEN '11'
WHEN A.INSTITUTION = 'UMS06' AND A.ACAD_PLAN LIKE '%-CGS' THEN '13'
WHEN A.INSTITUTION = 'UMS05' AND A.ACAD_PLAN = 'IEI' THEN '12'
WHEN A.INSTITUTION = 'UMS05' AND A.ACAD_PLAN LIKE 'VIS%' AND A.ACAD_CAREER = 'GRAD' THEN '16'
WHEN A.INSTITUTION = 'UMS05' AND A.ACAD_PLAN LIKE 'VIS%' AND A.ACAD_CAREER = 'UGRD' THEN '12'
WHEN A.INSTITUTION = 'UMS06' AND A.ACAD_PROG_PRIMARY in ('NDPR', 'NDPN') THEN '17'
WHEN A.ACAD_PROG_PRIMARY IN ('NDEC', 'NECN', 'NDUG', 'DIST', 'P-NON', 'NONCR', 'NDPR', 'NSEU', 'NDUMA', 'APNDU') THEN '12'
WHEN A.ACAD_PROG_PRIMARY IN ('NDGR', 'GRNON') THEN '16'
WHEN A.ACAD_PROG_PRIMARY LIKE '%UN' THEN '12'
WHEN A.ACAD_PROG_PRIMARY LIKE '%GN' THEN '16'
WHEN A.LEVEL_LOAD_RULE in ('UG2YR', 'UGAS', 'UGA', 'AA') THEN '10'
WHEN A.LEVEL_LOAD_RULE in ('UG4YR', 'UG') THEN '11'
WHEN A.Acad_Level_Bot = 'PHD' THEN '14'
WHEN A.LEVEL_LOAD_RULE in ('GR', 'GRAD') THEN '13'
WHEN A.Level_Load_Rule = 'LAW' THEN '15'
WHEN A.ACAD_CAREER = 'NCRD' AND A.INSTITUTION = 'UMS07' THEN '12'
WHEN A.Acad_Career = 'UGRD' THEN '11'
WHEN A.Acad_Career = 'GRAD' THEN '13'
WHEN A.Acad_Career = 'LAW' THEN '15'
WHEN A.Acad_Career = 'PBAC' THEN '11'
ELSE '20'
END
/*8- UM_ADMIT_TYPE_DESC*/
CASE WHEN (A.INSTITUTION = 'UMS02' AND A.DEGREE = 'CGS') OR (A.INSTITUTION = 'UMS06' AND A.ACAD_PLAN LIKE '%-CERT') OR (A.INSTITUTION = 'UMS06' AND A.ACAD_PLAN LIKE '%-CGS') THEN
CASE WHEN (A.Admit_Term = Strm OR (to_number(A.STRM) - to_number(ltrim(A.ADMIT_TERM, ' '))) = 80) THEN
CASE WHEN A.Institution = 'UMS05' AND A.Prog_Reason = 'RADM' THEN 'Readmit Student'
WHEN A.ADMIT_TYPE IN ('FYR', 'EFY') AND (A.ACAD_LEVEL_BOT in ('01','10') or A.Um_Last_Sch_Type IN ('SCD', 'SHS')) THEN 'First-Time Undergraduate Student'
WHEN A.ADMIT_TYPE IN ('GRD', 'GR6', 'GR2', 'DAT') THEN 'Graduate Student'
WHEN A.ADMIT_TYPE = 'LAW' AND A.ACAD_LEVEL_BOT = 'L1' THEN 'Law Student'
WHEN A.ADMIT_TYPE = 'PBA' THEN 'Post-Baccalaureate Student'
WHEN A.ADMIT_TYPE = 'REA' THEN 'Readmit Student'
WHEN A.ADMIT_TYPE = 'TRF' AND A.Institution <> DECODE(A.Ext_Org_Id, '0136250', 'UMS05', '0136246', 'UMS01', '0136247', 'UMS02',
'0136248', 'UMS03', '0136249', 'UMS04', '0136252', 'UMS07',
'0136392', 'UMS06', 'OTHER') THEN 'Transfer Student'
ELSE 'Continuing Student' END
ELSE 'Continuing Student' END
WHEN A.ACAD_PLAN = 'IEI' AND A.INSTITUTION = 'UMS05' THEN 'Non-Degree'
WHEN A.ACAD_PLAN LIKE 'VIS%' AND A.INSTITUTION = 'UMS05' AND A.ACAD_CAREER IN ('GRAD', 'UGRD') THEN 'Non-Degree'
WHEN A.ACAD_PROG_PRIMARY IN ('NDEC', 'NECN', 'NDUG', 'DIST', 'P-NON', 'NONCR', 'NDPR', 'NDGR', 'GRNON', 'NDPN', 'NSEU', 'NDUMA', 'APNDU') THEN 'Non-Degree'
WHEN A.ACAD_PROG_PRIMARY LIKE '%UN' THEN 'Non-Degree'
WHEN A.ACAD_PROG_PRIMARY LIKE '%GN' THEN 'Non-Degree'
WHEN A.ACAD_CAREER = 'NCRD' AND A.INSTITUTION = 'UMS07' THEN 'Non-Degree'
WHEN (A.Admit_Term = Strm OR (to_number(A.STRM) - to_number(ltrim(A.ADMIT_TERM, ' '))) = 80) THEN
CASE WHEN A.Institution = 'UMS05' AND A.Prog_Reason = 'RADM' THEN 'Readmit Student'
WHEN A.ADMIT_TYPE IN ('FYR', 'EFY') AND (A.ACAD_LEVEL_BOT in ('01','10') or A.Um_Last_Sch_Type IN ('SCD', 'SHS')) THEN 'First-Time Undergraduate Student'
WHEN A.ADMIT_TYPE IN ('GRD', 'GR6', 'GR2', 'DAT') THEN 'Graduate Student'
WHEN A.ADMIT_TYPE = 'LAW' AND A.ACAD_LEVEL_BOT = 'L1' THEN 'Law Student'
WHEN A.ADMIT_TYPE = 'PBA' THEN 'Post-Baccalaureate Student'
WHEN A.ADMIT_TYPE = 'REA' THEN 'Readmit Student'
WHEN A.ADMIT_TYPE = 'TRF' AND A.Institution <> DECODE(A.Ext_Org_Id, '0136250', 'UMS05', '0136246', 'UMS01', '0136247', 'UMS02',
'0136248', 'UMS03', '0136249', 'UMS04', '0136252', 'UMS07',
'0136392', 'UMS06', 'OTHER') THEN 'Transfer Student'
ELSE 'Continuing Student'
END
ELSE 'Continuing Student'
END
/*9- UM_ADMIT_TYPE_SORT*/
CASE WHEN (A.INSTITUTION = 'UMS02' AND A.DEGREE = 'CGS') OR (A.INSTITUTION = 'UMS06' AND A.ACAD_PLAN LIKE '%-CERT') OR (A.INSTITUTION = 'UMS06' AND A.ACAD_PLAN LIKE '%-CGS') THEN
CASE WHEN (A.Admit_Term = Strm OR (to_number(A.STRM) - to_number(ltrim(A.ADMIT_TERM, ' '))) = 80) THEN
CASE WHEN A.Institution = 'UMS05' AND A.Prog_Reason = 'RADM' THEN '08'
WHEN A.ADMIT_TYPE IN ('FYR', 'EFY') AND (A.ACAD_LEVEL_BOT in ('01','10') or A.Um_Last_Sch_Type IN ('SCD', 'SHS')) THEN '01'
WHEN A.ADMIT_TYPE IN ('GRD', 'GR6', 'GR2', 'DAT') THEN '05'
WHEN A.ADMIT_TYPE = 'LAW' AND A.ACAD_LEVEL_BOT = 'L1' THEN '06'
WHEN A.ADMIT_TYPE = 'PBA' THEN '04'
WHEN A.ADMIT_TYPE = 'REA' THEN '08'
WHEN A.ADMIT_TYPE = 'TRF' AND A.Institution <> DECODE(A.Ext_Org_Id, '0136250', 'UMS05', '0136246', 'UMS01', '0136247', 'UMS02',
'0136248', 'UMS03', '0136249', 'UMS04', '0136252', 'UMS07',
'0136392', 'UMS06', 'OTHER') THEN '09'
ELSE '10' END
ELSE '10' END
WHEN A.ACAD_PLAN = 'IEI' AND A.INSTITUTION = 'UMS05' THEN '11'
WHEN A.ACAD_PLAN LIKE 'VIS%' AND A.INSTITUTION = 'UMS05' AND A.ACAD_CAREER IN ('GRAD', 'UGRD') THEN '11'
WHEN A.ACAD_PROG_PRIMARY IN ('NDEC', 'NECN', 'NDUG', 'DIST', 'P-NON', 'NONCR', 'NDPR', 'NDGR', 'GRNON', 'NDPN', 'NSEU', 'NDUMA', 'APNDU') THEN '11'
WHEN A.ACAD_PROG_PRIMARY LIKE '%UN' THEN '11'
WHEN A.ACAD_PROG_PRIMARY LIKE '%GN' THEN '11'
WHEN A.ACAD_CAREER = 'NCRD' AND A.INSTITUTION = 'UMS07' THEN '11'
WHEN (A.Admit_Term = Strm OR (to_number(A.STRM) - to_number(ltrim(A.ADMIT_TERM, ' '))) = 80) THEN
CASE WHEN A.Institution = 'UMS05' AND A.Prog_Reason = 'RADM' THEN '08'
WHEN A.ADMIT_TYPE IN ('FYR', 'EFY') AND (A.ACAD_LEVEL_BOT in ('01','10') or A.Um_Last_Sch_Type IN ('SCD', 'SHS')) THEN '01'
WHEN A.ADMIT_TYPE IN ('GRD', 'GR6', 'GR2', 'DAT') THEN '05'
WHEN A.ADMIT_TYPE = 'LAW' AND A.ACAD_LEVEL_BOT = 'L1' THEN '06'
WHEN A.ADMIT_TYPE = 'PBA' THEN '04'
WHEN A.ADMIT_TYPE = 'REA' THEN '08'
WHEN A.ADMIT_TYPE = 'TRF' AND A.Institution <> DECODE(A.Ext_Org_Id, '0136250', 'UMS05', '0136246', 'UMS01', '0136247', 'UMS02',
'0136248', 'UMS03', '0136249', 'UMS04', '0136252', 'UMS07',
'0136392', 'UMS06', 'OTHER') THEN '09'
ELSE '10'
END
ELSE '10'
END
/*10- UM_ADMIT_TYPE_D_ND*/
CASE WHEN (A.INSTITUTION = 'UMS02' AND A.DEGREE = 'CGS') OR (A.INSTITUTION = 'UMS06' AND A.ACAD_PLAN LIKE '%-CERT') OR (A.INSTITUTION = 'UMS06' AND A.ACAD_PLAN LIKE '%-CGS') THEN 'Continuing Student'
WHEN (A.ACAD_PLAN = 'IEI' AND A.INSTITUTION = 'UMS05') OR
(A.ACAD_PLAN LIKE 'VIS%' AND A.INSTITUTION = 'UMS05' AND A.ACAD_CAREER IN ('GRAD', 'UGRD')) OR
(A.ACAD_PROG_PRIMARY IN ('NDEC', 'NECN', 'NDUG', 'DIST', 'P-NON', 'NONCR', 'NDPR', 'NDGR', 'GRNON', 'NDPN', 'NSEU', 'NDUMA', 'APNDU') OR
(A.ACAD_PROG_PRIMARY LIKE '%UN') OR
(A.ACAD_PROG_PRIMARY LIKE '%GN') OR
(A.ACAD_CAREER = 'NCRD' AND A.INSTITUTION = 'UMS07') THEN
CASE WHEN (A.Admit_Term = Strm OR (to_number(A.STRM) - to_number(ltrim(A.ADMIT_TERM, ' '))) = 80) THEN
CASE WHEN A.Institution = 'UMS05' AND A.Prog_Reason = 'RADM' THEN 'Readmit Student'
WHEN A.ADMIT_TYPE IN ('FYR', 'EFY') AND (A.ACAD_LEVEL_BOT in ('01','10') or A.Um_Last_Sch_Type IN ('SCD', 'SHS')) THEN 'First-Time Undergraduate Student'
WHEN A.ADMIT_TYPE IN ('GRD', 'GR6', 'GR2', 'DAT') THEN 'Graduate Student'
WHEN A.ADMIT_TYPE = 'LAW' AND A.ACAD_LEVEL_BOT = 'L1' THEN 'Law Student'
WHEN A.ADMIT_TYPE = 'PBA' THEN 'Post-Baccalaureate Student'
WHEN A.ADMIT_TYPE = 'REA' THEN 'Readmit Student'
WHEN A.ADMIT_TYPE = 'TRF' AND A.Institution <> DECODE(A.Ext_Org_Id, '0136250', 'UMS05', '0136246', 'UMS01', '0136247', 'UMS02',
'0136248', 'UMS03', '0136249', 'UMS04', '0136252', 'UMS07',
'0136392', 'UMS06', 'OTHER') THEN 'Transfer Student'
ELSE 'Continuing Student'
END
ELSE 'Continuing Student'
END
ELSE 'Continuing Student'
END
/*11- UM_FIRST_TIME*/
CASE WHEN (A.INSTITUTION = 'UMS02' AND A.DEGREE = 'CGS') OR (A.INSTITUTION = 'UMS06' AND A.ACAD_PLAN LIKE '%-CERT') OR (A.INSTITUTION = 'UMS06' AND A.ACAD_PLAN LIKE '%-CGS') THEN
CASE WHEN (A.Admit_Term = Strm OR (to_number(A.STRM) - to_number(ltrim(A.ADMIT_TERM, ' '))) = 80) THEN
CASE WHEN A.Institution = 'UMS05' AND A.Prog_Reason = 'RADM' THEN 'Y'
WHEN A.ADMIT_TYPE IN ('FYR', 'EFY') AND (A.ACAD_LEVEL_BOT in ('01','10') or A.Um_Last_Sch_Type IN ('SCD', 'SHS')) THEN 'Y'
WHEN A.ADMIT_TYPE IN ('GRD', 'GR6', 'GR2', 'DAT') THEN 'Y'
WHEN A.ADMIT_TYPE = 'LAW' AND A.ACAD_LEVEL_BOT = 'L1' THEN 'Y'
WHEN A.ADMIT_TYPE = 'PBA' THEN 'Y'
WHEN A.ADMIT_TYPE = 'REA' THEN 'Y'
WHEN A.ADMIT_TYPE = 'TRF' AND A.Institution <> DECODE(A.Ext_Org_Id, '0136250', 'UMS05', '0136246', 'UMS01', '0136247', 'UMS02', '0136248', 'UMS03',
'0136249', 'UMS04', '0136252', 'UMS07', '0136392', 'UMS06', 'OTHER') THEN 'Y'
ELSE 'N' END
ELSE 'N' END
WHEN A.ACAD_PLAN = 'IEI' AND A.INSTITUTION = 'UMS05' THEN 'N'
WHEN A.ACAD_PLAN LIKE 'VIS%' AND A.INSTITUTION = 'UMS05' AND A.ACAD_CAREER IN ('GRAD', 'UGRD') THEN 'N'
WHEN A.ACAD_PROG_PRIMARY IN ('NDEC', 'NECN', 'NDUG', 'DIST', 'P-NON', 'NONCR', 'NDPR', 'NDGR', 'GRNON', 'NDPN', 'NSEU', 'NDUMA', 'APNDU') THEN 'N'
WHEN A.ACAD_PROG_PRIMARY LIKE '%UN' THEN 'N'
WHEN A.ACAD_PROG_PRIMARY LIKE '%GN' THEN 'N'
WHEN A.ACAD_CAREER = 'NCRD' AND A.INSTITUTION = 'UMS07' THEN 'N'
WHEN (A.Admit_Term = Strm OR (to_number(A.STRM) - to_number(ltrim(A.ADMIT_TERM, ' '))) = 80) THEN
CASE WHEN A.Institution = 'UMS05' AND A.Prog_Reason = 'RADM' THEN 'Y'
WHEN A.ADMIT_TYPE IN ('FYR', 'EFY') AND (A.ACAD_LEVEL_BOT in ('01','10') or A.Um_Last_Sch_Type IN ('SCD', 'SHS')) THEN 'Y'
WHEN A.ADMIT_TYPE IN ('GRD', 'GR6', 'GR2', 'DAT') THEN 'Y'
WHEN A.ADMIT_TYPE = 'LAW' AND A.ACAD_LEVEL_BOT = 'L1' THEN 'Y'
WHEN A.ADMIT_TYPE = 'PBA' THEN 'Y'
WHEN A.ADMIT_TYPE = 'REA' THEN 'Y'
WHEN A.ADMIT_TYPE = 'TRF' AND A.Institution <> DECODE(A.Ext_Org_Id, '0136250', 'UMS05', '0136246', 'UMS01', '0136247', 'UMS02', '0136248', 'UMS03',
'0136249', 'UMS04', '0136252', 'UMS07', '0136392', 'UMS06', 'OTHER') THEN 'Y'
ELSE 'N'
END
ELSE 'N'
END
/*12- UM_FIRST_TIME_NDEG */
CASE
WHEN A.INSTITUTION = 'UMS02' AND A.DEGREE = 'CGS' THEN 'N'
WHEN A.INSTITUTION = 'UMS06' AND A.ACAD_PLAN LIKE '%-CERT' THEN 'N'
WHEN A.INSTITUTION = 'UMS06' AND A.ACAD_PLAN LIKE '%-CGS' THEN 'N'
WHEN ((A.ACAD_PLAN = 'IEI' AND A.INSTITUTION = 'UMS05') OR
(A.ACAD_PLAN LIKE 'VIS%' AND A.INSTITUTION = 'UMS05') OR
A.ACAD_PROG_PRIMARY IN ('NDEC', 'NECN', 'NDUG', 'DIST', 'P-NON', 'NONCR', 'NDPR', 'NDGR', 'GRNON', 'NDPN', 'NSEU', 'NDUMA', 'APNDU') OR
A.ACAD_PROG_PRIMARY LIKE '%UN' OR
A.ACAD_PROG_PRIMARY LIKE '%GN' OR
(A.ACAD_CAREER = 'NCRD' AND A.INSTITUTION = 'UMS07')) THEN
CASE
WHEN (A.Admit_Term = Strm OR (to_number(A.STRM) - to_number(ltrim(A.ADMIT_TERM, ' '))) = 80) THEN
CASE
WHEN A.Institution = 'UMS05' AND A.Prog_Reason = 'RADM' THEN 'Y'
WHEN A.ADMIT_TYPE IN ('FYR', 'EFY') AND (A.ACAD_LEVEL_BOT in ('01','10') or A.Um_Last_Sch_Type IN ('SCD', 'SHS')) THEN 'Y'
WHEN A.ADMIT_TYPE IN ('GRD', 'GR6', 'GR2', 'DAT') THEN 'Y'
WHEN A.ADMIT_TYPE = 'LAW' AND A.ACAD_LEVEL_BOT = 'L1' THEN 'Y'
WHEN A.ADMIT_TYPE = 'PBA' THEN 'Y'
WHEN A.ADMIT_TYPE = 'REA' THEN 'Y'
WHEN A.ADMIT_TYPE = 'TRF' AND A.Institution <> DECODE(A.Ext_Org_Id, '0136250', 'UMS05',
'0136246', 'UMS01',
'0136247', 'UMS02',
'0136248', 'UMS03',
'0136249', 'UMS04',
'0136252', 'UMS07',
'0136392', 'UMS06', 'OTHER') THEN 'Y'
ELSE 'N'
END
ELSE 'N'
END
ELSE 'N'
END