Created by Corina C Larsen on Jan 25, 2018

by Bill Gilfillan 2014

(Using UM_D_STD_ENR_VW - Student Enrollment Table)

The following shows how some of the distance fields are populated. Field names in mixed case are fields that are populated when the tables are built. Field names in all caps are derived fields that are created in Discoverer.

Distance Flag - Using UM_D_CLSS ATT_V







CASE







WHEN Crse Attr = 'DIST'  AND Crse Attr Value = 'ITV' AND no associated Crse Attr = 'BRD' THEN 'R'
WHEN Crse Attr = 'DIST'  AND Crse Attr Value = 'VIDEOCONF' AND no associated Crse Attr = 'BRD' THEN 'R'
WHEN Crse Attr = 'DIST'  AND Crse Attr Value = 'ITV' AND associated Crse Attr = 'BRD' THEN 'B'
WHEN Crse Attr = 'DIST'  AND Crse Attr Value = 'VIDEOCONF' AND associated Crse Attr = 'BRD' THEN 'B'
WHEN Crse Attr = BRD  AND Crse Attr Value = BROADCAST

AND no associated Crse Attr Value = 'ITV' or 'VIDEOCONF' THEN ''

ELSE ''
END
















































DIST FLG DESCR







CASE







WHEN Distance Flag = 'B' THEN 'Broadcast'
WHEN Distance Flag = 'R' THEN 'Receive'

ELSE ''
END
























Dist Attr Flag - Using UM_D_CLSS ATT_V
















CASE







WHEN Crse Attr = 'DIST'

THEN 'Y'
ELSE 'N'
END


DIST ATTR FLG DESCR







CASE







WHEN Dist Attr Flag = 'Y' THEN 'UC DIST'
ELSE ''
END


















Imode







CASE







WHEN Crse Attr = 'DIST'  AND Crse Attr Value = 'ITV' THEN 'ITV'
WHEN Crse Attr = 'DIST'  AND Crse Attr Value = 'VIDEOCONF' THEN 'VIDEOCONF'
WHEN Crse Attr = 'DIST'  AND Crse Attr Value = 'ONLINE' THEN 'ONLINE'
WHEN Crse Attr = 'DIST'  AND Crse Attr Value = 'ONSITE' THEN 'ONSITE'
WHEN Crse Attr = 'DIST'  AND Crse Attr Value = 'BLEND' THEN 'BLEND'
WHEN Crse Attr = KBLE  AND Crse Attr Value = 'BLEND' THEN 'BLEND'
WHEN Crse Attr = BRD  AND Crse Attr Value = BROADCAST

AND no associated Crse Attr Value = ITV or VIDEOCONF or ONLINE or ONSITETHEN BROADCAST

ELSE ''
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 Dist Attr Flag = 'Y' THEN 'UC DIST'
WHEN Imode = 'BLEND"THEN 'OTHER DIST'
WHEN Instruction Mode = 'BL' THEN 'OTHER 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
































































































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




























































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 Imode = 'BLEND"THEN Distance Blend'
WHEN Instruction Mode = 'BL' THEN 'Distance Blend'
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


























































































INSTRUCTION MODE DESCR







CASE







WHEN Instruction Mode = 'BL' THEN 'Blended Class'
WHEN Instruction Mode = 'RE' THEN 'Receive 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
















































UNIV CENTER DESCR







CASE







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'
WHEN Campus = 'BATH' THEN 'Bath/Brunswick UC Center'
WHEN Campus = 'BBC' THEN 'Bath/Brunswick UC Center'
WHEN Campus = 'ELL' THEN 'Ellsworth UC Center'
WHEN Campus = 'EML' THEN 'East Millinocket UC Center'
WHEN Campus = 'FHC' THEN 'Hutchinson Center - Belfast UM'
WHEN Campus = 'HOU' THEN 'Houlton UC Center'
WHEN Campus = 'HOULT' THEN 'Houlton UC Center'
WHEN Campus = 'PEN' THEN 'Penquis /Dover-Foxcroft UC Center'
WHEN Campus = 'ROC' THEN 'Rockland UC Center'
WHEN Campus = 'RUM' THEN 'Rumford/Mexico UC Center'
WHEN Campus = 'SAC' THEN 'Saco UC Center'
WHEN Campus = 'SACO' THEN 'Saco UC Center'
WHEN Campus = 'SAN' THEN 'Saco UC Center'
WHEN Campus = 'SNFRD' THEN 'Saco UC Center'
WHEN Campus = 'SOP' THEN 'Norway/South Paris UC Center'

ELSE 'Other'
END












































































































UNIV CENTER FLAG







CASE







WHEN Location = 'V01150' THEN 'Y'
WHEN Location = 'V01190' THEN 'Y'
WHEN Location = 'V01390' THEN 'Y'
WHEN Location = 'V01440' THEN 'Y'
WHEN Location = 'V01490' THEN 'Y'
WHEN Location = 'V01690' THEN 'Y'
WHEN Location = 'V01874' THEN 'Y'
WHEN Location = 'V01945' THEN 'Y'
WHEN Location = 'V01950' THEN 'Y'
WHEN Location = 'V01972' THEN 'Y'
WHEN Campus = 'BATH' THEN 'Y'
WHEN Campus = 'BBC' THEN 'Y'
WHEN Campus = 'ELL' THEN 'Y'
WHEN Campus = 'EML' THEN 'Y'
WHEN Campus = 'FHC' THEN 'Y'
WHEN Campus = 'HOU' THEN 'Y'
WHEN Campus = 'HOULT' THEN 'Y'
WHEN Campus = 'PEN' THEN 'Y'
WHEN Campus = 'ROC' THEN 'Y'
WHEN Campus = 'RUM' THEN 'Y'
WHEN Campus = 'SAC' THEN 'Y'
WHEN Campus = 'SACO' THEN 'Y'
WHEN Campus = 'SAN' THEN 'Y'
WHEN Campus = 'SNFRD' THEN 'Y'
WHEN Campus = 'SOP' THEN 'Y'

ELSE 'N'
END






































































































LOC DESCR
SITE CATEGORY
REGION

CASE

CASE

CASE

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

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

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