Created by Corina C Larsen, last modified on Jul 16, 2018

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 or the UM_D_STD_ENR_VW - Student Enrollment Table. The field names may be different in the actual table or they fields may not have been used.  This is for reference only.

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

CLASS_DELIVERY_MODE 
CASE WHEN Dist Attr Flag = 'Y' AND Distance Flag = 'R' AND Imode = 'ITV' THEN 'Distance ITV' WHEN Dist Attr Flag = 'Y' AND Distance Flag = 'R' AND Imode = 'VIDEOCONF' THEN 'Distance Video Conference' WHEN Dist Attr Flag = 'Y' AND Distance Flag = 'B' AND Imode = 'ITV' AND UNIV CENTER FLAG = 'Y' THEN 'Distance Onsite' WHEN Dist Attr Flag = 'Y' AND Distance Flag = 'B' AND Imode = 'VIDEOCONF' AND UNIV CENTER FLAG = 'Y' THEN 'Distance Onsite' WHEN Dist Attr Flag = 'Y' AND Imode = 'ONLINE' THEN 'Distance Online' WHEN Dist Attr Flag = 'Y' AND Imode = 'ONSITE' THEN 'Distance Onsite' WHEN Instruction Mode = 'RE' THEN 'Distance ITV' WHEN Instruction Mode = 'TV' THEN 'Distance ITV' WHEN Instruction Mode = 'TW' THEN 'Distance ITV' WHEN Instruction Mode = 'VC' THEN 'Distance Video Conference' WHEN Instruction Mode = 'VD' THEN 'Distance Video Conference' WHEN Instruction Mode = 'VS' THEN 'Distance Online' WHEN Instruction Mode = 'WB' THEN 'Distance Online' WHEN Location = 'V02035' THEN 'Distance Online' WHEN UNIV CENTER FLAG = 'Y' THEN 'Distance Onsite' ELSE 'Traditional Class ' END

CLASS_LEVEL 
CASE WHEN Catalog Nbr = ' ' THEN 0 WHEN SUBSTR(Catalog Nbr,1,1) <> ' ' THEN TO_NUMBER(SUBSTR(Catalog Nbr,1,1)) WHEN SUBSTR(Catalog Nbr,2,3) < '100' THEN 0 ELSE TO_NUMBER(SUBSTR(Catalog Nbr,2,1)) END

DIST_ATTR_FLG_DESCR 
CASE WHEN Dist Attr Flag = 'Y' THEN 'Distance Course' ELSE 'Traditional Campus Course' END

DIST_CLASS 
CASE WHEN Dist Attr Flag = 'Y' AND Distance Flag = 'R' AND Imode = 'ITV' THEN 'UC DIST' WHEN Dist Attr Flag = 'Y' AND Distance Flag = 'R' AND Imode = 'VIDEOCONF' THEN 'UC DIST' WHEN Dist Attr Flag = 'Y' AND Distance Flag = 'B' AND Imode = 'ITV' AND UNIV CENTER FLAG = 'Y' THEN 'UC DIST' WHEN Dist Attr Flag = 'Y' AND Distance Flag = 'B' AND Imode = 'VIDEOCONF' AND UNIV CENTER FLAG = 'Y' THEN 'UC DIST' WHEN Dist Attr Flag = 'Y' AND Imode = 'ONLINE' THEN 'UC DIST' WHEN Dist Attr Flag = 'Y' AND Imode = 'ONSITE' THEN 'UC DIST' WHEN Instruction Mode = 'RE' THEN 'OTHER DIST' WHEN Instruction Mode = 'TV' THEN 'OTHER DIST' WHEN Instruction Mode = 'TW' THEN 'OTHER DIST' WHEN Instruction Mode = 'VC' THEN 'OTHER DIST' WHEN Instruction Mode = 'VD' THEN 'OTHER DIST' WHEN Instruction Mode = 'VS' THEN 'OTHER DIST' WHEN Instruction Mode = 'WB' THEN 'OTHER DIST' WHEN Location = 'V02035' THEN 'OTHER DIST' WHEN UNIV CENTER FLAG = 'Y' THEN 'OTHER DIST' ELSE 'NOT DIST' END

DIST_FLG_DESCR 
CASE WHEN Distance Flag = 'B' THEN 'Broadcast' WHEN Distance Flag = 'R' THEN 'Receive' ELSE ' ' END

INSTRUCTION_MODE_DESCR 
CASE WHEN Instruction Mode = 'BL' THEN 'Blended Class' WHEN Instruction Mode = 'BR' THEN 'Broadcast Class' WHEN Instruction Mode = 'P' THEN 'Onsite Class' WHEN Instruction Mode = 'RE' THEN 'Receive Class' WHEN Instruction Mode = 'TR' THEN 'Travel Class' WHEN Instruction Mode = 'TV' THEN 'ITV Class' WHEN Instruction Mode = 'TW' THEN 'ITV/Online Class' WHEN Instruction Mode = 'VC' THEN 'Video Conference Class' WHEN Instruction Mode = 'VD' THEN 'Video Tape Class' WHEN Instruction Mode = 'VS' THEN 'Video Stream Class' WHEN Instruction Mode = 'WB' THEN 'Online Class' ELSE 'Other' END

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

IPEDS_DIST_CLASS 
CASE WHEN Dist Attr Flag = 'Y' AND Distance Flag = 'R' AND Imode = 'ITV' THEN 'UC DIST' WHEN Dist Attr Flag = 'Y' AND Distance Flag = 'R' AND Imode = 'VIDEOCONF' THEN 'UC DIST' WHEN Dist Attr Flag = 'Y' AND Imode = 'ONLINE' THEN 'UC DIST' WHEN Instruction Mode = 'RE' THEN 'OTHER DIST' WHEN Instruction Mode = 'TV' THEN 'OTHER DIST' WHEN Instruction Mode = 'TW' THEN 'OTHER DIST' WHEN Instruction Mode = 'VC' THEN 'OTHER DIST' WHEN Instruction Mode = 'VD' THEN 'OTHER DIST' WHEN Instruction Mode = 'VS' THEN 'OTHER DIST' WHEN Instruction Mode = 'WB' THEN 'OTHER DIST' WHEN Location = 'V02035' THEN 'OTHER DIST' ELSE 'NOT DIST' END

LOC_DESCR 
CASE WHEN CLASS DELIVERY MODE = 'Distance Online' THEN 'Distance Online' WHEN Location = 'V01190' THEN 'Bath/Brunswick UC Center' WHEN Location = 'V01525' THEN 'Falmouth - Baxter School' WHEN Location = 'V01820' THEN 'Lisbon Falls' WHEN Location = 'V02047' THEN 'Windham/Maine Correctional Center' WHEN Location = 'V02060' THEN 'Wiscasset' WHEN Location = 'V01440' THEN 'East Millinocket UC Center' WHEN Location = 'V01800' THEN 'Lincoln' WHEN Location = 'V01970' THEN 'Sherman Station' WHEN Location = 'V01490' THEN 'Ellsworth UC Center' WHEN Location = 'V01070' THEN 'Bangor - BMHI' WHEN Location = 'V01210' THEN 'Bucksport' WHEN Location = 'V01360' THEN 'Deer Isle' WHEN Location = 'V01450' THEN 'East Sullivan' WHEN Location = 'V01740' THEN 'Isle au Haut' WHEN Location = 'V01900' THEN 'Mount Desert' WHEN Location = 'V01980' THEN 'Swans Island' WHEN Location = 'V01690' THEN 'Houlton UC Center' WHEN Location = 'V01700' THEN 'Houlton' WHEN Location = 'V01250' THEN 'Caribou' WHEN Location = 'V01340' THEN 'Danforth' WHEN Location = 'V01540' THEN 'Fort Fairfield' WHEN Location = 'V01730' THEN 'Island Falls' WHEN Location = 'V01972' THEN 'Norway/South Paris UC Center' WHEN Location = 'V01160' THEN 'Bethel' WHEN Location = 'V01390' THEN 'Penquis/Dover-Foxcroft UC Center' WHEN Location = 'V01380' THEN 'Dexter' WHEN Location = 'V01640' THEN 'Greenville' WHEN Location = 'V01650' THEN 'Guilford' WHEN Location = 'V01670' THEN 'Hermon' WHEN Location = 'V01760' THEN 'Jackman' WHEN Location = 'V01910' THEN 'Newport' WHEN Location = 'V01945' THEN 'Rockland UC Center' WHEN Location = 'V01230' THEN 'Camden' WHEN Location = 'V01750' THEN 'Islesboro' WHEN Location = 'V01902' THEN 'Lincoln Academy (Newcastle)' WHEN Location = 'V01895' THEN 'Monhegan Island' WHEN Location = 'V02020' THEN 'Maine State Prison' WHEN Location = 'V02020' THEN 'Maine State Prison' WHEN Location = 'V01920' THEN 'North Haven' WHEN Location = 'V01982' THEN 'Maine State Prison' WHEN Location = 'V02010' THEN 'Vinalhaven' WHEN Location = 'V01874' THEN 'Rumford/Mexico UC Center' WHEN Location = 'V01170' THEN 'Bingham' WHEN Location = 'V01780' THEN 'Kingfield' WHEN Location = 'V01830' THEN 'Livermore Falls' WHEN Location = 'V01535' THEN 'Farmington - Mt. Blue' WHEN Location = 'V01940' THEN 'Rangeley' WHEN Location = 'V01950' THEN 'Saco UC Center' WHEN Location = 'V01954' THEN 'Sanford High School' WHEN Location = 'V01951' THEN 'Sanford UC Center' WHEN Location = 'V01955' THEN 'Scarborough' WHEN Location = 'V01973' THEN 'South Berwick' WHEN Location = 'V01928' THEN 'Orono UM Campus' WHEN Location = 'V01150' THEN 'Hutchinson Center - Belfast' WHEN Location = 'V01035' THEN 'Augusta UMA Campus' WHEN Location = 'V01075' THEN 'Bangor UMA Campus' WHEN Location = 'V01520' THEN 'Fairfield' WHEN Location = 'V01037' THEN 'Maine State Library' WHEN Location = 'V01040' THEN 'Riverview Psychiatric' WHEN Location = 'V01971' THEN 'Skowhegan' WHEN Location = 'V01990' THEN 'Thorndike' WHEN Location = 'V02050' THEN 'Winthrop' WHEN Location = 'V01530' THEN 'Farmington UMF Campus' WHEN Location = 'V02081' THEN 'Farmington UMF Campus' WHEN Location = 'V09998' THEN 'Farmington UMF Campus' WHEN Location = 'V01545' THEN 'Fort Kent UMFK Campus' WHEN Location = 'V02085' THEN 'Fort Kent UMFK Campus' WHEN Location = 'V01410' THEN 'Eagle Lake' WHEN Location = 'V01546' THEN 'Fort Kent' WHEN Location = 'V01860' THEN 'Madawaska' WHEN Location = 'V02000' THEN 'Van Buren' WHEN Location = 'V01855' THEN 'Machias UMM Campus' WHEN Location = 'V02081' THEN 'Machias UMM Campus' WHEN Location = 'V01215' THEN 'Calais' WHEN Location = 'V01470' THEN 'Eastport' WHEN Location = 'V01850' THEN 'Lubec' WHEN Location = 'V01939' THEN 'Presque Isle UMPI Campus' WHEN Location = 'V01941' THEN 'Presque Isle High School' WHEN Location = 'V01595' THEN 'Gorham USM Campus' WHEN Location = 'V01785' THEN 'Lewiston-Auburn USM Campus' WHEN Location = 'V01938' THEN 'Portland USM Campus' WHEN Location = 'V02082' THEN 'USM Campus' WHEN Location = 'V99099' THEN 'USM Campus' WHEN Campus2 = 'BATH' THEN 'Bat/Brunswick UC Center' WHEN Campus2 = 'BBC' THEN 'Bath/Brunswick UC Center' WHEN Campus2 = 'ELL' THEN 'Ellsworth UC Center' WHEN Campus2 = 'EML' THEN 'East Millinocket UC Center' WHEN Campus2 = 'FHC' THEN 'Hutchinson Center - Belfast' WHEN Campus2 = 'HOU' THEN 'Houlton UC Center' WHEN Campus2 = 'HOULT' THEN 'Houlton UC Center' WHEN Campus2 = 'PEN' THEN 'Penquis /Dover-Foxcroft UC Center' WHEN Campus2 = 'ROC' THEN 'Rockland UC Center' WHEN Campus2 = 'RUM' THEN 'Rumford/Mexico UC Center' WHEN Campus2 = 'SAC' THEN 'Saco UC Center' WHEN Campus2 = 'SACO' THEN 'Saco UC Center' WHEN Campus2 = 'SOP' THEN 'Norway/South Paris UC Center' WHEN Institution2 = 'UMS01' THEN 'Augusta UMA Campus' WHEN Institution2 = 'UMS02' THEN 'Farmington UMF Campus' WHEN Institution2 = 'UMS03' THEN 'Fort Kent UMFK Campus' WHEN Institution2 = 'UMS04' THEN 'Machias UMM Campus' WHEN Institution2 = 'UMS05' THEN 'Orono UM Campus' WHEN Institution2 = 'UMS06' THEN 'USM Campus' WHEN Institution2 = 'UMS07' THEN 'Presque Isle UMPI Campus' ELSE 'Other' END

REGION 
CASE WHEN CLASS DELIVERY MODE = 'Distance Online' THEN 'Distance Online' WHEN Location = 'V01190' THEN 'Bath/Brunswick UC Center' WHEN Location = 'V01525' THEN 'Bath/Brunswick UC Center' WHEN Location = 'V01820' THEN 'Bath/Brunswick UC Center' WHEN Location = 'V02047' THEN 'Bath/Brunswick UC Center' WHEN Location = 'V02060' THEN 'Bath/Brunswick UC Center' WHEN Location = 'V01440' THEN 'East Millinocket UC Center' WHEN Location = 'V01800' THEN 'East Millinocket UC Center' WHEN Location = 'V01970' THEN 'East Millinocket UC Center' WHEN Location = 'V01490' THEN 'Ellsworth UC Center' WHEN Location = 'V01070' THEN 'Ellsworth UC Center' WHEN Location = 'V01210' THEN 'Ellsworth UC Center' WHEN Location = 'V01360' THEN 'Ellsworth UC Center' WHEN Location = 'V01450' THEN 'Ellsworth UC Center' WHEN Location = 'V01740' THEN 'Ellsworth UC Center' WHEN Location = 'V01900' THEN 'Ellsworth UC Center' WHEN Location = 'V01980' THEN 'Ellsworth UC Center' WHEN Location = 'V01690' THEN 'Houlton UC Center' WHEN Location = 'V01700' THEN 'Houlton UC Center' WHEN Location = 'V01250' THEN 'Houlton UC Center' WHEN Location = 'V01340' THEN 'Houlton UC Center' WHEN Location = 'V01540' THEN 'Houlton UC Center' WHEN Location = 'V01730' THEN 'Houlton UC Center' WHEN Location = 'V01972' THEN 'Norway/South Paris UC Center' WHEN Location = 'V01160' THEN 'Norway/South Paris UC Center' WHEN Location = 'V01390' THEN 'Penquis /Dover-Foxcroft UC Center' WHEN Location = 'V01380' THEN 'Penquis /Dover-Foxcroft UC Center' WHEN Location = 'V01640' THEN 'Penquis /Dover-Foxcroft UC Center' WHEN Location = 'V01650' THEN 'Penquis /Dover-Foxcroft UC Center' WHEN Location = 'V01670' THEN 'Penquis /Dover-Foxcroft UC Center' WHEN Location = 'V01760' THEN 'Penquis /Dover-Foxcroft UC Center' WHEN Location = 'V01910' THEN 'Penquis /Dover-Foxcroft UC Center' WHEN Location = 'V01945' THEN 'Rockland UC Center' WHEN Location = 'V01230' THEN 'Rockland UC Center' WHEN Location = 'V01750' THEN 'Rockland UC Center' WHEN Location = 'V01902' THEN 'Rockland UC Center' WHEN Location = 'V01895' THEN 'Rockland UC Center' WHEN Location = 'V02020' THEN 'Rockland UC Center' WHEN Location = 'V02020' THEN 'Rockland UC Center' WHEN Location = 'V01920' THEN 'Rockland UC Center' WHEN Location = 'V01982' THEN 'Rockland UC Center' WHEN Location = 'V02010' THEN 'Rockland UC Center' WHEN Location = 'V01874' THEN 'Rumford/Mexico UC Center' WHEN Location = 'V01170' THEN 'Rumford/Mexico UC Center' WHEN Location = 'V01780' THEN 'Rumford/Mexico UC Center' WHEN Location = 'V01830' THEN 'Rumford/Mexico UC Center' WHEN Location = 'V01535' THEN 'Rumford/Mexico UC Center' WHEN Location = 'V01940' THEN 'Rumford/Mexico UC Center' WHEN Location = 'V01950' THEN 'Saco UC Center' WHEN Location = 'V01954' THEN 'Saco UC Center' WHEN Location = 'V01951' THEN 'Saco UC Center' WHEN Location = 'V01955' THEN 'Saco UC Center' WHEN Location = 'V01973' THEN 'Saco UC Center' WHEN Location = 'V01928' THEN 'UM Campus' WHEN Location = 'V01150' THEN 'Hutchinson Center - Belfast' WHEN Location = 'V01035' THEN 'UMA Campus' WHEN Location = 'V01075' THEN 'UMA Campus' WHEN Location = 'V01520' THEN 'UMA Campus' WHEN Location = 'V01037' THEN 'UMA Campus' WHEN Location = 'V01040' THEN 'UMA Campus' WHEN Location = 'V01971' THEN 'UMA Campus' WHEN Location = 'V01990' THEN 'UMA Campus' WHEN Location = 'V02050' THEN 'UMA Campus' WHEN Location = 'V01530' THEN 'UMF Campus' WHEN Location = 'V02081' THEN 'UMF Campus' WHEN Location = 'V09998' THEN 'UMF Campus' WHEN Location = 'V01545' THEN 'UMFK Campus' WHEN Location = 'V02085' THEN 'UMFK Campus' WHEN Location = 'V01410' THEN 'UMFK Campus' WHEN Location = 'V01546' THEN 'UMFK Campus' WHEN Location = 'V01860' THEN 'UMFK Campus' WHEN Location = 'V02000' THEN 'UMFK Campus' WHEN Location = 'V01855' THEN 'UMM Campus' WHEN Location = 'V02081' THEN 'UMM Campus' WHEN Location = 'V01215' THEN 'UMM Campus' WHEN Location = 'V01470' THEN 'UMM Campus' WHEN Location = 'V01850' THEN 'UMM Campus' WHEN Location = 'V01939' THEN 'UMPI Campus' WHEN Location = 'V01941' THEN 'UMPI Campus' WHEN Location = 'V01595' THEN 'USM Campus' WHEN Location = 'V01785' THEN 'USM Campus' WHEN Location = 'V01938' THEN 'USM Campus' WHEN Location = 'V02082' THEN 'USM Campus' WHEN Location = 'V99099' THEN 'USM Campus' WHEN Campus2 = 'BATH' THEN 'Bath/Brunswick UC Center' WHEN Campus2 = 'BBC' THEN 'Bath/Brunswick UC Center' WHEN Campus2 = 'ELL' THEN 'Ellsworth UC Center' WHEN Campus2 = 'EML' THEN 'East Millinocket UC Center' WHEN Campus2 = 'FHC' THEN 'Hutchinson Center - Belfast' WHEN Campus2 = 'HOU' THEN 'Houlton UC Center' WHEN Campus2 = 'HOULT' THEN 'Houlton UC Center' WHEN Campus2 = 'PEN' THEN 'Penquis /Dover-Foxcroft UC Center' WHEN Campus2 = 'ROC' THEN 'Rockland UC Center' WHEN Campus2 = 'RUM' THEN 'Rumford/Mexico UC Center' WHEN Campus2 = 'SAC' THEN 'Saco UC Center' WHEN Campus2 = 'SACO' THEN 'Saco UC Center' WHEN Campus2 = 'SOP' THEN 'Norway/South Paris UC Center' WHEN Institution2 = 'UMS01' THEN 'UMA Campus' WHEN Institution2 = 'UMS02' THEN 'UMF Campus' WHEN Institution2 = 'UMS03' THEN 'UMFK Campus' WHEN Institution2 = 'UMS04' THEN 'UMM Campus' WHEN Institution2 = 'UMS05' THEN 'UM Campus' WHEN Institution2 = 'UMS06' THEN 'USM Campus' WHEN Institution2 = 'UMS07' THEN 'UMPI Campus' ELSE 'Other' END

SITE_CATEGORY 
CASE WHEN CLASS DELIVERY MODE = 'Distance Online' THEN 'Distance Online' WHEN Location = 'V01190' THEN 'UC Center' WHEN Location = 'V01525' THEN 'Site' WHEN Location = 'V01820' THEN 'Site' WHEN Location = 'V02047' THEN 'Site' WHEN Location = 'V02060' THEN 'Site' WHEN Location = 'V01440' THEN 'UC Center' WHEN Location = 'V01800' THEN 'Site' WHEN Location = 'V01970' THEN 'Site' WHEN Location = 'V01490' THEN 'UC Center' WHEN Location = 'V01070' THEN 'Site' WHEN Location = 'V01210' THEN 'Site' WHEN Location = 'V01360' THEN 'Site' WHEN Location = 'V01450' THEN 'Site' WHEN Location = 'V01740' THEN 'Site' WHEN Location = 'V01900' THEN 'Site' WHEN Location = 'V01980' THEN 'Site' WHEN Location = 'V01690' THEN 'UC Center' WHEN Location = 'V01700' THEN 'Site' WHEN Location = 'V01250' THEN 'Site' WHEN Location = 'V01340' THEN 'Site' WHEN Location = 'V01540' THEN 'Site' WHEN Location = 'V01730' THEN 'Site' WHEN Location = 'V01972' THEN 'UC Center' WHEN Location = 'V01160' THEN 'Site' WHEN Location = 'V01390' THEN 'UC Center' WHEN Location = 'V01380' THEN 'Site' WHEN Location = 'V01640' THEN 'Site' WHEN Location = 'V01650' THEN 'Site' WHEN Location = 'V01670' THEN 'Site' WHEN Location = 'V01760' THEN 'Site' WHEN Location = 'V01910' THEN 'Site' WHEN Location = 'V01945' THEN 'UC Center' WHEN Location = 'V01230' THEN 'Site' WHEN Location = 'V01750' THEN 'Site' WHEN Location = 'V01902' THEN 'Site' WHEN Location = 'V01895' THEN 'Site' WHEN Location = 'V02020' THEN 'Site' WHEN Location = 'V02020' THEN 'Site' WHEN Location = 'V01920' THEN 'Site' WHEN Location = 'V01982' THEN 'Site' WHEN Location = 'V02010' THEN 'Site' WHEN Location = 'V01874' THEN 'UC Center' WHEN Location = 'V01170' THEN 'Site' WHEN Location = 'V01780' THEN 'Site' WHEN Location = 'V01830' THEN 'Site' WHEN Location = 'V01535' THEN 'Site' WHEN Location = 'V01940' THEN 'Site' WHEN Location = 'V01950' THEN 'UC Center' WHEN Location = 'V01954' THEN 'Site' WHEN Location = 'V01951' THEN 'Site' WHEN Location = 'V01955' THEN 'Site' WHEN Location = 'V01973' THEN 'Site' WHEN Location = 'V01928' THEN 'Campus' WHEN Location = 'V01150' THEN 'Campus Center' WHEN Location = 'V01035' THEN 'Campus' WHEN Location = 'V01075' THEN 'Campus' WHEN Location = 'V01520' THEN 'Site' WHEN Location = 'V01037' THEN 'Site' WHEN Location = 'V01040' THEN 'Site' WHEN Location = 'V01971' THEN 'Site' WHEN Location = 'V01990' THEN 'Site' WHEN Location = 'V02050' THEN 'Site' WHEN Location = 'V01530' THEN 'Campus' WHEN Location = 'V02081' THEN 'Campus' WHEN Location = 'V09998' THEN 'Campus' WHEN Location = 'V01545' THEN 'Campus' WHEN Location = 'V02085' THEN 'Campus' WHEN Location = 'V01410' THEN 'Site' WHEN Location = 'V01546' THEN 'Site' WHEN Location = 'V01860' THEN 'Site' WHEN Location = 'V02000' THEN 'Site' WHEN Location = 'V01855' THEN 'Campus' WHEN Location = 'V02081' THEN 'Campus' WHEN Location = 'V01215' THEN 'Site' WHEN Location = 'V01470' THEN 'Site' WHEN Location = 'V01850' THEN 'Site' WHEN Location = 'V01939' THEN 'Campus' WHEN Location = 'V01941' THEN 'Site' WHEN Location = 'V01595' THEN 'Campus' WHEN Location = 'V01785' THEN 'Campus' WHEN Location = 'V01938' THEN 'Campus' WHEN Location = 'V02082' THEN 'Campus' WHEN Location = 'V99099' THEN 'Campus' WHEN Campus2 = 'BATH' THEN 'UC Center' WHEN Campus2 = 'BBC' THEN 'UC Center' WHEN Campus2 = 'ELL' THEN 'UC Center' WHEN Campus2 = 'EML' THEN 'UC Center' WHEN Campus2 = 'FHC' THEN 'Campus Center' WHEN Campus2 = 'HOU' THEN 'UC Center' WHEN Campus2 = 'HOULT' THEN 'UC Center' WHEN Campus2 = 'PEN' THEN 'UC Center' WHEN Campus2 = 'ROC' THEN 'UC Center' WHEN Campus2 = 'RUM' THEN 'UC Center' WHEN Campus2 = 'SAC' THEN 'UC Center' WHEN Campus2 = 'SACO' THEN 'UC Center' WHEN Campus2 = 'SOP' THEN 'UC Center' ELSE 'Campus' END

STDNT_ENRL_STATUS_DECODED 
CASE WHEN Stdnt Enrl Status = 'A' THEN 'All' WHEN Stdnt Enrl Status = 'D' THEN 'Dropped' WHEN Stdnt Enrl Status = 'E' THEN 'Enrolled' WHEN Stdnt Enrl Status = 'W' THEN 'Waiting' ELSE 'Other' END

UNIV_CENTER_DESCR 
CASE WHEN Campus2 = 'BATH' THEN 'Bath/Brunswick UC Center' WHEN Campus2 = 'BBC' THEN 'Bath/Brunswick UC Center' WHEN Campus2 = 'ELL' THEN 'Ellsworth UC Center' WHEN Campus2 = 'EML' THEN 'East Millinocket UC Center' WHEN Campus2 = 'FHC' THEN 'Hutchinson Center - Belfast' WHEN Campus2 = 'HOU' THEN 'Houlton UC Center' WHEN Campus2 = 'HOULT' THEN 'Houlton UC Center' WHEN Campus2 = 'PEN' THEN 'Penquis /Dover-Foxcroft UC Center' WHEN Campus2 = 'ROC' THEN 'Rockland UC Center' WHEN Campus2 = 'RUM' THEN 'Rumford/Mexico UC Center' WHEN Campus2 = 'SAC' THEN 'Saco UC Center' WHEN Campus2 = 'SACO' THEN 'Saco UC Center' WHEN Campus2 = 'SOP' THEN 'Norway/South Paris UC Center' WHEN Location = 'V01190' THEN 'Bath/Brunswick UC Center' WHEN Location = 'V01490' THEN 'Ellsworth UC Center' WHEN Location = 'V01440' THEN 'East Millinocket UC Center' WHEN Location = 'V01150' THEN 'Hutchinson Center - Belfast' WHEN Location = 'V01690' THEN 'Houlton UC Center' WHEN Location = 'V01390' THEN 'Penquis /Dover-Foxcroft UC Center' WHEN Location = 'V01945' THEN 'Rockland UC Center' WHEN Location = 'V01874' THEN 'Rumford/Mexico UC Center' WHEN Location = 'V01950' THEN 'Saco UC Center' WHEN Location = 'V01972' THEN 'Norway/South Paris UC Center' ELSE 'Other' END

UNIV_CENTER_FLAG 
CASE WHEN Campus2 = 'BATH' THEN 'Y' WHEN Campus2 = 'BBC' THEN 'Y' WHEN Campus2 = 'ELL' THEN 'Y' WHEN Campus2 = 'EML' THEN 'Y' WHEN Campus2 = 'FHC' THEN 'Y' WHEN Campus2 = 'HOU' THEN 'Y' WHEN Campus2 = 'HOULT' THEN 'Y' WHEN Campus2 = 'PEN' THEN 'Y' WHEN Campus2 = 'ROC' THEN 'Y' WHEN Campus2 = 'RUM' THEN 'Y' WHEN Campus2 = 'SAC' THEN 'Y' WHEN Campus2 = 'SACO' THEN 'Y' WHEN Campus2 = 'SOP' THEN 'Y' WHEN Location = 'V01190' THEN 'Y' WHEN Location = 'V01490' THEN 'Y' WHEN Location = 'V01440' THEN 'Y' WHEN Location = 'V01150' THEN 'Y' WHEN Location = 'V01690' THEN 'Y' WHEN Location = 'V01390' THEN 'Y' WHEN Location = 'V01945' THEN 'Y' WHEN Location = 'V01874' THEN 'Y' WHEN Location = 'V01950' THEN 'Y' WHEN Location = 'V01972' THEN 'Y' ELSE 'N' END