Degree/Non-Degree Coding - Current

Body

WARNING: Field Name Definitions are Linked to the UMS Data Cookbook - this requires a University of Maine System ID and password

Degree versus Non-Degree seeking students need to be identified for many reasons, various query codes exist for different purposes

Detailed Information

Follow these link to the UMS Data Cookbook definitions for Degree/certificate Seeking Student and Non-degree-seeking Student.
Please note that you can copy this coded by "selecting all" and pasting the code into  a coding application.
You will copy all of the code in the code block even if it appears" chopped on the left margin.

1- UM_DEGREE_NONDEG

2 - UM_STUDENT_LEVEL

3 - UM_STUD_LEVEL_SORT

4 - UM_STUD_LEVEL_SUM

5 - UM_STD_LVL_SUM_SRT

6 - UM_STD_LVL_SUM_UG

7 - UM_NEASC_LEVEL

  8 - UM_NEASC_LEVEL_SRT

  9 - UM_ADMIT_TYPE_DESC

10 - UM_ADMIT_TYPE_SORT

11 - UM_ADMIT_TYPE_D_ND

12 - UM_FIRST_TIME

13- UM_FIRST_TIME_NDEG

1 - UM_DEGREE_NONDEGREE

This 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

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.) 

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

Back to top

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

Back to top

4 - 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'

Back to top

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

Back to top

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

Back to top

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

Back to top

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

Back to top

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

Back to top

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

Back to top

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

Back to top

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

Back to top

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

Back to top

Environment

PeopleSoft Campus Solutions

Details

Details

Article ID: 158964
Created
Fri 5/10/24 4:29 AM
Modified
Mon 8/19/24 12:27 PM
Applies To
Faculty
Staff
Community

Related Articles

Related Articles (1)

UM_STUD_EXT_VW - Student Reporting Extract

Related Services / Offerings

Related Services / Offerings (1)

DARTS (UMS Data) Inquiry
Submit an inquiry about UMS Data (except Data Governance)