The following is documentation from Bill Gilfillan of his calculations for some of the fields which may have been used in the UM_STUD_CENS_VW - Student Reporting Extract. The field names may be different in the actual table or they fields may not have been used.  This is for reference only.

ACADEMIC_YEAR
CASE WHEN Acad Level Bot = '10' THEN 'First Year' WHEN Acad Level Bot = '01' THEN 'First Year' WHEN Acad Level Bot = '20' THEN 'Second Year' WHEN Acad Level Bot = '02' THEN 'Second Year' WHEN Acad Level Bot = '30' THEN 'Third Year' WHEN Acad Level Bot = '03' THEN 'Third Year' WHEN Acad Level Bot = '40' THEN 'Fourth Year' WHEN Acad Level Bot = '04' THEN 'Fourth Year' WHEN Acad Level Bot = '50' THEN 'Fifth Year' WHEN Acad Level Bot = '05' THEN 'Fifth Year' WHEN Acad Level Bot = 'GR' THEN 'Graduate' WHEN Acad Level Bot = 'MAS' THEN 'Graduate' WHEN Acad Level Bot = 'PHD' THEN 'Graduate' WHEN Acad Level Bot = 'L1' THEN 'Law First Year' WHEN Acad Level Bot = 'L2' THEN 'Law Second Year' WHEN Acad Level Bot = 'L3' THEN 'Law Third Year' ELSE 'Other' END

ACADEMIC_YEAR_SORTED
CASE WHEN Acad Level Bot = '10' THEN '10' WHEN Acad Level Bot = '01' THEN '10' WHEN Acad Level Bot = '20' THEN '11' WHEN Acad Level Bot = '02' THEN '11' WHEN Acad Level Bot = '30' THEN '12' WHEN Acad Level Bot = '03' THEN '12' WHEN Acad Level Bot = '40' THEN '13' WHEN Acad Level Bot = '04' THEN '13' WHEN Acad Level Bot = '50' THEN '14' WHEN Acad Level Bot = '05' THEN '14' WHEN Acad Level Bot = 'GR' THEN '15' WHEN Acad Level Bot = 'MAS' THEN '15' WHEN Acad Level Bot = 'PHD' THEN '15' WHEN Acad Level Bot = 'L1' THEN '16' WHEN Acad Level Bot = 'L2' THEN '17' WHEN Acad Level Bot = 'L3' THEN '18' ELSE '20' END

ADMIT_TERM_YEAR
CASE WHEN Admit Term IS NULL THEN 0 WHEN SUBSTR(Admit Term,1,2) < '04' THEN 0 WHEN SUBSTR(Admit Term,3,1) = '1' THEN TO_NUMBER('20'||SUBSTR(Admit Term,1,2),'9999')-1 ELSE TO_NUMBER('20'||SUBSTR(Admit Term,1,2),'9999') END

ADMIT_TYPE_DESCRIPTION
CASE WHEN FIRST_TIME = 'Y' AND Institution = 'UMS05' AND Prog Reason = 'RADM' THEN 'Readmit Student' WHEN FIRST_TIME = 'Y' AND Admit Type = 'EFY' AND ( Acad Level Bot = '01' OR Acad Level Bot = '10' ) THEN 'First-Time First-Year Student' WHEN FIRST_TIME = 'Y' AND Admit Type = 'FYR' AND ( Acad Level Bot = '01' OR Acad Level Bot = '10' ) THEN 'First-Time First-Year Student' WHEN FIRST_TIME = 'Y' AND Admit Type = 'EFY' THEN 'Other First-Time Undergraduate Student' WHEN FIRST_TIME = 'Y' AND Admit Type = 'FYR' THEN 'Other First-Time Undergraduate Student' WHEN FIRST_TIME = 'Y' AND Admit Type = 'GRD' THEN 'Graduate Student' WHEN FIRST_TIME = 'Y' AND Admit Type = 'GR6' THEN 'Graduate Student' WHEN FIRST_TIME = 'Y' AND Admit Type = 'GR2' THEN 'Graduate Student' WHEN FIRST_TIME = 'Y' AND Admit Type = 'DAT' THEN 'Graduate Student' WHEN FIRST_TIME = 'Y' AND Admit Type = 'LAW' THEN 'Law Student' WHEN FIRST_TIME = 'Y' AND Admit Type = 'PBA' THEN 'Post-Baccalaureate Student' WHEN FIRST_TIME = 'Y' AND Admit Type = 'REA' THEN 'Readmit Student' WHEN FIRST_TIME = 'Y' AND Admit Type = 'TRF' THEN 'Transfer Student' WHEN FIRST_TIME = 'N' THEN 'Continuing Student' ELSE 'Other' END

ADMIT_TYPE_DESCRIPTION_NON_DEGREE
CASE WHEN FIRST_TIME_NON_DEGREE = 'Y' AND Institution = 'UMS05' AND Prog Reason = 'RADM' THEN 'Readmit Student' WHEN FIRST_TIME_NON_DEGREE = 'Y' AND Admit Type = 'EFY' AND ( Acad Level Bot = '01' OR Acad Level Bot = '10' ) THEN 'First-Time First-Year Student' WHEN FIRST_TIME_NON_DEGREE = 'Y' AND Admit Type = 'FYR' AND ( Acad Level Bot = '01' OR Acad Level Bot = '10' ) THEN 'First-Time First-Year Student' WHEN FIRST_TIME_NON_DEGREE = 'Y' AND Admit Type = 'EFY' THEN 'Other First-Time Undergraduate Student' WHEN FIRST_TIME_NON_DEGREE = 'Y' AND Admit Type = 'FYR' THEN 'Other First-Time Undergraduate Student' WHEN FIRST_TIME_NON_DEGREE = 'Y' AND Admit Type = 'GRD' THEN 'Graduate Student' WHEN FIRST_TIME_NON_DEGREE = 'Y' AND Admit Type = 'GR6' THEN 'Graduate Student' WHEN FIRST_TIME_NON_DEGREE = 'Y' AND Admit Type = 'LAW' THEN 'Law Student' WHEN FIRST_TIME_NON_DEGREE = 'Y' AND Admit Type = 'PBA' THEN 'Post-Baccalaureate Student' WHEN FIRST_TIME_NON_DEGREE = 'Y' AND Admit Type = 'REA' THEN 'Readmit Student' WHEN FIRST_TIME_NON_DEGREE = 'Y' AND Admit Type = 'TRF' AND Institution = EXT_ORG_INST THEN 'Readmit Student' WHEN FIRST_TIME_NON_DEGREE = 'Y' AND Admit Type = 'TRF' THEN 'Transfer Student' WHEN FIRST_TIME_NON_DEGREE = 'N' THEN 'Continuing Student' ELSE 'Other' END

ADMIT_TYPE_SORT
CASE WHEN FIRST_TIME = 'Y' AND Institution = 'UMS05' AND Prog Reason = 'RADM' THEN '08' WHEN FIRST_TIME = 'Y' AND Admit Type = 'EFY' AND ( Acad Level Bot = '01' OR Acad Level Bot = '10' ) THEN '01' WHEN FIRST_TIME = 'Y' AND Admit Type = 'FYR' AND ( Acad Level Bot = '01' OR Acad Level Bot = '10' ) THEN '01' WHEN FIRST_TIME = 'Y' AND Admit Type = 'EFY' THEN '02' WHEN FIRST_TIME = 'Y' AND Admit Type = 'FYR' THEN '02' WHEN FIRST_TIME = 'Y' AND Admit Type = 'GRD' THEN '05' WHEN FIRST_TIME = 'Y' AND Admit Type = 'GR6' THEN '05' WHEN FIRST_TIME = 'Y' AND Admit Type = 'GR2' THEN '05' WHEN FIRST_TIME = 'Y' AND Admit Type = 'DAT' THEN '05' WHEN FIRST_TIME = 'Y' AND Admit Type = 'LAW' THEN '06' WHEN FIRST_TIME = 'Y' AND Admit Type = 'PBA' THEN '04' WHEN FIRST_TIME = 'Y' AND Admit Type = 'REA' THEN '08' WHEN FIRST_TIME = 'Y' AND Admit Type = 'TRF' THEN '07' WHEN FIRST_TIME = 'N' THEN '09' ELSE '10' END

ADVISOR_NAME_FORMATTED
CASE WHEN Um Advisr Name Sfx <= ' ' AND Um Advisr Lst Name > ' ' THEN Um Advisr Lst Name||', '||Um Advisr Fst Name||''||Um Advisr Mid Name WHEN Um Advisr Lst Name > ' ' THEN Um Advisr Lst Name||''||Um Advisr Name Sfx ELSE ''||', '||Um Advisr Fst Name||''||Um Advisr Mid Name END

CALCULATED_ANY_COUNTRY
CASE WHEN Citizenship Status = '4' AND ( Country Descr1 <> 'United States' AND Country Descr1 > ' ' ) THEN Country Descr1 WHEN Citizenship Status = '4' AND Residency = 'CAN' THEN 'Canada' WHEN Citizenship Status = '4' AND ( Country Descr1 = 'United States' AND Um Country Oth > ' ' ) THEN Um Country Oth WHEN Citizenship Status = '4' AND ( Country <> 'USA' AND Country > ' ' ) THEN Country WHEN Citizenship Status = '4' THEN 'Other Country' WHEN Residency = 'CAN' THEN 'Canada' WHEN Residency = 'INTNL' AND ( Country Descr1 <> 'United States' AND Country Descr1 > ' ' ) THEN Country Descr1 WHEN Residency = 'INTNL' AND ( Country Descr1 = 'United States' AND Um Country Oth > ' ' ) THEN Um Country Oth WHEN Residency = 'INTNL' AND ( Country <> 'USA' AND Country > ' ' ) THEN Country WHEN Residency = 'INTNL' THEN 'Other Country' WHEN Residency = 'OS' AND ( Country Descr1 <> 'United States' AND Country Descr1 > ' ' ) THEN Country Descr1 WHEN Residency = 'OS' AND ( Country <> 'USA' AND Country > ' ' ) THEN Country WHEN Residency = 'NEBHE' AND ( Country Descr1 <> 'United States' AND Country Descr1 > ' ' ) THEN Country Descr1 WHEN Residency = 'NEBHE' AND ( Country <> 'USA' AND Country > ' ' ) THEN Country WHEN Country <> 'USA' AND Country > ' ' THEN Country ELSE 'United States' END

CALCULATED_COUNTRY
CASE WHEN Citizenship Status = '1' THEN 'United States' WHEN Citizenship Status = '2' THEN 'United States' WHEN Citizenship Status = '3' THEN 'United States' WHEN Citizenship Status = '4' AND ( Country Descr1 <> 'United States' AND Country Descr1 > ' ' ) THEN Country Descr1 WHEN Citizenship Status = '4' AND Residency = 'CAN' THEN 'Canada' WHEN Citizenship Status = '4' AND ( Country Descr1 = 'United States' AND Um Country Oth > ' ' ) THEN Um Country Oth WHEN Citizenship Status = '4' AND ( Country <> 'USA' AND Country > ' ' ) THEN Country WHEN Citizenship Status = '4' THEN 'Other Country' WHEN Residency = 'CAN' THEN 'Canada' WHEN Residency = 'INTNL' AND ( Country Descr1 <> 'United States' AND Country Descr1 > ' ' ) THEN Country Descr1 WHEN Residency = 'INTNL' AND ( Country Descr1 = 'United States' AND Um Country Oth > ' ' ) THEN Um Country Oth WHEN Residency = 'INTNL' AND ( Country <> 'USA' AND Country > ' ' ) THEN Country WHEN Residency = 'INTNL' THEN 'Other Country' WHEN Residency = 'OS' AND ( Country Descr1 <> 'United States' AND Country Descr1 > ' ' ) THEN Country Descr1 WHEN Residency = 'OS' AND ( Country <> 'USA' AND Country > ' ' ) THEN Country WHEN Residency = 'NEBHE' AND ( Country Descr1 <> 'United States' AND Country Descr1 > ' ' ) THEN Country Descr1 WHEN Residency = 'NEBHE' AND ( Country <> 'USA' AND Country > ' ' ) THEN Country WHEN Country <> 'USA' AND Country > ' ' THEN Country ELSE 'United States' END

CALCULATED_COUNTY
CASE WHEN County <= ' ' AND Institution = 'UMS01' THEN 'Kennebec' WHEN County <= ' ' AND Institution = 'UMS02' THEN 'Franklin' WHEN County <= ' ' AND Institution = 'UMS03' THEN 'Aroostook' WHEN County <= ' ' AND Institution = 'UMS04' THEN 'Washington' WHEN County <= ' ' AND Institution = 'UMS05' THEN 'Penobscot' WHEN County <= ' ' AND Institution = 'UMS06' THEN 'Cumberland' WHEN County <= ' ' AND Institution = 'UMS07' THEN 'Aroostook' WHEN County <= ' ' THEN 'Unknown County' WHEN LOWER(County) LIKE '%dros%' THEN 'Androscoggin' WHEN LOWER(County) LIKE '%aroos%' THEN 'Aroostook' WHEN LOWER(County) LIKE '%cumber%' THEN 'Cumberland' WHEN LOWER(County) LIKE '%frank%' THEN 'Franklin' WHEN LOWER(County) LIKE '%hanc%' THEN 'Hancock' WHEN LOWER(County) LIKE '%bec' THEN 'Kennebec' WHEN LOWER(County) LIKE '%knox' THEN 'Knox' WHEN LOWER(County) LIKE '%lincoln' THEN 'Lincoln' WHEN LOWER(County) LIKE '%oxford' THEN 'Oxford' WHEN LOWER(County) LIKE '%penob%' THEN 'Penobscot' WHEN LOWER(County) LIKE '%piscat%' THEN 'Piscataquis' WHEN LOWER(County) LIKE '%saga%' THEN 'Sagadahoc' WHEN LOWER(County) LIKE '%somer%' THEN 'Somerset' WHEN LOWER(County) LIKE '%waldo' THEN 'Waldo' WHEN LOWER(County) LIKE '%wash%' THEN 'Washington' WHEN LOWER(County) LIKE '%york' THEN 'York' WHEN County NOT IN ('Androscoggin','Aroostook','Cumberland','Franklin','Hancock','Kennebec','Knox','Lincoln','Oxford','Penobscot','Piscataquis','Sagadahoc','Somerset','Waldo','Washington','York') THEN 'Unknown County' ELSE County END

CALCULATED_STATE
CASE WHEN COUNTRY STATUS = 'Non-USA' THEN 'Non-USA' WHEN Residency = 'OS' AND State <= ' ' THEN 'Other State' WHEN Residency = 'NEBHE' AND State <= ' ' THEN 'Other State' WHEN State <> 'ME' AND State Descr1 > ' ' THEN State Descr1 WHEN State = 'NH' THEN 'New Hampshire' WHEN State = 'VT' THEN 'Vermont' WHEN State = 'MA' THEN 'Massachusetts' WHEN State = 'CT' THEN 'Connecticut' WHEN State = 'RI' THEN 'Rhode Island' WHEN State = 'ME' THEN 'Maine' WHEN State <> 'ME' AND State Descr1 <= ' ' THEN 'Other State' WHEN Residency = 'IS' THEN 'Maine' ELSE 'Other State' END

CAMP
CASE WHEN Institution = 'UMS01' THEN 'UMA' WHEN Institution = 'UMS02' THEN 'UMF' WHEN Institution = 'UMS03' THEN 'UMFK' WHEN Institution = 'UMS04' THEN 'UMM' WHEN Institution = 'UMS07' THEN 'UMPI' WHEN Institution = 'UMS05' THEN 'UM' WHEN Institution = 'UMS06' THEN 'USM' ELSE 'Other' END

CANADA
CASE WHEN State = 'AB' AND CALCULATED COUNTRY IN ('Canada','CAN') THEN 'Alberta' WHEN State = 'BC' AND CALCULATED COUNTRY IN ('Canada','CAN') THEN 'British Columbia' WHEN State = 'MB' AND CALCULATED COUNTRY IN ('Canada','CAN') THEN 'Manitoba' WHEN State = 'NB' AND CALCULATED COUNTRY IN ('Canada','CAN') THEN 'New Brunswick' WHEN State = 'NF' AND CALCULATED COUNTRY IN ('Canada','CAN') THEN 'Newfoundland' WHEN State = 'NL' AND CALCULATED COUNTRY IN ('Canada','CAN') THEN 'Newfoundland' WHEN State = 'NS' AND CALCULATED COUNTRY IN ('Canada','CAN') THEN 'Nova Scotia' WHEN State = 'NT' AND CALCULATED COUNTRY IN ('Canada','CAN') THEN 'Northwest Territories' WHEN State = 'NN' AND CALCULATED COUNTRY IN ('Canada','CAN') THEN 'Nunavut' WHEN State = 'NU' AND CALCULATED COUNTRY IN ('Canada','CAN') THEN 'Nunavut' WHEN State = 'ON' AND CALCULATED COUNTRY IN ('Canada','CAN') THEN 'Ontario' WHEN State = 'PE' AND CALCULATED COUNTRY IN ('Canada','CAN') THEN 'Prince Edward Island' WHEN State = 'QC' AND CALCULATED COUNTRY IN ('Canada','CAN') THEN 'Quebec' WHEN State = 'SK' AND CALCULATED COUNTRY IN ('Canada','CAN') THEN 'Saskatchewan' WHEN State = 'YT' AND CALCULATED COUNTRY IN ('Canada','CAN') THEN 'Yukon' WHEN CALCULATED COUNTRY IN ('Canada','CAN') THEN 'Canada' ELSE 'Not Canada' END

CENSUS_AGE TRUNC(( CENSUSDTE-BIRTHDTE )/365.25)

CENSUS_AGE_PRECISE
CASE WHEN BIRTHDTE IS NULL THEN NULL ELSE MONTHS_BETWEEN(CENSUSDTE,BIRTHDTE)/12 END

CENSUS_AGE_RANGE
CASE WHEN CENSUS AGE >= 14 AND CENSUS AGE <= 17 THEN 'Under 18' WHEN CENSUS AGE >= 18 AND CENSUS AGE <= 19 THEN '18 - 19' WHEN CENSUS AGE >= 20 AND CENSUS AGE <= 21 THEN '20 - 21' WHEN CENSUS AGE >= 22 AND CENSUS AGE <= 24 THEN '22 - 24' WHEN CENSUS AGE >= 25 AND CENSUS AGE <= 29 THEN '25 - 29' WHEN CENSUS AGE >= 30 AND CENSUS AGE <= 34 THEN '30 - 34' WHEN CENSUS AGE >= 35 AND CENSUS AGE <= 39 THEN '35 - 39' WHEN CENSUS AGE >= 40 AND CENSUS AGE <= 49 THEN '40 - 49' WHEN CENSUS AGE >= 50 AND CENSUS AGE <= 64 THEN '50 - 64' WHEN CENSUS AGE >= 65 AND CENSUS AGE <= 105 THEN '65 and Over' ELSE 'Unknown' END

CENSUS_AGE_RANGE_SORT
CASE WHEN CENSUS AGE >= 14 AND CENSUS AGE <= 17 THEN '01' WHEN CENSUS AGE >= 18 AND CENSUS AGE <= 19 THEN '02' WHEN CENSUS AGE >= 20 AND CENSUS AGE <= 21 THEN '03' WHEN CENSUS AGE >= 22 AND CENSUS AGE <= 24 THEN '04' WHEN CENSUS AGE >= 25 AND CENSUS AGE <= 29 THEN '05' WHEN CENSUS AGE >= 30 AND CENSUS AGE <= 34 THEN '06' WHEN CENSUS AGE >= 35 AND CENSUS AGE <= 39 THEN '07' WHEN CENSUS AGE >= 40 AND CENSUS AGE <= 49 THEN '08' WHEN CENSUS AGE >= 50 AND CENSUS AGE <= 64 THEN '09' WHEN CENSUS AGE >= 65 AND CENSUS AGE <= 105 THEN '10' ELSE '11' END

CITIZENSHIP_STATUS_DESCR
CASE WHEN Citizenship Status = '4' THEN 'Alien Temporary' WHEN Citizenship Status = '3' THEN 'Alien Permanent' WHEN Citizenship Status = '2' THEN 'Naturalized' WHEN Citizenship Status = '1' THEN 'Native' WHEN Citizenship Status = 'N' THEN 'Not Indicated' ELSE ' ' END

COUNTRY_STATUS
CASE WHEN CALCULATED COUNTRY = 'United States' THEN 'USA' ELSE 'Non-USA' END

CURRENT_AGE_RANGE
CASE WHEN CURRENT_AGE >= 14 AND CURRENT_AGE <= 17 THEN 'Under 18' WHEN CURRENT_AGE >= 18 AND CURRENT_AGE <= 19 THEN '18 - 19' WHEN CURRENT_AGE >= 20 AND CURRENT_AGE <= 21 THEN '20 - 21' WHEN CURRENT_AGE >= 22 AND CURRENT_AGE <= 24 THEN '22 - 24' WHEN CURRENT_AGE >= 25 AND CURRENT_AGE <= 29 THEN '25 - 29' WHEN CURRENT_AGE >= 30 AND CURRENT_AGE <= 34 THEN '30 - 34' WHEN CURRENT_AGE >= 35 AND CURRENT_AGE <= 39 THEN '35 - 39' WHEN CURRENT_AGE >= 40 AND CURRENT_AGE <= 49 THEN '40 - 49' WHEN CURRENT_AGE >= 50 AND CURRENT_AGE <= 64 THEN '50 - 64' WHEN CURRENT_AGE >= 65 AND CURRENT_AGE <= 105 THEN '65 and Over' ELSE 'Unknown' END

CURRENT_AGE_RANGE_SORT
CASE WHEN CURRENT_AGE >= 14 AND CURRENT_AGE <= 17 THEN '01' WHEN CURRENT_AGE >= 18 AND CURRENT_AGE <= 19 THEN '02' WHEN CURRENT_AGE >= 20 AND CURRENT_AGE <= 21 THEN '03' WHEN CURRENT_AGE >= 22 AND CURRENT_AGE <= 24 THEN '04' WHEN CURRENT_AGE >= 25 AND CURRENT_AGE <= 29 THEN '05' WHEN CURRENT_AGE >= 30 AND CURRENT_AGE <= 34 THEN '06' WHEN CURRENT_AGE >= 35 AND CURRENT_AGE <= 39 THEN '07' WHEN CURRENT_AGE >= 40 AND CURRENT_AGE <= 49 THEN '08' WHEN CURRENT_AGE >= 50 AND CURRENT_AGE <= 64 THEN '09' WHEN CURRENT_AGE >= 65 AND CURRENT_AGE <= 105 THEN '10' ELSE '11' END
CURRENT_AGE TRUNC(( CURRDTE-BIRTHDTE )/365.25)

DEGREE_NONDEG
CASE WHEN Acad Prog Primary LIKE '%UN' THEN 'Non-Degree' WHEN Acad Prog Primary LIKE '%GN' THEN 'Non-Degree' WHEN Acad Prog Primary LIKE '%PN' THEN 'Non-Degree' WHEN Acad Prog Primary LIKE '%EU' THEN 'Non-Degree' WHEN Acad Prog Primary = 'NDUG' THEN 'Non-Degree' WHEN Acad Prog Primary = 'NDGR' THEN 'Non-Degree' WHEN Acad Prog Primary = 'NDPR' THEN 'Non-Degree' WHEN Acad Prog Primary = 'DIST' THEN 'Non-Degree' WHEN Acad Prog Primary = 'P-NON' THEN 'Non-Degree' WHEN Acad Prog Primary = 'NONCR' THEN 'Non-Degree' WHEN Acad Prog Primary = 'GRNON' THEN 'Non-Degree' ELSE 'Degree' END

ETHNIC_GRP
CASE WHEN Citizenship Status = '4' THEN 'Nonresident Alien' WHEN Ethnic Group = '3' THEN 'Hispanic/Latino' WHEN Hisp Latino = 'Y' THEN 'Hispanic/Latino' WHEN Um Multiple Ethnic = 'Y' THEN '2 or More Races' WHEN Ethnic Group = '1' THEN 'White' WHEN Ethnic Group = '2' THEN 'Black/African American' WHEN Ethnic Group = '4' THEN 'Asian' WHEN Ethnic Group = '5' THEN 'American Indian/Alaska Native' WHEN Ethnic Group = '7' THEN 'Native Hawaiian/Pacific Islander' WHEN Ethnic Group = '6' THEN 'Unknown' ELSE 'Unknown' END

ETHNIC_GRP_SORT
CASE WHEN Citizenship Status = '4' THEN '7' WHEN Ethnic Group = '3' THEN '3' WHEN Hisp Latino = 'Y' THEN '3' WHEN Um Multiple Ethnic = 'Y' THEN '8' WHEN Ethnic Group = '1' THEN '1' WHEN Ethnic Group = '2' THEN '2' WHEN Ethnic Group = '4' THEN '4' WHEN Ethnic Group = '5' THEN '5' WHEN Ethnic Group = '7' THEN '6' WHEN Ethnic Group = '6' THEN '9' ELSE '9' END

EXTERNAL_ORGANIZATION
CASE WHEN Ext Org Id IN ('0136246','0136247','0136248','0136249','0136250','0136252','0136392') THEN 'From UM System' WHEN Ext Org Id IN ('0133747','0135621','0136836','0132691','0132013','0134784','0136593') THEN 'From ME CC System' WHEN Ext Org Id = '0134088' THEN 'From ME Maritime Academy' WHEN ADMIT_TYPE_DESCRIPTION = 'Transfer Student' THEN 'Other External' ELSE ' ' END

EXTERNAL_ORGANIZATION_DTL
CASE WHEN Ext Org Id = '0136246' THEN 'From UMA' WHEN Ext Org Id = '0136247' THEN 'From UMF' WHEN Ext Org Id = '0136248' THEN 'From UMFK' WHEN Ext Org Id = '0136249' THEN 'From UMM' WHEN Ext Org Id = '0136250' THEN 'From UM' WHEN Ext Org Id = '0136252' THEN 'From UMPI' WHEN Ext Org Id = '0136392' THEN 'From USM' WHEN Ext Org Id = '0133747' THEN 'From KVCC' WHEN Ext Org Id = '0135621' THEN 'From SMCC' WHEN Ext Org Id = '0136836' THEN 'From YCCC' WHEN Ext Org Id = '0132691' THEN 'From EMCC' WHEN Ext Org Id = '0132013' THEN 'From CMCC' WHEN Ext Org Id = '0134784' THEN 'From NMCC' WHEN Ext Org Id = '0136593' THEN 'From WCCC' WHEN Ext Org Id = '0134088' THEN 'From MMA' WHEN ADMIT_TYPE_DESCRIPTION = 'Transfer Student' THEN 'Other External' ELSE ' ' END
EXTERNAL_ORGANIZATION_SUM CASE WHEN Ext Org Id IN ('0136246','0136247','0136248','0136249','0136250','0136252','0136392') THEN 'Internal' WHEN Ext Org Id IN ('0133747','0135621','0136836','0132691','0132013','0134784','0136593') THEN 'External' WHEN Ext Org Id = '0134088' THEN 'External' WHEN ADMIT_TYPE_DESCRIPTION = 'Transfer Student' THEN 'External' ELSE ' ' END

EXT_ORG_INST DECODE(Ext Org Id,'0136250','UMS05','0136246','UMS01','0136247','UMS02','0136248','UMS03','0136249','UMS04','0136252','UMS07','0136392','UMS06','OTHER')

FIRST_TERM
CASE WHEN Admit Term = Strm THEN 'Y' WHEN SUBSTR(Strm,3,1) = '1' AND SUBSTR(Admit Term,3,1) = '3' AND STRM_YEAR-ADMIT_TERM_YEAR = 0 THEN 'Y' ELSE 'N' END

FIRST_TIME
CASE WHEN FIRST_TERM = 'Y' AND Institution = 'UMS05' AND Prog Reason = 'RADM' AND DEGREE_NONDEG = 'Degree' THEN 'Y' WHEN FIRST_TERM = 'Y' AND Admit Type IN ('FYR','EFY') AND ( Acad Level Bot = '01' OR Acad Level Bot = '10' ) AND DEGREE_NONDEG = 'Degree' THEN 'Y' WHEN FIRST_TERM = 'Y' AND Admit Type IN ('FYR','EFY') AND "Um Last Sch Type" = 'SCD' AND DEGREE_NONDEG = 'Degree' THEN 'Y' WHEN FIRST_TERM = 'Y' AND Admit Type = 'GRD' AND DEGREE_NONDEG = 'Degree' THEN 'Y' WHEN FIRST_TERM = 'Y' AND Admit Type = 'GR6' AND DEGREE_NONDEG = 'Degree' THEN 'Y' WHEN FIRST_TERM = 'Y' AND Admit Type = 'GR2' AND DEGREE_NONDEG = 'Degree' THEN 'Y' WHEN FIRST_TERM = 'Y' AND Admit Type = 'DAT' AND Acad Career = 'GRAD' AND DEGREE_NONDEG = 'Degree' THEN 'Y' WHEN FIRST_TERM = 'Y' AND Admit Type = 'PBA' AND DEGREE_NONDEG = 'Degree' THEN 'Y' WHEN FIRST_TERM = 'Y' AND Admit Type = 'TRF' AND DEGREE_NONDEG = 'Degree' AND Institution = EXT_ORG_INST THEN 'N' WHEN FIRST_TERM = 'Y' AND Admit Type = 'TRF' AND DEGREE_NONDEG = 'Degree' THEN 'Y' WHEN FIRST_TERM = 'Y' AND Admit Type = 'REA' AND DEGREE_NONDEG = 'Degree' THEN 'Y' WHEN FIRST_TERM = 'Y' AND Admit Type = 'LAW' AND Acad Level Bot = 'L1' AND DEGREE_NONDEG = 'Degree' THEN 'Y' ELSE 'N' END

FIRST_TIME_NON_DEGREE
CASE WHEN FIRST_TERM = 'Y' AND Institution = 'UMS05' AND Prog Reason = 'RADM' AND DEGREE_NONDEG = 'Non-Degree' THEN 'Y' WHEN FIRST_TERM = 'Y' AND Admit Type IN ('FYR','EFY') AND ( Acad Level Bot = '01' OR Acad Level Bot = '10' ) AND DEGREE_NONDEG = 'Non-Degree' THEN 'Y' WHEN FIRST_TERM = 'Y' AND Admit Type IN ('FYR','EFY') AND "Um Last Sch Type" = 'SCD' AND DEGREE_NONDEG = 'Non-Degree' THEN 'Y' WHEN FIRST_TERM = 'Y' AND Admit Type = 'GRD' AND DEGREE_NONDEG = 'Non-Degree' THEN 'Y' WHEN FIRST_TERM = 'Y' AND Admit Type = 'GR6' AND DEGREE_NONDEG = 'Non-Degree' THEN 'Y' WHEN FIRST_TERM = 'Y' AND Admit Type = 'PBA' AND DEGREE_NONDEG = 'Non-Degree' THEN 'Y' WHEN FIRST_TERM = 'Y' AND Admit Type = 'TRF' AND DEGREE_NONDEG = 'Non-Degree' THEN 'Y' WHEN FIRST_TERM = 'Y' AND Admit Type = 'REA' AND DEGREE_NONDEG = 'Non-Degree' THEN 'Y' WHEN FIRST_TERM = 'Y' AND Admit Type = 'LAW' AND Acad Level Bot = 'L1' AND DEGREE_NONDEG = 'Non-Degree' THEN 'Y' ELSE 'N' END
FTE Um Unt Tak Prg Rc/FTE DIVISOR

FTE_DIVISOR
CASE WHEN Acad Level Bot = 'GR' THEN 9 WHEN Acad Level Bot = 'MAS' THEN 9 WHEN Acad Level Bot = 'PHD' THEN 9 WHEN Acad Level Bot = 'L1' THEN 15 WHEN Acad Level Bot = 'L2' THEN 15 WHEN Acad Level Bot = 'L3' THEN 15 WHEN Institution = 'UMS02' THEN 16 ELSE 15 END

FULL_PART 
CASE WHEN Acad Level Bot = 'GR' AND Um Unt Tak Prg Rc >= 6 THEN 'Full-Time' WHEN Acad Level Bot = 'MAS' AND Um Unt Tak Prg Rc >= 6 THEN 'Full-Time' WHEN Acad Level Bot = 'PHD' AND Um Unt Tak Prg Rc >= 6 THEN 'Full-Time' WHEN Um Unt Tak Prg Rc >= 12 THEN 'Full-Time' ELSE 'Part-Time' END

GENDER CASE WHEN Sex = 'M' THEN 'Male' ELSE 'Female' END

GRADUATION_DATE_YEAR TO_NUMBER(TO_CHAR(EUL_DATE_TRUNC(Graduation Dt,'YYYY'),'YYYY'),'9999')
HEADCOUNT 1

IN_OUT
CASE WHEN Residency = 'IS' THEN 'In-State' ELSE 'Out-of-State' END

MAINE_COUNTY
CASE WHEN CALCULATED COUNTY = 'Aroostook' THEN 'Y' WHEN CALCULATED COUNTY = 'Androscoggin' THEN 'Y' WHEN CALCULATED COUNTY = 'Hancock' THEN 'Y' WHEN CALCULATED COUNTY = 'Knox' THEN 'Y' WHEN CALCULATED COUNTY = 'Kennebec' THEN 'Y' WHEN CALCULATED COUNTY = 'Franklin' THEN 'Y' WHEN CALCULATED COUNTY = 'Lincoln' THEN 'Y' WHEN CALCULATED COUNTY = 'Hancock' THEN 'Y' WHEN CALCULATED COUNTY = 'Penobscot' THEN 'Y' WHEN CALCULATED COUNTY = 'Piscataquis' THEN 'Y' WHEN CALCULATED COUNTY = 'Sagadahoc' THEN 'Y' WHEN CALCULATED COUNTY = 'Somerset' THEN 'Y' WHEN CALCULATED COUNTY = 'Waldo' THEN 'Y' WHEN CALCULATED COUNTY = 'Washington' THEN 'Y' WHEN CALCULATED COUNTY = 'Oxford' THEN 'Y' WHEN CALCULATED COUNTY = 'York' THEN 'Y' ELSE 'N' END

NEASC_LEVEL
CASE WHEN Acad Prog Primary LIKE '%UN' THEN 'Non-Degree Undergraduate' WHEN Acad Prog Primary LIKE '%GN' THEN 'Non-Degree Graduate' WHEN Acad Prog Primary LIKE '%PN' THEN 'Non-Degree Law' WHEN Acad Prog Primary LIKE '%EU' THEN 'Non-Degree Undergraduate' WHEN Acad Prog Primary = 'NDUG' THEN 'Non-Degree Undergraduate' WHEN Acad Prog Primary = 'DIST' THEN 'Non-Degree Undergraduate' WHEN Acad Prog Primary = 'P-NON' THEN 'Non-Degree Undergraduate' WHEN Acad Prog Primary = 'NONCR' THEN 'Non-Degree Undergraduate' WHEN Acad Prog Primary = 'NDGR' THEN 'Non-Degree Graduate' WHEN Acad Prog Primary = 'GRNON' THEN 'Non-Degree Graduate' WHEN Acad Prog Primary = 'NDPR' AND Institution = 'UMS06' THEN 'Non-Degree Law' WHEN Acad Prog Primary = 'NDPR' THEN 'Non-Degree Undergraduate' WHEN Level Load Rule = 'UG2YR' THEN 'Associate' WHEN Level Load Rule = 'UG4YR' THEN 'Baccalaureate' WHEN Level Load Rule = 'UG' THEN 'Baccalaureate' WHEN Level Load Rule = 'UGAS' THEN 'Associate' WHEN Level Load Rule = 'UGA' THEN 'Associate' WHEN Level Load Rule = 'AA' THEN 'Associate' WHEN Acad Level Bot = 'PHD' THEN 'Doctorate' WHEN Level Load Rule = 'GR' THEN 'Masters' WHEN Level Load Rule = 'GRAD' THEN 'Masters' WHEN Level Load Rule = 'LAW' THEN 'Law' WHEN Acad Career = 'UGRD' THEN 'Baccalaureate' WHEN Acad Career = 'GRAD' THEN 'Masters' WHEN Acad Career = 'LAW' THEN 'Law' WHEN Acad Career = 'PBAC' THEN 'Baccalaureate' ELSE 'Other' END

NEASC_LEVEL_SORT
CASE WHEN Acad Prog Primary LIKE '%UN' THEN '12' WHEN Acad Prog Primary LIKE '%GN' THEN '16' WHEN Acad Prog Primary LIKE '%PN' THEN '17' WHEN Acad Prog Primary LIKE '%EU' THEN '12' WHEN Acad Prog Primary = 'NDUG' THEN '12' WHEN Acad Prog Primary = 'DIST' THEN '12' WHEN Acad Prog Primary = 'P-NON' THEN '12' WHEN Acad Prog Primary = 'NONCR' THEN '12' WHEN Acad Prog Primary = 'NDGR' THEN '16' WHEN Acad Prog Primary = 'GRNON' THEN '16' WHEN Acad Prog Primary = 'NDPR' AND Institution = 'UMS06' THEN '17' WHEN Acad Prog Primary = 'NDPR' THEN '12' WHEN Level Load Rule = 'UG2YR' THEN '10' WHEN Level Load Rule = 'UG4YR' THEN '11' WHEN Level Load Rule = 'UG' THEN '11' WHEN Level Load Rule = 'UGAS' THEN '10' WHEN Level Load Rule = 'UGA' THEN '10' WHEN Level Load Rule = 'AA' THEN '10' WHEN Acad Level Bot = 'PHD' THEN '14' WHEN Level Load Rule = 'GR' THEN '13' WHEN Level Load Rule = 'GRAD' THEN '13' WHEN Level Load Rule = 'LAW' THEN '15' WHEN Acad Career = 'UGRD' THEN '11' WHEN Acad Career = 'GRAD' THEN '13' WHEN Acad Career = 'LAW' THEN '15' WHEN Acad Career = 'PBAC' THEN '11' ELSE '20' END

NURSING
CASE WHEN Acad Plan LIKE 'NUR%' THEN 'Y' WHEN Acad Prog LIKE 'NUR%' THEN 'Y' ELSE 'N' END

RESIDENCY_DESCR
CASE WHEN Residency = 'IS' THEN 'In-State' WHEN Residency = 'OS' THEN 'Out-of-State' WHEN Residency = 'CAN' THEN 'Canadian' WHEN Residency = 'NEBHE' THEN 'NEBHE' WHEN Residency = 'INTNL' THEN 'International' ELSE 'Out-of-State' END

RESIDENCY_DESCR_SORT
CASE WHEN Residency = 'IS' THEN '10' WHEN Residency = 'OS' THEN '20' WHEN Residency = 'CAN' THEN '40' WHEN Residency = 'NEBHE' THEN '30' WHEN Residency = 'INTNL' THEN '50' ELSE '20' END

STRM_YEAR
CASE WHEN SUBSTR(Strm,3,1) = '1' THEN TO_NUMBER('20'||SUBSTR(Strm,1,2),'9999')-1 ELSE TO_NUMBER('20'||SUBSTR(Strm,1,2),'9999') END

STUDENT_NAME_FORMATTED
CASE WHEN Student Name Suffix <= ' ' AND "Student Last Name" > ' ' THEN "Student Last Name"||', '||"Student First Name"||' '||Student Middle Name WHEN "Student Last Name" > ' ' THEN "Student Last Name"||' '||Student Name Suffix||', '||"Student First Name"||' '||Student Middle Name ELSE '' END

STUDENT_LEVEL
CASE WHEN Acad Prog Primary LIKE '%UN' THEN 'Non-Degree Undergraduate' WHEN Acad Prog Primary LIKE '%GN' THEN 'Non-Degree Graduate' WHEN Acad Prog Primary LIKE '%PN' THEN 'Non-Degree Law' WHEN Acad Prog Primary LIKE '%EU' THEN 'Non-Degree Undergraduate' WHEN Acad Prog Primary = 'NDUG' THEN 'Non-Degree Undergraduate' WHEN Acad Prog Primary = 'DIST' THEN 'Non-Degree Undergraduate' WHEN Acad Prog Primary = 'P-NON' THEN 'Non-Degree Undergraduate' WHEN Acad Prog Primary = 'NONCR' THEN 'Non-Degree Undergraduate' WHEN Acad Prog Primary = 'NDGR' THEN 'Non-Degree Graduate' WHEN Acad Prog Primary = 'GRNON' THEN 'Non-Degree Graduate' WHEN Acad Prog Primary = 'NDPR' AND Institution = 'UMS06' THEN 'Non-Degree Law' WHEN Acad Prog Primary = 'NDPR' THEN 'Non-Degree Undergraduate' WHEN Level Load Rule = 'UG2YR' THEN 'Associate' WHEN Level Load Rule = 'UG4YR' THEN 'Baccalaureate' WHEN Level Load Rule = 'UG' THEN 'Baccalaureate' WHEN Level Load Rule = 'UGAS' THEN 'Associate' WHEN Level Load Rule = 'UGA' THEN 'Associate' WHEN Level Load Rule = 'AA' THEN 'Associate' WHEN Level Load Rule = 'GR' THEN 'Graduate' WHEN Level Load Rule = 'GRAD' THEN 'Graduate' WHEN Level Load Rule = 'LAW' THEN 'Law' WHEN Acad Career = 'UGRD' THEN 'Baccalaureate' WHEN Acad Career = 'GRAD' THEN 'Graduate' WHEN Acad Career = 'LAW' THEN 'Law' WHEN Acad Career = 'PBAC' THEN 'Baccalaureate' ELSE 'Other' END

STUDENT_LEVEL_SORT
CASE WHEN Acad Prog Primary LIKE '%UN' THEN '12' WHEN Acad Prog Primary LIKE '%GN' THEN '14' WHEN Acad Prog Primary LIKE '%PN' THEN '16' WHEN Acad Prog Primary LIKE '%EU' THEN '12' WHEN Acad Prog Primary = 'NDUG' THEN '12' WHEN Acad Prog Primary = 'DIST' THEN '12' WHEN Acad Prog Primary = 'P-NON' THEN '12' WHEN Acad Prog Primary = 'NONCR' THEN '12' WHEN Acad Prog Primary = 'NDGR' THEN '14' WHEN Acad Prog Primary = 'GRNON' THEN '14' WHEN Acad Prog Primary = 'NDPR' AND Institution = 'UMS06' THEN '16' WHEN Acad Prog Primary = 'NDPR' THEN '12' WHEN Level Load Rule = 'UG2YR' THEN '10' WHEN Level Load Rule = 'UG4YR' THEN '11' WHEN Level Load Rule = 'UG' THEN '11' WHEN Level Load Rule = 'UGAS' THEN '10' WHEN Level Load Rule = 'UGA' THEN '10' WHEN Level Load Rule = 'AA' THEN '10' WHEN Level Load Rule = 'GR' THEN '13' WHEN Level Load Rule = 'GRAD' THEN '13' WHEN Level Load Rule = 'LAW' THEN '15' WHEN Acad Career = 'UGRD' THEN '11' WHEN Acad Career = 'GRAD' THEN '13' WHEN Acad Career = 'LAW' THEN '15' WHEN Acad Career = 'PBAC' THEN '11' ELSE '20' END

STUDENT_LEVEL_SUM
CASE WHEN Acad Prog Primary LIKE '%UN' THEN 'Undergraduate' WHEN Acad Prog Primary LIKE '%GN' THEN 'Graduate' WHEN Acad Prog Primary LIKE '%PN' THEN 'Law' WHEN Acad Prog Primary LIKE '%EU' THEN 'Undergraduate' WHEN Acad Prog Primary = 'NDUG' THEN 'Undergraduate' WHEN Acad Prog Primary = 'DIST' THEN 'Undergraduate' WHEN Acad Prog Primary = 'P-NON' THEN 'Undergraduate' WHEN Acad Prog Primary = 'NONCR' THEN 'Undergraduate' WHEN Acad Prog Primary = 'NDGR' THEN 'Graduate' WHEN Acad Prog Primary = 'GRNON' THEN 'Graduate' WHEN Acad Prog Primary = 'NDPR' AND Institution = 'UMS06' THEN 'Law' WHEN Acad Prog Primary = 'NDPR' THEN 'Undergraduate' WHEN Level Load Rule = 'UG2YR' THEN 'Undergraduate' WHEN Level Load Rule = 'UG4YR' THEN 'Undergraduate' WHEN Level Load Rule = 'UG' THEN 'Undergraduate' WHEN Level Load Rule = 'UGAS' THEN 'Undergraduate' WHEN Level Load Rule = 'UGA' THEN 'Undergraduate' WHEN Level Load Rule = 'AA' THEN 'Undergraduate' WHEN Level Load Rule = 'GR' THEN 'Graduate' WHEN Level Load Rule = 'GRAD' THEN 'Graduate' WHEN Level Load Rule = 'LAW' THEN 'Law' WHEN Acad Career = 'UGRD' THEN 'Undergraduate' WHEN Acad Career = 'GRAD' THEN 'Graduate' WHEN Acad Career = 'LAW' THEN 'Law' WHEN Acad Career = 'PBAC' THEN 'Undergraduate' ELSE 'Other' END

STUDENT_LEVEL_SUM_SORT
CASE WHEN Acad Prog Primary LIKE '%UN' THEN '10' WHEN Acad Prog Primary LIKE '%GN' THEN '11' WHEN Acad Prog Primary LIKE '%PN' THEN '12' WHEN Acad Prog Primary LIKE '%EU' THEN '10' WHEN Acad Prog Primary = 'NDUG' THEN '10' WHEN Acad Prog Primary = 'DIST' THEN '10' WHEN Acad Prog Primary = 'P-NON' THEN '10' WHEN Acad Prog Primary = 'NONCR' THEN '10' WHEN Acad Prog Primary = 'NDGR' THEN '11' WHEN Acad Prog Primary = 'GRNON' THEN '11' WHEN Acad Prog Primary = 'NDPR' AND Institution = 'UMS06' THEN '12' WHEN Acad Prog Primary = 'NDPR' THEN '10' WHEN Level Load Rule = 'UG2YR' THEN '10' WHEN Level Load Rule = 'UG4YR' THEN '10' WHEN Level Load Rule = 'UG' THEN '10' WHEN Level Load Rule = 'UGAS' THEN '10' WHEN Level Load Rule = 'UGA' THEN '10' WHEN Level Load Rule = 'AA' THEN '10' WHEN Level Load Rule = 'GR' THEN '11' WHEN Level Load Rule = 'GRAD' THEN '11' WHEN Level Load Rule = 'LAW' THEN '12' WHEN Acad Career = 'UGRD' THEN '10' WHEN Acad Career = 'GRAD' THEN '11' WHEN Acad Career = 'LAW' THEN '12' WHEN Acad Career = 'PBAC' THEN '10' ELSE '20' END

STUDENT_LEVEL_SUM_UG_GRAD
CASE WHEN Acad Prog Primary LIKE '%UN' THEN 'Undergraduate' WHEN Acad Prog Primary LIKE '%GN' THEN 'Graduate' WHEN Acad Prog Primary LIKE '%PN' THEN 'Graduate' WHEN Acad Prog Primary LIKE '%EU' THEN 'Undergraduate' WHEN Acad Prog Primary = 'NDUG' THEN 'Undergraduate' WHEN Acad Prog Primary = 'DIST' THEN 'Undergraduate' WHEN Acad Prog Primary = 'P-NON' THEN 'Undergraduate' WHEN Acad Prog Primary = 'NONCR' THEN 'Undergraduate' WHEN Acad Prog Primary = 'NDGR' THEN 'Graduate' WHEN Acad Prog Primary = 'GRNON' THEN 'Graduate' WHEN Acad Prog Primary = 'NDPR' AND Institution = 'UMS06' THEN 'Graduate' WHEN Acad Prog Primary = 'NDPR' THEN 'Undergraduate' WHEN Level Load Rule = 'UG2YR' THEN 'Undergraduate' WHEN Level Load Rule = 'UG4YR' THEN 'Undergraduate' WHEN Level Load Rule = 'UG' THEN 'Undergraduate' WHEN Level Load Rule = 'UGAS' THEN 'Undergraduate' WHEN Level Load Rule = 'UGA' THEN 'Undergraduate' WHEN Level Load Rule = 'AA' THEN 'Undergraduate' WHEN Level Load Rule = 'GR' THEN 'Graduate' WHEN Level Load Rule = 'GRAD' THEN 'Graduate' WHEN Level Load Rule = 'LAW' THEN 'Graduate' WHEN Acad Career = 'UGRD' THEN 'Undergraduate' WHEN Acad Career = 'GRAD' THEN 'Graduate' WHEN Acad Career = 'LAW' THEN 'Graduate' WHEN Acad Career = 'PBAC' THEN 'Undergraduate' ELSE 'Other' END

TUITION_COUNTRY
CASE WHEN Residency = 'IS' THEN 'USA' WHEN Citizenship Status = '4' AND Um Country Oth > ' ' THEN Um Country Oth WHEN Citizenship Status = '4' AND ( Country <> 'USA' AND Country > ' ' ) THEN Country WHEN Citizenship Status = '4' AND Residency = 'CAN' THEN 'CAN' WHEN Citizenship Status = '4' THEN 'OTH' ELSE 'USA' END

TUITION_COUNTY
CASE WHEN Residency = 'IS' AND LOWER(County) LIKE '%dros%' THEN 'Androscoggin' WHEN Residency = 'IS' AND LOWER(County) LIKE '%aroos%' THEN 'Aroostook' WHEN Residency = 'IS' AND LOWER(County) LIKE '%cumber%' THEN 'Cumberland' WHEN Residency = 'IS' AND LOWER(County) LIKE '%frank%' THEN 'Franklin' WHEN Residency = 'IS' AND LOWER(County) LIKE '%hanc%' THEN 'Hancock' WHEN Residency = 'IS' AND LOWER(County) LIKE '%bec' THEN 'Kennebec' WHEN Residency = 'IS' AND LOWER(County) LIKE '%knox' THEN 'Knox' WHEN Residency = 'IS' AND LOWER(County) LIKE '%lincoln' THEN 'Lincoln' WHEN Residency = 'IS' AND LOWER(County) LIKE '%oxford' THEN 'Oxford' WHEN Residency = 'IS' AND LOWER(County) LIKE '%penob%' THEN 'Penobscot' WHEN Residency = 'IS' AND LOWER(County) LIKE '%piscat%' THEN 'Piscataquis' WHEN Residency = 'IS' AND LOWER(County) LIKE '%saga%' THEN 'Sagadahoc' WHEN Residency = 'IS' AND LOWER(County) LIKE '%somer%' THEN 'Somerset' WHEN Residency = 'IS' AND LOWER(County) LIKE '%waldo' THEN 'Waldo' WHEN Residency = 'IS' AND LOWER(County) LIKE '%wash%' THEN 'Washington' WHEN Residency = 'IS' AND LOWER(County) LIKE '%york' THEN 'York' WHEN Residency = 'IS' AND Institution = 'UMS01' THEN 'Kennebec' WHEN Residency = 'IS' AND Institution = 'UMS02' THEN 'Franklin' WHEN Residency = 'IS' AND Institution = 'UMS03' THEN 'Aroostook' WHEN Residency = 'IS' AND Institution = 'UMS04' THEN 'Washington' WHEN Residency = 'IS' AND Institution = 'UMS05' THEN 'Penobscot' WHEN Residency = 'IS' AND Institution = 'UMS06' THEN 'Cumberland' WHEN Residency = 'IS' AND Institution = 'UMS07' THEN 'Aroostook' ELSE 'Non-Maine' END

TUITION_STATE
CASE WHEN Residency = 'IS' THEN 'Maine' WHEN State = 'AB' AND TUITION COUNTRY = 'CAN' THEN 'Alberta' WHEN State = 'BC' AND TUITION COUNTRY = 'CAN' THEN 'British Columbia' WHEN State = 'MB' AND TUITION COUNTRY = 'CAN' THEN 'Manitoba' WHEN State = 'NB' AND TUITION COUNTRY = 'CAN' THEN 'New Brunswick' WHEN State = 'NF' AND TUITION COUNTRY = 'CAN' THEN 'Newfoundland' WHEN State = 'NL' AND TUITION COUNTRY = 'CAN' THEN 'Newfoundland' WHEN State = 'NS' AND TUITION COUNTRY = 'CAN' THEN 'Nova Scotia' WHEN State = 'NT' AND TUITION COUNTRY = 'CAN' THEN 'Northwest Territories' WHEN State = 'NN' AND TUITION COUNTRY = 'CAN' THEN 'Nunavut' WHEN State = 'NU' AND TUITION COUNTRY = 'CAN' THEN 'Nunavut' WHEN State = 'ON' AND TUITION COUNTRY = 'CAN' THEN 'Ontario' WHEN State = 'PE' AND TUITION COUNTRY = 'CAN' THEN 'Prince Edward Island' WHEN State = 'QC' AND TUITION COUNTRY = 'CAN' THEN 'Quebec' WHEN State = 'SK' AND TUITION COUNTRY = 'CAN' THEN 'Saskatchewan' WHEN State = 'YT' AND TUITION COUNTRY = 'CAN' THEN 'Yukon' WHEN TUITION COUNTRY = 'CAN' THEN 'Canada' WHEN Citizenship Status = '4' THEN 'Non-USA' WHEN State <> 'ME' AND State Descr1 > ' ' THEN State Descr1 WHEN State = 'NH' THEN 'New Hampshire' WHEN State = 'VT' THEN 'Vermont' WHEN State = 'MA' THEN 'Massachusetts' WHEN State = 'CT' THEN 'Connecticut' WHEN State = 'RI' THEN 'Rhode Island' ELSE 'Other State' END

SCHOOL_CODE
CASE WHEN Institution = 'UMS01' THEN '006760' WHEN Institution = 'UMS02' THEN '002040' WHEN Institution = 'UMS03' THEN '002041' WHEN Institution = 'UMS04' THEN '002055' WHEN Institution = 'UMS05' THEN '002053' WHEN Institution = 'UMS06' THEN '002054' WHEN Institution = 'UMS07' THEN '002033' ELSE ' ' END