California Community Colleges Chancellor's Office
Students who meet the full-term reporting criteria in at least one of the terms during an academic year are included in this query.
SELECT GI01 DISTRICT-COLLEGE-IDENTIFIER, GI03 TERM-IDENTIFIER, SB00 STUDENT-IDENTIFIER, SB04 STUDENT-GENDER, STD1 STUDENT-AGE-AT-TERM, derived DataMart ethnicity from SB29 STUDENT-MULTI-ETHNICITY (ST_RACE) FROM term enrollment data WHERE STD7 STUDENT-HEADCOUNT-STATUS IN ('A','B','C','F')
FROM: Term Enrollment Data WHERE: STD7 STUDENT-HEADCOUNT-STATUS is 'A' (Credit Student Enrolled in Weekly/Daily Census Section) OR, 'B' (Credit Student Enrolled in Positive Attendance Section with 8 or More Hours or 0.50 or More Units Earned) OR, 'C' (Credit Student Enrolled in Independent Study Section with 0.50 or More Units Earned ) OR, 'F' (Noncredit Student Enrolled in Positive Attendance Section with 8 or More Hours)
Edit Related Elements
(List Picker here)
Back to List
Data Set Registry