Attribute Description
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 |
Known Issues, Related Details, and Other Notes
· Cpl (Credit for Prior Learning) is not yet in the datamart. The business process for Cbe (Credit by Exam) has shifted to Cpl, both will need to be excluded, especially once Cpl appears.