Created by Corina C Larsen, last modified by Miki Yanagi on Oct 16, 2024
This is a view of UM_STD_ENR_CENS table. It contains the same fields as UM_D_STD_ENR_VW.
This view also contains the UM_INST_HOST field used for Cross-listed Course Reporting.
| Key | Record.Fieldname | Format | XLAT | Heading Text | Notes |
|---|---|---|---|---|---|
| → | ACAD_CAREER - Academic Career | Char4 | Career | ||
| ACAD_GROUP - Academic Group | Char5 | Acad Group | |||
| ACAD_ORG - Academic Organization | Char10 | Acad Org | |||
| ACAD_PROG - Academic Program | Char5 | Acad Prog | |||
| ASSOCIATED_CLASS - Associated Class | Num4.0 | Assoc | |||
| ASSOCIATION_99 - Association 99 | Char1 | Assoc 99 | |||
| AUDIT_GRADE_BASIS - Audit Grading Basis | Char1 | Audit | |||
| CAMPUS - Campus | Char5 | Campus | |||
| CATALOG_NBR - Catalog Nbr | Char10 | Catalog | |||
| → | CLASS_NBR - Class Nbr | Num5.0 | Class Nbr | ||
| → | CLASS_SECTION - Class Section | Char4 | Section | ||
| CLASS_STAT - Class Status | Char1 | N | Class Stat | ||
| CLASS_TYPE - Class Type | Char1 | N | Class Type | ||
| CRSE_CAREER - Course Career | Char4 | Course Car | |||
| CRSE_COUNT - Course Count | Num3.2 | Crse Count | |||
| CRSE_GRADE_INPUT - Grade Input | Char3 | Grade In | |||
| CRSE_GRADE_OFF - Official Grade | Char3 | Grade | |||
| → | CRSE_ID - Course ID | Char6 | Course ID | ||
| → | CRSE_OFFER_NBR - Course Offering Nbr | Num2.0 | Offer Nbr | ||
| DESCR - Description | Char30 | Descr | |||
| DESCR_LOCATION - Location Description | Char30 | Description | |||
| DROP_CLASS_IF_ENRL - Drop This Class if Enrolled | Num5.0 | Drop if Enroll | |||
| DYN_CLASS_NBR - Dynamic Class Nbr | Num5.0 | Dyn Class Nbr | |||
| EARN_CREDIT - Earn Credit | Char1 | EarnCredit | |||
| → | EMPLID - Empl ID | Char11 | ID | ||
| ENRL_ACTION_LAST - Last Enrollment Action | Char2 | Last Act | |||
| ENRL_ACTN_PRC_LAST - Last Enrollment Action Process | Char2 | Process | |||
| ENRL_ACTN_RSN_LAST - Last Enrl Action Reason | Char4 | Reason | |||
| ENRL_ADD_DT - Enrollment Add Date | Date | Add Dt | |||
| ENRL_CAP - Enrollment Capacity | Num4.0 | Cap Enrl | |||
| ENRL_DROP_DT - Enrollment Drop Date | Date | Drop Dt | |||
| ENRL_REQ_SOURCE - Enrollment Request Source | Char2 | N | Source | ||
| ENRL_STAT - Enrollment Status | Char1 | N | Enrl Stat | ||
| ENRL_STATUS_REASON - Enrollment Status Reason | Char4 | N | Reason | ||
| FIRST_NAME - First Name | Char30 | First Name | |||
| GRADE_CATEGORY - Grade Category | Char4 | N | Grade Category | ||
| GRADE_DT - Grade Date | Date | Grade Dt | |||
| GRADE_POINTS - Grade Points | Num7.3 | Grd Points | |||
| GRADE_POINTS_FA - Financial Aid Grade Points | Num7.3 | FA Grd Pt | |||
| GRADING_BASIS_DT - Grading Basis Date | Date | Basis Dt | |||
| GRADING_BASIS_ENRL - Grading Basis | Char3 | Grade Base | |||
| GRADING_SCHEME_ENR - Field is not active yet | Char3 | Field not activ | |||
| GRD_PTS_PER_UNIT - Grade Points Per Unit | Num7.3 | Grd Pt/Unt | |||
| INCLUDE_IN_GPA - Include in GPA | Char1 | Incl GPA | |||
| → | INSTITUTION - Academic Institution | Char5 | Institution | ||
| INSTRUCTION_MODE - Instruction Mode | Char2 | Mode | |||
| INSTRUCTOR_ID - Instructor ID | Char11 | Instructor | |||
| LAST_DROP_DT_STMP - Last Drop Date Stamp | Date | Last Drop Date | |||
| LAST_DROP_TM_STMP - Last Drop Time Stamp | Time | Last Drop Time | |||
| LAST_ENRL_DT_STMP - Last Enrollment Date Stamp | Date | Last Enrl Date | |||
| LAST_ENRL_TM_STMP - Last Enrollment Time Stamp | Time | Last Enrl Time | |||
| LAST_NAME - Last Name | Char30 | Last | |||
| LAST_UPD_DT_STMP - Last Update Date Stamp | Date | Last Upd Date | |||
| LAST_UPD_ENREQ_SRC - Enrollment Request Source | Char2 | N | Source | ||
| LAST_UPD_TM_STMP - Last Update Time Stamp | Time | Last Upd Time | |||
| LOCATION - Location Code | Char10 | Location | |||
| MANDATORY_GRD_BAS - Mandatory Grading Basis | Char1 | Mandatory | |||
| MIDDLE_NAME - Middle Name | Char30 | Middle | |||
| NAME_PREFIX - Name Prefix | Char4 | Prefix | |||
| NAME_SUFFIX - Name Suffix | Char15 | Suffix | |||
| NOTIFY_STDNT_CHNG - Notify Student of Change | Char2 | N | Notify Student | ||
| OVRD_GRADING_BASIS - Override Grading Basis | Char1 | Grading Basis | |||
| RELATE_CLASS_NBR_1 - Field is not active yet | Num5.0 | Field not activ | |||
| RELATE_CLASS_NBR_2 - Field is not active yet | Num5.0 | Field not activ | |||
| REPEAT_CANDIDATE - Repeat Candidate Flag | Char1 | Rpt Candidat | |||
| REPEAT_CODE - Repeat Code | Char4 | Repeat | |||
| REPEAT_DT - Repeat Date | Date | Repeat Dt | |||
| SCTN_COMBINED_ID - Combined Sections ID | Char4 | Comb Sects ID | |||
| SEL_GROUP - Tuition Group | Char10 | Group | |||
| SESSION_CODE - Session | Char3 | N | Session | ||
| SSR_COMPONENT - Course Component | Char3 | N | Component | The translation is on psxlatitem. (fieldname ='SSR_COMPONENT') | |
| STATUS_DT - Status Date | Date | Stat Dt | |||
| STDNT_ENRL_STATUS - Student Enrollment Status | Char2 | N | Status | ||
| STDNT_SPEC_PERM - Student Specific Permissions | Char1 | Stdnt Spec | |||
| → | STRM - Term | Char4 | Term | ||
| SUBJECT - Subject Area | Char8 | Subject | |||
| TSCRPT_NOTE_EXISTS - Transcript Note Exists Flag | Char1 | Tscrpt Ex | |||
| TSCRPT_NOTE_ID - Transcript Note ID | Char4 | Note ID | |||
| UM_ACAD_ORG_DESCR - Academic Organization Descript | Char30 | Acad Org Dsecr | |||
| UM_CENTER_CD - Center Code | Char4 | Center | Please see Distance Education Course Coding - Current page for the code | ||
| UM_CENTER_DESCR - Center Description | Char25 | Center Descr | Please see Distance Education Course Coding - Current page for the code | ||
| UM_CLASS_DLV_MODE - Class Delivery Mode | Char30 | Class Dlv Mode | Please see Distance Education Course Coding - Current page for the code | ||
| UM_CLASS_LEVEL - Class Level | Char1 | Class Level | |||
| UM_DISTANCE_FLAG - Distance Flag | Char2 | Distance Flag | Please see Distance Education Course Coding - Current page for the code | ||
| UM_DIST_ATTR_FLAG - Distance Attribute Flag | Char2 | N | Dist Attr Flag | Please see Distance Education Course Coding - Current page for the code | |
| UM_DIST_ATTR_F_DSC - Dist Attr Flag Description | Char30 | Dist Attr F Dsc | Please see Distance Education Course Coding - Current page for the code | ||
| UM_DIST_CLASS - Distance Class | Char10 | Distance Class | Please see Distance Education Course Coding - Current page for the code | ||
| UM_DIST_FLG_DESCR - Distribution Flag Description | Char30 | Dist Flg Descr | Please see Distance Education Course Coding - Current page for the code | ||
| UM_IMODE - Imode | Char10 | Imode | Please see Distance Education Course Coding - Current page for the code | ||
| UM_IMODE_DESCR - Instruction Mode Description | Char30 | IMODE Descr | |||
| UM_INSTRUCTOR_NAME - Instructor Name | Char50 | Instructor Name | |||
| UM_INST_HOST - UM Host Institution | Char5 | Host Inst | Created for reporting cross-listed course. Click here for the definitions, fields, and field values. | ||
| UM_INST_SHORT - Institution Short | Char5 | Inst Short | |||
| UM_IPEDS_DIST_CLSS - IPEDS Distribution Class | Char30 | IPEDS Dist Clss | Please see Distance Education Course Coding - Current page for the code | ||
| UM_LOCATION_DESCR - Location Description | Char30 | Location Descr | Please see Distance Education Course Coding - Current page for the code | ||
| UM_REGION - Region | Char30 | Region | Please see Distance Education Course Coding - Current page for the code | ||
| UM_SITE_CATEGORY - Site Category | Char20 | Site Category | Please see Distance Education Course Coding - Current page for the code | ||
| UM_STDNT_ENRL_STAT - Student Enroll Stat Decoded | Char30 | Stud Enr Stat | |||
| UM_UNIV_CENTER_DSC - University Center Description | Char30 | Univ Center Dsc | Please see Distance Education Course Coding - Current page for the code | ||
| UM_UNIV_CENTER_FLG - University Center Flag | Char1 | Univ Center Flg | Please see Distance Education Course Coding - Current page for the code | ||
| UNITS_ACAD_PROG - Academic Progress Units | Num4.2 | Prgrss Unt | |||
| UNITS_ATTEMPTED - Units Attempted | Char1 | N | Units Att | ||
| UNITS_MAXIMUM - Maximum Units | Num4.2 | Max Units | |||
| UNITS_MINIMUM - Minimum Units | Num4.2 | Min Units | |||
| UNT_BILLING - Billing Units | Num4.2 | Bill Units | |||
| UNT_EARNED - Units Earned | Num4.2 | Units | |||
| UNT_PRGRSS - Units Taken-Academic Progress | Num4.2 | Progress | |||
| UNT_PRGRSS_FA - Units Taken-Fin Aid Progress | Num4.2 | FA Progress | |||
| UNT_TAKEN - Units Taken | Num4.2 | Unit Taken | |||
| VALID_ATTEMPT - Valid Attempted Grade | Char1 | Valid Attempt |
SQL for PS_UM_STD_ENR_C_VW Expand source
WITH MOROC AS
(SELECT A.EMPLID,
A.ACAD_CAREER,
A.INSTITUTION,
A.STRM,
A.CLASS_NBR,
A.CRSE_CAREER,
A.SESSION_CODE,
A.STDNT_ENRL_STATUS,
A.ENRL_STATUS_REASON,
A.ENRL_ACTION_LAST,
A.ENRL_ACTN_RSN_LAST,
A.ENRL_ACTN_PRC_LAST,
A.STATUS_DT,
A.ENRL_ADD_DT,
A.ENRL_DROP_DT,
A.UNT_TAKEN,
A.UNT_PRGRSS,
A.UNT_PRGRSS_FA,
A.UNT_BILLING,
A.CRSE_COUNT,
A.GRADING_BASIS_ENRL,
A.GRADING_BASIS_DT,
A.OVRD_GRADING_BASIS,
A.CRSE_GRADE_OFF,
A.CRSE_GRADE_INPUT,
A.GRADE_DT,
A.REPEAT_CODE,
A.REPEAT_DT,
A.ASSOCIATED_CLASS,
A.AUDIT_GRADE_BASIS,
A.EARN_CREDIT,
A.INCLUDE_IN_GPA,
A.UNITS_ATTEMPTED,
A.GRADE_POINTS,
A.GRADE_POINTS_FA,
A.GRD_PTS_PER_UNIT,
A.MANDATORY_GRD_BAS,
A.INSTRUCTOR_ID,
A.DROP_CLASS_IF_ENRL,
A.ASSOCIATION_99,
A.TSCRPT_NOTE_ID,
A.TSCRPT_NOTE_EXISTS,
A.NOTIFY_STDNT_CHNG,
A.REPEAT_CANDIDATE,
A.VALID_ATTEMPT,
A.GRADE_CATEGORY,
A.SEL_GROUP,
A.DYN_CLASS_NBR,
A.UNT_EARNED,
A.LAST_UPD_DT_STMP,
A.LAST_UPD_TM_STMP,
A.LAST_ENRL_DT_STMP,
A.LAST_ENRL_TM_STMP,
A.LAST_DROP_DT_STMP,
A.LAST_DROP_TM_STMP,
A.ENRL_REQ_SOURCE,
A.LAST_UPD_ENREQ_SRC,
A.GRADING_SCHEME_ENR,
A.RELATE_CLASS_NBR_1,
A.RELATE_CLASS_NBR_2,
A.ACAD_PROG,
A.CRSE_ID,
A.CRSE_OFFER_NBR,
A.CLASS_SECTION,
A.ACAD_GROUP,
A.SUBJECT,
A.CATALOG_NBR,
A.DESCR,
A.SSR_COMPONENT,
A.ENRL_STAT,
A.CLASS_STAT,
A.CLASS_TYPE,
A.STDNT_SPEC_PERM,
A.CAMPUS,
A.LOCATION,
A.INSTRUCTION_MODE,
A.DESCR_LOCATION,
A.UM_DISTANCE_FLAG,
A.UM_CENTER_CD,
A.UM_CENTER_DESCR,
A.LAST_NAME,
A.FIRST_NAME,
A.MIDDLE_NAME,
A.NAME_PREFIX,
A.NAME_SUFFIX,
A.UM_DIST_ATTR_FLAG,
A.UM_IMODE,
A.ENRL_CAP,
A.ACAD_ORG,
A.UM_ACAD_ORG_DESCR,
A.SCTN_COMBINED_ID,
A.UNITS_MINIMUM,
A.UNITS_MAXIMUM,
A.UNITS_ACAD_PROG,
DECODE(A.INSTITUTION,
'UMS01',
'UMA',
'UMS02',
'UMF',
'UMS03',
'UMFK',
'UMS04',
'UMM',
'UMS07',
'UMPI',
'UMS05',
'UM',
'UMS06',
'USM',
'Other') INSTITUTION_SHORT,
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 CLASS_DELIVERY_MODE,
CASE
WHEN A.CATALOG_NBR = ' ' THEN
0
WHEN SUBSTR(A.CATALOG_NBR, 1, 1) <> ' ' THEN
TO_NUMBER(SUBSTR(A.CATALOG_NBR, 1, 1))
WHEN SUBSTR(A.CATALOG_NBR, 2, 3) < '100' THEN
0
ELSE
TO_NUMBER(SUBSTR(A.CATALOG_NBR, 2, 1))
END CLASS_LEVEL,
CASE
WHEN A.UM_DIST_ATTR_FLAG = 'Y' THEN
'Distance Course'
ELSE
'Traditional Campus Course'
END DIST_ATTR_FLG_DESCR,
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 DIST_CLASS,
DECODE(A.UM_DISTANCE_FLAG, 'B', 'Broadcast', 'R', 'Receive', ' ') DIST_FLG_DESCR,
DECODE(A.INSTRUCTION_MODE,
'BL',
'Blended',
'BR',
'Broadcast Class',
'OA',
'Online Asynchronous',
'OL',
'Online Low Residency',
'OS',
'Online Synchronous',
'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',
'AR',
'By Arrangement',
'DS',
'Distance Synchronous Learning',
'HB',
'Hybrid/Blended',
'HF',
'Hyflex',
'P',
'In-Person',
'RE',
'Receive',
'SD',
'Split Delivery',
'SL',
'Service Learning',
'WW',
'Online',
'WS',
'Web-Synchronous',
'Other') INSTRUCTION_MODE_DESCR,
CASE
WHEN A.NAME_SUFFIX = ' ' AND A.LAST_NAME <> ' ' THEN
A.LAST_NAME || ', ' || A.FIRST_NAME || ' ' || A.MIDDLE_NAME
WHEN A.LAST_NAME <> ' ' THEN
A.LAST_NAME || ' ' || A.NAME_SUFFIX || ', ' || A.FIRST_NAME || ' ' ||
A.MIDDLE_NAME
ELSE
' '
END INSTRUCTOR_NAME,
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 IPEDS_DIST_CLASS,
DECODE(A.STDNT_ENRL_STATUS,
'A',
'All',
'D',
'Dropped',
'E',
'Enrolled',
'W',
'Waiting',
'Other') UM_STDNT_ENRL_STAT,
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 UNIV_CENTER_DESC,
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 UNIV_CENTER_FLAG
FROM SYSADM.PS_UM_STD_ENR_CENS A)
SELECT MOC.EMPLID,
MOC.ACAD_CAREER,
MOC.INSTITUTION,
MOC.STRM,
MOC.CLASS_NBR,
MOC.CRSE_CAREER,
MOC.SESSION_CODE,
MOC.STDNT_ENRL_STATUS,
MOC.ENRL_STATUS_REASON,
MOC.ENRL_ACTION_LAST,
MOC.ENRL_ACTN_RSN_LAST,
MOC.ENRL_ACTN_PRC_LAST,
MOC.STATUS_DT,
MOC.ENRL_ADD_DT,
MOC.ENRL_DROP_DT,
MOC.UNT_TAKEN,
MOC.UNT_PRGRSS,
MOC.UNT_PRGRSS_FA,
MOC.UNT_BILLING,
MOC.CRSE_COUNT,
MOC.GRADING_BASIS_ENRL,
MOC.GRADING_BASIS_DT,
MOC.OVRD_GRADING_BASIS,
MOC.CRSE_GRADE_OFF,
MOC.CRSE_GRADE_INPUT,
MOC.GRADE_DT,
MOC.REPEAT_CODE,
MOC.REPEAT_DT,
MOC.ASSOCIATED_CLASS,
MOC.AUDIT_GRADE_BASIS,
MOC.EARN_CREDIT,
MOC.INCLUDE_IN_GPA,
MOC.UNITS_ATTEMPTED,
MOC.GRADE_POINTS,
MOC.GRADE_POINTS_FA,
MOC.GRD_PTS_PER_UNIT,
MOC.MANDATORY_GRD_BAS,
MOC.INSTRUCTOR_ID,
MOC.DROP_CLASS_IF_ENRL,
MOC.ASSOCIATION_99,
MOC.TSCRPT_NOTE_ID,
MOC.TSCRPT_NOTE_EXISTS,
MOC.NOTIFY_STDNT_CHNG,
MOC.REPEAT_CANDIDATE,
MOC.VALID_ATTEMPT,
MOC.GRADE_CATEGORY,
MOC.SEL_GROUP,
MOC.DYN_CLASS_NBR,
MOC.UNT_EARNED,
MOC.LAST_UPD_DT_STMP,
MOC.LAST_UPD_TM_STMP,
MOC.LAST_ENRL_DT_STMP,
MOC.LAST_ENRL_TM_STMP,
MOC.LAST_DROP_DT_STMP,
MOC.LAST_DROP_TM_STMP,
MOC.ENRL_REQ_SOURCE,
MOC.LAST_UPD_ENREQ_SRC,
MOC.GRADING_SCHEME_ENR,
MOC.RELATE_CLASS_NBR_1,
MOC.RELATE_CLASS_NBR_2,
MOC.ACAD_PROG,
MOC.CRSE_ID,
MOC.CRSE_OFFER_NBR,
MOC.CLASS_SECTION,
MOC.ACAD_GROUP,
MOC.SUBJECT,
MOC.CATALOG_NBR,
MOC.DESCR,
MOC.SSR_COMPONENT,
MOC.ENRL_STAT,
MOC.CLASS_STAT,
MOC.CLASS_TYPE,
MOC.STDNT_SPEC_PERM,
MOC.CAMPUS,
MOC.LOCATION,
MOC.INSTRUCTION_MODE,
MOC.DESCR_LOCATION,
MOC.UM_DISTANCE_FLAG,
MOC.UM_CENTER_CD,
MOC.UM_CENTER_DESCR,
MOC.LAST_NAME,
MOC.FIRST_NAME,
MOC.MIDDLE_NAME,
MOC.NAME_PREFIX,
MOC.NAME_SUFFIX,
MOC.UM_DIST_ATTR_FLAG,
MOC.UM_IMODE,
MOC.ENRL_CAP,
MOC.ACAD_ORG,
MOC.UM_ACAD_ORG_DESCR,
MOC.SCTN_COMBINED_ID,
MOC.UNITS_MINIMUM,
MOC.UNITS_MAXIMUM,
MOC.UNITS_ACAD_PROG,
MOC.INSTITUTION_SHORT,
MOC.CLASS_DELIVERY_MODE,
MOC.CLASS_LEVEL,
MOC.DIST_ATTR_FLG_DESCR,
MOC.DIST_CLASS,
MOC.DIST_FLG_DESCR,
MOC.INSTRUCTION_MODE_DESCR,
MOC.INSTRUCTOR_NAME,
MOC.IPEDS_DIST_CLASS,
CASE
WHEN MOC.CLASS_DELIVERY_MODE = 'Distance Online' THEN
'Distance Online'
WHEN MOC.LOCATION = 'V01190' THEN
'Bath/Brunswick UC Center'
WHEN MOC.LOCATION = 'V01525' THEN
'Falmouth - Baxter School'
WHEN MOC.LOCATION = 'V01820' THEN
'Lisbon Falls'
WHEN MOC.LOCATION = 'V02047' THEN
'Windham/Maine Correctional Center'
WHEN MOC.LOCATION = 'V02060' THEN
'Wiscasset'
WHEN MOC.LOCATION = 'V01440' THEN
'East Millinocket UC Center'
WHEN MOC.LOCATION = 'V01800' THEN
'Lincoln'
WHEN MOC.LOCATION = 'V01970' THEN
'Sherman Station'
WHEN MOC.LOCATION = 'V01490' THEN
'Ellsworth UC Center'
WHEN MOC.LOCATION = 'V01070' THEN
'Bangor - BMHI'
WHEN MOC.LOCATION = 'V01210' THEN
'Bucksport'
WHEN MOC.LOCATION = 'V01360' THEN
'Deer Isle'
WHEN MOC.LOCATION = 'V01450' THEN
'East Sullivan'
WHEN MOC.LOCATION = 'V01740' THEN
'Isle au Haut'
WHEN MOC.LOCATION = 'V01900' THEN
'Mount Desert'
WHEN MOC.LOCATION = 'V01980' THEN
'Swans Island'
WHEN MOC.LOCATION = 'V01690' THEN
'Houlton UC Center'
WHEN MOC.LOCATION = 'V01700' THEN
'Houlton'
WHEN MOC.LOCATION = 'V01250' THEN
'Caribou'
WHEN MOC.LOCATION = 'V01340' THEN
'Danforth'
WHEN MOC.LOCATION = 'V01540' THEN
'Fort Fairfield'
WHEN MOC.LOCATION = 'V01730' THEN
'Island Falls'
WHEN MOC.LOCATION = 'V01972' THEN
'Norway/South Paris UC Center'
WHEN MOC.LOCATION = 'V01160' THEN
'Bethel'
WHEN MOC.LOCATION = 'V01390' THEN
'Penquis/Dover-Foxcroft UC Center'
WHEN MOC.LOCATION = 'V01380' THEN
'Dexter'
WHEN MOC.LOCATION = 'V01640' THEN
'Greenville'
WHEN MOC.LOCATION = 'V01650' THEN
'Guilford'
WHEN MOC.LOCATION = 'V01670' THEN
'Hermon'
WHEN MOC.LOCATION = 'V01760' THEN
'Jackman'
WHEN MOC.LOCATION = 'V01910' THEN
'Newport'
WHEN MOC.LOCATION = 'V01945' THEN
'Rockland UC Center'
WHEN MOC.LOCATION = 'V01230' THEN
'Camden'
WHEN MOC.LOCATION = 'V01750' THEN
'Islesboro'
WHEN MOC.LOCATION = 'V01902' THEN
'Lincoln Academy (Newcastle)'
WHEN MOC.LOCATION = 'V01895' THEN
'Monhegan Island'
WHEN MOC.LOCATION = 'V02020' THEN
'Maine State Prison'
WHEN MOC.LOCATION = 'V02020' THEN
'Maine State Prison'
WHEN MOC.LOCATION = 'V01920 ' THEN
'North Haven'
WHEN MOC.LOCATION = 'V01982' THEN
'Maine State Prison'
WHEN MOC.LOCATION = 'V02010' THEN
'Vinalhaven'
WHEN MOC.LOCATION = 'V01874' THEN
'Rumford/Mexico UC Center'
WHEN MOC.LOCATION = 'V01170' THEN
'Bingham'
WHEN MOC.LOCATION = 'V01780' THEN
'Kingfield'
WHEN MOC.LOCATION = 'V01830' THEN
'Livermore Falls'
WHEN MOC.LOCATION = 'V01535' THEN
'Farmington - Mt. Blue'
WHEN MOC.LOCATION = 'V01940' THEN
'Rangeley'
WHEN MOC.LOCATION = 'V01950' THEN
'Saco UC Center'
WHEN MOC.LOCATION = 'V01954' THEN
'Sanford High School'
WHEN MOC.LOCATION = 'V01951' THEN
'Sanford UC Center'
WHEN MOC.LOCATION = 'V01955' THEN
'Scarborough'
WHEN MOC.LOCATION = 'V01973' THEN
'South Berwick'
WHEN MOC.LOCATION = 'V01928' THEN
'Orono UM Campus'
WHEN MOC.LOCATION = 'V01150' THEN
'Hutchinson Center - Belfast'
WHEN MOC.LOCATION = 'V01035' THEN
'Augusta UMA Campus'
WHEN MOC.LOCATION = 'V01075' THEN
'Bangor UMA Campus'
WHEN MOC.LOCATION = 'V01520' THEN
'Fairfield'
WHEN MOC.LOCATION = 'V01037' THEN
'Maine State Library'
WHEN MOC.LOCATION = 'V01040' THEN
'Riverview Psychiatric'
WHEN MOC.LOCATION = 'V01971' THEN
'Skowhegan'
WHEN MOC.LOCATION = 'V01990' THEN
'Thorndike'
WHEN MOC.LOCATION = 'V02050' THEN
'Winthrop'
WHEN MOC.LOCATION = 'V01530' THEN
'Farmington UMF Campus'
WHEN MOC.LOCATION = 'V02081' THEN
'Farmington UMF Campus'
WHEN MOC.LOCATION = 'V09998' THEN
'Farmington UMF Campus'
WHEN MOC.LOCATION = 'V01545' THEN
'Fort Kent UMFK Campus'
WHEN MOC.LOCATION = 'V02085' THEN
'Fort Kent UMFK Campus'
WHEN MOC.LOCATION = 'V01410' THEN
'Eagle Lake'
WHEN MOC.LOCATION = 'V01546' THEN
'Fort Kent'
WHEN MOC.LOCATION = 'V01860' THEN
'Madawaska'
WHEN MOC.LOCATION = 'V02000' THEN
'Van Buren'
WHEN MOC.LOCATION = 'V01855' THEN
'Machias UMM Campus'
WHEN MOC.LOCATION = 'V02081' THEN
'Machias UMM Campus'
WHEN MOC.LOCATION = 'V01215' THEN
'Calais'
WHEN MOC.LOCATION = 'V01470' THEN
'Eastport'
WHEN MOC.LOCATION = 'V01850' THEN
'Lubec'
WHEN MOC.LOCATION = 'V01939' THEN
'Presque Isle UMPI Campus'
WHEN MOC.LOCATION = 'V01941' THEN
'Presque Isle High School '
WHEN MOC.LOCATION = 'V01595' THEN
'Gorham USM Campus'
WHEN MOC.LOCATION = 'V01785' THEN
'Lewiston-Auburn USM Campus'
WHEN MOC.LOCATION = 'V01938' THEN
'Portland USM Campus'
WHEN MOC.LOCATION = 'V02082' THEN
'USM Campus'
WHEN MOC.LOCATION = 'V99099' THEN
'USM Campus'
WHEN MOC.CAMPUS = 'BATH' THEN
'Bath/Brunswick UC Center'
WHEN MOC.CAMPUS = 'BBC' THEN
'Bath/Brunswick UC Center'
WHEN MOC.CAMPUS = 'ELL' THEN
'Ellsworth UC Center'
WHEN MOC.CAMPUS = 'EML' THEN
'East Millinocket UC Center'
WHEN MOC.CAMPUS = 'FHC' THEN
'Hutchinson Center - Belfast'
WHEN MOC.CAMPUS = 'HOU' THEN
'Houlton UC Center'
WHEN MOC.CAMPUS = 'HOULT' THEN
'Houlton UC Center'
WHEN MOC.CAMPUS = 'PEN' THEN
'Penquis /Dover-Foxcroft UC Center'
WHEN MOC.CAMPUS = 'ROC' THEN
'Rockland UC Center'
WHEN MOC.CAMPUS = 'RUM' THEN
'Rumford/Mexico UC Center'
WHEN MOC.CAMPUS = 'SAC' THEN
'Saco UC Center'
WHEN MOC.CAMPUS = 'SACO' THEN
'Saco UC Center'
WHEN MOC.CAMPUS = 'SOP' THEN
'Norway/South Paris UC Center'
WHEN MOC.INSTITUTION = 'UMS01' THEN
'Augusta UMA Campus'
WHEN MOC.INSTITUTION = 'UMS02' THEN
'Farmington UMF Campus'
WHEN MOC.INSTITUTION = 'UMS03' THEN
'Fort Kent UMFK Campus'
WHEN MOC.INSTITUTION = 'UMS04' THEN
'Machias UMM Campus'
WHEN MOC.INSTITUTION = 'UMS05' THEN
'Orono UM Campus'
WHEN MOC.INSTITUTION = 'UMS06' THEN
'USM Campus'
WHEN MOC.INSTITUTION = 'UMS07' THEN
'Presque Isle UMPI Campus'
ELSE
'Other'
END LOC_DESCR,
CASE
WHEN MOC.CLASS_DELIVERY_MODE = 'Distance Online' THEN
'Distance Online'
WHEN MOC.LOCATION = 'V01190' THEN
'Bath/Brunswick UC Center'
WHEN MOC.LOCATION = 'V01525' THEN
'Bath/Brunswick UC Center'
WHEN MOC.LOCATION = 'V01820' THEN
'Bath/Brunswick UC Center'
WHEN MOC.LOCATION = 'V02047' THEN
'Bath/Brunswick UC Center'
WHEN MOC.LOCATION = 'V02060' THEN
'Bath/Brunswick UC Center'
WHEN MOC.LOCATION = 'V01440' THEN
'East Millinocket UC Center'
WHEN MOC.LOCATION = 'V01800' THEN
'East Millinocket UC Center'
WHEN MOC.LOCATION = 'V01970' THEN
'East Millinocket UC Center'
WHEN MOC.LOCATION = 'V01490' THEN
'Ellsworth UC Center'
WHEN MOC.LOCATION = 'V01070' THEN
'Ellsworth UC Center'
WHEN MOC.LOCATION = 'V01210' THEN
'Ellsworth UC Center'
WHEN MOC.LOCATION = 'V01360' THEN
'Ellsworth UC Center'
WHEN MOC.LOCATION = 'V01450' THEN
'Ellsworth UC Center'
WHEN MOC.LOCATION = 'V01740' THEN
'Ellsworth UC Center'
WHEN MOC.LOCATION = 'V01900' THEN
'Ellsworth UC Center'
WHEN MOC.LOCATION = 'V01980' THEN
'Ellsworth UC Center'
WHEN MOC.LOCATION = 'V01690' THEN
'Houlton UC Center'
WHEN MOC.LOCATION = 'V01700' THEN
'Houlton UC Center'
WHEN MOC.LOCATION = 'V01250' THEN
'Houlton UC Center'
WHEN MOC.LOCATION = 'V01340' THEN
'Houlton UC Center'
WHEN MOC.LOCATION = 'V01540' THEN
'Houlton UC Center'
WHEN MOC.LOCATION = 'V01730' THEN
'Houlton UC Center'
WHEN MOC.LOCATION = 'V01972' THEN
'Norway/South Paris UC Center'
WHEN MOC.LOCATION = 'V01160' THEN
'Norway/South Paris UC Center'
WHEN MOC.LOCATION = 'V01390' THEN
'Penquis /Dover-Foxcroft UC Center'
WHEN MOC.LOCATION = 'V01380' THEN
'Penquis /Dover-Foxcroft UC Center'
WHEN MOC.LOCATION = 'V01640' THEN
'Penquis /Dover-Foxcroft UC Center'
WHEN MOC.LOCATION = 'V01650' THEN
'Penquis /Dover-Foxcroft UC Center'
WHEN MOC.LOCATION = 'V01670' THEN
'Penquis /Dover-Foxcroft UC Center'
WHEN MOC.LOCATION = 'V01760' THEN
'Penquis /Dover-Foxcroft UC Center'
WHEN MOC.LOCATION = 'V01910' THEN
'Penquis /Dover-Foxcroft UC Center'
WHEN MOC.LOCATION = 'V01945' THEN
'Rockland UC Center'
WHEN MOC.LOCATION = 'V01230 ' THEN
'Rockland UC Center'
WHEN MOC.LOCATION = 'V01750' THEN
'Rockland UC Center'
WHEN MOC.LOCATION = 'V01902' THEN
'Rockland UC Center'
WHEN MOC.LOCATION = 'V01895' THEN
'Rockland UC Center'
WHEN MOC.LOCATION = 'V02020' THEN
'Rockland UC Center'
WHEN MOC.LOCATION = 'V02020' THEN
'Rockland UC Center'
WHEN MOC.LOCATION = 'V01920' THEN
'Rockland UC Center'
WHEN MOC.LOCATION = 'V01982' THEN
'Rockland UC Center'
WHEN MOC.LOCATION = 'V02010' THEN
'Rockland UC Center'
WHEN MOC.LOCATION = 'V01874' THEN
'Rumford/Mexico UC Center'
WHEN MOC.LOCATION = 'V01170' THEN
'Rumford/Mexico UC Center'
WHEN MOC.LOCATION = 'V01780' THEN
'Rumford/Mexico UC Center'
WHEN MOC.LOCATION = 'V01830' THEN
'Rumford/Mexico UC Center'
WHEN MOC.LOCATION = 'V01535' THEN
'Rumford/Mexico UC Center'
WHEN MOC.LOCATION = 'V01940' THEN
'Rumford/Mexico UC Center'
WHEN MOC.LOCATION = 'V01950' THEN
'Saco UC Center'
WHEN MOC.LOCATION = 'V01954' THEN
'Saco UC Center'
WHEN MOC.LOCATION = 'V01951' THEN
'Saco UC Center'
WHEN MOC.LOCATION = 'V01955' THEN
'Saco UC Center'
WHEN MOC.LOCATION = 'V01973' THEN
'Saco UC Center'
WHEN MOC.LOCATION = 'V01928' THEN
'UM Campus'
WHEN MOC.LOCATION = 'V01150' THEN
'Hutchinson Center - Belfast'
WHEN MOC.LOCATION = 'V01035' THEN
'UMA Campus'
WHEN MOC.LOCATION = 'V01075' THEN
'UMA Campus'
WHEN MOC.LOCATION = 'V01520' THEN
'UMA Campus'
WHEN MOC.LOCATION = 'V01037' THEN
'UMA Campus'
WHEN MOC.LOCATION = 'V01040' THEN
'UMA Campus'
WHEN MOC.LOCATION = 'V01971' THEN
'UMA Campus'
WHEN MOC.LOCATION = 'V01990' THEN
'UMA Campus'
WHEN MOC.LOCATION = 'V02050' THEN
'UMA Campus'
WHEN MOC.LOCATION = 'V01530' THEN
'UMF Campus'
WHEN MOC.LOCATION = 'V02081' THEN
'UMF Campus'
WHEN MOC.LOCATION = 'V09998' THEN
'UMF Campus'
WHEN MOC.LOCATION = 'V01545' THEN
'UMFK Campus'
WHEN MOC.LOCATION = 'V02085' THEN
'UMFK Campus'
WHEN MOC.LOCATION = 'V01410' THEN
'UMFK Campus'
WHEN MOC.LOCATION = 'V01546' THEN
'UMFK Campus'
WHEN MOC.LOCATION = 'V01860' THEN
'UMFK Campus'
WHEN MOC.LOCATION = 'V02000' THEN
'UMFK Campus'
WHEN MOC.LOCATION = 'V01855' THEN
'UMM Cam p u s'
WHEN MOC.LOCATION = 'V02081' THEN
'UMM Campus'
WHEN MOC.LOCATION = 'V01215' THEN
'UMM Campus'
WHEN MOC.LOCATION = 'V01470' THEN
'UMM Campus'
WHEN MOC.LOCATION = 'V01850' THEN
'UMM Campus'
WHEN MOC.LOCATION = 'V01939' THEN
'UMPI Campus'
WHEN MOC.LOCATION = 'V01941' THEN
'UMPI Campus'
WHEN MOC.LOCATION = 'V01595' THEN
'USM Campus'
WHEN MOC.LOCATION = 'V01785' THEN
'USM Campus'
WHEN MOC.LOCATION = 'V01938' THEN
'USM Campus'
WHEN MOC.LOCATION = 'V02082' THEN
'USM Campus'
WHEN MOC.LOCATION = 'V99099' THEN
'USM Campus'
WHEN MOC.CAMPUS = 'BATH' THEN
'Bath/Brunswick UC Center'
WHEN MOC.CAMPUS = 'BBC' THEN
'Bath/Brunswick UC Center'
WHEN MOC.CAMPUS = 'ELL' THEN
'Ellsworth UC Center'
WHEN MOC.CAMPUS = 'EML' THEN
'East Millinocket UC Center'
WHEN MOC.CAMPUS = 'FHC' THEN
'Hutchinson Center - Belfast'
WHEN MOC.CAMPUS = 'HOU' THEN
'Houlton UC Center'
WHEN MOC.CAMPUS = 'HOULT' THEN
'Houlton UC Center'
WHEN MOC.CAMPUS = 'PEN' THEN
'Penquis /Dover-Foxcroft UC Center'
WHEN MOC.CAMPUS = 'ROC' THEN
'Rockland UC Center'
WHEN MOC.CAMPUS = 'RUM' THEN
'Rumford/Mexico UC Center'
WHEN MOC.CAMPUS = 'SAC' THEN
'Saco UC Center'
WHEN MOC.CAMPUS = 'SACO' THEN
'Saco UC Center'
WHEN MOC.CAMPUS = 'SOP' THEN
'Norway/South Paris UC Center'
WHEN MOC.INSTITUTION = 'UMS01' THEN
'UMA Campus'
WHEN MOC.INSTITUTION = 'UMS02' THEN
'UMF Campus'
WHEN MOC.INSTITUTION = 'UMS03' THEN
'UMFK Campus'
WHEN MOC.INSTITUTION = 'UMS04' THEN
'UMM Campus'
WHEN MOC.INSTITUTION = 'UMS05' THEN
'UM Campus'
WHEN MOC.INSTITUTION = 'UMS06' THEN
'USM Campus'
WHEN MOC.INSTITUTION = 'UMS07' THEN
'UMPI Campus'
ELSE
'Other'
END REGION,
CASE
WHEN MOC.CLASS_DELIVERY_MODE = 'Distance Online' THEN
'Distance Online'
WHEN MOC.LOCATION = 'V01190' THEN
'UC Center'
WHEN MOC.LOCATION = 'V01525' THEN
'Site'
WHEN MOC.LOCATION = 'V01820' THEN
'Site'
WHEN MOC.LOCATION = 'V02047' THEN
'Site'
WHEN MOC.LOCATION = 'V02060' THEN
'Site'
WHEN MOC.LOCATION = 'V01440' THEN
'UC Center'
WHEN MOC.LOCATION = 'V01800' THEN
'Site'
WHEN MOC.LOCATION = 'V01970' THEN
'Site'
WHEN MOC.LOCATION = 'V01490' THEN
'UC Center'
WHEN MOC.LOCATION = 'V01070' THEN
'Site'
WHEN MOC.LOCATION = 'V01210' THEN
'Site'
WHEN MOC.LOCATION = 'V01360' THEN
'Site'
WHEN MOC.LOCATION = 'V01450' THEN
'Site'
WHEN MOC.LOCATION = 'V01740' THEN
'Site'
WHEN MOC.LOCATION = 'V01900' THEN
'Site'
WHEN MOC.LOCATION = 'V01980' THEN
'Site'
WHEN MOC.LOCATION = 'V01690' THEN
'UC Center'
WHEN MOC.LOCATION = 'V01700' THEN
'Site'
WHEN MOC.LOCATION = 'V01250' THEN
'Site'
WHEN MOC.LOCATION = 'V01340' THEN
'Site'
WHEN MOC.LOCATION = 'V01540' THEN
'Site'
WHEN MOC.LOCATION = 'V01730' THEN
'Site'
WHEN MOC.LOCATION = 'V01972' THEN
'UC Center'
WHEN MOC.LOCATION = 'V01160' THEN
'Site'
WHEN MOC.LOCATION = 'V01390' THEN
'UC Center'
WHEN MOC.LOCATION = 'V01380' THEN
'Site'
WHEN MOC.LOCATION = 'V01640' THEN
'Site'
WHEN MOC.LOCATION = 'V01650' THEN
'Site'
WHEN MOC.LOCATION = 'V01670' THEN
'Site'
WHEN MOC.LOCATION = 'V01760' THEN
'Site'
WHEN MOC.LOCATION = 'V01910' THEN
'Site'
WHEN MOC.LOCATION = 'V01945' THEN
'UC Center'
WHEN MOC.LOCATION = 'V01230' THEN
'Site'
WHEN MOC.LOCATION = 'V01750' THEN
'Site'
WHEN MOC.LOCATION = 'V01902' THEN
'Site'
WHEN MOC.LOCATION = 'V01895' THEN
'Site'
WHEN MOC.LOCATION = 'V02020' THEN
'Site'
WHEN MOC.LOCATION = 'V02020' THEN
'Site'
WHEN MOC.LOCATION = 'V01920' THEN
'Site'
WHEN MOC.LOCATION = 'V01982' THEN
'Site'
WHEN MOC.LOCATION = 'V02010' THEN
'Site'
WHEN MOC.LOCATION = 'V01874' THEN
'UC Center'
WHEN MOC.LOCATION = 'V01170' THEN
'Site'
WHEN MOC.LOCATION = 'V01780' THEN
'Site'
WHEN MOC.LOCATION = 'V01830' THEN
'Site'
WHEN MOC.LOCATION = 'V01535' THEN
'Site'
WHEN MOC.LOCATION = 'V01940' THEN
'Site'
WHEN MOC.LOCATION = 'V01950' THEN
'UC Center'
WHEN MOC.LOCATION = 'V01954' THEN
'Site'
WHEN MOC.LOCATION = 'V01951' THEN
'Site'
WHEN MOC.LOCATION = 'V01955' THEN
'Site'
WHEN MOC.LOCATION = 'V01973' THEN
'Site'
WHEN MOC.LOCATION = 'V01928' THEN
'Campus'
WHEN MOC.LOCATION = 'V01150' THEN
'Campus Center'
WHEN MOC.LOCATION = 'V01035' THEN
'Campus'
WHEN MOC.LOCATION = 'V01075' THEN
'Campus'
WHEN MOC.LOCATION = 'V01520' THEN
'Site'
WHEN MOC.LOCATION = 'V01037' THEN
'Site'
WHEN MOC.LOCATION = 'V01040' THEN
'Site'
WHEN MOC.LOCATION = 'V01971' THEN
'Site'
WHEN MOC.LOCATION = 'V01990' THEN
'Site'
WHEN MOC.LOCATION = 'V02050' THEN
'Site'
WHEN MOC.LOCATION = 'V01530' THEN
'Campus'
WHEN MOC.LOCATION = 'V02081' THEN
'Campus'
WHEN MOC.LOCATION = 'V09998' THEN
'Campus'
WHEN MOC.LOCATION = 'V01545' THEN
'Campus'
WHEN MOC.LOCATION = 'V02085' THEN
'Campus'
WHEN MOC.LOCATION = 'V01410' THEN
'Site'
WHEN MOC.LOCATION = 'V01546' THEN
'Site'
WHEN MOC.LOCATION = 'V01860' THEN
'Site'
WHEN MOC.LOCATION = 'V02000' THEN
'Site'
WHEN MOC.LOCATION = 'V01855' THEN
'Campus'
WHEN MOC.LOCATION = 'V02081' THEN
'Campus'
WHEN MOC.LOCATION = 'V01215' THEN
'Site'
WHEN MOC.LOCATION = 'V01470' THEN
'Site'
WHEN MOC.LOCATION = 'V01850' THEN
'Site'
WHEN MOC.LOCATION = 'V01939' THEN
'Campus'
WHEN MOC.LOCATION = 'V01941' THEN
'Site'
WHEN MOC.LOCATION = 'V01595' THEN
'Campus'
WHEN MOC.LOCATION = 'V01785' THEN
'Campus'
WHEN MOC.LOCATION = 'V01938' THEN
'Campus'
WHEN MOC.LOCATION = 'V02082' THEN
'Campus'
WHEN MOC.LOCATION = 'V99099' THEN
'Campus'
WHEN MOC.CAMPUS = 'BATH' THEN
'UC Center'
WHEN MOC.CAMPUS = 'BBC' THEN
'UC Center'
WHEN MOC.CAMPUS = 'ELL' THEN
'UC Center'
WHEN MOC.CAMPUS = 'EML' THEN
'UC Center'
WHEN MOC.CAMPUS = 'FHC' THEN
'Campus Center'
WHEN MOC.CAMPUS = 'HOU' THEN
'UC Center'
WHEN MOC.CAMPUS = 'HOULT' THEN
'UC Center'
WHEN MOC.CAMPUS = 'PEN' THEN
'UC Center'
WHEN MOC.CAMPUS = 'ROC' THEN
'UC Center'
WHEN MOC.CAMPUS = 'RUM' THEN
'UC Center'
WHEN MOC.CAMPUS = 'SAC' THEN
'UC Center'
WHEN MOC.CAMPUS = 'SACO' THEN
'UC Center'
WHEN MOC.CAMPUS = 'SOP' THEN
'UC Center'
ELSE
'Campus'
END SITE_CATEGORY,
MOC.UM_STDNT_ENRL_STAT,
MOC.UNIV_CENTER_DESC,
MOC.UNIV_CENTER_FLAG,
CASE
WHEN MOC.STRM < '1910' THEN
MOC.INSTITUTION
WHEN MOC.GRADING_BASIS_ENRL = 'NON' THEN
MOC.INSTITUTION
WHEN MOC.ACAD_GROUP IN
('FUMA', 'KUMA', 'MUMA', 'OUMA', 'PUMA', 'IUMA') THEN
'UMS01'
WHEN MOC.ACAD_GROUP IN
('AUMF', 'KUMF', 'MUMF', 'OUMF', 'PUMF', 'IUMF') THEN
'UMS02'
WHEN MOC.ACAD_GROUP IN
('AUMFK', 'FUMFK', 'MUMFK', 'OUMFK', 'PUMFK', 'IUMFK') THEN
'UMS03'
WHEN MOC.STRM < '2510' AND
MOC.ACAD_GROUP IN
('AUMM', 'FUMM', 'KUMM', 'OUMM', 'PUMM', 'IUMM') THEN
'UMS04'
WHEN MOC.STRM >= '2510' AND
MOC.ACAD_GROUP IN
('AUMM', 'FUMM', 'KUMM', 'OUMM', 'PUMM', 'IUMM') THEN
'UMS05'
WHEN MOC.ACAD_GROUP IN ('AUM', 'FUM', 'KUM', 'MUM', 'PUM', 'IUM') THEN
'UMS05'
WHEN MOC.ACAD_GROUP IN
('AUSM', 'FUSM', 'KUSM', 'MUSM', 'OUSM', 'IUSM') THEN
'UMS06'
WHEN MOC.ACAD_GROUP IN
('AUMPI', 'FUMPI', 'KUMPI', 'MUMPI', 'OUMPI', 'PUMPI') THEN
'UMS07'
ELSE
MOC.INSTITUTION
END UM_INST_HOST
FROM MOROC MOC;