Metric Details

Category: Students/Headcounts
Title: Enrollment Status
Location: https://datamart.cccco.edu/Students/Enrollment_Status.aspx
PseudoCode: SELECT GI01 DISTRICT-COLLEGE-IDENTIFIER, GI03 TERM-IDENTIFIER SB00 STUDENT-IDENTIFIER, SB04 STUDENT-GENDER, STD1 STUDENT-AGE-AT-TERM, derived DataMart ethnicity from SB29 STUDENT-MULTI-ETHNICITY (ST_RACE), SB11 STUDENT-EDUCATION-STATUS, SB15 STUDENT-ENROLLMENT-STATUS, STD4 STUDENT-ACADEMIC-LEVEL, STD6 STUDENT-DAY-EVENING-CLASS-CODE-2, SUM(SXD3 ENROLLMENT-UNITS-ATTEMPTED) FROM term enrollment data WHERE STD7 STUDENT-HEADCOUNT-STATUS IN ('A','B','C','F') GROUP BY GI01 DISTRICT-COLLEGE-IDENTIFIER, GI03 TERM-IDENTIFIER, SB00 STUDENT-IDENTIFIER, SB04 STUDENT-GENDER, STD1 STUDENT-AGE-AT-TERM, derived DataMart ethnicity from SB29 STUDENT-MULTI-ETHNICITY (ST_RACE), SB11 STUDENT-EDUCATION-STATUS, SB15 STUDENT-ENROLLMENT-STATUS, STD4 STUDENT-ACADEMIC-LEVEL, STD6 STUDENT-DAY-EVENING-CLASS-CODE-2
Selection Criteria: FROM term enrollment data WHERE STD7 STUDENT-HEADCOUNT-STATUS IN ('A','B','C','F') GROUP BY GI01 DISTRICT-COLLEGE-IDENTIFIER,