EM001 Global Enrollment Management Parameters (GEMP)

OD Report and #

Enrollment Management EM001

Name

GEMP

Purpose

Global exclusion of values from Course Section table that are related to Business processes and not sections/enrollments of ‘community college courses’ students enroll in. 

It excludes processes associated with the District (Offerno 9) like Challenge Exams, Tentative or Cancelled sections, Credit by Exam and Credit for Prior Learning, Tutoring, Apprenticeship, and for CE, Non-state supported Accounting method. 

Business Owner

Vice Chancellor of Educational Services

Location

Stg_Course_Section

Stage

Formula

= Table.AddColumn(#"Added TermCrnOff", "GEMP", each if [Sam] = "A" then 0  

else if ([Offerno] = "4" and [Acctgmeth] = "O") then 0 

else if [Classstat] <> "T" and [Classstat] <> "X" and [Cbe] <> "CBE" and [Cbe] <> "TPRP" and [Schtype] <> "TUT" and [Offerno] <> "9" then 1  

else 0) 

Pipeline

Dependencies

None;  uses Sam, Offerno, Acctgmeth, Classstat, Cbe, Cpl, Schtype, Offerno 

Notes

Acctgmeth != O will be revisited later on to see if it is applicable to SDCCD districtwide.  Until then, they will be excluded from each metric that is not applicable. 

Last Updated

2/24/2023

Metric

No