Delete Metric
Are you sure you want to delete this?
Metric
- Topic
- DataMart
- Category
- Students/Headcounts
- Link
- Title
- Education Status
- Definition
- Student Type
- Display
- Data Source
- 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')
- Denominator
- Value Type
- Notes
- Political Context
- Intent
- Collection Guidance