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.
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