DARTS : Census Reporting Changes - Fall 2020: Instruction Mode & Residency

Background

Instruction modes describe how a class is delivered (e.g., in-person, online, or blended). Newly updated instruction mode codes and descriptions have been developed for usage across the University of Maine System. UMPI implemented the revised codes for the Fall 2020 semester; the remaining institutions will being using the new codes in Summer 2021.

Fields related to Instruction Mode

Four reporting fields and the tables in which they can be found will be updated for the Fall 2020 census.

To ensure accurate reporting related to Instruction Modes, the following fields in UM_D_STD_ENR_VW and UM_STD_ENR_C_VW in CSRPT will be changed:

UM_CLASS_DLV_MODE: adds new Instruction Modes and descriptions to all existing Instruction Modes and distance descriptions
UM_DIST_CLASS: classifies new On-Site Instruction Mode as NOT DISTANCE and all other new Instruction Modes as DISTANCE
UM_IMODE_DESCR: adds new Instruction Modes and descriptions to all existing Instruction Modes and Descriptions
UM_IPEDS_DIST_CLSS: classifies new On-Site Instruction Mode as NOT DISTANCE and all other new Instruction Modes as DISTANCE

Expand a box below to view the new code.

UM_CLASS_DLV_MODE

CASE
  WHEN A.STRM >= '2130' 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.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')       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

UM_DIST_CLASS

CASE
  WHEN A.STRM >= '2130' AND A.INSTRUCTION_MODE = 'P'                                                         THEN 'NOT DIST'
  WHEN A.STRM >= '2130' AND A.INSTRUCTION_MODE IN ('BL', 'HF', 'OA', 'OL', 'OS')                             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') 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_IMODE_DESCR

DECODE(A.INSTRUCTION_MODE, 
'BL', 'Blended Class', 
'BR', 'Broadcast Class', 
'HF', 'Hyflex',    
'OA', 'Online Asynchronous', 
'OL', 'Online Low Residency',  
'OS', 'Online Synchronous', 
'P',  'Onsite Class',                         
'RE', 'Receive Class', 
'TR', 'Travel Class',    
'TV', 'ITV Class', 
'TW', 'ITV/Online Class',    
'VC', 'Video Conference Class',
'VD', 'Video Tape Class',   
'VS', 'Video Stream Class',
'WB', 'Online Class',  
'Other')

UM_IPEDS_DIST_CLSS

CASE
  WHEN A.INSTRUCTION_MODE  = 'P'  THEN 'NOT DIST'
  WHEN A.INSTRUCTION_MODE  = 'BL' THEN 'OTHER DIST'
  WHEN A.INSTRUCTION_MODE  = 'OL' THEN 'OTHER DIST'
  WHEN A.INSTRUCTION_MODE  = 'OS' THEN 'OTHER DIST'
  WHEN A.INSTRUCTION_MODE  = 'OA' THEN 'OTHER DIST'
  WHEN A.INSTRUCTION_MODE  = 'HF' 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  = 'RE' THEN 'OTHER DIST'
  WHEN A.INSTRUCTION_MODE  = 'TV' THEN 'OTHER DIST'
  WHEN A.INSTRUCTION_MODE  = 'TW' THEN 'OTHER DIST'
  WHEN A.INSTRUCTION_MODE  = 'VC' THEN 'OTHER DIST'
  WHEN A.INSTRUCTION_MODE  = 'VD' THEN 'OTHER DIST'
  WHEN A.INSTRUCTION_MODE  = 'VS' THEN 'OTHER DIST'
  WHEN A.INSTRUCTION_MODE  = 'WB' THEN 'OTHER DIST'
  WHEN A.LOCATION          = 'V02035' THEN 'OTHER DIST'
  ELSE 'NOT DIST'
END

Information & Resources

Instruction Modes Documentation

Faculty & Staff Instruction Mode Decision Tree

Student & Parent Instruction Mode Decision Tree

Instruction Mode Final Proposal

DG-5 - Instruction Mode Parked

Fields related to Residency

Some online students are enrolled through a contract the UMS has with a company called Academic Partnerships. These students' tuition is handled differently, and designated by the Tuition Residency code of MEONL.

The following fields in CSRPT will be changed:

UM_IN_OUT: modified such that MEONL Tuition Residency students are categorized as in-state or out-of-state according to their Residency. All other students continue to be categorized using the Tuition Residency.
UM_RESIDENCY_DESCR: addition of MEONL decode to Academic Partnerships
UM_RESIDENCY_SORT: addition of MEONL sorting as seventh type

These fields are used in the Census Reports, as well as in UM_STUD_EXT_VW, UM_STUD_CENS_VW, and UM_CNS_RPT_VW. They are also used in various queries.

The new code is listed below. The A.Residency is from UM_STUD_EXRACT, which is based on the Tuition residency (TUITION_RES) from the RESIDENCY_OFF table. QB.Residency is RESIDENCY from the RESIDENCY_OFF table.

UM_IN_OUT

CASE
WHEN A.RESIDENCY = 'MEONL' AND QB.RESIDENCY = 'IS' THEN 'In-State'
WHEN A.Residency = 'IS' THEN 'In-State'
ELSE 'Out-of-State'
END

UM_RESIDENCY_DESCR

DECODE(A.Residency,
              'IS', 'In-State',
              'OS', 'Out-of-State',
             'CAN', 'Canadian',
           'NEBHE', 'NEBHE',
           'INTNL', 'International',
           'ONLIN', 'Online',
           'MEONL', 'Academic Partnerships'
                    'Out-of-State'  )

UM_ RESIDENCY_SORT

DECODE(A.Residency,
              'IS', '10',
              'OS', '20',
             'CAN', '40',
           'NEBHE', '30',
           'INTNL', '50',
           'ONLIN', '60',
           'MEONL', '70'
                    '20'  )

Information & Resources

Residency definition

Additional Residency Data: Below the Line

RESIDENCY_OFF - Official Residency Data - UMS Reporting Tables