California Community Colleges Chancellor's Office
Home
About
Privacy
Open Menu
Edit Metric
Metric
Topic
Category
Title
Location
Definition
Students who meet the full-term reporting criteria in at least one of the terms during an academic year are included in this query. Among all applicants in the previous or selected year, the proportion who enrolled in a community college in the selected year.
Student Type
Display
Statutory Reference
Link
Data Source
PseudoCode
SELECT GI01 DISTRICT-COLLEGE-IDENTIFIER, derived academic year from GI03 TERM-IDENTIFIER, SB00 STUDENT-IDENTIFIER, MIN(SB04 STUDENT-GENDER), MIN(STD1 STUDENT-AGE-AT-TERM), MIN(derived DataMart ethnicity from SB29 STUDENT-MULTI-ETHNICITY (ST_RACE)) FROM term enrollment data WHERE STD7 STUDENT-HEADCOUNT-STATUS IN ('A','B','C','F') GROUP BY GI01 DISTRICT-COLLEGE-IDENTIFIER, derived academic year from GI03 TERM-IDENTIFIER, SB00 STUDENT-IDENTIFIER With a record in the Student Enrollment Data Elements (SX) file, SX has a value AND in the selected year WHERE GI03 is within the selected year AND is not a Special Admit student concurrently enrolled in K12 AND SB15 not equal to Y
Selection Criteria
Denominator
Value Type
Notes
Political Context
Intent
Collection Guidance
Collection Guidance goes here.
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