Body
The UM_DIST_CLASS field is commonly used in CSRPT to identify distance education courses. Additionally, more fields have been created in UM_D_STD_ENR_VW and UM_STD_ENR_C_VW.
Detailed Information
Fields with build logic used for reporting
These fields use distance education coding logic in UM_D_STD_ENR_VW and UM_STD_ENR_C_VW in CSRPT. Select a field name below to jump to the SQL code. Please note that some fields have not been reviewed for a while and may not be accurate anymore.
UM_DIST_CLASS
The field classifies whether a course is a distance course (OTHER DIST & UC DIST) or not a distance course (NOT DISTANCE). This field was reviewed for accuracy and modified in the summer of 2021.
SQL for UM_DIST_CLASS field (Alias A= PS_UM_D_STD_ENRL)
CASE
WHEN A.STRM >= '2130'
AND A.INSTRUCTION_MODE IN ('AR', 'HF', 'P', 'SD', 'SL') THEN 'NOT DIST'
WHEN A.STRM >= '2130'
AND A.INSTRUCTION_MODE IN ('DS', 'HB', 'RE', 'WW') THEN 'OTHER DIST'
WHEN A.STRM >= '2110' AND A.INSTITUTION = 'UMS07'
AND A.INSTRUCTION_MODE = 'P'THEN 'NOT DIST'
WHEN A.STRM >= '2110' AND A.INSTITUTION = 'UMS07'
AND A.INSTRUCTION_MODE IN ('BL', 'HF', 'OA', 'OL', 'OS') THEN 'OTHER DIST'
WHEN A.UM_DIST_ATTR_FLAG = 'Y' AND A.UM_DISTANCE_FLAG = 'R'
AND A.UM_IMODE IN ('ITV', 'VIDEOCONF') THEN 'UC DIST'
WHEN A.UM_DIST_ATTR_FLAG = 'Y' AND A.UM_DISTANCE_FLAG = 'B'
AND A.UM_IMODE IN ('ITV', 'VIDEOCONF')
AND(CASE
WHEN A.CAMPUS IN
('BATH', 'BBC', 'ELL', 'EML', 'FHC', 'HOU', 'HOULT', 'PEN',
'ROC', 'RUM', 'SAC', 'SACO', 'SOP') THEN 'Y'
WHEN A.LOCATION IN
('V01190', 'V01490', 'V01440', 'V01150', 'V01690',
'V01390', 'V01945', 'V01874', 'V01950', 'V01972') THEN 'Y'
ELSE 'N' END) = 'Y' THEN 'UC DIST'
WHEN A.UM_DIST_ATTR_FLAG = 'Y'
AND A.UM_IMODE IN ('ONLINE', 'ONSITE') THEN 'UC DIST'
WHEN A.INSTRUCTION_MODE IN
('RE', 'TV', 'TW', 'VC', 'VD', 'VS', 'WB', 'WS') THEN 'OTHER DIST'
WHEN A.LOCATION = 'V02035' THEN 'OTHER DIST'
WHEN (CASE
WHEN A.CAMPUS IN
('BATH', 'BBC', 'ELL', 'EML', 'FHC', 'HOU', 'HOULT',
'PEN', 'ROC', 'RUM', 'SAC', 'SACO', 'SOP') THEN 'Y'
WHEN A.LOCATION IN
('V01190', 'V01490', 'V01440', 'V01150', 'V01690',
'V01390', 'V01945', 'V01874', 'V01950', 'V01972') THEN 'Y'
ELSE 'N' END) = 'Y' THEN 'OTHER DIST' ELSE 'NOT DIST' END
UM_IPEDS_DIST_CLSS
Similar to the UM_DIST_CLASS field. Classifies distance course or not.
UM_IPEDS_DIST_CLSS (Alias A= PS_UM_D_STD_ENRL)
CASE
WHEN A.STRM >= '2130' AND A.INSTRUCTION_MODE IN
('AR', 'HF', 'P', 'SD', 'SL') THEN 'NOT DIST'
WHEN A.STRM >= '2130' AND A.INSTRUCTION_MODE IN
('DS', 'HB', 'RE', 'WW') THEN 'OTHER DIST'
WHEN A.STRM >= '2110' AND A.INSTITUTION = 'UMS07'
AND A.INSTRUCTION_MODE = 'P'THEN 'NOT DIST'
WHEN A.STRM >= '2110' AND A.INSTITUTION = 'UMS07'
AND A.INSTRUCTION_MODE IN
('BL', 'HF', 'OA', 'OL', 'OS') THEN 'OTHER DIST'
WHEN A.UM_DIST_ATTR_FLAG = 'Y'
AND A.UM_DISTANCE_FLAG = 'R'
AND A.UM_IMODE = 'ITV' THEN 'UC DIST'
WHEN A.UM_DIST_ATTR_FLAG = 'Y'
AND A.UM_DISTANCE_FLAG = 'R'
AND A.UM_IMODE = 'VIDEOCONF' THEN 'UC DIST'
WHEN A.UM_DIST_ATTR_FLAG = 'Y'
AND A.UM_IMODE = 'ONLINE' THEN 'UC DIST'
WHEN A.INSTRUCTION_MODE IN
('RE', 'TV', 'TW', 'VC', 'VD', 'VS', 'WB', 'WS') THEN 'OTHER DIST'
WHEN A.LOCATION = 'V02035'
THEN 'OTHER DIST' ELSE 'NOT DIST' END
Back to top
UM_CLASS_DLV_MODE
Descriptions of all existing and historical instruction modes and distance descriptions
Back to top
UM_CENTER_CD & UM_CENTER_DESCR
UM_CENTER_DESCR field (Center description) is from PS_UM_CENTER_TBL.
SELECT MAX(inh.um_center_cd) um_center_cd
, inh.location
FROM ps_um_location_dtl inh
WHERE inh.effdt = (
SELECT MAX(H1.EFFDT)
FROM PS_UM_LOCATION_DTL H1
WHERE INH.LOCATION = H1.LOCATION
AND INH.UM_CENTER_CD = H1.UM_CENTER_CD
AND H1.EFFDT <= %CurrentDateIn)
AND inh.eff_status = 'A'
GROUP BY inh.location
Back to top
UM_DIST_ATTR_FLAG
Distance Attribute Flag - based on course attribute: Y or N
UM_DIST_ATTR_FLAG (Alias z = ps_class_attribute)
CASE WHEN z.crse_attr = 'DIST' THEN 'Y' ELSE 'N'END
Back to top
UM_DIST_ATTR_F_DSC
Distance Attribute Flag Description: 'Distance course' or 'traditional campus course'
UM_DIST_ATTR_F_DSC (Alias A= PS_UM_D_STD_ENRL)
CASE WHEN A.UM_DIST_ATTR_FLAG = 'Y' THEN 'Distance Course' ELSE 'Traditional Campus Course' END
Back to top
UM_DISTANCE_FLAG
Distance Flag - based on course attribute and class table: B or R or blank.
UM_DIST_ATTR_FLAG (Alias b = PS_CLASS_TBL)
Decode((SELECT SUM(decode(z.crse_attr ,'DIST',1,'BRD',2,0))
FROM ps_class_attribute z
WHERE b.crse_id = z.crse_id
AND b.crse_offer_nbr = z.crse_offer_nbr
AND b.strm = z.strm
AND b.session_code = z.session_code
AND b.class_section = z.class_section
AND ((z.crse_attr = 'DIST'
AND (z.crse_attr_value = 'ITV'
OR z.crse_attr_value = 'VIDEOCONF'))
OR (z.crse_attr ='BRD' ))),1,'R',3,'B',' ')
Back to top
UM_DIST_FLG_DESCR
Distribution Flag Description based on UM_DISTANCE_FLAG field: Broadcast, Receive or blank
UM_DIST_FLG_DESCR (Alias A= PS_UM_D_STD_ENRL)
DECODE(A.UM_DISTANCE_FLAG,'B','Broadcast','R', Receive',' ')
Back to top
UM_IMODE
Based on crse_attr_value: 'ITV', 'VIDEOCONF', 'ONLINE', 'ONSITE', or 'BROADCAST'
UM_IMODE (Alias b = PS_CLASS_TBL)
decode ( ( SELECT MIN( decode(z.crse_attr_value
,'ITV' ,'1' ,'VIDEOCONF' ,'2' ,'ONLINE' ,'3' ,'ONSITE' ,'4' ,'BROADCAST' ,'5' ,'0') )
FROM ps_class_attribute z
WHERE b.crse_id = z.crse_id
AND b.crse_offer_nbr = z.crse_offer_nbr
AND b.strm = z.strm
AND b.session_code = z.session_code
AND b.class_section = z.class_section
AND ( ( z.crse_attr = 'DIST' AND z.crse_attr_value = 'ITV' )
OR (z.crse_attr = 'DIST' AND z.crse_attr_value = 'VIDEOCONF')
OR (z.crse_attr = 'DIST' AND z.crse_attr_value = 'ONLINE')
OR (z.crse_attr = 'DIST' AND z.crse_attr_value = 'ONSITE')
OR (z.crse_attr ='BRD' AND z.crse_attr_value = 'BROADCAST') ) )
,'1','ITV','2','VIDEOCONF','3','ONLINE','4','ONSITE','5','BROADCAST','0','?')
Back to top
UM_LOCATION_DESCR
Location Description
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 'BathBrunswick 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 'PenquisDover-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 'RumfordMexico 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 'NorwaySouth 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 'BathBrunswick UC Center'
WHEN Campus = 'BBC' THEN 'BathBrunswick 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 'RumfordMexico 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 'NorwaySouth 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
Back to top
UM_REGION
Expand source
CASE
WHEN CLASS_DELIVERY_MODE = 'Distance Online' THEN 'Distance Online'
WHEN LOCATION = 'V01190' THEN 'BathBrunswick UC Center'
WHEN LOCATION = 'V01525' THEN 'BathBrunswick UC Center'
WHEN LOCATION = 'V01820' THEN 'BathBrunswick UC Center'
WHEN LOCATION = 'V02047' THEN 'BathBrunswick UC Center'
WHEN LOCATION = 'V02060' THEN 'BathBrunswick 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 'NorwaySouth Paris UC Center'
WHEN LOCATION = 'V01160' THEN 'NorwaySouth 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 'RumfordMexico UC Center'
WHEN LOCATION = 'V01170' THEN 'RumfordMexico UC Center'
WHEN LOCATION = 'V01780' THEN 'RumfordMexico UC Center'
WHEN LOCATION = 'V01830' THEN 'RumfordMexico UC Center'
WHEN LOCATION = 'V01535' THEN 'RumfordMexico UC Center'
WHEN LOCATION = 'V01940' THEN 'RumfordMexico 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 Campu s'
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 CAMPUS = 'BATH' THEN 'BathBrunswick UC Center'
WHEN CAMPUS = 'BBC' THEN 'BathBrunswick UC Center'
WHEN CAMPUS = 'ELL' THEN 'Ellsworth UC Center'
WHEN CAMPUS = 'EML' THEN 'East Millinocket UC Center'
WHEN CAMPUS = 'FHC' THEN 'Hutchinson Center - Belfast'
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 'RumfordMexico UC Center'
WHEN CAMPUS = 'SAC' THEN 'Saco UC Center'
WHEN CAMPUS = 'SACO' THEN 'Saco UC Center'
WHEN CAMPUS = 'SOP' THEN 'NorwaySouth 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
Back to top
UM_SITE_CATEGORY
Expand source
CASE
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
Back to top
UM_UNIV_CENTER_DSC
University Center Description
UM_UNIV_CENTER_DSC (Alias A= PS_UM_D_STD_ENRL)
CASE
WHEN A.CAMPUS = 'BATH' THEN 'BathBrunswick UC Center'
WHEN A.CAMPUS = 'BBC' THEN 'BathBrunswick UC Center'
WHEN A.CAMPUS = 'ELL' THEN 'Ellsworth UC Center'
WHEN A.CAMPUS = 'EML' THEN 'East Millinocket UC Center'
WHEN A.CAMPUS = 'FHC' THEN 'Hutchinson Center - Belfast'
WHEN A.CAMPUS = 'HOU' THEN 'Houlton UC Center'
WHEN A.CAMPUS = 'HOULT' THEN 'Houlton UC Center'
WHEN A.CAMPUS = 'PEN' THEN 'Penquis Dover-Foxcroft UC Center'
WHEN A.CAMPUS = 'ROC' THEN 'Rockland UC Center'
WHEN A.CAMPUS = 'RUM' THEN 'RumfordMexico UC Center'
WHEN A.CAMPUS = 'SAC' THEN 'Saco UC Center'
WHEN A.CAMPUS = 'SACO' THEN 'Saco UC Center'
WHEN A.CAMPUS = 'SOP' THEN 'NorwaySouth Paris UC Center'
WHEN A.LOCATION = 'V01190' THEN 'BathBrunswick UC Center'
WHEN A.LOCATION = 'V01490' THEN 'Ellsworth UC Center'
WHEN A.LOCATION = 'V01440' THEN 'East Millinocket UC Center'
WHEN A.LOCATION = 'V01150' THEN 'Hutchinson Center - Belfast'
WHEN A.LOCATION = 'V01690' THEN 'Houlton UC Center'
WHEN A.LOCATION = 'V01390' THEN 'Penquis Dover-Foxcroft UC Center'
WHEN A.LOCATION = 'V01945' THEN 'Rockland UC Center'
WHEN A.LOCATION = 'V01874' THEN 'RumfordMexico UC Center'
WHEN A.LOCATION = 'V01950' THEN 'Saco UC Center'
WHEN A.LOCATION = 'V01972' THEN 'NorwaySouth Paris UC Center'
ELSE 'Other' END
Back to top
UM_UNIV_CENTER_FLG
University Center Flag
UM_UNIV_CENTER_FLG (Alias A= PS_UM_D_STD_ENRL)
CASE
WHEN A.CAMPUS = 'BATH' THEN 'Y'
WHEN A.CAMPUS = 'BBC' THEN 'Y'
WHEN A.CAMPUS = 'ELL' THEN 'Y'
WHEN A.CAMPUS = 'EML' THEN 'Y'
WHEN A.CAMPUS = 'FHC' THEN 'Y'
WHEN A.CAMPUS = 'HOU' THEN 'Y'
WHEN A.CAMPUS = 'HOULT' THEN 'Y'
WHEN A.CAMPUS = 'PEN' THEN 'Y'
WHEN A.CAMPUS = 'ROC' THEN 'Y'
WHEN A.CAMPUS = 'RUM' THEN 'Y'
WHEN A.CAMPUS = 'SAC' THEN 'Y'
WHEN A.CAMPUS = 'SACO' THEN 'Y'
WHEN A.CAMPUS = 'SOP' THEN 'Y'
WHEN A.LOCATION = 'V01190' THEN 'Y'
WHEN A.LOCATION = 'V01490' THEN 'Y'
WHEN A.LOCATION = 'V01440' THEN 'Y'
WHEN A.LOCATION = 'V01150' THEN 'Y'
WHEN A.LOCATION = 'V01690' THEN 'Y'
WHEN A.LOCATION = 'V01390' THEN 'Y'
WHEN A.LOCATION = 'V01945' THEN 'Y'
WHEN A.LOCATION = 'V01874' THEN 'Y'
WHEN A.LOCATION = 'V01950' THEN 'Y'
WHEN A.LOCATION = 'V01972' THEN 'Y'
ELSE 'N'END
Back to top
Environment
PeopleSoft Campus Solutions