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,
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)