Metric Details

Category: Students/Headcounts
Title: Education Status
Location: https://datamart.cccco.edu/Students/Education_Status_Summary.aspx
PseudoCode: SELECT GI01 DISTRICT-COLLEGE-IDENTIFIER GI03 TERM-IDENTIFIER SB04 STUDENT-GENDER STD1 STUDENT-AGE-AT-TERM derived DataMart ethnicity (ST_RACE) LEFT(SB11 STUDENT-EDUCATION-STATUS, 1) SUM(CASE WHEN STD7 STUDENT-HEADCOUNT-STATUS IN ('A','B','C') THEN 1 ELSE 0 END) SUM(CASE WHEN STD7 STUDENT-HEADCOUNT-STATUS = 'F' THEN 1 ELSE 0 END) FROM term enrollment data WHERE STD7 STUDENT-HEADCOUNT-STATUS IN ('A','B','C','F') GROUP BY GI01 DISTRICT-COLLEGE-IDENTIFIER GI03 TERM-IDENTIFIER SB04 STUDENT-GENDER STD1 STUDENT-AGE-AT-TERM derived DataMart ethnicity from SB29 STUDENT-MULTI-ETHNICITY (ST_RACE) LEFT(SB11 STUDENT-EDUCATION-STATUS, 1)
Selection Criteria: SUM(CASE WHEN STD7 STUDENT-HEADCOUNT-STATUS IN ('A','B','C') THEN 1 ELSE 0 END) SUM(CASE WHEN STD7 STUDENT-HEADCOUNT-STATUS = 'F' THEN 1 ELSE 0 END) FROM term enrollment data WHERE STD7 STUDENT-HEADCOUNT-STATUS IN ('A','B','C','F')