DARTS : Distance Education Course Coding - Current

Definitions & Resources

Distance Education definition
Instruction Modes & Distance Education documentation page

Field used for Reporting

UM_DIST_CLASS field in UM_D_STD_ENR_VW and UM_STD_ENR_C_VW is used for many reports in CSRPT. UM_DIST_CLASS 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 Summer 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

Jump to the other related fields

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.

Some fields have not been reviewed for a while and may not be accurate anymore.

/*1- UM_IPEDS_DIST_CLSS*/
/*2- UM_CLASS_DLV_MODE*/
/*3- UM_CENTER_CD & UM_CENTER_DESCR */
/*4- UM_DIST_ATTR_FLAG*/
/*5- UM_DIST_ATTR_F_DSC*/
/*6- UM_DISTANCE_FLAG*/
/*7- UM_DIST_FLG_DESCR*/
/*8- UM_IMODE*/
/*9- UM_LOCATION_DESCR*/
/*10- UM_REGION*/
/*11- UM_SITE_CATEGORY*/
/*12- UM_UNIV_CENTER_DSC*/
/*13- UM_UNIV_CENTER_FLG*/

**/1- UM_IPEDS_DIST_CLSS/**

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

**/2- UM_CLASS_DLV_MODE/**

Descriptions to all existing and historical Instruction Modes and distance descriptions

UM_CLASS_DLV_MODE (Alias A= PS_UM_D_STD_ENRL)

CASE
  WHEN A.STRM >= '2130' THEN (CASE
                                WHEN A.INSTRUCTION_MODE  = 'AR' THEN 'By Arrangement'
                                WHEN A.INSTRUCTION_MODE  = 'DS' THEN 'Distance Synchronous Learning'
                                WHEN A.INSTRUCTION_MODE  = 'HB' THEN 'Hybrid/Blended'
                                WHEN A.INSTRUCTION_MODE  = 'HF' THEN 'Hyflex'
                                WHEN A.INSTRUCTION_MODE  = 'P'  THEN 'In-Person'
                                WHEN A.INSTRUCTION_MODE  = 'RE' THEN 'Receive'
                                WHEN A.INSTRUCTION_MODE  = 'SD' THEN 'Split Delivery'
                                WHEN A.INSTRUCTION_MODE  = 'SL' THEN 'Service Learning'
                                WHEN A.INSTRUCTION_MODE  = 'WW' THEN 'Online'
                                ELSE 'Unknown'
                              END)
  WHEN A.STRM >= '2110' AND A.INSTITUTION = 'UMS07' THEN (CASE
                                                            WHEN A.INSTRUCTION_MODE  = 'P'  THEN 'On-Site'
                                                            WHEN A.INSTRUCTION_MODE  = 'BL' THEN 'Blended'
                                                            WHEN A.INSTRUCTION_MODE  = 'OL' THEN 'Online Low Residency'
                                                            WHEN A.INSTRUCTION_MODE  = 'OS' THEN 'Online Synchronous'
                                                            WHEN A.INSTRUCTION_MODE  = 'OA' THEN 'Online Asynchronous'
                                                            WHEN A.INSTRUCTION_MODE  = 'HF' THEN 'Hyflex'
                                                            ELSE 'Unknown'
                                                          END)
  WHEN A.UM_DIST_ATTR_FLAG = 'Y' AND A.UM_DISTANCE_FLAG = 'R' AND A.UM_IMODE  = 'ITV'       THEN 'Distance ITV'
  WHEN A.UM_DIST_ATTR_FLAG = 'Y' AND A.UM_DISTANCE_FLAG = 'R' AND A.UM_IMODE  = 'VIDEOCONF' THEN 'Distance Video Conference'
  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 'Distance Onsite'
  WHEN A.UM_DIST_ATTR_FLAG = 'Y' AND A.UM_IMODE = 'ONLINE' THEN 'Distance Online'
  WHEN A.UM_DIST_ATTR_FLAG = 'Y' AND A.UM_IMODE = 'ONSITE' THEN 'Distance Onsite'
  WHEN A.INSTRUCTION_MODE IN ('RE', 'TV', 'TW') THEN 'Distance ITV'
  WHEN A.INSTRUCTION_MODE IN ('VC', 'VD')       THEN 'Distance Video Conference'
  WHEN A.INSTRUCTION_MODE IN ('VS', 'WB', 'WS')       THEN 'Distance Online'
  WHEN A.LOCATION = 'V02035' THEN 'Distance Online'
  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 'Distance Onsite'
  ELSE 'Traditional Class '
END

Back to top

**/3- UM_CENTER_CD & UM_CENTER_DESCR /**

Center Code

UM_CENTER_DESCR field (Center description) is from PS_UM_CENTER_TBL.

UM_CENTER_CD

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

**/4- 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

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

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

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

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

**/9- UM_LOCATION_DESCR/**

Location Description

UM_LOCATION_DESCR

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

Back to top

**/10- UM_REGION/**

Region

UM_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 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          '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'
         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 = '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

Back to top

**/11- UM_SITE_CATEGORY/**

Site Category

UM_SITE_CATEGORY

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

**/12- UM_UNIV_CENTER_DSC/**

University Center Description

UM_UNIV_CENTER_DSC (Alias A= PS_UM_D_STD_ENRL)

CASE
           WHEN A.CAMPUS = 'BATH' THEN 'Bath/Brunswick UC Center'
           WHEN A.CAMPUS = 'BBC' THEN 'Bath/Brunswick 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 'Rumford/Mexico UC Center'
           WHEN A.CAMPUS = 'SAC' THEN 'Saco UC Center'
           WHEN A.CAMPUS = 'SACO' THEN 'Saco UC Center'
           WHEN A.CAMPUS = 'SOP' THEN 'Norway/South Paris UC Center'
           WHEN A.LOCATION = 'V01190' THEN 'Bath/Brunswick 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 'Rumford/Mexico UC Center'
           WHEN A.LOCATION = 'V01950' THEN 'Saco UC Center'
           WHEN A.LOCATION = 'V01972' THEN 'Norway/South Paris UC Center'
           ELSE 'Other'
END

Back to top

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

DARTS : Distance Education Course Coding - Current

Definitions & Resources

Field used for Reporting

Jump to the other related fields

/*1- UM_IPEDS_DIST_CLSS*/

/*2- UM_CLASS_DLV_MODE*/

/*3- UM_CENTER_CD & UM_CENTER_DESCR */

/*4- UM_DIST_ATTR_FLAG*/

/*5- UM_DIST_ATTR_F_DSC*/

/*6- UM_DISTANCE_FLAG*/

/*7- UM_DIST_FLG_DESCR*/

/*8- UM_IMODE*/

/*9- UM_LOCATION_DESCR*/

/*10- UM_REGION*/

/*11- UM_SITE_CATEGORY*/

/*12- UM_UNIV_CENTER_DSC*/

/*13- UM_UNIV_CENTER_FLG*/

**/1- UM_IPEDS_DIST_CLSS/**

**/2- UM_CLASS_DLV_MODE/**

**/3- UM_CENTER_CD & UM_CENTER_DESCR /**

**/4- UM_DIST_ATTR_FLAG/**

**/5- UM_DIST_ATTR_F_DSC/**

**/6- UM_DISTANCE_FLAG/**

**/7- UM_DIST_FLG_DESCR/**

**/8- UM_IMODE/**

**/9- UM_LOCATION_DESCR/**

**/10- UM_REGION/**

**/11- UM_SITE_CATEGORY/**

**/12- UM_UNIV_CENTER_DSC/**

**/13- UM_UNIV_CENTER_FLG/**