California Community Colleges Chancellor's Office
Home
About
Privacy
Open Menu
Edit Metric
Metric
Topic
Category
Title
Location
Definition
Student Type
Display
Statutory Reference
Link
Data Source
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
Authoritative Source
Edit Elements
Edit Related Elements
×
(List Picker here)
Back to List
×
Home
Search
Data Mart
LaunchBoard
SCFF
MIS DED
CCCApply
Data Set Registry
Glossary
About